php 关联数据库的留言板练习
时间：2021-07-01 10:21:17
帮助过：1人阅读
"-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
<style type="text/css">
*{ margin:0px auto; padding:
0px}
#top{ width:500px; height:300px;}
#bottom{ width:500px; height:150px;}
.nr{ width:100%; height:30px; font-family:微软雅黑; font-size:
20px;}
.xm{ color:
#3FF; margin-right:10px}
.sj{ color:
#0F0; margin-right:10px}
.content{ color:
#F00; margin-right:10px}
</style>
<?
php
session_start();
$_SESSION["uid"]="lisi"
;
include("DBDA.php"
);
$db=
new DBDA();
?>
</head>
<body>
<h1>留言板</h1>
<div id="top">
<?
php
$sql="select * from liuyanban"
;
$attr=
$db->Query(
$sql);
foreach(
$attr as $V)
{
$sname="select name from users where uid=‘{
$V[1]}‘"
;
$name=
$db->StrQuery(
$sname);
echo"
<div class=‘nr‘>
<span class=‘xm‘>{$name}</span>
<span class=‘sj‘>{$V[3]}</span>
<span class=‘content‘>{$V[2]}</span>
</div>"
;
}
?>
</div>
<div id="bottom">
<form action="liuyanbanchuli.php" method="post">
<span>请输入要留言的内容：</span>
<div>
<textarea style="width:300px; height:100px" name="nr"></textarea>
</div>
<div>
<input type="submit" value="留言" />
</div>
</form>
</div>
</body>
</html>
View Code
<?php
session_start();
include("DBDA.php");
$db=new DBDA();
$nr=$_POST["nr"];
$uid=$_SESSION["uid"];
$times=date("Y-m-d H:i:s");
$sql="insert into liuyanban values(‘‘,‘{$uid}‘,‘{$nr}‘,‘$times‘)";
$db->Query($sql,0);
header("location:liuyanban.php");
View Code
php 关联数据库的留言板练习
标签：
