I have created a hook function in one of my controller to update a field after submitting the form.
The hook should populate the field "laboratory" of the "orders_detail" database with the name of a laboratory.
/* POPULATE the laboratory FIELD */
DB::table('orders_detail')->where('id',$id)->first();
/* dd($id); */
/* REQUESTED VALUE IN ARRAY : "ordersdetail-productname" => array:1 [▼ 0 => "1" ] : */
$productname = $_REQUEST['ordersdetail-productnameID'][0];
/* dd($productnameID); **RETURN VALUE "1"** */
/* QUERY : select laboratories.laboratory FROM products LEFT JOIN laboratories ON products.laboratoryID = laboratories.id WHERE products.id = productnameID : */
$laboratory = DB::table('products')
->join('laboratories', 'products.laboratoryID', '=', 'laboratories.id')
->selectRaw('laboratories.laboratory')
->where('products.id', '=', $productnameID)
->get();
/* dd($laboratory); **RETURNED ARRAY
Collection {#3536 ▼
#items: array:1 [▼
0 => {#3534 ▼
+"laboratory": "Boulanger"
}
]
}** */
/* UPDATE THE laboratory FIELD WITH THE RETURNED VALUE */
DB::table('orders_detail')->where('orderID', '=', $id)
->update(['laboratory'=> $laboratory]);
How can I get rid of "laboratory": "Boulanger" and just keep Boulanger which is the name of the laboratory I want to update the field "laboratory" with.
Thanks for your expertise.
Cheers, Marc
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire