Getting parse error: syntax error, unexpected T_LNUMBER in php?

Question

I am trying to insert serialize values into ac_services table but getting error:

syntax error, unexpected T_LNUMBER in C:\wamp\www\db-setup\steps\db-install-script.php on line 559

$insert_ac_services = "

INSERT INTO `ac_services` 
( `id` , `name` , `desc` , `duration` , `unit` , `paddingtime` , `cost` , `capacity` , `availability` , `business_id` , `category_id` , `staff_id` ) 
VALUES 
( 1, 'Default', 'this is default service.', 30, 'minute', 10, 15, 1, 'yes', 0, 0, 'a:1:{i:0;s:2:"1";}' ) ;
";

mysql_query($insert_ac_services);

I generated this php query by phpmyadmin. But not working, Any suggestion? Thanks...

Sherlock · Accepted Answer · 2012-08-31 13:45:22Z

6

You should escape the ".

'a:1:{i:0;s:2:\"1\";}' ) ;

answered Aug 31, 2012 at 13:45

Sherlock

7,6356 gold badges42 silver badges83 bronze badges

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

1 Comment

Frank Over a year ago

Some-times stacker rocks. I made it and my installer completed. Thanks so much...

Eric · Accepted Answer · 2012-08-31 13:55:26Z

2

Use a heredoc, so that you don't need to escape any quotes.

$insert_ac_services = <<<SQL

INSERT INTO `ac_services` 
( `id` , `name` , `desc` , `duration` , `unit` , `paddingtime` , `cost` , `capacity` , `availability` , `business_id` , `category_id` , `staff_id` ) 
VALUES 
( 1, 'Default', 'this is default service.', 30, 'minute', 10, 15, 1, 'yes', 0, 0, 'a:1:{i:0;s:2:"1";}' ) ;
SQL;

That way, you can paste any query in from php_my_admin without having to worry about escaping.

edited Aug 31, 2012 at 13:55

answered Aug 31, 2012 at 13:47

Eric

98.1k54 gold badges257 silver badges389 bronze badges

Comments

GeoffreyB · Accepted Answer · 2012-08-31 13:46:19Z

0

In your last field, you insert a:1:{i:0;s:2:"1";}. " is already open, and you close it here.

You should escape the ".

answered Aug 31, 2012 at 13:46

GeoffreyB

1,8394 gold badges21 silver badges36 bronze badges

Comments

TheTechGuy · Accepted Answer · 2015-07-23 14:54:55Z

0

I got the same error, in my case it was a silly typo error

retun 0; //r is missing in return

Was getting the same error

Parse error: syntax error, unexpected '0' (T_LNUMBER)

answered Jul 23, 2015 at 14:54

TheTechGuy

17.5k18 gold badges120 silver badges144 bronze badges

Collectives™ on Stack Overflow

Getting parse error: syntax error, unexpected T_LNUMBER in php?

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related