SQLSTATE[22007]：无效的日期时间格式：1292 "fotostudio transaction_details"列的日期时间值不正确："28-01-2022 12：00"。

Question

我收到一个错误。SQLSTATE[22007]：无效的日期时间格式：1292列fotostudio的日期时间值"28-01-2022 12:00"不正确。CCD_ 2。第1行的datetime(SQL：插入transaction_details(username、phone、datetime、transactions_id、updated_at、created_at(值(Candradimuka Production，085328663110，28-01-2022 12:00，112021-09 08:13:14，2022-01-09 08:13:14(

这是我的型号

<?php
namespace AppModels;
use IlluminateDatabaseEloquentFactoriesHasFactory;
use IlluminateDatabaseEloquentModel;
use IlluminateDatabaseEloquentSoftDeletes;
class Transaction extends Model
{
use SoftDeletes;

protected $fillable = [
'reservations_id', 'reservations_title', 'users_id',
'transaction_total', 'transaction_status'
];
protected $hidden = [
];
//relasi ke galery dan reservasi
public function details() {
return $this->hasMany(
TransactionDetail::class, 'transactions_id', 'id');
}
public function reservation() {
return $this->belongsTo(
Reservation::class, 'reservations_id', 'id');
}
public function user() {
return $this->belongsTo(User::class, 'users_id', 'id');
}
}```

这是我的控制器

<?php
namespace AppHttpControllers;
use AppModelsTransaction;
use AppModelsTransactionDetail;
use AppModelsReservation;
use CarbonCarbon;
use IlluminateHttpRequest;
use IlluminateSupportFacadesAuth;
class CheckoutController extends Controller
{
public function index(request $request, $id)
{
$item = Transaction::with(
['details', 'reservation', 'user'])->findOrFail($id);
return view('pages.checkout',
['item' => $item]);
}
public function process(request $request, $id)
{
$reservation = Reservation::findOrFail($id);
$transaction = Transaction::create([
'reservations_id' => $id,
'reservations_title' => $reservation->title,
'user_id' => Auth::user()->id,
'transaction_total' => $reservation->price,
'transaction_status' => 'IN_CART'
]);
return redirect()->route('checkout', $transaction->id);
}
public function remove(request $request, $detail_id)
{
$item = TransactionDetail::findOrFail($detail_id);
//dd($item); 
$transaction = Transaction::with(['details', 'reservation'])
->findOrFail($item->transaction_id);

$item->delete();
return redirect()->route('checkout', $item->transaction_id);
}
public function create(request $request, $id)
{
$request->validate([
'username' => 'required|string|exists:users,username',
'phone' => 'required|string',
'datetime' => 'required|date'
]);
$data = $request->all();
$data['transactions_id'] = $id;
TransactionDetail::create($data);
$transaction = Transaction::with(['reservation'])->find($id);
return redirect()->route('checkout', $id);
}
public function success(request $request, $id)
{
$transaction = Transaction::findOrFail($id);
$transaction->transaction_status = 'PENDING';
$transaction->save();
return view('pages.success');
}
}

Answer 1

在插入数据之前尝试此设置格式

$data = $request->all();
$data['transactions_id'] = $id;    
$data['datetime'] = date('Y-m-d H:i:s', strtotime($data['datetime']));
TransactionDetail::create($data);