21,886
社区成员
发帖
与我相关
我的任务
分享
$user = 'sa';
$password = 'sa';
$dbh = new PDO("sqlsrv:Server=192.168.1.15,1433;Database=dbname", $user , $password); //这行报错了
$stmt = $dbh->prepare("select * from users");
$stmt->execute();
while ($row = $stmt->fetch()) {
print_r($row);
}
unset($dbh);
unset($stmt);
<?php
$servern="127.0.0.1";
$coninfo=array("Database"=>"heroes","UID"=>"sa","PWD"=>"123456");
$conn=sqlsrv_connect($servern,$coninfo) or die (print_r(sqlsrv_errors(),true));
$stmt =sqlsrv_query($conn,"SELECT * FROM [User]");
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
print_r($row);
}
?>
try {
$hostname='192.168.1.15';
$port=1433;//端口
$dbname="dbname";//库名
$username="sa";//用户
$pw="sa";//密码
$dbh= new PDO("dblib:host=$hostname:$port;dbname=$dbname","$username","$pw");
} catch (PDOException $e) {
echo"Failed to get DB handle: ".$e->getMessage() ."n";
exit;
}
echo'connent MSSQL succeed';
$stmt = $dbh->prepare("select * from users");
$stmt->execute();
while ($row = $stmt->fetch()) {
print_r($row);
}
unset($dbh);
unset($stmt);
参考:http://www.php.net/manual/en/ref.pdo-dblib.php