原生 MySQL API--查询数据的写法

<?php    /*    * mysql_connect()打开一个到 MySQL 服务器的连接    * mysql_select_db()选择 MySQL 数据库    * mysql_set_charset()设置客户端的字符集    * mysql_query()发送一条 MySQL 查询     * mysql_fetch_assoc()从结果集中取得一行作为关联数组     * @param $link resource(3, mysql link) 链接到服务器的变量    * @param $res resource(4, mysql result) 查询某条mysql语句的资源变量    * @param $rows Array 从结果集中取得的一条数据    */   //链接数据库   //打开一个到 MySQL 服务器的连接   $link =mysql_connect("localhost","root","***");   //选择 "lamp113" 数据库作为查询对象   mysql_select_db("lamp113",$link);   //设置客户端的字符集   mysql_set_charset("utf8");   //发送sql语句，进行查询   $res = mysql_query("select * from stu");   //输出表格，并将从数据库拿到的内容放到里面   echo "<center>";   echo "数据库内容";   echo "<table border='1'>";   echo "<tr><td>ID</td><td>名字</td><td>性别</td><td>年龄</td><td>班级</td><tr>";   //采用mysql_fetch_assoc获取数据,每次只能读一行，所有用while循环读出所有   while($rows = mysql_fetch_assoc($res)){       echo "<tr>";       echo "<td align='center'>".$rows['id']."</td>";       echo "<td>".$rows['name']."</td>";       if($rows['sex']==0){echo "<td>男</td>";}else{echo "<td>女</td>";};       echo "<td>".$rows['age']."</td>";       echo "<td>".$rows['classid']."</td>";       echo "</tr>";   }   //关闭数据库   mysql_close($link);附：测试用数据CREATE DATABASE lamp113;/*Table structure for table `stu` */DROP TABLE IF EXISTS `stu`;CREATE TABLE `stu` (  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,  `name` char(32) DEFAULT NULL,  `sex` int(11) DEFAULT NULL,  `age` int(11) DEFAULT NULL,  `classid` char(32) DEFAULT NULL,  `caozuo` char(32) DEFAULT NULL,  PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=320 DEFAULT CHARSET=utf8;/*Data for the table `stu` */insert  into `stu`(`id`,`name`,`sex`,`age`,`classid`,`caozuo`) values (267,'xixikkk',1,24,'114',NULL), (271,'ere',0,33,'112',NULL),(275,'congcong',0,23,'114',NULL),(276,'dandan',0,24,'115',NULL),(277,'beibei',0,21,'113',NULL),(278,'congcong',0,23,'114',NULL),(279,'dandan',0,24,'115',NULL),(280,'yangli',0,22,'113',NULL),(281,'liucong',0,22,'112',NULL),(285,'AA',1,20,'lamp113',NULL),(286,'BB',0,21,'lamp114',NULL),(287,'CC',1,24,'lamp113',NULL),(300,'qw',1,20,'113',NULL),(301,'qe',0,21,'114',NULL),(302,'qr',1,24,'113',NULL),(303,'qw',1,20,'113',NULL),(304,'qe',0,21,'114',NULL),(305,'qr',1,24,'113',NULL),(307,'1',1,23,'lamp113',NULL),(309,'mayao',0,24,'lamp113',NULL),(312,'mayao',0,24,'lamp113',NULL),(314,'nn',0,20,'333',NULL),(316,'a11',NULL,22,NULL,NULL),(317,'aaaaaaaaaaaaaa',NULL,11,NULL,NULL),(318,'aaaaa',NULL,22,NULL,NULL),(319,'s',1,33,'s',NULL);