How to append data in a mysql database using php [closed]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? As written, this question is lacking some of the information it needs to be answered. If the author adds details in comments, consider editing them into the question. Once there's sufficient detail to answer, vote to reopen the question.

Closed 10 years ago.

Improve this question

Please don't mark this as a duplicate since I have already read the following post but still can't understand this issue:

MySQL UPDATE append data into column

I want to append data when users post multiple times. I have a ecommerce site. Now, if the user wants to upload several products for sale, I can't store the information. how would I go about this? should I use UPDATE syntax plus a .= or should I use INSERT plus .= ? I have tried INSERT on my query but it doesn't append anything. and update just replaces the existing data with the new one.

please help me as I like to learn.

here is my code for query:

if(isset($_POST['submit'])) {
 $sql = $conn->query("INSERT INTO user(user_id, post_title, post_description) Values('{$user}', '{$productname}', '{$post_desc}')");     
 $sql .= $conn->query("INSERT INTO user(user_id, post_title, post_description) Values('{$user}', '{$productname}', '{$post_desc}')");     
    // or should I use the below update query?
 $sql .= $conn->query("UPDATE user SET post_title = '{$productname}', post_description = '{$post_desc}' WHERE user_id=$user");

}

seriously did you really had to give it a -1? like if I am trying to waste the communities time? Oh my God. — koroush
– koroush, Commented Aug 16, 2015 at 1:35
Whomever gave me a +1 thank you. However, I promise to learn how to ask questions here. but I am a newbie. So sorry. — koroush
– koroush, Commented Aug 16, 2015 at 1:46

gommb · Accepted Answer · 2015-08-16 02:10:53Z

0

just add a new row for each post:

$sql = $conn->query("INSERT INTO user(user_id, post_title, post_description) Values('$user', '$productname', '$post_desc')");

answered Aug 16, 2015 at 2:10

gommb

1,1071 gold badge7 silver badges21 bronze badges

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

12 Comments

koroush Over a year ago

I have already tried this but it wouldn't add a new row.

gommb Over a year ago

well it should so try adding echo $conn->error; after querying to see if there is an error.

koroush Over a year ago

i did ask for the error and I got this: Duplicate entry '4' for key 'PRIMARY' what does this mean? thanks.

gommb Over a year ago

that shouldn't be the problem but you can change the variable name just in case. but are you getting an error from what I just commented?

koroush Over a year ago

I think I know what it means. this is saying that you can't insert twice in the same field but my problem is that I need to create a new row for the same user but it wouldn't.

|

Collectives™ on Stack Overflow

How to append data in a mysql database using php [closed]

1 Answer 1

12 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

12 Comments

Linked

Related