下面是一段早期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']);
解决方案 »
- session_unset()与session_destroy()的用法
- 提问: 这个网站的流媒体是如何实现的,采用的是什么方法
- PHP正则Dz7论坛发帖应用(preg_match_all)
- 急:安装Zend Optimizer,在选择C:\Inetpub之后点NEXT就没有反应了,怎么解啊?
- php 读取数据库表的 基础问题?
- 关于分割字符串问题!
- 急求一段验证用户登录验证的代码
- to ekeen(hiekeen) for vbb 2.2.5
- php 中把一个array(255,11,22,2,0...)转换成图片输出
- 'PDOException' with message 'SQLSTATE[HY000] [14] unable to open database file'
- 将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