Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

melx's avatar
Level 4

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();
0 likes
1 reply
Snapey's avatar
Snapey
Best Answer
Level 122
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.