Dear friends, I recently encountered a problem with the color and size attributes of a product. For example, a product has two colors and three sizes.
Product A has a color design [black, white] and a size design [ S, M, L】
I want to click on the product list to go to the product details page, enter the quantity of each sku ordered, and then save and submit to the database. As shown below, can you give me some ideas? The color and size of each product are not fixed. The color and size information are retrieved from the database and displayed in an untabled header.
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
Use the `` tag to create an input box, and use the `name` attribute to identify different SKUs. For example,
'商品A', 'sku' => 'A001'], ['name' => '商品B', 'sku' => 'B001'], // 其他商品数据... ]; // 遍历商品列表 foreach ($products as $product) { echo "";
echo "{$product['name']} ";
// 为每个SKU创建输入框
foreach ($colors as $color) {
foreach ($sizes as $size) {
$sku = "{$product['sku']}_{$color}_{$size}";
echo " ";
}
?>
uses PHP to process form data and save it to the database. You can use the `$_POST` superglobal variable to get the form data and insert it into the database using SQL statements like
connect_error) { die('数据库连接失败：' . $conn->connect_error); } // 遍历表单数据 foreach ($_POST as $sku => $quantity) { // 将SKU拆分为颜色和尺码 $parts = explode('_', $sku); $color = $parts[1]; $size = $parts[2]; // 使用SQL语句将数据插入数据库 $sql = "INSERT INTO orders (sku, color, size, quantity) VALUES ('$sku', '$color', '$size', '$quantity')"; $result = $conn->query($sql); // 检查插入是否成功 if (!$result) { echo "插入数据失败：{$conn->error}"; } } // 关闭数据库连接 $conn->close(); } ?>