I have copied the PDO connection script directly from the php.net documentation, however, it fails to work, because it gets this error.
<?php
global $pdo = new PDO('mysql:host=localhost;dbname=pionear', "root", "");
?>
1 Answer
You cannot declare a variable in the global scope like that. You have to declare it as a normal variable and than access it through global (e.g. in a function):
$pdo = new PDO('mysql:host=localhost;dbname=pionear', "root", "");
function something() {
global $pdo;
$pdo->doSometing();
}
something();
You can check the documentation on the global keyword for more information. If you do not want to use the global keyword you can instead use $GLOBALS (which is a 'superglobal', thus no need to do global $pdo;).
6 Comments
Brad
Good catch. I'm surprised this threw a syntax error, but it makes sense.
Spechal
@Brad but a different one than the title, which only goes to show it was an edit to correct the obviousness of not a doc problem. It would have caused
Parse error: parse error, expecting `','' or `';'' in Command line code on line 1Brad
@Spechal It's definitely not a documentation problem as Jack's code was not copied/pasted from the docs as he asserted.
Brad
@Spechal He also added
global.
Qirel
Generally speaking, it's not a good idea to use global variables in the first place - they should be passed as arguments to the function, that way you have more control over which variables are in what scope.
|
PDO('dblib:host=your_hostname;dbname=your_db;charset=UTF-8', $user, $pass);