How to Insert Auth::user()->id in sql query
What can i do to store Auth::user()->id user_id on this sql query,
public function saveLoadingsData()
// Validate for a valid Post Request
if (isset($_POST['orderNumber']) && isset($_POST['Truck']) && isset($_POST['receiptNumber']) &&
isset($_POST['items'])) {
// {"orderNumber":"CRS1104200001","agentId":"3","items":
[{"itemId":"4","itemName":"Embe","quantity":"13"}]}
$orderNumber = $_POST['orderNumber'];
$items = $_POST['items'];
$receiptNumber = $_POST['receiptNumber'];
$Truck = $_POST['Truck'];
$driverName = $_POST['driverName'];
// $user_id=Auth::user()->id;
foreach ($items as $singleItem) {
$data = array('order_no' => $orderNumber, "receiptNumber" => $receiptNumber, "Truck" =>
$Truck, "driverName" => $driverName, "pid" => $singleItem['itemId'], "qty" => $singleItem['quantity']);
DB::table('loadings')->insert($data);
// return redirect()->back();
}
// return redirect()->back();
foreach ($items as $singleItem) {
$data = array(
'order_no' => $orderNumber,
"receiptNumber" => $receiptNumber,
"Truck" => $Truck,
"driverName" => $driverName,
"pid" => $singleItem['itemId'],
"qty" => $singleItem['quantity']
"user_id" => Auth::id(),
);
DB::table('loadings')->insert($data);
}
Reminds me how much better Laravel is than old school php (above)
Please or to participate in this conversation.