php连接数据库,并把数据库里表内容输出到页面上
大学生作业
<?php
/*
* 数据库操作*(创建数据库,表,插入数据,插入多条数据)
*
* To change the template for this generated file go to
* Window - Preferences - PHPeclipse - PHP - Code Templates
*/
//先连接数据库
$servername="localhost";
$username="root";
$userpassword="********";
$dbname = "testdb";
$connent=new mysqli($servername,$username,$userpassword,$dbname);
if($connent->connect_error){
die("连接失败: " . $connent->connect_error);
}else{
echo "连接成功";
}
//创建数据库
$createdatabase="create database db_test";
if($connent->query($createdatabase)==true){
echo "创建数据库成功";
}else{
echo "Error creating database: " . $connent->error."<br>";
}
//创建表 原生的建表语句 id自增唯一 name age email
$createtable="CREATE TABLE `student` (
`学号` int(11) NOT NULL AUTO_INCREMENT,
`姓名` varchar(255) DEFAULT NULL,
`性别` varchar(5) DEFAULT NULL,
`出生时间` varchar(255) DEFAULT NULL,
`专业` varchar(255) DEFAULT NULL,
`总学分` varchar(255) DEFAULT NULL,
`备注` varchar(255) DEFAULT '',
`照片` varchar(255) DEFAULT '',
PRIMARY KEY (`学号`)) ";
if($connent->query($createtable)==true){//执行
echo "创建表成功";
}else{
echo "Error creating table: " . $connent->error."<br>";
}
//插入数据
$insertdata="INSERT INTO `student` VALUES
(81101,'王林','男','1995-2-10','1','50',NULL,NULL),
(81102,'李珊琳','女','1996-1-18','2','50',NULL,NULL),
(81103,'王向东','男','1994-12-8','1','46',NULL,NULL),
(81104,'王振峰','男','1995-8-18','1','50',NULL,NULL),
(81105,'吴宝威','男','1995-7-10','2','50',NULL,NULL),
(81106,'肖晨琪','女','1995-5-6','2','48',NULL,NULL),
(81107,'邢丹丹','男','1995-9-22','2','46',NULL,NULL),
(81108,'徐玉洋','男','1995-9-22','1','52',NULL,NULL),
(81109,'颜婷婷','女','1997-1-10','2','44',NULL,NULL),
(81110,'杨锦程','男','1996-6-16','1','52',NULL,NULL),
(81111,'杨丽','女','1995-7-2','2','50',NULL,NULL),
(81112,'于永庆','男','1999-8-6','1','48',NULL,NULL),
(81113,'张玉琴','女','1994-2-10','1','50',NULL,NULL),
(81114,'赵其豪','男','1996-1-30','2','54',NULL,NULL),
(81115,'赵阳','女','1995-10-1','1','50',NULL,NULL)";
if($connent->query($insertdata)==true){
echo "插入数据成功";
}else{
echo "Error insert data: " . $connent->error;
}
$mysqli = null;
$sql = $mysqli->query("select * from student");
if($sql){
// echo '有数据!<br>';
$rows = $sql->num_rows;
echo '查询结果共有'.$rows.'条记录<br>';
echo "<table>
<tr>
<th>学号</th>
<th>姓名</th>
<th>性别</th>
<th>出生时间</th>
<th>专业</th>
<th>总学分</th>
<th>备注</th>
<th>照片</th>
<tr>";
if($rows){
while($row = $sql->fetch_assoc()){
echo "<tr>
<td>".$row['id']."</td>
<td>".$row['name']."</td>
<td>".$row['sex']."</td>
<td>".$row['birthday']."</td>
<td>".$row['major']."</td>
<td>".$row['credit']."</td>
<td>".$row['remark']."</td>
<td>".$row['photo']."</td>
</tr>
";
}
echo "</table>";
}else{
echo '没有您要找的数据。<br>';
}
}else{
$mysqli = null;
echo 'MySQL语句有误。<br>'.$mysqli->error.'<br>';
}
mysqli_close($connent);
?>