php mysql 显示数据,[PHP与MySQL]②---获取和显示数据

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

苹果

香蕉

荔枝