php连接sqlserver数据库
<?php/*
* Created on 2012-8-8
*
* To change the template for this generated file go to
* Window - Preferences - PHPeclipse - PHP - Code Templates
*/
//$server = "172.**.*.**";
//$username = "sa";
//$password = "123456";
//$server = "172.**.*.**";
//$username = "sa";
//$password = "as";
//$database = "test";
/*php5.2.17*/
//$conn = mssql_connect($server, $username, $password) or die("Couldn't connect to SQL Server on $server");
//
//print ("Connected successfully");
//$db = mssql_select_db($database) or die("Couldn't open database $database");
//$sql = "select * from user1";
//$rows = mssql_query($sql);
//while ($rs = mssql_fetch_assoc($rows)) {
//echo $rs['name'] . "<br>";
//}
//$sql = "insert user1(name) values('中国130123456')";
//$rows = mssql_query($sql);
/*php5.3.6*/
$serverName = "172.**.*.**";
$uid = "sa";
$pwd = "123456";
//$serverName = "localhost";
//$uid = "sa";
//$pwd = "as";
$connectionInfo = array (
"UID" => $uid,
"PWD" => $pwd,
"Database" => "SqlTest"
);
$conn = sqlsrv_connect($serverName, $connectionInfo);
if ($conn == false) {
echo "连接失败！";
die(print_r(sqlsrv_errors(), true));
}else{
print ("Connected successfully");
}
$sql = "select * from emp";
$stmt = sqlsrv_query($conn,$sql);
if( $rows === false )
{
echo "Error in statement preparation/execution.\n";
die( print_r( sqlsrv_errors(), true));
}
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC))
{
echo $row['ename']."\n";
}
//$sql = "insert user1(name) values('中国')";
//$rows = sqlsrv_query($conn,$sql);
?>
页:
[1]