<?php
/**
* @author samsun
* @copyright 2007
* php使用mssql库,连接sql server数据库实例
*/
$server='ip地址或服务器名';
$username='数据库用户名';
$password='数据库密码';
$database='数据库名';
$conn=mssql_connect($server,$username,$password) or die("Couldn't connect to SQL Server on $server");
$db=mssql_select_db($database) or die("Couldn't open database $database");
?>
<?php
/**
* @author samsun
* @copyright 2007
* php使用ODBC连接sql server数据库实例
*/
$server='ip地址或服务器名';
$username='数据库用户名';
$password='数据库密码';
$database='数据库名';
$connstr = "Driver={SQL Server};Server=$server;Database=$database";
if ( !odbc_connect($connstr,$username,$password,SQL_CUR_USE_ODBC)){
echo "Couldn't connect to SQL Server on $server";
/*
$sql="UPDATE `admin` SET `name`='aaa'";
$rs=odbc_exec($conn,$sql);}
*/
}
else{
echo "Connect successfully!<br>";
}
?>
<?
/**
* 推荐!!!!!!!!!!!!!
* php使用PDO接口连接sql server数据库实例(PHP 5.2.4以上)
*/
$mssql_server = '20100416C';
$mssql_db = 'test';
$mssql_login = 'sa';
$mssql_pwd = 'sa';
$db = new PDO ('mssql:host='.$mssql_server.';dbname='.$mssql_db, $mssql_login, $mssql_pwd);
foreach ($db->query('SELECT * FROM client') as $row) {
print_r($row); //你可以用 echo($GLOBAL); 来看到这些值
}
?>