php - MYSQL 插入到 laravel 5.5 请求 Controller

Question

我有以下代码循环动态创建的下拉菜单并将每个产品添加到订单数据库。我已将页面移至 laravel，但仍坚持让这部分工作。下面是我的遗留代码:

// prepare and bind
$stmt = $conn->prepare("INSERT INTO orders (customer_id, order_id, 
enrolment_id, product_description, delivery_mode, course_cost) VALUES (?, ?, 
?, ?, ?, ?);");
$stmt->bind_param("iisssi", $payment_cid, $mysql_id, $enrolment_id, 
$mysql_desc, $mysql_mode, $mysql_cost);
$fetchid = mysqli_insert_id($conn);


$result = array_map(function($d, $c, $m) { 
return array('product_description'=>$d, 'course_cost'=>$c, 
'delivery_mode'=>$m); 
}, $product_description, $course_cost, $delivery_mode
);  

// set parameters and execute

foreach($result as $item){
$mysql_id = $fetchid;
$mysql_desc = $item['product_description'];
$mysql_mode = $item['delivery_mode'];
$mysql_cost = $item['course_cost'];
$stmt->execute();
}

$stmt->close();
$conn->close();

我将其转换为 Laravel。这是我尝试使用 CRUD Controller 进行保存的尝试。顶部可以很好地保存单个数据输入，但是当有多个产品时，我会遇到错误。

Hey Serge, yes all code is massive to paste in here so snippets super brief.  My product_description saving snippet is example as this is where I get stuck.

我知道以下代码是错误的，因为它是单个保存和我尝试的循环的混搭:

$orders = new Order([
'customer_id' => $customers{'id'},
'course_cost' => $request->get('product_cost'),
'order_id' => $customers{'id'},
'enrolment_id' => $customers{'enrolment_id'},
'product_description' => $request->get('product_description'),
'delivery_mode' => $request->get('delivery_mode'),
'course_cost' => $request->get('course_cost'),
]);

$dataSet = [];
foreach ($orders as $item) {
$dataSet[] = [
'product_description'  => $request->get('product_description'),   
];
}
DB::table('orders')->insert($dataSet);
return redirect('/customers');
}

当前代码错误

Answer 1

我想象那些是代码片段......单个看起来不错......有趣的产品描述保存在产品描述中并没有注意到......大声笑想象这只是一个例子......但适当的 Eloquent 看起来像这样...... .

$orders = Request::where('product_description', $request->get('product_description')->get();
foreach($orders as $order) {
    order->product_description => $request->get('product_description');
    order->save();
}