Laravel向数据库插入空值和空值 [英] Laravel Inserting Empty to Form and Null Value to Database
问题描述
如何插入一个空值来输入文本并将其设置为null到数据库,因为这样做,我出错了,因为数据库的行没有值.我该如何做到没有错误?
How to insert an empty value to input text and set it to null to the database, as I do this I'm having an error because the rows of the database do not have a value. How can I do this without an error?
SQLSTATE [23000]:违反完整性约束:1048列标题" 不能为null(SQL:插入
awards
(title
,description
,awards_image
,updated_at
,created_at
)值(,,a:0:{}, 2018-11-28 10:29:35,2018-11-28 10:29:35))
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'title' cannot be null (SQL: insert into
awards
(title
,description
,awards_image
,updated_at
,created_at
) values (, , a:0:{}, 2018-11-28 10:29:35, 2018-11-28 10:29:35))
EDIT
EDIT
<?php
foreach ($awards as $key => $values) {
$awardsContent = new Award;
$awardsContent->title = $request->title[$key];
$awardsContent->description = $request->description[$key];
$awardsContent->awards_image = $values;
$awardsContent->save();
}
控制器
public function store(Request $request)
{
$this->validate($request, [
'title' => 'nullable',
'description' => 'nullable',
'awards_image.*' => 'image|nullable|max:1999'
]);
$awards = [];
if ($request->has('awards_image')) {
foreach ($request->file('awards_image') as $key => $file) {
$filenameWithExt = $file->getClientOriginalName();
$filename = pathinfo($filenameWithExt, PATHINFO_FILENAME);
$extension = $file->getClientOriginalExtension();
$fileNameToStore = $filename . '_' . time() . '.' . $extension;
$path = $file->storeAs('public/awards_images', $fileNameToStore);
array_push($awards, $fileNameToStore);
}
$fileNameToStore = serialize($awards);
} else {
$fileNameToStore = 'noimage.jpg';
}
$awardsContent = new Award;
$awardsContent->title = $request->input('title');
$awardsContent->description = $request->input('description');
$awardsContent->awards_image = $fileNameToStore;
$awardsContent->save();
return redirect('/admin/airlineplus/awards')->with('success', 'Content Created');
}
推荐答案
您的数据库当前不允许标题列为空.您可以将表中的该字段更改为可为空,或者如果请求中的值为空,则可以更新代码以使用空字符串.
Your database doesn't currently allow the title column to be null. You can either change that field in the table to be nullable, or you can update your code to use an empty string if the value from the request is null.
$awardsContent->title = $request->filled('title') ? $request->get('title') : '';
这篇关于Laravel向数据库插入空值和空值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!