php簡易留言板程式碼_PHP教程

這是一個最基礎的留言板程式了，但是己經有了留言板程式準系統，很適合於php初學者用用，學慣用啊，當然也可以用於企業網站也是很不錯的哦。

代碼如下

複製代碼

session_start(); $con=mysql_connect('localhost','root','root') or die('連結資料庫失敗！'); mysql_query('set names utf8'); mysql_select_db('GuestBook'); $pagesize = 10;//每一頁顯示多少留言記錄 if(isset($_GET['page'])&&$_GET['page']!='') $page=$_GET['page']; else $page=0; $sql = "SELECT a . * , b.name, b.email, b.qq, c.revert_time, c.revert FROM post a LEFT JOIN revert c ON ( a.id = c.post_id ) , guest b WHERE a.guest_id = b.id ORDER BY a.id DESC"; $numRecord = mysql_num_rows(mysql_query($sql)); $totalpage = ceil($numRecord/$pagesize); $recordSql = $sql. " LIMIT ".$page*$pagesize.",".$pagesize; $result = mysql_query($recordSql); ?> PHPiask簡易留言板 簡易留言板教程（PHP iask） while($rs=mysql_fetch_object($result)){?> if(isset($_SESSION['login'])&&$_SESSION['login']){ ?> } ?> }?> 留言人：name?> |Email：email?>|QQ:qq?>|留言時間：post_time+8*3600)?> id?>">回複 | id?>">刪除 留言內容：post))?> 回複內容：revert))?>[revert_time!="") echo date("Y-m-d H:i:s",$rs->revert_time+8*3600)?> ] if($page>0) echo "上一頁|" ; if($page<$totalpage-1) echo "下一頁" ; ?> post.php檔案 header('content-type:text/html;charset=utf-8'); //如果PHP設定的自動轉義函數未開啟，就轉義這些值 if(!get_magic_quotes_gpc()){ foreach ($_POST as &$items){ $items = addslashes($items); } } $name = $_POST['name']; $qq = $_POST['qq']; $email = $_POST['email']; $post = $_POST['post']; if($name==""||strlen($name)>10){ echo << tem; exit(); } if($qq==""&&$email==""){ echo << tem; exit(); } if($qq!=""&&(!is_numeric($qq)||$qq>9999999999||$qq<=9999)){ echo << tem; exit(); } if($email!=""&&(!ereg("^([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+(.[a-zA-Z0-9_-])+",$email)||strlen($email)>60)){ echo << tem; exit(); } if(strlen($post)>400){ echo << tem; exit(); } //連結資料庫 $con=mysql_connect('localhost','root','root') or die('連結資料庫失敗！'); mysql_query('set names utf8'); mysql_select_db('GuestBook'); //把客戶資訊插入guest表 $insertSql="insert into guest (name,qq,email) values ('$name','$qq','$email')"; if(mysql_query($insertSql)){ $guestid = mysql_insert_id(); } else{ echo $insertSql; echo mysql_error(); echo "資料插入失敗!"; exit(); } //把以上插入取得的客戶id和留言資訊插入到post表中 $post_time = time(); $insertPostSql = "insert into post(guest_id,post,post_time) values('$guestid','$post','$post_time')"; if(mysql_query($insertPostSql)){ echo << tem; } else{ echo << tem; } ?>

下面為後台管理管理的頁面 login.php登入先

代碼如下	複製代碼
session_start(); if(isset($_POST['Submit'])){ if(!get_magic_quotes_gpc()){ foreach ($_POST as &$items){ $items = addslashes($items); } } if($_POST['username']=='phpiask'&&md5($_POST['password'])=='6dc88b87062a5de19895e952fa290dad'){ $_SESSION['login']=true; echo ""; exit(); } else { echo ""; } } ?> 無標題文檔

刪除留言的delete.php

代碼如下

複製代碼

session_start(); header('content-type:text/html;charset=utf-8'); $con=mysql_connect('localhost','root','root') or die('連結資料庫失敗！'); mysql_query('set names utf8'); mysql_select_db('GuestBook'); if(!$_SESSION['login']){ echo ""; exit(); } if(isset($_GET['id'])&&$_GET['id']!=""){ $delRevertSql="delete from revert where post_id=".$_GET['id']; mysql_query($delRevertSql); $delGuestSql="delete from guest where id = (select guest_id from post where id=".$_GET['id'].")"; mysql_query($delGuestSql); $delPostSql="delete from post where id=".$_GET['id']; mysql_query($delPostSql); if(mysql_error()==""){ echo ""; } } ?>

回複留言的revert.php檔案

代碼如下

複製代碼

session_start(); $con=mysql_connect('localhost','root','root') or die('連結資料庫失敗！'); mysql_query('set names utf8'); mysql_select_db('GuestBook'); if(!$_SESSION['login']){ echo ""; exit(); } if($_POST['Submit']){ if(!get_magic_quotes_gpc()){ foreach ($_POST as $items){ $items = addslashes($items); } } if(strlen($_POST['revert'])>400){ echo ""; exit(); } $post_id = $_POST['post_id']; $revert = $_POST['revert']; $insertRevertSql = "insert into revert (post_id,revert,revert_time) value('$post_id','$revert','$time')"; if(mysql_query($insertRevertSql)){ echo ""; exit(); } else { echo ""; } } ?> 無標題文檔

http://www.bkjia.com/PHPjc/631670.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/631670.htmlTechArticle這是一個最基礎的留言板程式了，但是己經有了留言板程式準系統，很適合於php初學者用用，學慣用啊，當然也可以用於企業網站也是很...

