// SQL server connection information
$sql_details = array(
'user' => 'root',
'pass' => 'root',
'db' => 'table_demo',
'host' => 'localhost'
);
static function sql_connect ( $sql_details )
{
try {
$db = @new PDO(
"mysql:host={$sql_details['host']};dbname={$sql_details['db']}",
$sql_details['user'],
$sql_details['pass'],
array( PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION )
);
}
catch (PDOException $e) {
self::fatal(
"An error occurred while connecting to the database. ".
"The error reported by the server was: ".$e->getMessage()
);
}
return $db;
}
以上链接SQL server数据库的代码,如何写成链接mysql数据库的呢?
static function sql_connect ( $sql_details )
{
try {
$db = @new PDO("mysql:host=".$sql_details['host'].";port=".$sql_details['port'].";dbname=".$sql_details['db'].";charset=".$sql_details['charSet'];, $sql_details['user'],$sql_details['pass'],array( PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION ));
}
catch (PDOException $e) {
self::fatal(
"An error occurred while connecting to the database. ".
"The error reported by the server was: ".$e->getMessage()
);
}
return $db;
}
$sql_details = array(
'user' => 'root',
'pass' => 'root',
'db' => 'table_demo',
'host' => 'localhost',
'port' => 3306,
'charSet' => 'utf8'
);
试试看吧,要保证已经开启了PDO链接方式,就是到php.ini配置文件中 注销掉extension=php_pdo_mysql.dll 前面的分号,并且重启服务
这只是一个变量吧,存取对应数据库链接信息,改成你mysql对应的username、password、database和host就好了。
PDO 提供的是一个数据访问抽象层,不管使用哪种数据库,都可以用相同的函数(方法)来查询和获取数据。因此换个MySQL服务器的连接信息(数据库用户名、密码、端口、数据库名、服务器IP地址)就可以了。