Chet Posted April 9, 2006 Share Posted April 9, 2006 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~quantityitem2=name~price~quantityitem3=name~price~quantityand so on...So if the customer purchases 3 items it would post like this:item1=Mens Polo Shirt~25.00~2item2=Ladies Sport Socks~10.00~3item3=Mens Tie~20.00~1I 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 tablelist($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 Quote Link to comment Share on other sites More sharing options...
karthikeyan_coder Posted April 9, 2006 Share Posted April 9, 2006 its very simplejust 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. Quote Link to comment Share on other sites More sharing options...
Chet Posted April 9, 2006 Author Share Posted April 9, 2006 [!--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 :) Quote Link to comment Share on other sites More sharing options...
karthikeyan_coder Posted April 9, 2006 Share Posted April 9, 2006 [!--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,$item3now,$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 functionfor($K=1;$K<=$number_of_items;$K++){insertrow($ordernum[$K], $itemname[$K], $itemprice[$K], $itemqty[$K],$item[$K],$invnum[$K]);}enough? :) Quote Link to comment Share on other sites More sharing options...
Chet Posted April 9, 2006 Author Share Posted April 9, 2006 Guess I'm not ready for this php stuff yet..Thanks for taking the time to try to help out. Quote Link to comment Share on other sites More sharing options...
karthikeyan_coder Posted April 10, 2006 Share Posted April 10, 2006 ok np. :) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.