Php - 调用未定义的函数mssql_query()
问题描述:
我已经使用以下代码php
代码来显示sql
表中的行数,但是我收到了错误消息。Php - 调用未定义的函数mssql_query()
Fatal error: Call to undefined function mssql_query()
in D:\wamp\www\thereport24\gp.php
on line 22
我的代码:
$conn = odbc_connect('gpcon','','');
if ($conn)
{
$query= "select * from SubscriberServices where SubscriptionGroupID like 'ms_gp_tr24bn_3333'";
$results = mssql_query($query);
$rows = mssql_fetch_array($results);
echo $rows[0];
mssql_close($con);
}
答
如果使用SQL Server,使用此代码。这适用于我:
<?php
$serverName = "serverName";
$options = array( "UID" => "sa", "PWD" => "Password", "Database" => "DBname");
$conn = sqlsrv_connect($serverName, $options);
if($conn) {
echo "Connection established.<br />";
$query="select * from SubscriberServices where SubscriptionGroupID like 'ms_gp_tr24bn_3333'";
$result = sqlsrv_query($conn,$query);
sqlsrv_close($conn);
}else{
echo "Connection could not be established.<br />";
die(print_r(sqlsrv_errors(), true));
}
?>
如果它返回“连接建立”。这意味着您正确安装了MS SQL驱动程序。
检查'extension = php_mssql.dll'是否已在您的机器上安装的php.ini和mssql中取消注释 – bigbobr 2014-11-08 12:18:56
@bigbobr,请检查extension = php_mssql.dll ...它已完成...已安装mssql .. 。但即时通讯相同的错误... – 2014-11-08 14:06:45
可能重复的[无法连接到从PHP脚本的SQL](http://*.com/questions/5753667/cant-connect-to-sql-from-php-script ) – Max 2014-11-08 17:19:02