Getting SQL error while inserting the data into database using MySQL and PHP

Question

I am getting the following error while trying to insert data into database.

Error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Live Your Life Well'. Live Your Life Well' was a theme designed to encourage peo' at line 1

I am providing the query below:

INSERT phr_health_care set title='Mental Health Awareness',description='In 2010, the theme was 'Live Your Life Well'. Live Your Life Well' was a theme designed to encourage people to take responsibility for the prevention of mental health issues during times of personal challenge and stress. The message was to inform the public that many mental health problems could be avoided by striving toward and making positive lifestyle choices in the ways we act and think',status='1',image='4o2kgkpgu_awarenessdaycolorgen.jpg',date='2016-02-12 15:32:44'

How can I resolve this error?

Please put whitespaces after comma's and [Please read this excellent post on Stackoverflow, on when to use single and double quotes and backticks](http://stackoverflow.com/questions/11321491/when-to-use-single-quotes-double-quotes-and-backticks/11321508#11321508) — Werner, Feb 12 '16 at 10:27

Muhammad Husnain Tahir · Accepted Answer · 2016-02-12T10:38:29.947

1

if insert then

INSERT INTO table_name("column_names_separates_by_commas") VALUES ("values_for_columns_separated_by_commas");

if update then

UPDATE table_name SET column1="value1", column2="vaule2", columnN="valueN"

but following SQL is also executing fine.

INSERT phr_health_care set 
title='Mental Health Awareness',
description="In 2010, the theme was 'Live Your Life Well'. Live Your Life Well' was a theme designed to encourage people to take responsibility for the prevention of mental health issues during times of personal challenge and stress. The message was to inform the public that many mental health problems could be avoided by striving toward and making positive lifestyle choices in the ways we act and think",
status='1',
image='4o2kgkpgu_awarenessdaycolorgen.jpg',
date='2016-02-12 15:32:44'

this is exact query i tested by myself and it is executing fine.

edited Feb 12 '16 at 10:38

answered Feb 12 '16 at 10:18

Muhammad Husnain Tahir

1,009
1
15
28

@ Tahir : your deleted answer was perfect actually what i wanted. – satya Feb 12 '16 at 10:33
i solved this using `INSERT INTO table_name("column_names_separates_by_commas") VALUES ("values_for_columns_separated_by_commas");` this way. – satya Feb 12 '16 at 10:39
Glad i could help, Happy coding :) – Muhammad Husnain Tahir Feb 12 '16 at 10:40

score 1 · Answer 2 · edited Feb 12 '16 at 12:18

1

You are passing description '$newCustomerobj->description' with single quotes. You first add backslash like:

$description = addslashes($newCustomerobj->description);

Now pass this variable in your query.

edited Feb 12 '16 at 12:18

Alexei - check Codidact

22,016
16
145
164

answered Feb 12 '16 at 10:37

Gunjanvijayvergiya

41
3

Jenz · Answer 3 · 2016-02-12T10:17:07.250

The problem is with the quotes. You should escape the special characters using the \ character. Try with,

 INSERT phr_health_care set title='Mental Health 
Awareness',description='In 2010, the theme was \'Live Your Life Well\'. 
Live Your Life Well\' was a theme designed to encourage people to take 
responsibility for the prevention of mental health issues during times of
personal challenge and stress. The message was to inform the public that
 many mental health problems could be avoided by striving toward and 
making positive lifestyle choices in the ways we act and 
think',status='1',image='4o2kgkpgu_awarenessdaycolorgen.jpg',date='2016-
02-12 15:32:44'

score 0 · Answer 4 · answered Feb 12 '16 at 10:14

The following code should work, you'll need backslashes for quotes in your string. I've reformatted your code, this should now work.

INSERT `phr_health_care` SET `title` = 'Mental Health Awareness', 
`description` = 'In 2010, the theme was \'Live Your Life Well\'. Live Your 
Life Well' was a theme designed to encourage people to take responsibility for
 the prevention of mental health issues during times of personal challenge and 
stress. The message was to inform the public that many mental health problems 
could be avoided by striving toward and making positive lifestyle choices in 
the ways we act and think', `status` = '1', `image` = 
'4o2kgkpgu_awarenessdaycolorgen.jpg', `date` = '2016-02-12 15:32:44'

Hope this helps, thanks!

i am passing one one paragraph for the field `description`.here is my actual query `$sql="INSERT ".PREFIX."health_care set title='".$newCustomerobj->title."',description='".$newCustomerobj->description."',status='".$newCustomerobj->status."',image='".$newCustomerobj->image."',date='".date('Y-m-d H:i:s')."' ";` — satya, Feb 12 '16 at 10:17

score 0 · Answer 5 · answered Feb 12 '16 at 10:30

0

Its because of single quotes.

In MySQL, strings (field values) are enclosed with single quotes.

So, if single quote comes in the string itself, string breaks and upcoming words are considered as MySQL Reserved Keywords.

Use mysqli_real_escape_string()

answered Feb 12 '16 at 10:30

Pupil

23,834
6
44
66

Getting SQL error while inserting the data into database using MySQL and PHP

5 Answers5