首先是mssql_connect方式,这种方式比较方便,但是可能会遇到服务器没有安装mssql模块的情况。
$ms_host = "192.168.0.xx"; //主机
$ms_user = "sa"; //用户名
$ms_pass = "aa"; //密码
$ms_data = "test"; //MSSQL库名
$ms_connect = mssql_connect($ms_host, $ms_user, $ms_pass)
or die("Couldn't connect to SQL Server on
$$ms_host");
$ms_select = mssql_select_db($ms_data, $ms_connect)
or die("Couldn't open database
$ms_select");
$update
= "SELECT reportid
FROM ReportInfo
WHERE (report_goods_id =
'$id') ;";
$result = mssql_query($update);
return $result;
报错可能是:
(1) Call to undefined function
mssql_connect() :这是因为没有开启mssql模块。
①在php.ini中找到:
extension=php_mssql.dll,和extension