PHP中类似ASP中的recordcount

发布时间:2007-08-26 02:58:00 阅读:974次

create database victor

use victor

create table mytable(id int primary key auto_increment,username char(10))

insert into mytable(username) values('victor'),('test'),('ysy'),('siyuroom')

<?php
$hostName = "localhost";
$userName = "root";
$password = "115115";
$dbName = "victor";
$cn=mysql_connect($hostName, $userName, $password) or die("Unable to connect to host $hostName");
$db=mysql_select_db($dbName) or die( "Unable to select database $dbName");
$query = "SELECT *FROM mytable";
$result = mysql_query($query);
$number = mysql_num_rows($result);    //取得符合条件的所有记录条数
print "There are $number types of computers:<p>";
for ($i=0; $i<$number; $i++) {
     $username = mysql_result($result,$i,"username");    
     print "$username<br>";
}
echo mysql_result($result,5,1);         显示第5条,字段为表中的第二个字段,默认为第一个字段
echo mysql_result($result,5,"username");  同上
mysql_close();
?>

mysql_fetch_object

<?php
mysql_connect("localhost", "root", "115115");
mysql_select_db("victor");
$result = mysql_query("select * from mytable");
while ($row = mysql_fetch_object($result)) {
    echo $row->id;
    echo $row->username;
}
mysql_free_result($result);
?>

 

如有问题,可以QQ搜索群1028468525加入群聊,欢迎一起研究技术

支付宝 微信

有疑问联系站长,请联系QQ:QQ咨询
下一篇:php数组操作

转载请注明:PHP中类似ASP中的recordcount 出自老鄢博客 | 欢迎分享