$row[1],这样以数组下标来读取数据,而mysql_fetch_array()返回的数组既包含第一种,也包含键值
对的形式,我们可以这样读取数据,(假如数据库的字段是 username,passwd):
$row['username'], $row['passwd']
而且,如果用($row as $kay => $value)来操作的话,还以直接取得数据库的字段名称。
更主要的是mysqli是php5提供的新函数库,(i)表示改进,其执行速度更快.
例如:
![](https://i-blog.csdnimg.cn/blog_migrate/8f900a89c6347c561fdf2122f13be562.gif)
![ExpandedBlockStart.gif](https://i-blog.csdnimg.cn/blog_migrate/961ddebeb323a10fe0623af514929fc1.gif)
<?
php
// 连接到本地mysql数据库,选择test为操作库
$mysqli = mysqli_connect ( " localhost " , " root " , "" , " test " , 3306 );
// 用mysql_query函数从user表里读取数据
$result = mysqli_query ( $mysqli , " SELECT * FROM userinfo " );
while ( $row = mysqli_fetch_array ( $result )) // 通过循环读取数据内容
{
?>
< tr >
< td align = " center " height = " 19 " ><? php echo $row [ " ID " ] ?></ td >
< td align = " center " ><? php echo $row [ " Name " ] ?></ td >
< td align = " center " ><? php echo $row [ " Detail " ] ?></ td >
</ tr >
<? php
}
// 关闭对数据库的连接
mysqli_free_result ( $result );
mysqli_close ( $mysqli ); */
?>
// 连接到本地mysql数据库,选择test为操作库
$mysqli = mysqli_connect ( " localhost " , " root " , "" , " test " , 3306 );
// 用mysql_query函数从user表里读取数据
$result = mysqli_query ( $mysqli , " SELECT * FROM userinfo " );
while ( $row = mysqli_fetch_array ( $result )) // 通过循环读取数据内容
{
?>
< tr >
< td align = " center " height = " 19 " ><? php echo $row [ " ID " ] ?></ td >
< td align = " center " ><? php echo $row [ " Name " ] ?></ td >
< td align = " center " ><? php echo $row [ " Detail " ] ?></ td >
</ tr >
<? php
}
// 关闭对数据库的连接
mysqli_free_result ( $result );
mysqli_close ( $mysqli ); */
?>