Jump to content

Archived

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

Chet

Insering Multiple Rows In DB

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

Share this post


Link to post
Share on other sites
its very simple
just put your codes inside a function like insertrow();

then call that function number of times with items like insertrow(item1); insertrow(item2) ... insertrow(itemN);

i hope you can got my idea? enough?

Thank you,
Karthi Keyan.

Share this post


Link to post
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 :)

Share this post


Link to post
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? :)

Share this post


Link to post
Share on other sites
Guess I'm not ready for this php stuff yet..
Thanks for taking the time to try to help out.

Share this post


Link to post
Share on other sites

×

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.