<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>留言板信息</title>
<style type="text/css">
#cap{color: #a26fab;font-size: 20px;}
#tb{width:300px;border:1px solid #607d8b;box-shadow:10px 10px 5px rgba(244, 67, 54, 0.19);cellspaceing="10";}
.class{color: red;}
</style>
</head>
<body>
<center>
<table id="tb" >
<caption id="cap">留言内容</caption>
<!-- <tr><th>用户</th><th>标题</th><th>内容</th></tr> -->
<?PHP
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "messageboard";
//创建连接
$conn = new mysqli($servername,$username,$password,$dbname);
//检测连接
if($conn->connect_error)
{
die("Connection failed:" .$conn->connect_error);
}
$result = $conn->query("select * from mymessage");//执行查询
while($row = mysqli_fetch_assoc($result))//将result结果集中查询结果取出一条
{?>
<!-- echo"<tr><td>".$row["name"]."</td><td>".$row["title"]."</td><td>".$row["content"]."</td><tr>"; -->
<tr bgcolor="white">
<td>
用户：<font color="#ff9800"><?=$row['name']?></font>
标题：<font color="#ff9800"><?=$row['title'] ?></font>
</td>
</tr>
<tr bgcolor="white">
<td>
内容：<font color="#ff9800"><?=$row['content']?></font><br><br>
<div align="right"><a href="testlocal.html"><font color="#8bc34a">增加</font></a> | <a href="del.php?id=<?=$row['content'];?>"><font color="#00bcd4">删除</font></a></div>
</td>
</tr>
<?php } ?>
</table>
</center>
</body>
</html>
html+php+mysql留言板功能的实现
1星 需积分: 50 15 浏览量
2017-06-08
09:27:11
上传
评论 16
收藏 333KB RAR 举报 
数据库存储.rar （30个子文件） 
数据库存储 
mess.php 2KB server.php 679B bootstrap-3.3.7-dist fonts glyphicons-halflings-regular.woff2 18KB glyphicons-halflings-regular.ttf 44KB glyphicons-halflings-regular.woff 23KB
glyphicons-halflings-regular.svg 106KB glyphicons-halflings-regular.eot 20KB js npm.js 484B bootstrap.js 68KB bootstrap.min.js 36KB css bootstrap.css 143KB bootstrap-theme.min.css 23KB bootstrap.css.map 380KB bootstrap.min.css 149KB bootstrap-theme.min.css.map 25KB bootstrap-theme.css.map 47KB bootstrap.min.css.map 529KB bootstrap-theme.css 26KB
testlocal.html 4KB mess.html 966B uploadSingleImg server.php 153B js tools.js 7KB pictureHandle.js 3KB css uploadSingleImg.css 519B style.css 119B image 
pwd.png 1KB delete.png 1KB index.html 2KB del.php 465B conn.php 883B资源评论
salomonfaith2017-06-08如果能有个详细说明，并且附上数据库文件就有点参考价值
亲亲小朱儿2017-06-19好的 下次注意 谢谢
