php 关联数据库的留言板练习

<!DOCTYPE html PUBLIC "-//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{ 500px; height:300px;}
#bottom{ 500px; height:150px;}
.nr{ 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="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

相关阅读:
FTP Protocol
File Operations
Ubuntu Install Chinese Input Method
Vim Intro
ISA Introduction
Fourier Transform
Process/Thread Synchronization
Process Synchronization-Example 2
leetcode 栈和队列类型题
leetcode 字符串类型题

原文地址：https://www.cnblogs.com/bilibiliganbei/p/5631280.html