我有一个PHP脚本,用于连接MySQL数据库。使用mysql_connect连接完美运行,但是尝试使用PDO时,出现以下错误:
我用来连接的代码如下:
感谢您的提前帮助。
SQLSTATE[HY000] [2005] Unknown MySQL server host 'hostname' (3)
我用来连接的代码如下:
<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);
$hostname_localhost ="hostname";
$database_localhost ="dbname";
$username_localhost ="user";
$password_localhost ="pass";
$user = $_GET['user'];
$pass = $_GET['pass'];
try{
$dbh = new PDO("mysql:host=$hostname_localhost;dbname=$database_localhost",$username_localhost,$password_localhost);
echo 'Connected to DB';
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$stmt = $dbh->prepare("SELECT check_user_company(:user,:pass)");
$stmt = $dbh->bindParam(':user',$user,PDO::PARAM_STR, 16);
$stmt = $dbh->bindParam(':pass',$pass,PDO::PARAM_STR, 32);
$stmt->execute();
$result = $stmt->fetchAll();
foreach($result as $row)
{
echo $row['company_id'].'<br />';
}
$dbh = null;
}
catch(PDOException $e)
{
echo $e->getMessage();
}
?>
感谢您的提前帮助。
$hostname_localhost
我还在语句中加入了端口号,在添加了port=$port_localhost
后它就起作用了。 - user1337210