如何从多维数组插入订购数据 [英] How to insert ordering data from multidimensional array
问题描述
<?php
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// Section 5 (render the cart for the user to view on the page)
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$cartOutput = "";
$cartTotal = "";
$pp_checkout_btn = '';
$checkout_btn = '';
$product_id_array = '';
if (!isset($_SESSION["cart_array"]) || count($_SESSION["cart_array"]) < 1) {
$cartOutput = "<h2 align='center'>Your shopping cart is empty</h2>";
} else {
// Start PayPal Checkout Button
$pp_checkout_btn .= '<form action="http://chenlikpharmacy.freeserver.me/order_list.php" method="post">
<input type="hidden" name="cartOutput" id="cartOutput" value = "<?php echo $cartOutput; ?>
';
// Start the For Each loop
$i = 0;
foreach ($_SESSION["cart_array"] as $each_item) {
$item_id = $each_item['item_id'];
$sqlCommand = "SELECT * FROM products WHERE id='$item_id' LIMIT 1";
$sql = mysqli_query($myConnection,$sqlCommand);
while ($row = mysqli_fetch_array($sql)) {
$product_name = $row["product_name"];
$price = $row["price"];
$details = $row["details"];
}
$pricetotal = $price * $each_item['quantity'];
$cartTotal = $pricetotal + $cartTotal;
setlocale(LC_MONETARY, "ms_MY");
$pricetotal = money_format("%10.2n", $pricetotal);
// Dynamic Checkout Btn Assembly
$x = $i + 1;
$pp_checkout_btn .= '<input type="hidden" name="item_name[]" value="' . $product_name . '">
<input type="hidden" name="amount[]" value="' . $price . '">
<input type="hidden" name="quantity[]" value="' . $each_item['quantity'] . '"> ';
// Create the product array variable
$product_id_array .= "$item_id-".$each_item['quantity'].",";
// Dynamic table row assembly
$cartOutput .= "<tr>";
$cartOutput .= '<td><a href="product.php?id=' . $item_id . '">' . $product_name . '</a><br /><img src="inventory_images/' . $item_id . '.jpg" alt="' . $product_name. '" width="40" height="52" border="1" /></td>';
$cartOutput .= '<td>' . $details . '</td>';
$cartOutput .= '<td>RM ' . $price . '</td>';
$cartOutput .= '<td><form action="cart.php" method="post">
<input name="quantity" type="text" value="' . $each_item['quantity'] . '" size="1" maxlength="2" />
<input name="adjustBtn' . $item_id . '" type="submit" value="change" />
<input name="item_to_adjust" type="hidden" value="' . $item_id . '" />
</form></td>';
//$cartOutput .= '<td>' . $each_item['quantity'] . '</td>';
$cartOutput .= '<td>' . $pricetotal . '</td>';
$cartOutput .= '<td><form action="cart.php" method="post"><input name="deleteBtn' . $item_id . '" type="submit" value="X" /><input name="index_to_remove" type="hidden" value="' . $i . '" /></form></td>';
$cartOutput .= '</tr>';
$i++;
}
setlocale(LC_MONETARY, "ms_MY");
$cartTotal = money_format("%10.2n", $cartTotal);
$cartTotal = "<div style='font-size:18px; margin-top:12px;' align='right'>Cart Total : ".$cartTotal." MYR</div>";
// Finish the Paypal Checkout Btn
$pp_checkout_btn .= '<input type="hidden" name="custom" value="' . $product_id_array . '">
<input type="submit" type="button" name="submit">
</form>';
}
?>
上面是我在网上学到的用于创建多维数组并将其提交给paypal进行处理的源代码.现在,我尝试避免使用贝宝,并希望插入提交到我的新数据库订单"中的数据.为此,我创建了行(标识(主要,自动递增),产品名称,价格,数量,日期已添加),但是我无法将数据插入其中....
The above is the source code I learnt online to create a multidimensional array and submit to paypal for processing. Now I try to avoid paypal and wanna to insert the data submitted to my new database 'orders'. I created row (id (primary,auto increment),product_name,price,quantity,date_added) for this purpose but I failed to insert the data into it....
我的尝试如下
<?php
// This file is www.developphp.com curriculum material
// Written by Adam Khoury January 01, 2011
// http://www.youtube.com/view_play_list?p=442E340A42191003
session_start(); // Start session first thing in script
// Script Error Reporting
error_reporting(E_ALL);
ini_set('display_errors', '1');
// Connect to the MySQL database
include "storescripts/connect_to_mysqli.php";
?>
<?php
// Parse the form data and add inventory item to the system
if (isset($_POST['cartOutput'])) {
$product_name=mysqli_real_escape_string($myConnection,$_POST[' . $product_name . ']);
$price=mysqli_real_escape_string($myConnection,$_POST[' . $price . ']);
$quantity=mysqli_real_escape_string($myConnection,$_POST[$each_item['quantity']]);
$date = date('d/m/Y', time());
$sqlCommand = ""INSERT INTO orders (product_name, price, quantity, date_added) VALUES('" . $_POST[$product_name] . "','" . $_POST[$price] . "','" . $_POST[$each_item['quantity']] . "', now())";
$sql = mysqli_query($myConnection,$sqlCommand) or die (mysqli_error());
$stmt = $mysqli->prepare($sql);
$countArray = count($_SESSION["cart_array");
for ($i = 0; $i < $countArray; $i++) {
$stmt->bind_param('ssd', $array[$product_name][$i], $array[$price][$i], $array[$each_item['quantity']][$i],$array[$date][$i]);
$stmt->execute();
}
echo $sql ;
exit();
}
?>
HELP ~~~我需要知道if(isset($ _ POST ['cartOutput'])){为了获取日期,我该怎么办...我真的是一个初学者.我需要一些魔法……
HELP~~~ I need to know what shall I put in if (isset($_POST['cartOutput'])) { in order to retrieve the date...i am really a beginner. I need some magic......
推荐答案
我的示例使用PDO,但我认为您已经明白了,也应该使用PDO或MYSQLI代替mysql
My example use PDO but I think you get the idea, Also you should move to PDO or MYSQLI instead of mysql
示例:
<?php
// pdo example
$sql = 'INSERT INTO table (field1, field2, field3) VALUES (:value1, :value2, :value3)';
// $dbh is pdo connection
$insertTable = $dbh->prepare($sql);
$countArray = count($array);
for ($i = 0; $i < $countArray; $i++) {
$insertTable->bindParam(':value1', $array['value1'][$i], PDO::PARAM_INT); // if value is int
$insertTable->bindParam(':value2', $array['value2'][$i], PDO::PARAM_STR); // if value is str
$insertTable->bindParam(':value3', $array['value3'][$i], PDO::PARAM_STR);
$insertTable->execute();
}
?>
输入名称格式
我看到您正在执行此操作:amount_' . $x . '
您的数组帖子将如下所示:
I see you are doing this: amount_' . $x . '
your array post will look like this:
[amount_0] => 100
[amount_1] => 200
[amount_2] => 1
[quantity] => 10
[quantity] => 20
[quantity] => 1
但是如果您写amount[]
,则数组将如下所示:
but if your write amount[]
the array will look like this:
[amount] => Array
(
[0] => 100
[1] => 200
[2] => 1
)
[quantity] => Array
(
[0] => 10
[1] => 20
[2] => 1
最后一个选项使读取数组更好.
The last option makes it much better to read the array.
MYSQLI示例
<?php
$sql = 'INSERT INTO table (field1, field2, field3) VALUES (?, ?, ?)';
$stmt = $mysqli->prepare($sql);
$countArray = count($array);
for ($i = 0; $i < $countArray; $i++) {
$stmt->bind_param('ssd', $array['value1'][$i], $array['value2'][$i], $array['value3'][$i]);
$stmt->execute();
}
?>
如您所见,在这些类型的参数之前有ssd
,
As you can see there is standing ssd
before the parameters these are the types there are 4 types:
- i =热情
- s =字符串
- d = double
- b = blob
您必须始终对此进行定义.
You must always define this.
修改
您应该使用此:
<?php
// Parse the form data and add inventory item to the system
if (isset($_POST['cartOutput'])) {
$sql= 'INSERT INTO orders (product_name, price, quantity, date_added) VALUES(?,?,?, NOW())';
$stmt = $myConnection->prepare($sql);
$countArray = count($_POST["item_name");
for ($i = 0; $i < $countArray; $i++) {
$stmt->bind_param('sss', $_POST['item_name'][$i], $_POST['amount'][$i], $_POST['quantity'][$i]);
$stmt->execute();
}
echo $sql ;
exit();
}
?>
这篇关于如何从多维数组插入订购数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!