PHP/SQL error which executing

Question

<?php
$dbhost="host";
$dbusername="user";
$dbpassword="pass";
$dbname="db";

try {
  # MySQL with PDO_MYSQL
  $DBH = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbusername, $dbpassword);
  echo "Connected Successfully";
}
catch(PDOException $e) {
    echo $e->getMessage();
}

#  close the connection  
$DBH = null; 
?>

When running it in my server, i get the following error:

Parse error: parse error, unexpected '{' in /home/web/i/htdocs/search/pdo.php on line 7

I am trying to do a test to use PDO to save variable to a database and was advised PDO was the way to securely store variable to a database. Please let me know why I am receiving the error and how to resolve it.

Is this the full code your running on a separate PHP file - no other includes? — TheBlackBenzKid
– TheBlackBenzKid, Commented Mar 5, 2013 at 16:51

Francois Bourgeois · Accepted Answer · 2013-03-05 16:47:04Z

3

I've run your code and do not get a parse error. It looks all fine. Maybe you did not run the same as you posted here.

answered Mar 5, 2013 at 16:47

Francois Bourgeois

3,7185 gold badges34 silver badges41 bronze badges

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

2 Comments

Si8 Over a year ago

I checked the PHP parser and everything is fine. Maybe it's the web server?

TheBlackBenzKid Over a year ago

Is this now resolved as you have marked it as answered yet continue to post.

Collectives™ on Stack Overflow

PHP/SQL error which executing

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related