Insert Into Multiple Value MySQL & PHP

Question

I'm completely new on PHP & MySQL. I manage to add 1 value from table "products" but failed to add another one.

There is two row within products table like below:

products:

product_name
product_price

My code:

 $sql = "INSERT INTO products (product_name, user_id) VALUES (?, ?)";
 $statement = $conn->prepare($sql);
 $statement->bind_param('si', $_POST['product_name'], $_SESSION['user_id']);

 if ($statement->execute()) {
   redirect_to("/create.php?created=true");
 } else {
   echo "Error: " . $conn->error;
 }

What is the correct way to add another row which is product_price ?

Are you asking how to add another database field or column? Database fields or columns are not rows. Fields are like id, name, price, etc. Rows contain your data. — dmikester1
– dmikester1, Commented Oct 19, 2018 at 18:14
Do you want to use this like an "add to cart" feature where the first click populates with quantity 1 and the second adds +1 to that? — tadman
– tadman, Commented Oct 19, 2018 at 19:33

Geshe · Accepted Answer · 2018-10-19 20:06:32Z

1

if "porducts" table has a variable as 'product_price' then you can just update with it's primary id. every table must have primary id for identification.

edited Oct 19, 2018 at 20:06

answered Oct 19, 2018 at 18:10

Geshe

7992 gold badges11 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Simão Garcia Over a year ago

Nope. Read what they wrote and take your conclusions.

dmikester1 Over a year ago

@SimãoGarcia have to been to w3fools lately? It's pretty empty and they are simply linking to a web.archive page.

tadman Over a year ago

Please don't link to w3schools. We're still repairing the damage it's done to the programming community with its hazardously out-dated advice. The official documentation for the UPDATE statement is vastly better.

Geshe Over a year ago

@tadman you are right. sorry me too new user in stackoverflow. and i will edit comments.

tadman Over a year ago

Thanks! Just trying to keep people from falling into that trap.

Argenis Barraza Guillén · Accepted Answer · 2018-10-19 18:08:44Z

0

You only have to put the column and the value on the SQL statement

$sql = "INSERT INTO products(product_name,product_price,user_id) VALUES('productNameValue','productoPriceValue',user_id);

Tell me if this works for you

answered Oct 19, 2018 at 18:08

Argenis Barraza Guillén

365 bronze badges

Collectives™ on Stack Overflow

Insert Into Multiple Value MySQL & PHP

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related