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
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 :)
Link to comment
Share on other sites

[!--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? :)
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • 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.