//控制器
public function create(Request $request)
{
// dd($request->all());
$this->validate($request, [
'emp_nm' => 'required',
'emp_email' => 'required | email',
'emp_password' => 'required' ,
'mobile' => 'required | max:20' ,
'emp_type_id' => 'required',
'emp_img' => 'required|image|mimes:jpeg,png,jpg,gif,svg|max:2048',
]);
$employee = new Employee();
$employee->emp_nm = $request->input('emp_nm');
$employee->emp_email = $request->input('emp_email');
$employee->emp_password = Hash::make($request->input('emp_password'));
$employee->mobile = $request->input('mobile');
$employee->emp_type_id = $request->input('emp_type_id');
if ($request->hasfile('emp_img')) {
$file = $request->file('emp_img');
$extention = $file->getClientOriginalExtension(); // get img extension
$filename = time() . '.' . $extention;
$file->move('upload/employee/',$filename);
$employee->emp_img = $filename;
}else{
return $request;
$employee->emp_img = '';
}
$employee->save();
$id = $employee->id;
$created_at = $employee->created_at;
$updated_at = $employee->updated_at;
$post = Employee::find($id);
// $created = Employee::get('created_at');
// $updated = Employee::get('updated_at');
$employee = DB::table('employees')->get();
$admin = new Admin();
$admin->name = $request->input('emp_email');
$admin->password = $request->input('emp_password');
$admin->employee_id = $post;
// $admin->created_at = $created;
// $admin->updated_at = $updated;
$admin->save();
return redirect()->back();
}
//错误
SQLSTATE [22007]:无效的日期时间格式:1366不正确的整数值:'{“ id”:1,“ emp_nm”:“ admin”,“ emp_email”:“ [email protected]”,“ emp_password”:“ $ 2y $ 10 $ NLkdEn1ohHvHKU / uummrvOrwhJ3iEy7PPfxpk9dj9u6.pOVu1'列
mycrm
。admins
。employee_id
在第1行(SQL:INSERT INTOadmins
(name
,password
,employee_id
,updated_at
,created_at
)值([email protected],管理@ 1234#,{ “ID”:1, “emp_nm”:” admin“,” emp_email“:” [email protected]“,” emp_password“:” $ 2y $ 10 $ NLkdEn1ohHvHKU / uummrvOrwhJ3iEy7PPfxpk9dj9u6.pOVu10YTa“,” mobile“:9426399403,” emp_type_id“:”“:”“ 1581590201.jpg“,” created_at“:” 2020-02-13 10:36:41“,”Updated_at“:”“ 2020-02-13 10:36:41”},2020-02-13 10:36:41,2020-02-13 10:36:41))
在控制器中,代码正在同时插入2个表,如果我分配了日期,则返回日期格式错误。.发现了意外的数据。尾随数据,所以我该如何解决此错误?
您的代码有误$admin->employee_id = $post;
尝试使用$admin->employee_id = $post->id;
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句