Jump to content

Insering Multiple Rows In DB


Chet

Recommended Posts

Hello,

I am using the SecureNetShop shopping cart for my business. Their final checkout page (thank you page) posts the items as such (for silent posting):

Each item's name, price and quantity are posted in the following format:
item1=name~price~quantity
item2=name~price~quantity
item3=name~price~quantity
and so on...

So if the customer purchases 3 items it would post like this:

item1=Mens Polo Shirt~25.00~2
item2=Ladies Sport Socks~10.00~3
item3=Mens Tie~20.00~1

I am trying to post a row in my DB for each item purchased but I am lost when it comes to arrays or loops.

My code below works great as long as the customer only purchases one item. But if they purchase 2 or more items it only inserts the first item instead of all of them.

[code]// Insert all ordered items into items table

list($order_num, $item_name, $item_price, $item_qty) =
split("~", $item1);

mysql_query("INSERT into items
(inv_num, item_name, item_qty, item_price)
VALUES
('$inv_num','$item_name', '$item_qty', '$item_price')");[/code]

If I change [b]item1[/b] to [b]item2[/b] it will insert the second item on the list only. If I change it to [b]item3[/b] it will insert only the third product on the list and so on... So I need to get it to insert all items purchased.

If anyone can help me out here I would greatly appreciate it :)

Thank You
Link to comment
https://forums.phpfreaks.com/topic/6960-insering-multiple-rows-in-db/
Share on other sites

[!--quoteo(post=363088:date=Apr 9 2006, 02:59 PM:name=Karthikeyan)--][div class=\'quotetop\']QUOTE(Karthikeyan @ Apr 9 2006, 02:59 PM) [snapback]363088[/snapback][/div][div class=\'quotemain\'][!--quotec--]i hope you can got my idea? enough?[/quote] Thanks for replying... but no, I don't understand :)
[!--quoteo(post=363091:date=Apr 9 2006, 02:06 PM:name=Chet)--][div class=\'quotetop\']QUOTE(Chet @ Apr 9 2006, 02:06 PM) [snapback]363091[/snapback][/div][div class=\'quotemain\'][!--quotec--]
Thanks for replying... but no, I don't understand :)
[/quote]

[code]function insertrow($order_num, $item_name, $item_price, $item_qty,$item,$inv_num)
{
list($order_num, $item_name, $item_price, $item_qty) =
split("~", $item);

mysql_query("INSERT into items
(inv_num, item_name, item_qty, item_price)
VALUES
('$inv_num','$item_name', '$item_qty', '$item_price')");
}[/code]

above code is just a function which inserts rows:
function name: insertrow();
input parameters: $ordernum, $itemname, $itemprice, $itemqty,[b]$item[/b],$invnum

$item = current item to be inserted.

let you have three items, which are $item1,$item2,$item3
now,
$item[1] = $item1;
$item[2] = $item2;
$item[3] = $item3;
$order_num[1][2][3] = $order_num1, $order_num2,$order_num3
$itemname.........
$itemprice.................
$itemqty.......................
$invnum............................

$number_of_items = 3; //total number of items to be inserted.
now just call that function
for($K=1;$K<=$number_of_items;$K++)
{
insertrow($ordernum[$K], $itemname[$K], $itemprice[$K], $itemqty[$K],$item[$K],$invnum[$K]);
}

enough? :)

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.