Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Apr 2011
    Posts
    95
    Thanks
    13
    Thanked 1 Time in 1 Post

    insert data from cart to mysql

    Hello I have a cart and i want to insert some users data into mysql in 2 different tables.

    My basic cart code is this

    PHP Code:
    <?php
    $cartOutput
    ="";
    $cartTotal="";
    if(!isset(
    $_SESSION["cart_array"])||count($_SESSION["cart_array"])<1){
        
    $cartOutput="<h2 align='center'>your shopping cart is empty</h2>";
    }else{
        
    $i=0;
        foreach(
    $_SESSION["cart_array"]as $each_item){
            
    $item_id=$each_item['item_id'];
            
    $sql=mysql_query("SELECT productid,productname,price,image FROM products WHERE productid='$item_id' LIMIT 1");
            while(
    $rowmysql_fetch_array($sql)){
                
    $productname=$row['productname'];
                
    $price=$row['price'];
                
    $image=$row['image'];
                
    $productid=$row['productid'];
            }
            
    $pricetotal=number_format($price*$each_item['quantity'],2,".","");
            
    $cartTotal=number_format($pricetotal+$cartTotal,2,".","");
            
            
    $cartOutput.="<tr>";
            
    $cartOutput.='<td><img src="images/site pic 2/mysql/'.$image.'" width="45" height="45" /></td>';
            
    $cartOutput.='<td>'$productid.'</td>';
            
    $cartOutput.='<td>'$productname.'</td>';
            
    $cartOutput.='<td>$'$price.'</td>';
            
    $cartOutput.='<td><form action="mycart.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="mycart.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++;
            
        }
        
        
    $cartTotal="<div align='center'>Cart Total: $".$cartTotal."</div>";
    }
    ?>

    When the user wish to buy the products i display him a form to complete some data like address/credit card/payment method/and card type.
    i have method post and action orderdata.php.


    I Tried to pass some values with sessions but i am not really experienced.

    My current orderdata.php looks like this


    PHP Code:

    <?php
    session_start
    ();

    $productid=$_SESSION['productid'] ;
    $pricetotal=$_SESSION['pricetotal'] ;
    $price=$_SESSION['price'] ;
    $cartTotal=$_SESSION['cartTotal'] ;
    $each_item=$_SESSION['quantity'] ;


     
    $con mysql_connect("localhost","root","");
     if (!
    $con)
       {
       die(
    'Could not connect: ' mysql_error());
       }
     
    mysql_select_db("mypc"$con);
     
    $sql="INSERT INTO sales (address, paymethod, creditcard,credittype,totalprice)
     VALUES
     ('$_POST[address]','$_POST[RadioGroup1]','$_POST[pass]', '$_POST[type]','$cartTotal')"
    ;
     
     
    $sql="INSERT INTO orders (productid, quantity, unitprice, pricetotal)
     VALUES
     ('$productid','$each_item','$price','$pricetotal')"
    ;
     
     
    if (!
    mysql_query($sql,$con))
       {
       die(
    'Error: ' mysql_error());
       }
     echo 
    "1 record added";
     
    mysql_close($con)
     
    ?>

  • #2
    New Coder
    Join Date
    Apr 2011
    Posts
    95
    Thanks
    13
    Thanked 1 Time in 1 Post
    Ok i almosd done everything tnx anyway
    Last edited by garevn; 05-23-2011 at 11:23 PM.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •