Parse error trying parameterize $_SESSION into query

Asked Aug 01 '19 at 15:25

Active Aug 01 '19 at 15:25

Viewed 15 times

i'm new on PDO.

I need to parameterize $_SESSION['lang']

$query = "SELECT * FROM category WHERE cat_parent_id=:parentid AND cat_lang = '{$_SESSION['lang']}'";

$stmt->execute(array( 'parentid' => $cat_parent_id));

So i tried in this way:

$query = "SELECT * FROM category WHERE cat_parent_id=:parentid AND cat_lang = :id";
$stmt->execute(array( 'parentid' => $cat_parent_id), 'id' => $_SESSION['lang']);

but i have an parse error on execute: Parse error: syntax error, unexpected '=>' (T_DOUBLE_ARROW) in....

what's wrong? Thanks

asked Aug 01 '19 at 15:25

Ogum

1

You close the array before you start the id – aynber Aug 01 '19 at 15:25
ah ok, it works..i just don't understand why $_SESSION must be put inside the array, anyway thanks – Ogum Aug 01 '19 at 15:29
You can use `[ ... ]` as an alternative to `array( ... )` in newer versions of PHP. – tadman Aug 01 '19 at 16:00

Parse error trying parameterize $_SESSION into query

0 Answers0