Paste_Image.png
Paste_Image.png
mysql_fetch_row
获取和显示数据
Paste_Image.png
每次调用指针自动指向下一个记录
mysql_connect('127.0.0.1','root','');
mysql_select_db('info');
mysql_query("set names 'utf8'");
$query=mysql_query('select * from test');
while($row=mysql_fetch_row($query)){
//Array ( [0] => 1 [1] => abc )返回查询资源的第一条数据
echo $row[1].$row[2].'个
';
}
$uid=mysql_insert_id();
echo $uid;//返回插入的id
?>
abc3个
苹果5个
香蕉7个
荔枝9个
0
mysql_fetch_row与mysql_fetch_array区别
mysql_fetch_row会产生索引数组
mysql_fetch_array默认产生索引数组和关联数组
mysql_fetch_row效率高(通过下标取值)
mysql_connect('127.0.0.1','root','');
mysql_selectdb('info');
mysql_query('set names utf8');
$query=mysql_query('select * from test');
print_r(mysql_fetch_row($query));
echo '
';
print_r(mysql_fetch_array($query));
?>
Array ( [0] => 1 [1] => abc [2] => 3 )
Array ( [0] => 2 [id] => 2 [1] => 苹果 [name] => 苹果 [2] => 5 [num] => 5 )
mysql_fetch_array
Paste_Image.png
mysql_connect('127.0.0.1','root','');
mysql_selectdb('info');
mysql_query('set names utf8');
$query=mysql_query('select * from test');
while($row=mysql_fetch_array($query)){
echo $row['name'].$row['num'].'个
';
}
?>
abc3个
苹果5个
香蕉7个
荔枝9个
Paste_Image.png
mysql_fetch_assoc
等同于mysql_fetch_array(‘资源标识符’,MYSQL_ASSOC);
练习
假设现在想从表art里按时间date取最新一条记录的title字段的值并打印。$q = mysql_query(‘select title from art order by date desc limit 1’),后续步骤正确的是?
$data = mysql_fetch_row($q);echo $data[0];
mysql_fetch_object
mysql_connect('127.0.0.1','root','');
mysql_selectdb('info');
mysql_query('set names utf8');
$query=mysql_query('select * from test');
$arr=mysql_fetch_object($query);
print_r($arr);
?>
stdClass Object ( [id] => 1 [name] => abc [num] => 3 [price] => 10 )
mysql_connect('127.0.0.1','root','');
mysql_selectdb('info');
mysql_query('set names utf8');
$query=mysql_query('select * from test');
while($arr=mysql_fetch_object($query))
{
echo $arr->name.'
';
}
?>
abc
苹果
香蕉
荔枝