一个小作业
homework.png
.sql文件
SET NAMES UTF8;
DROP DATABASE IF EXISTS sbsh;
CREATE DATABASE sbsh CHARSET=UTF8;
USE sbsh;
CREATE TABLE msg(
mid INT PRIMARY KEY AUTO_INCREMENT,
uname VARCHAR(10),
phone VARCHAR(16),
pubTime DATE,
content VARCHAR(100)
);
INSERT INTO msg VALUES(NULL,'李明','13502876189','2017-08-23','好好好好');
INSERT INTO msg VALUES(NULL,'丹妮','13502876189','2017-08-23','好好好好');
INSERT INTO msg VALUES(NULL,'珍妮','13502876189','2017-08-23','好好好好');
SELECT * FROM msg;
重复使用的PHP代码写在新的php中
<?php
$conn=mysqli_connect('127.0.0.1','root','','sbsh',3306);
$sql='SET NAMES UTF8';
mysqli_query($conn,$sql);
执行添加语句的php
<?php
$uname=$_REQUEST['uname'];
$phone=$_REQUEST['phone'];
$pubTime=$_REQUEST['pubTime'];
$content=$_REQUEST['content'];
require('init.php');
$sql="INSERT INTO msg VALUES(NULL,'$uname','$phone','$pubTime','$content')";
$result=mysqli_query($conn,$sql);
if($result===true){
echo "输入正确";
}else{
echo "输入错误";
}
require('init.php');讲重复的php代码引入进来
执行添加语句的html
<form action="msg_add.php">
<p>
发布人姓名：<input type="text" name="uname">
</p>
<p>
联系电话：<input type="text" name="phone">
</p>
<p>
发布时间：<input type="text" name="pubTime">
</p>
<p>
留言内容：<input type="text" name="content">
</p>
<input type="submit" value="提交">
</form>
执行删除语句的php
<?php
$mid=$_REQUEST['mid'];
require('init.php');
$sql="DELETE FROM msg WHERE mid='$mid'";
$result=mysqli_query($conn,$sql);
if($result===true){
echo "正确";
echo "<a href='msg_select.php'>返回查看</a>";
}else{
echo "错误";
}
最后界面
<body>
<?php
echo "<div class='box'>";
foreach ($all as $key => $value) {
echo "<div class='box-connt'>";
echo "<span class='s1'>留言编号：$value[mid]</span>";
echo "<p class='p1'>发布人姓名：$value[uname]</p>";
echo "<p class='p2'>联系电话：$value[phone]</p>";
echo "<p class='p3'>发布时间：$value[pubTime]</p>";
echo "<p class='p4'>留言内容：$value[content]</p>";
echo "<span class='s2'><a href='$value[mid]' class='a1'>×</a></span>";
echo "</div>";
}
echo "</div>";
?>
<script type="text/javascript">
//查找删除按钮
var close=document.querySelectorAll('.a1');
for(var i=0;i<close.length;i++){
close[i].onclick=function(e){
e.preventDefault();
var choose=confirm('确定删除吗？此操作不可恢复');
if(choose){
var mid=this.getAttribute('href');
location.href='msg_delete.php?mid='+mid;
}
}
}
</script>
<a href="msg_delete.php">点我</a>
</body>
