<?phpfunction db_connect()
{
$result = new mysqli('localhost', 'root', '654321', 'smsprj');
//$result = new mysqli('localhost', 'root', '654321');
if (!$result)
{
throw new Exception('Could not connect to database server');
}
else
{
return $result;
}
}?>$conn = db_connect();
$sql = $conn->query("SELECT * FROM user");if (!$sql)
{
echo ("wrong");
}
else
{
echo "<table>";
echo "<tr><td>userid</td><td>name</td><td>pssword</td><td>maxsmscount</td><td>maxuseday</td><td>leftday</td><td>leftsmscount</td></tr>";
while( $row = mysql_fetch_row($sql) )
{
echo "<tr><td>$row[0]</td><td>$row[1]</td><td>$row[2]</td><td>$row[3]</td><td>$row[4]</td><td>$row[5]</td><td>$row[6]</td></tr>";
}
}
我的目的是将数据库中的所有用户信息显示出来
可这段程序老是报错,不知道什么原因
求大侠帮助,小弟不胜感激mysql_fetch_row
{
$result = new mysqli('localhost', 'root', '654321', 'smsprj');
//$result = new mysqli('localhost', 'root', '654321');
if (!$result)
{
throw new Exception('Could not connect to database server');
}
else
{
return $result;
}
}?>$conn = db_connect();
$sql = $conn->query("SELECT * FROM user");if (!$sql)
{
echo ("wrong");
}
else
{
echo "<table>";
echo "<tr><td>userid</td><td>name</td><td>pssword</td><td>maxsmscount</td><td>maxuseday</td><td>leftday</td><td>leftsmscount</td></tr>";
while( $row = mysql_fetch_row($sql) )
{
echo "<tr><td>$row[0]</td><td>$row[1]</td><td>$row[2]</td><td>$row[3]</td><td>$row[4]</td><td>$row[5]</td><td>$row[6]</td></tr>";
}
}
我的目的是将数据库中的所有用户信息显示出来
可这段程序老是报错,不知道什么原因
求大侠帮助,小弟不胜感激mysql_fetch_row
$result = new mysqli('localhost', 'root', '654321', 'smsprj');所以要这样查询
$sql = $conn->query("SELECT * FROM user");要这样读取
while( $row = $sql->fetch_row())
复制一段mysqli查看结果集的代码,一共就是下面这几个步骤。
<?php
header('content-type:text/html;charset=utf-8');
//A、面向对象---创建MySql对象
$mysqli=new MySQLi('localhost','root','1234abcd','test2') or die('连接失败'.$mysqli->connect_error);
//B. 设置操作编码(建议有)!!!
$mysqli->query('set names utf8');
//C.面向对象--操作数据库(发送sql)
$sql="select * from user1";
$res=$mysqli->query($sql);
//D.面向对象--处理结果
while($row=$res->fetch_row()){
foreach($row as $key => $val){
echo "--$val";
}echo "<br/>";
}
//E.释放内存,关闭连接
$res->free();
$mysqli->close();楼主看来对mysqli不太了解,可以看下传智播客php视频教程第94讲-97讲,使用mysqli扩展库。韩老师对mysqli的用法介绍的很详细。