Parse error: syntax error, unexpected '', 0);''

Question

i have this error:

Parse error: syntax error, unexpected '', 0);'' (T_CONSTANT_ENCAPSED_STRING) on line 18 (my first INSERT)

but i cant find the prob... can you help?

<?php


$link = mysql_connect('localhost', 'user', '');
if (!$link) {
    die('Connexion impossible : ' . mysql_error());
}
$db_selected = mysql_select_db('woe_site', $link);
if (!$db_selected) {
   die ('Impossible de sélectionner la base de données : ' . mysql_error());
}

$query1 = 'SELECT account FROM vote_voteurs WHERE account NOT IN (SELECT account FROM boutique_clients);';

$result1 = mysql_query($query1, $link);

while ($row1 = mysql_fetch_assoc($result1)) {
    $query2 = 'INSERT INTO boutique_clients (account, credit, date_ouverture, last_achat, nb_achats) VALUES ('.$row1['account'].', 0, NOW(), '', 0);';
    mysql_query($query2, $link);
}

$query3 = 'SELECT account FROM vote_voteurs';
$resul3 = mysql_query($query3 , $link);
while ($row3 = mysql_fetch_assoc($result3)) {
    $query4 = 'UPDATE boutique_clients SET credit = credit+ (SELECT (totalVotes+monthVotes) *0.0025 FROM vote_voteurs WHERE account='.$row3['account'].') WHERE account = '.$row3['account'].';';
    mysql_query($query4, $link);
}

mysql_close($link);

$query2 = 'INSERT INTO boutique_clients (account, credit, date_ouverture, last_achat, nb_achats) VALUES (".$row1['account'].", 0, NOW(), "", 0)'; — Krishna Gupta, Dec 08 '15 at 07:21

score 1 · Answer 1 · answered Dec 08 '15 at 07:21

based on the code you gave

on line 18 change:

$query2 = 'INSERT INTO boutique_clients (account, credit, date_ouverture, last_achat, nb_achats) VALUES ('.$row1['account'].', 0, NOW(), '', 0);';

to

$query2 = 'INSERT INTO boutique_clients (account, credit, date_ouverture, last_achat, nb_achats) VALUES ('.$row1['account'].', 0, NOW(), "", 0);';

change the single quotes to double qoutes

score 1 · Answer 2 · edited Dec 08 '15 at 07:56

1

Have a look at line 18. You have unescaped single quotes in your string literal.

Try with this one:

$query2 = "INSERT INTO boutique_clients (account, credit, date_ouverture, last_achat, nb_achats) VALUES ('".$row1['account']."', 0, NOW(), '', 0);";

edited Dec 08 '15 at 07:56

Lino

19,604
6
47
65

answered Dec 08 '15 at 07:23

Christian Kiewiet

869
6
19

score 1 · Answer 3 · answered Dec 08 '15 at 07:38

change this line

$query2 = 'INSERT INTO boutique_clients (account, credit, date_ouverture, last_achat, nb_achats) VALUES ('.$row1['account'].', 0, NOW(), '', 0);';

to

 $query2 = 'INSERT INTO boutique_clients (account, credit, date_ouverture, last_achat, nb_achats) VALUES ('.$row1['account'].', 0, NOW(), "", 0);';

you can use this link to see how to work with quotes

Krishna Gupta · Answer 4 · 2015-12-08T07:26:06.937

0

Update your insert query as like :

$query2 = "INSERT INTO boutique_clients (account, credit, date_ouverture, last_achat, nb_achats) VALUES ('$row1["account"]', 0, NOW(), '', 0)";

edited Dec 08 '15 at 07:26

answered Dec 08 '15 at 07:23

Krishna Gupta

695
4
15

This is not working because you are mixing single and double quotes. Your string begins with single quote and ends with double quote. – mario.van.zadel Dec 08 '15 at 07:25
1

I were updating my query now check it – Krishna Gupta Dec 08 '15 at 07:27

score 0 · Answer 5 · answered Dec 08 '15 at 07:23

There are 3 possibilities to solve it:

Change

$query2 = 'INSERT INTO boutique_clients (account, credit, date_ouverture, last_achat, nb_achats) VALUES ('.$row1['account'].', 0, NOW(), '', 0);';

to

$query2 = 'INSERT INTO boutique_clients (account, credit, date_ouverture, last_achat, nb_achats) VALUES ('.$row1['account'].', 0, NOW(), \'\', 0);';

or

$query2 = 'INSERT INTO boutique_clients (account, credit, date_ouverture, last_achat, nb_achats) VALUES ('.$row1['account'].', 0, NOW(), "", 0);';

or

$query2 = "INSERT INTO boutique_clients (account, credit, date_ouverture, last_achat, nb_achats) VALUES (".$row1['account'].", 0, NOW(), '', 0);";

score 0 · Answer 6 · answered Dec 08 '15 at 07:24

0

'', 0 should be "", 0.

You are using single quotes inside another single quotes which is breaking the string.

answered Dec 08 '15 at 07:24

Ashish Choudhary

2,004
1
18
26

score 0 · Answer 7 · answered Dec 08 '15 at 07:27

On line 18 you you have inclose sql query by single inverted coma, in same line during insert value you use again single inverted coma sot that inside value single inverted coma break you line. so
either
 $query2 = 'INSERT INTO boutique_clients (account, credit, date_ouverture, last_achat, nb_achats) VALUES ('.$row1['account'].', 0, NOW(), "", 0);';
    mysql_query($query2, $link);
Or
 $query2 = "INSERT INTO boutique_clients (account, credit, date_ouverture, last_achat, nb_achats) VALUES ('.$row1['account'].', 0, NOW(), '', 0);";
    mysql_query($query2, $link);

Parse error: syntax error, unexpected '', 0);''

7 Answers7