Php bindParam error

Question

I am getting a error on my server on my MAMP server it worked but on my live server there is an error:

Parse error: syntax error, unexpected '[', expecting ')'

How to fix this? and what is wrong or why?

My code:

try {
    $sql = "INSERT INTO collection (name, numberO, city) VALUES (:name, :numberO, :city)";
    $statement = $db->prepare($sql);
    $sth = $statement->execute( ['name' => $name, 'numberO' => $number, 'city' => $city] );
} catch(PDOExepction $e) {
    echo "SORRY";
    exit;
}

You're on an older PHP version that doesn't support the [] array shortcut notation. Use ->execute(array(....)) instead. — Marc B
– Marc B, Commented Aug 21, 2014 at 16:59

MH2K9 · Accepted Answer · 2014-08-21 17:08:15Z

3

Try this

$sth = $statement->execute(array(
    ':name' => $name, 
    ':numberO' => $number, 
    ':city' => $city
));

As of PHP 5.4 you can also use the short array syntax, which replaces array() with []. More about PHP array

edited Aug 21, 2014 at 17:08

answered Aug 21, 2014 at 17:01

MH2K9

12.1k7 gold badges34 silver badges49 bronze badges

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

Comments

Awlad Liton · Accepted Answer · 2014-08-21 16:59:42Z

1

Check your server's php version.

You need PHP 5.4+ to use shorthand arrays

asp per PHP Doc:

As of PHP 5.4 you can also use the short array syntax, which replaces array() with [].

1) Update php version or
2) Change short hand array syntax

answered Aug 21, 2014 at 16:59

Awlad Liton

9,3513 gold badges30 silver badges53 bronze badges

1 Comment

Pullapooh Over a year ago

The server version is: 5.3.28

Collectives™ on Stack Overflow

Php bindParam error

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related