Merhabalar bir sorunla karşılaştım da yardım edermisiniz acaba
Hata:
SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '{"id":1,"name":"Fatih Tuzlu","email":"fatihtuzlu07@gmail.com","email_verified_at":null,"current_team_id":1,"profile_photo_pat...' for column site
.products
.user_id
at row 1 (SQL: insert into products
(title
, keywords
, description
, slug
, status
, category_id
, user_id
, price
, quantity
, minquantity
, tax
, detail
, updated_at
, created_at
) values (ev adresi, ?, ?, zxczxc, False, ?, {"id":1,"name":"Fatih Tuzlu","email":"fatihtuzlu07@gmail.com","email_verified_at":null,"current_team_id":1,"profile_photo_path":null,"created_at":"2021-04-05T20:41:03.000000Z","updated_at":"2021-04-05T21:45:15.000000Z","profile_photo_url":"https:\/\/ui-avatars.com\/api\/?name=Fatih+Tuzlu&color=7F9CF5&background=EBF4FF"}, 0, ?, 5, 18, ?, 2021-04-10 17:31:01, 2021-04-10 17:31:01))
web.php:
Route::prefix('poduct')->group(function (){
Route::get('/',[App\Http\Controllers\Admin\ProductController::class,'index'])->name('admin_products');
Route::get('/create',[App\Http\Controllers\Admin\ProductController::class,'create'])->name('admin_product_add');
Route::post('/store',[App\Http\Controllers\Admin\ProductController::class,'store'])->name('admin_product_store');
Route::get('/edit/{id}',[App\Http\Controllers\Admin\ProductController::class,'edit'])->name('admin_product_edit');
Route::post('/update/{id}',[App\Http\Controllers\Admin\ProductController::class,'update'])->name('admin_product_update');
Route::get('/delete/{id}',[App\Http\Controllers\Admin\ProductController::class,'destroy'])->name('admin_product_delete');
Route::get('/show',[App\Http\Controllers\Admin\ProductController::class,'show'])->name('admin_product_show');
});
ProductController:
public function store(Request $request, )
{
$data= new Product;
$data->title=$request->input('title');
$data->keywords=$request->input('keywords');
$data->description=$request->input('description');
$data->slug=$request->input('slug');
$data->status=$request->input('status');
$data->category_id=$request->input('category_id');
$data->user_id=Auth::user();
$data->price=$request->input('price');
$data->quantity=$request->input('quantity');
$data->minquantity=$request->input('minquantity');
$data->tax=(int)$request-> input('tax');
$data->detail=$request->input('detail');
$data->save();
return redirect()->route('admin_products');
}
create_product table:
public function up()
{
Schema::create('products', function (Blueprint $table) {
$table->id();
$table->string('title',150);
$table->string('keywords')->nullable();
$table->string('description')->nullable();
$table->string('image',75)->nullable();
$table->integer('category_id')->nullable();
$table->integer('user_id')->nullable();
$table->float('price')->nullable();
$table->integer('quantity')->default(1);
$table->integer('minquantity')->default(5);
$table->integer('tax')->default(18);
$table->text('detail')->nullable();
$table->string('slug',100)->nullable();
$table->string('status',5)->nullable()->default('false');
$table->timestamps();
});
}