pdo mysql dsn,在数据库PDO中使用$ dsn字符串变量作为参数

Goal: to simply fetch array from a MySQL database.

Issue: I am using the $dsn "string variable" as a parameter in the PDO Statement but there appears to be an uncaught exception and it has something to do with invoking the driver or the (PDO->__construct) -- I am not sure. Do you have any ideas on how to fix the $dsn string variable or other areas of this code that would cause it to fail? Thanks in advance.

// Define Database Parameters

$dbhost = "localhost";

$dbname = "x";

$dbuser = "y";

$dbpass = "z";

// Invoke Driver (as a variable string)

$dsn = "mysql:host=$dbhost;dbname=$dbname";

// Connect to newly created db object

$dbh = new PDO($dsn, $dbuser, $dbpass);

// Set the PDO error mode to enable exceptions

$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);

// Execute query to the database

$sql = "SELECT * FROM a_aif_remaining";

$sth = $dbh->prepare($sql);

$sth->execute();

// Present results from query

print("PDO::FETCH_ASSOC: ");

print("Return next row as an array indexed by column name");

$result = $sth->fetch(PDO::FETCH_ASSOC);

print_r($result);

print("");

return $results;

// Close db connection

$dbh = NULL;

?>

解决方案

Put your code in a try catch block. And see the error message reported. An example of this below:

try

{

if ( !class_exists( 'PDO' ) )

throw new Exception( 'PHP without PDO' );

if ( array_search( PDO::getAvailableDrivers(), 'mysql' ) === false )

throw new Exception( 'PHP without PDO mysql driver' );

$dbh = new PDO( ... );

...

}

catch ( PDOException $e )

{

print $e->getMessage();

}

catch ( Exception $e )

{

print $e->getMessage();

}