php - Laravel - 如何找到外键值

问题描述

第一次使用 Laravel 和 PHP。我试图在表配置文件中插入行，其中属性 uID 是引用用户表上 uID 的外键，但出现错误。如何仅插入配置文件的摘要属性并自动设置 uID（外键）。我可以毫无问题地插入具有 uID 的用户。这是我的模型和控制器文件。谢谢！

用户模型

namespace App;

use Illuminate\Database\Eloquent\Model;

    class user extends Model
    {
    // specify which attributes can be filled out during registration
    public $timestamps = false;
    protected $fillable=['firstname','lastname','email','password',];

    public function profile(){
      return $this->hasOne(profile::class);
    }
}

轮廓模型

namespace App;

use Illuminate\Database\Eloquent\Model;

class profile extends Model
{
    //
    public $timestamps = false;
    protected $fillable = ['summary',];

    public function user(){
      return $this->belongsTo(user::class);
    }
}

配置文件迁移

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateProfilesTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
     // create profile table
       Schema::create('profiles', function (Blueprint $table) {
           $table->increments('pID');
           $table->timestamp('created_at')->useCurrent();
           $table->string('summary')->default('');
           $table->unsignedInteger('uID');

           $table->foreign('uID')->references('uID')->on('users')->onDelete('cascade');
       });
   }
}

配置文件控制器

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\profile;

class ProfileController extends Controller
{
    public function create()
    {
        //
        return view('profile.create');
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        // used to store user profile after validation
        $this->validate($request,[
          'summary' => 'required'
        ]);
        $profile = new profile([
          'summary' => $request->get('summary'),
          'uID' => $request->user()->uID
        ]);

        return redirect()->route('profile.create')->with('success','Profile created');
    }
}

标签： phpmysqllaraveleloquentxampp

php - Laravel - 如何找到外键值

问题描述

解决方案

推荐阅读