標籤：
<!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{ 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><?phpsession_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
<?phpsession_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 關聯資料庫的留言板練習
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
