need HELP / updating stock

[Raja89]

i am facing trouble with retrieving session variables data as i want to insert these data into my database.

Code: Select all

<?php
function checkout()
{

$datetime = date_create();
$datetime = date_timestamp_get($datetime);
$total_amount = $_SESSION['total_price'];

$user = $_SESSION['my_username'];
$pass = $_SESSION['my_password'];

$sql="SElECT id FROM customer where customer.username='$user' AND customer.password='$pass'";
$customser_id = mysql_query($sql);

$sql2 = "INSERT INTO order_header  (customer_id) VALUES ( '$customser_id ')";
$result2 = mysql_query($sql2);

$_SESSION['my_order'] = $result2['id'];

print_r ($_SESSION['cart']);

   foreach ($_SESSION['cart'] as $id => $quantity):
   $product = get_product($id);

   $product_id = $product['id'];
   $product_quantity = $quantity;
   $sub_total = $product['unit_price'] * $product_quantity;
 
    echo "<br>".$product_id."-".$product_quantity."-".$sub_total;
    echo"</br>";
   
   $sql3 = "INSERT INTO order_details ('product_id', 'product_quantity', 'sub_total', 'order_id')
   VALUES ('".$product['id']."', '".$quantity."', '".$product['unit_price'] * $product_quantity."', '1')";
   mysql_query($sql3);

   endforeach;

}
?>


I am able to print the $_SESSION['username'], $_SESSION['password'] and $_SESSION['cart'].
However the sql query does not return any values.

any help would be kindly appreciated as i am still a newbie to php.

[lokanath7]

change this line
$sql2 = "INSERT INTO order_header (customer_id) VALUES ( '$customser_id ')";

to

$sql2 = "INSERT INTO order_header (customer_id) VALUES ( '$customser_id')";

if still have issues then give the full supporting code.

[Raja89]

with much respect & appreciation there's nothing change in what u suggested.

[lokanath7]

mark the last part of the query as there is an extra space in the code and i told u to delete that space...
inly this much change i hv suggested u.

[Raja89]

Thank u so much for ur help.
I been able to solve the problem on my own.

[mikeyarde]

It is more important that to update the stock so you can see which product is your current product and sale more also you can know the market of your product. it is also useful to maintain the sales and profit and loss account.