<code class="language-php hljs has-numbering" style="box-sizing: border-box; font-family: 'Source Code Pro', monospace; font-size: 12.6px; padding: 0px; color: inherit; white-space: pre; border-radius: 0px; display: block; word-wrap: normal; background: transparent;"><span class="hljs-comment" style="box-sizing: border-box; margin: 0px; padding: 0px; font-weight: normal; color: rgb(136, 0, 0);">// here's a rough replacement using mysqli:</span> <span class="hljs-comment" style="box-sizing: border-box; margin: 0px; padding: 0px; font-weight: normal; color: rgb(136, 0, 0);">// 错略的使用mysqli替换</span> <span class="hljs-keyword" style="box-sizing: border-box; margin: 0px; padding: 0px; font-weight: normal; color: rgb(0, 0, 136);">if</span> (!function_exists(<span class="hljs-string" style="box-sizing: border-box; margin: 0px; padding: 0px; font-weight: normal; color: rgb(0, 136, 0);">'mysql_result'</span>)) { <span class="hljs-function" style="box-sizing: border-box; margin: 0px; padding: 0px; font-weight: normal;"><span class="hljs-keyword" style="box-sizing: border-box; margin: 0px; padding: 0px; font-weight: normal; color: rgb(0, 0, 136);">function</span> <span class="hljs-title" style="box-sizing: border-box; margin: 0px; padding: 0px; font-weight: normal;">mysql_result</span><span class="hljs-params" style="box-sizing: border-box; margin: 0px; padding: 0px; font-weight: normal; color: rgb(102, 0, 102);">(<span class="hljs-variable" style="box-sizing: border-box; margin: 0px; padding: 0px; font-weight: normal; color: rgb(102, 0, 102);">$result</span>, <span class="hljs-variable" style="box-sizing: border-box; margin: 0px; padding: 0px; font-weight: normal; color: rgb(102, 0, 102);">$number</span>, <span class="hljs-variable" style="box-sizing: border-box; margin: 0px; padding: 0px; font-weight: normal; color: rgb(102, 0, 102);">$field</span>=<span class="hljs-number" style="box-sizing: border-box; margin: 0px; padding: 0px; font-weight: normal; color: rgb(0, 102, 102);">0</span>)</span> {</span> mysqli_data_seek(<span class="hljs-variable" style="box-sizing: border-box; margin: 0px; padding: 0px; font-weight: normal; color: rgb(102, 0, 102);">$result</span>, <span class="hljs-variable" style="box-sizing: border-box; margin: 0px; padding: 0px; font-weight: normal; color: rgb(102, 0, 102);">$number</span>); <span class="hljs-variable" style="box-sizing: border-box; margin: 0px; padding: 0px; font-weight: normal; color: rgb(102, 0, 102);">$row</span> = mysqli_fetch_array(<span class="hljs-variable" style="box-sizing: border-box; margin: 0px; padding: 0px; font-weight: normal; color: rgb(102, 0, 102);">$result</span>); <span class="hljs-keyword" style="box-sizing: border-box; margin: 0px; padding: 0px; font-weight: normal; color: rgb(0, 0, 136);">return</span> <span class="hljs-variable" style="box-sizing: border-box; margin: 0px; padding: 0px; font-weight: normal; color: rgb(102, 0, 102);">$row</span>[<span class="hljs-variable" style="box-sizing: border-box; margin: 0px; padding: 0px; font-weight: normal; color: rgb(102, 0, 102);">$field</span>]; } }</code>
<?php
header("Content-Type:text/html;charset=utf-8");
include 'conn.php';
$sql = 'select count(*) as c from mytable';
$res = mysqli_query($db_link,$sql);
echo mysqli_result($res,0) ; //mysqli里没有和mysql_result()相对应的函数,因此自定义一个
function mysqli_result($res,$n){
$arr = mysqli_fetch_array($res);
return $arr[$n];
}
?>
评论(0)
暂无评论