The insert query is not inserting through my orders table

Question

This is the checkout code. my values of the query are not functioning. It's not inserting please help me fix this.

            $q = "select * from cart";
            $quer = mysqli_query($con, $q);

            while($q_row = mysqli_fetch_array($quer)){
            $order_id = $q_row['order_id'];
            $prod_id = $q_row['p_id'];

            //get p_id
            $p_id_q = "select * from products where prod_id = '$prod_id'";
            $run_products = mysqli_query($con, $p_id_q);
            $row_product = mysqli_fetch_array($run_products);
            $product_id = $row_product['prod_id'];
            $product_name = $row_product['prod_name'];


            $add_order = "insert into orders (order_id,p_id,prod_name,status) values ('$order_id','$prod_id','$prod_name','Pending')";
            $run_add = mysqli_query($con, $add_order);

            }
        }

        ?>

Check for errors. Since you're using mysqli, save yourself the headache and use prepared statements/parameter binding, or you're going to leave yourself wide open for SQL injection and issues with variable quoting. — aynber, Oct 10 '16 at 20:10
the error is the query "insert into" is not inserting to my orders table. — Michael, Oct 10 '16 at 20:14

score 0 · Answer 1 · answered Oct 10 '16 at 20:16

0

u have declared $product_name but using $prod_name in insert query

answered Oct 10 '16 at 20:16

Hassan Tahir

134
9

I tried but still did not inserting. – Michael Oct 10 '16 at 20:21
what are errors coming? – Hassan Tahir Oct 10 '16 at 20:26
i've click my check out button to insert all the values from the cart and it will be inserted in my orders table. that's what i want to do. i think it's in my query. – Michael Oct 10 '16 at 20:33
print the query by echo $add_order = "insert into orders (order_id,p_id,prod_name,status) values ('$order_id','$prod_id','$prod_name','Pending')"; and see the results – Hassan Tahir Oct 10 '16 at 20:35
Still not working sir. – Michael Oct 10 '16 at 20:47
what is the output of query?did u echo the query? – Hassan Tahir Oct 10 '16 at 20:53

The insert query is not inserting through my orders table

1 Answers1