php连接mysql测试脚本,PHP连接SQL server数据库测试脚本运行实例

以下是php7上的测试 sqlsrv扩展

header("Content-type: text/html; charset=utf-8");

$serverName = "192.168.0.1"; //数据库服务器地址

$uid = "site_user"; //数据库用户名

$pwd = "zkJ1246g"; //数据库密码

$connectionInfo = array("UID"=>$uid, "PWD"=>$pwd, "Database"=>"db_site");

$conn = sqlsrv_connect( $serverName, $connectionInfo);

if( $conn == false)

{

echo "连接失败！";

die( print_r( sqlsrv_errors(), true));

}else{

echo "连接成功！";

}

#$query = sqlsrv_query($conn, "select * from 数据库表");

#while($row = sqlsrv_fetch_array($query))

#{

# print_r($row);

#}

?>

以下是php5上的测试dblib扩展

try {

$hostname = "192.168.17";

$dbname = "lee";

$username = "le2r";

$pwd = "le52";

$dsn="dblib:host=$hostname;dbname=$dbname;charset=UTF-8";

$conn = new PDO ($dsn,$username,$pwd);

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

echo "mssql database connnection sucessed!\n";

} catch (PDOException $e) {

echo "Failed to get DB handle: " . $e->getMessage() . "\n";

exit;

}

?>

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持脚本之家。