<?phpinclude"conn.php";//选择数据库$conn->select_db("myDB");//SQL语句创建表$sql="CREATE TABLE MyGuests (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
email VARCHAR(50),
reg_date TIMESTAMP
)";//执行SQL语句 if($conn->query($sql)){echo"数据表创建成功";}?>
五 deleteData.php 删除
<?phpinclude"conn.php";//选择数据库$conn->select_db("myDB");//SQL语句 删除数据$sql="delete from myguests where id = 1";//执行插入if($conn->query($sql)){}else{echo$conn->error;}?>
六 insertDatas.php 新增插入
<?phpinclude"conn.php";//选择数据库$conn->select_db("myDB");//SQL语句 插入数据$sql="insert into myguests (firstname,lastname,email) values('张','翔云','zxy@163.com')";//执行插入$conn->query($sql);?>
七 insertMoreDatas.php
<?phpinclude"conn.php";//选择数据库$conn->select_db("myDB");//SQL语句 插入数据$sql="insert into myguests (firstname,lastname,email) values('张','翔云','zxy@163.com'),('zhang','jingpu','zjp@163.com')";//执行插入$conn->query($sql);?>
八 selectDatas.php 查询获取
<?phpinclude"conn.php";//选择数据库$conn->select_db("myDB");//SQL语句 取表里完整的数据//$sql = "select * from myguests";//取表里某些特定字段的值/* $sql = "select firstname,lastname from myguests"; *///根据条件取数据/* $sql = "select * from myguests where id > 2"; *///排序$sql="select * from myguests order by id desc";//执行之后,保存查询结果$result=$conn->query($sql);if($result->num_rows>0){// 统计数据库行目 如果大于0时while($row=$result->fetch_assoc()){//fetch_assoc函数从结果集中取得一行作为关联数组//echo $row["lastname"];//var_dump($row);echo$row["id"];}}?>
九 upDatas.php 修改编辑
<?phpinclude"conn.php";//选择数据库$conn->select_db("myDB");//SQL语句 更新数据/* $sql = "update myguests set firstname='shi' where id = 1"; */$sql="update myguests set firstname='shi'";//执行插入if($conn->query($sql)){}else{echo$conn->error;}?>