下面是一段早期php代码,由于php升级及sql server驱动升级
目前是php 5.2.14 + Sql serve 2008,所以有些用法不同了,像
$res = mssql_query($sql, $link);改为$res = sqlsrv_query($conn,$sql);但mssql_fetch_row不知道如何改?就这是句怎么改?
while ($row = mssql_fetch_row($res)){
$vals[strtolower(str_replace($search, '', $row[0]))] = (empty($row[1]) ? '0' : $row[1]);
}
#$res = mssql_query($sql, $link);
$res = sqlsrv_query($conn,$sql); $search = array(' ', '/sec', '(KB)', '/', '-'); while ($row = mssql_fetch_row($res)){
$vals[strtolower(str_replace($search, '', $row[0]))] = (empty($row[1]) ? '0' : $row[1]);
} $vals['buffercachehitratio'] = $vals['buffercachehitratio'] / $vals['buffercachehitratiobase'] * 100;
$vals['logcachehitratio'] = $vals['logcachehitratio'] / $vals['logcachehitratiobase'] * 100;
$vals['proccachehitratio'] = $vals['cachehitratio'] / $vals['cachehitratiobase'] * 100;
$vals['memoryhitratio'] = $vals['totalservermemory'] / $vals['targetservermemory'] * 100; unset($vals['buffercachehitratiobase'], $vals['logcachehitratiobase'], $vals['cachehitratiobase'], $vals['cachehitratio']);
目前是php 5.2.14 + Sql serve 2008,所以有些用法不同了,像
$res = mssql_query($sql, $link);改为$res = sqlsrv_query($conn,$sql);但mssql_fetch_row不知道如何改?就这是句怎么改?
while ($row = mssql_fetch_row($res)){
$vals[strtolower(str_replace($search, '', $row[0]))] = (empty($row[1]) ? '0' : $row[1]);
}
#$res = mssql_query($sql, $link);
$res = sqlsrv_query($conn,$sql); $search = array(' ', '/sec', '(KB)', '/', '-'); while ($row = mssql_fetch_row($res)){
$vals[strtolower(str_replace($search, '', $row[0]))] = (empty($row[1]) ? '0' : $row[1]);
} $vals['buffercachehitratio'] = $vals['buffercachehitratio'] / $vals['buffercachehitratiobase'] * 100;
$vals['logcachehitratio'] = $vals['logcachehitratio'] / $vals['logcachehitratiobase'] * 100;
$vals['proccachehitratio'] = $vals['cachehitratio'] / $vals['cachehitratiobase'] * 100;
$vals['memoryhitratio'] = $vals['totalservermemory'] / $vals['targetservermemory'] * 100; unset($vals['buffercachehitratiobase'], $vals['logcachehitratiobase'], $vals['cachehitratiobase'], $vals['cachehitratio']);
解决方案 »
- 求助:web service 电信的短信平台
- 页面表单数据通过AJAX传到后台,中文取不到值?为什么?
- 最近做一个登入功能遇到一个奇怪的错误
- 求一个正则表达式
- 深圳朋友寻找合作者,开发面向WEB3.0的人工智能项目。
- 求助:同一个页面中不同按钮显示不同DIV层效果
- smarty 模板循环生成的问题
- 为什么我用IE打开一个php论坛的安装程序(install.php)的时候不能运行,而是显示代码啊?见内容help!!!!!!!
- php4的cookie竟如此强大?我在禁用了ie的cookie之后,它仍然可以正常动作?
- 请教
- 将apahce作为IIS代理后,如何设置apache,将源请求ip转发到IIS
- 比较多的基础问题
while ($row = sqlsrv_fetch_array($res, SQLSRV_FETCH_NUMERIC){
谢谢,不过报错:Call to undefined function mssql_fetch_row() 这个函数mssql_fetch_row应该也变了,我没查到。
hnxxwyq能确定3楼和原代码同样的意思吗?另外,这句该怎么改呢?
list($server_version) = mssql_fetch_row(mssql_query("SELECT SERVERPROPERTY('productversion')"));谢谢
$vals[strtolower(str_replace($search, '', $row[0]))] = (empty($row[1]) ? '0' : $row[1]);
}// 这里这样打呢?
var_dump($vals);exit;
list($server_version) = mssql_fetch_row(mssql_query("SELECT SERVERPROPERTY('productversion')"));
改为:
list($server_version) = sqlsrv_fetch_array(sqlsrv_query($conn,"SELECT SERVERPROPERTY('productversion')"),SQLSRV_FETCH_NUMERIC);可就是一直报:
sqlsrv_query() expects parameter 1 to be resource, boolean given in xxx\scripts\ss_win_mssql.php on line 54