php comma separated value no inserting in php

Question

I am trying to simple insert comma separated value in table field.But I don't get any cause why it's not working.

<?php

$array = array('1', '2', '3');
$comma_separated = implode(",", $array);

echo $comma_separated; 

$sql = "INSERT INTO like(user_id,like_data)
VALUES ('1','$comma_separated')";

if ($connection->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $connection->error;
}

?>

Here like_data field I have taken varchar.

It is giving sql syntax error.

I think `like` is a reserved word! So put it in \`, like: INSERT INTO \`like` — Rizier123, Dec 03 '14 at 06:50
It's come from database connection. Like as $connection=mysqli("host","user","pass","db"); — Alimon Karim, Dec 03 '14 at 06:52

score 2 · Accepted Answer · answered Dec 03 '14 at 06:52

2

You have to put ` around LIKE since it's a reserved word in SQL! So it should look like this:

INSERT INTO `like`

answered Dec 03 '14 at 06:52

Rizier123

58,877
16
101
156

Voted you up because you were first to spot the issue and put it in a comment even though your answer came late and that the question is now closed :) – Hanky Panky Dec 03 '14 at 06:56
@Hanky웃Panky Thanks :D I always forget to mark a question as a Duplicate! And if i answered it i'm like asking my self: Wait, wasn't this question asked before. (Have to remember my self more to thing about this) – Rizier123 Dec 03 '14 at 06:58

score 1 · Answer 2 · answered Dec 03 '14 at 06:52

1

LIKE is a MySQL reserved keyword.

MySQL reserved Keywords

Solutions:

1) avoid using like as table name.

2) Add Database name before like: dbName.like

3) Add a backtick (`) against the like :

INSERT INTO `like`(user_id,like_data) VALUES ('1','$comma_separated')

answered Dec 03 '14 at 06:52

Pupil

23,834
6
44
66

haha !! oh !! Thank you. this is just an unconsciousness. – Alimon Karim Dec 03 '14 at 06:54

score 1 · Answer 3 · edited Dec 03 '14 at 06:57

1

You must not use the keywords for the table name

if you use them you just have to have them in backticks like this

INSERT INTO `like` (user_id,like_data) VALUES ('1','$comma_separated')

edited Dec 03 '14 at 06:57

Hanky Panky

46,730
8
72
95

answered Dec 03 '14 at 06:52

Jenno Richi Benat

671
5
23

php comma separated value no inserting in php

3 Answers3