我正在使用Laravel 8和 Bootstrap 5 制作博客應用程式。
articles我在表格中添加文章時遇到了問題。
在生成articles表的遷移檔案中，我有：
public function up() {
Schema::create('articles', function (Blueprint $table) {
$table->id();
$table->unsignedInteger('user_id');
$table->foreign('user_id')->references('id')->on('users');
$table->unsignedInteger('category_id');
$table->foreign('category_id')->references('id')->on('catergories');
$table->string('title');
$table->string('slug');
$table->string('short_description');
$table->longText('content');
$table->tinyInteger('featured')->default('0');
$table->string('image')->nullable();
$table->timestamps();
});
}
在Article模型中，我有：
class Article extends Model {
use HasFactory;
protected $fillable = [
'user_id',
'category_id',
'title',
'slug',
'short_description',
'content',
'featured',
'image',
];
// Join users to articles
public function user() {
return $this->belongsTo(User::class);
}
// Join categories to articles
public function category() {
return $this->belongsTo(ArticleCategory::class);
}
}
在控制器中，我有：
namespace App\Http\Controllers\Dashboard;
use Illuminate\Support\Str;
use Illuminate\Support\Facades\Validator;
use Illuminate\Support\Facades\Auth;
use App\Http\Controllers\Controller;
use App\Models\ArticleCategory;
use App\Models\Article;
use Illuminate\Http\Request;
class ArticleController extends Controller {
private $rules = [
'category_id' => 'required|exists:article_categories,id',
'title' => 'required|string|max:255',
'short_description' => 'required|string|max:255',
'image' => 'image|mimes:jpeg,png,jpg|max:2048',
'content' => 'required|string',
'featured' => 'required'
];
private $messages = [
'category_id.required' => 'Please pick a category for the article',
'title.required' => 'Please provide a title for the article',
'short_description.required' => 'The article needs a short description',
'content.required' => 'Please add content'
];
public function categories() {
return ArticleCategory::all();
}
public function index() {
$articles = Article::paginate(10);
return view('dashboard/articles',
['articles' => $articles]
);
}
public function create() {
// Load the view and populate the form with categories
return view('dashboard/add-article',
['categories' => $this->categories()]
);
}
public function save(Request $request) {
// Validate form (with custom messages)
$validator = Validator::make($request->all(), $this->rules, $this->messages);
if ($validator->fails()) {
return redirect()->back()->withErrors($validator->errors())->withInput();
}
$fields = $validator->validated();
// Upload article image
$current_user = Auth::user();
if (isset($request->image)) {
$imageName = md5(time()) . $current_user->id . '.' . $request->image->extension();
$request->image->move(public_path('images/articles'), $imageName);
}
// Data to be added
$form_data = [
'user_id' => Auth::user()->id,
'category_id' => $fields['category_id'],
'title' => $fields['title'],
'slug' => Str::slug($fields['title'], '-'),
'short_description' => $fields['short_description'],
'content' => $fields['content'],
'image' => $fields['image'],
'featured' => $fields['featured']
];
// Insert data in the 'articles' table
$query = Article::create($form_data);
if ($query) {
return redirect()->route('dashboard.articles')->with('success', 'Article added');
} else {
return redirect()->back()->with('error', 'Adding article failed');
}
}
}
表格：
<form method="POST" action="{{ route('dashboard.articles.add') }}" enctype="multipart/form-data" novalidate>
@csrf
<div class="row mb-2">
<label for="title" class="col-md-12">{{ __('Title') }}</label>
<div class="col-md-12 @error('title') has-error @enderror">
<input id="title" type="text" placeholder="Title" class="form-control @error('title') is-invalid @enderror" name="title" value="{{ old('title') }}" autocomplete="title" autofocus>
@error('title')
<span hljs-string">" role="alert">
<strong>{{ $message }}</strong>
</span>
@enderror
</div>
</div>
<div hljs-number">2">
<label for="short_description" hljs-number">12">{{ __('Short description') }}</label>
<div hljs-number">12 @error('short_description') has-error @enderror">
<input id="short_description" type="text" placeholder="Short description" hljs-built_in">error('short_description') is-invalid @enderror" name="short_description" value="{{ old('short_description') }}" autocomplete="short_description" autofocus>
@error('short_description')
<span hljs-string">" role="alert">
<strong>{{ $message }}</strong>
</span>
@enderror
</div>
</div>
<div hljs-number">2">
<label for="category" hljs-number">12">{{ __('Category') }}</label>
<div hljs-number">12 @error('category_id') has-error @enderror">
<select name="category_id" id="category" hljs-built_in">error('category_id') is-invalid @enderror">
<option value="0">Pick a category</option>
@foreach($categories as $category)
<option value="{{ $category->id }}">{{ $category->name }}</option>
@endforeach
</select>
@error('category_id')
<span hljs-string">" role="alert">
<strong>{{ $message }}</strong>
</span>
@enderror
</div>
</div>
<div hljs-number">2">
<div hljs-number">12 d-flex align-items-center switch-toggle">
<p hljs-number">0 me-3">Featured article?</p>
<input hljs-number">1" type="checkbox" name="featured" id="featured">
<label hljs-number">1" for="featured">{{ __('Toggle') }}</label>
</div>
</div>
<div hljs-number">2">
<label for="image" hljs-number">12">{{ __('Article image') }}</label>
<div hljs-number">12 @error('image') has-error @enderror">
<input type="file" name="image" id="file" hljs-string">">
@error('image')
<span hljs-string">" role="alert">
<strong>{{ $message }}</strong>
</span>
@enderror
</div>
</div>
<div hljs-number">2">
<label for="content" hljs-number">12">{{ __('Content') }}</label>
<div hljs-number">12 @error('content') has-error @enderror">
<textarea name="content" id="content" hljs-built_in">error('content') is-invalid @enderror" placeholder="Content" cols="30" rows="6">{{ old('content') }}</textarea>
@error('content')
<span hljs-string">" role="alert">
<strong>{{ $message }}</strong>
</span>
@enderror
</div>
</div>
<div hljs-number">0">
<div hljs-number">12">
<button type="submit" hljs-number">100 btn btn-primary">
{{ __('Save') }}
</button>
</div>
</div>
</form>
路線：
// Article routes
Route::group(['prefix' => 'articles'], function() {
Route::get('/', [ArticleController::class, 'index'])->name('dashboard.articles');
Route::get('/new', [ArticleController::class, 'create'])->name('dashboard.articles.new');
Route::post('/add', [ArticleController::class, 'save'])->name('dashboard.articles.add');
});
問題：
即使表單通過了驗證，并且發生了重定向，記錄實際上并沒有添加到articles表中。
Laravel 拋出錯誤General error: 1366 Incorrect integer value: 'on' for column 'featured' at row 1。
我的錯誤是什么？
uj5u.com熱心網友回復：
處理復選框時，您需要知道這一點；
a）您不能使用required，因為如果未選中復選框，則不會與表單資料一起發送。
b）默認值是“開”，但實際上，資料中存在該欄位意味著它已被檢查，所以我通常做的就是這樣；
'featured' => $request->has('featured')
這將回傳一個布林值 true 或 false，適合存盤在您的資料庫中
所以你可以寫
// Turn the 'featured' field value into a tiny integer
//$fields['featured'] = $request->get('featured') == 'on' ? 1 : 0;
// If no image is uploaded, use default.jpg
$fields['image'] = $request->get('image') == '' ? 'default.jpg' : $imageName;
// Data to be added
$form_data = [
'user_id' => Auth::user()->id,
'category_id' => $fields['category_id'],
'title' => $fields['title'],
'slug' => Str::slug($fields['title'], '-'),
'short_description' => $fields['short_description'],
'content' => $fields['content'],
'featured' => $request->has('featured'),
'image' => $fields['image']
];
uj5u.com熱心網友回復：
您的列被定義為 atinyInteger只能接受一個數字，但您似乎正在on向它傳遞一個字串。
$table->tinyInteger('featured')->default('0');
一般錯誤：1366 不正確的整數值：第 1 行的列 'featured' 的 'on'
嘗試將復選框的值設定為1.
<input class="mt-1" type="checkbox" name="featured" id="featured" value="1">
編輯，確保boolean在將值添加到您的輸入元素后添加到您的驗證規則。
private $rules = [
'category_id' => 'required|exists:article_categories,id',
'title' => 'required|string|max:255',
'short_description' => 'required|string|max:255',
'image' => 'image|mimes:jpeg,png,jpg|max:2048',
'content' => 'required|string',
'featured' => 'required|boolean'
];
uj5u.com熱心網友回復：
如果它對任何人有幫助，這里是創建文章的作業代碼：
路線：
// Article routes
Route::group(['prefix' => 'articles'], function() {
Route::get('/', [ArticleController::class, 'index'])->name('dashboard.articles');
Route::get('/new', [ArticleController::class, 'create'])->name('dashboard.articles.new');
Route::post('/add', [ArticleController::class, 'save'])->name('dashboard.articles.add');
});
在控制器中：
namespace App\Http\Controllers\Dashboard;
use Illuminate\Support\Str;
use Illuminate\Support\Facades\Validator;
use Illuminate\Support\Facades\Auth;
use App\Http\Controllers\Controller;
use App\Models\ArticleCategory;
use App\Models\Article;
use Illuminate\Http\Request;
class ArticleController extends Controller
{
private $rules = [
'category_id' => 'required|exists:article_categories,id',
'title' => 'required|string|max:255',
'short_description' => 'required|string|max:255',
'image' => 'image|mimes:jpeg,png,jpg|max:2048',
'content' => 'required|string'
];
private $messages = [
'category_id.required' => 'Please pick a category for the article',
'title.required' => 'Please provide a title for the article',
'short_description.required' => 'The article needs a short description',
'content.required' => 'Please add content'
];
public function categories() {
return ArticleCategory::all();
}
public function index() {
$articles = Article::orderBy('id', 'desc')->paginate(10);
return view('dashboard/articles',
['articles' => $articles]
);
}
public function create() {
// Load the view and populate the form with categories
return view('dashboard/add-article',
['categories' => $this->categories()]
);
}
public function save(Request $request) {
// Validate form (with custom messages)
$validator = Validator::make($request->all(), $this->rules, $this->messages);
if ($validator->fails()) {
return redirect()->back()->withErrors($validator->errors())->withInput();
}
$fields = $validator->validated();
// Upload article image
$current_user = Auth::user();
if (isset($request->image)) {
$imageName = md5(time()) . $current_user->id . '.' . $request->image->extension();
$request->image->move(public_path('images/articles'), $imageName);
}
// Turn the 'featured' field value into a tiny integer
$fields['featured'] = $request->get('featured') == 'on' ? 1 : 0;
// If no image is uploaded, use default.jpg
$fields['image'] = $request->get('image') == '' ? 'default.jpg' : $imageName;
// Data to be added
$form_data = [
'user_id' => Auth::user()->id,
'category_id' => $fields['category_id'],
'title' => $fields['title'],
'slug' => Str::slug($fields['title'], '-'),
'short_description' => $fields['short_description'],
'content' => $fields['content'],
'featured' => $fields['featured'],
'image' => $fields['image']
];
// Insert data in the 'articles' table
$query = Article::create($form_data);
if ($query) {
return redirect()->route('dashboard.articles')->with('success', 'Article added');
} else {
return redirect()->back()->with('error', 'Adding article failed');
}
}
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/450829.html