<?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);
原生 MySQL API--查询数据的写法
最新推荐文章于 2022-03-14 16:07:11 发布