大家好!我想做CRUD,但提交表单时出错了。错误显示"SQLSTATE42S02:基表或视图未找到: 1146表'hr.staff‘不存在“。下面显示了我的数据库结构和代码。
员工模型:-
class Staffs extends Model
{
use HasFactory;
protected $fillable = [
'name', 'staffid', 'address', 'religion', 'email', 'phonenum', 'maritalstatus'
];
}
工作人员迁移表:-
public function up()
{
Schema::create('staffs', function (Blueprint $table) {
$table->id();
$table->timestamps();
$table->string('name');
$table->integer('staffid');
$table->string('address');
$table->string('religion');
$table->string('email')->unique();
$table->integer('phonenum');
$table->string('maritalstatus');
});
}
StaffContoller:-
public function store(Request $request)
{
$request->validate([
'name' => 'required',
'staffid' => 'required',
'address' => 'required',
'religion' => 'required',
'email' => 'required',
'phonenum' => 'required',
'maritalstatus' => 'required',
]);
Staff::create($request->all());
return redirect()->route('staffs.index')
->with('success','Staff data has been created successfully.');
}
addstaff.blade.php:-
<form method="POST" action="{{ route('staffs.store') }}">
@csrf
<div class="grid grid-cols-2 gap-6">
<div class="grid grid-rows-2 gap-6">
<div>
<x-label for="name" :value="__('Name:')" />
<x-input id="name" class="block mt-1 w-full" type="text" name="name" value="{{ old('name') }}" autofocus />
</div>
<div>
<x-label for="staffid" :value="__('Staff ID:')" />
<x-input id="staffid" class="block mt-1 w-full" type="integer" name="staffid" value="{{ old('staffid') }}" autofocus />
</div>
<div class="flex items-center justify-end mt-4">
<x-button class="ml-3">
{{ __('Submit') }}
</x-button>
</div>
不能粘贴完整的提交形式,但是所有的字段都在那里。
数据库结构:-
发布于 2021-11-10 03:35:18
您的表名是staffs
,而不是staff
。
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'hr.staff' doesn't exist
将模型的$table
属性更新为正确的表名,然后您应该能够使用该模型创建记录。Staff::create($request->all());
https://stackoverflow.com/questions/69907671
复制相似问题