PHP string is giving syntax error

Question

Why am I getting this type of error in this string:

$query="SELECT Name,Lastname FROM $_SESSION['SESS_MAIN_BASE'] s,
     WHERE s.FK_ID_user={$id_user}
     AND DATE(s.time) BETWEEN '".$d_year1."-".$d_month1."-".$d_day1."' AND '".$d_year2."-".$d_month2."-".$d_day2."'";

Remove teh quotes from the array keys. When using arrays in a double-quoted string, the quoted keys will issue warnings. That or switch to the {} encapsulation notation. — Marc B
– Marc B, Commented Oct 19, 2012 at 17:44

Baba · Accepted Answer · 2012-10-19 18:07:51Z

8

Replace

 $query="SELECT Name,Lastname FROM $_SESSION['SESS_MAIN_BASE'] s,

With

$query="SELECT Name,Lastname FROM {$_SESSION['SESS_MAIN_BASE']} s,

Better Still

$query= "SELECT Name,Lastname FROM %s s, WHERE s.FK_ID_user= '%d' AND DATE(s.time) BETWEEN '%d-%d-%d' AND '%d-%d-%d'";
$query = sprintf($query,$_SESSION['SESS_MAIN_BASE'],$id_user,$d_year1 ,$d_month1,$d_day1,$d_year2,$d_month2,$d_day2);

edited Oct 19, 2012 at 18:07

answered Oct 19, 2012 at 17:41

Baba

95.3k29 gold badges172 silver badges222 bronze badges

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

6 Comments

user123_456 Over a year ago

I am still getting error on this place: WHERE s.FK_ID_user= ''

user123_456 Over a year ago

I checked that I am receiving a number as value $id_user but error still persists

user123_456 Over a year ago

With %d I am getting only 0 (zero)

Baba Over a year ago

What is the value of var_dump($_SESSION['SESS_MAIN_BASE'])

Baba Over a year ago

That has nothing to do with the question or error above .... PHP string is giving syntax error

|

phpisuber01 · Accepted Answer · 2012-10-19 17:42:18Z

1

Change

$_SESSION['SESS_MAIN_BASE']

to

{$_SESSION['SESS_MAIN_BASE']}

$_SESSION is becoming blank because the [] is a string.

answered Oct 19, 2012 at 17:42

phpisuber01

7,7453 gold badges25 silver badges26 bronze badges

Comments

justderb · Accepted Answer · 2012-10-19 17:42:09Z

0

Try this:

$query="SELECT Name,Lastname FROM {$_SESSION['SESS_MAIN_BASE']} s, ";
$query.="WHERE s.FK_ID_user={$id_user}";
$query.="AND DATE(s.time) BETWEEN '".$d_year1."-".$d_month1."-".$d_day1."' AND";
$query.="'".$d_year2."-".$d_month2."-".$d_day2."'";

answered Oct 19, 2012 at 17:42

justderb

2,8541 gold badge27 silver badges38 bronze badges

1 Comment

Marc B Over a year ago

Pointless. This changes nothing and just makes things a little harder to read. I won't -1 since you did put in the {}, which will fix the problem.

Alexey Sidorov · Accepted Answer · 2012-10-19 17:42:41Z

0

$query="SELECT Name,Lastname FROM $_SESSION['SESS_MAIN_BASE'] s,
     WHERE s.FK_ID_user=$id_user
     AND DATE(s.time) BETWEEN '$d_year1-$d_month1-$d_day1' AND '$d_year2-$d_month2-$d_day2'";

answered Oct 19, 2012 at 17:42

Alexey Sidorov

8661 gold badge10 silver badges17 bronze badges

Collectives™ on Stack Overflow

PHP string is giving syntax error

4 Answers 4

6 Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

6 Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related