php连接数据库创建表把表内容输出到网页上

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);
?>
  • 3
    点赞
  • 22
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值