PHP simple message board program code_PHP tutorial

This is the most basic message board program, but it already has the basic functions of the message board program. It is very suitable for PHP beginners to use for learning. Of course, it can also be used for corporate websites, which is also very good. .

The code is as follows

Copy code

session_start();
$con=mysql_connect('localhost','root','root') or die('Failed to connect to database!');
mysql_query('set names utf8');
mysql_select_db('GuestBook');

$pagesize = 10;//How many message records are displayed on each page
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);
?>

 

   
 
 
   
 

简易留言板教程（PHP iask）

while($rs=mysql_fetch_object($result)){
?>
 
   
 
    if(isset($_SESSION['login'])&&$_SESSION['login']){
  ?>
   
   
 
    }
  ?>
 
   
 
 
}
?>

留言人：name?> |Email：email?>|QQ:qq?>|留言时间：post_time+8*3600)?>

回复 | 删除

留言内容：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 "下一页" ;
?>

 
 
   
   
 
 
   
   
 
 
   
   
 
 

姓名：
Email：
QQ：
Message content:
Administrator login

post.php file

header('content-type:text/html;charset=utf-8');
//If the automatic escape function set by PHP is not turned on, escape these values ​​
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 << <script><br> alert('Email and QQ must be entered one!');<br> history.go(-1);<br> </script>
tem;
exit();
}
if($qq!=""&&(!is_numeric($qq)||$qq>9999999999||$qq<=9999)){
echo << <script><br> alert("Please enter the correct QQ number");<br> history.go(-1);<br> </script>
tem;
exit();
}
if($email!=""&&(!ereg("^([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+(.[a-zA-Z0 -9_-])+",$email)||strlen($email)>60)){
echo << <script><br> alert("Please enter the correct email");<br> history.go(-1);<br> </script>
tem;
exit();
}
if(strlen($post)>400){
echo << <script><br> alert("The message you entered is too long!");<br> history.go(-1);<br> </script>
tem;
exit();
}

//Link database
$con=mysql_connect('localhost','root','root') or die('Failed to connect to database!');
mysql_query('set names utf8');
mysql_select_db('GuestBook');

//Insert customer information into the guest table
$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 "Data insertion failed!";
exit();
}

//Insert the customer ID and message information obtained by the above insertion into the post table
$post_time = time();
$insertPostSql = "insert into post(guest_id,post,post_time) values('$guestid','$post','$post_time')";
if(mysql_query($insertPostSql)){
echo << <script><br> alert("Message successfully");<br> location.href="index.php";<br> </script>
tem;
}
else{
echo << <script><br> alert("Message failed");<br> location.href="index.php";<br> </script>
tem;
}
?>

The following is the backend management page login.php to log in first

代码如下

复制代码

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 "<script>alert('管理员登录成功');location.href='index.php';</script>";   exit();  }  else {   echo "<script>alert('登录失败！');</script>";  } } ?> 用户名： 密码：

delete.php to delete messages

The code is as follows

Copy code

代码如下

复制代码

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 "<script>alert('权限不足!');location.href='index.php';</script>";  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 "<script>alert('删除成功!');location.href='index.php';</script>";  } } ?>

session_start();
header('content-type:text/html;charset=utf-8');
$con=mysql_connect('localhost','root','root') or die('Failed to connect to database!');
mysql_query('set names utf8');
mysql_select_db('GuestBook'); if(!$_SESSION['login']){
echo "<script>alert('Insufficient permissions!');location.href='index.php';</script>";
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 "<script>alert('Delete successfully!');location.href='index.php';</script>";
}
}
?>

revert.php file for replying to messages

The code is as follows

代码如下

复制代码

session_start(); $con=mysql_connect('localhost','root','root') or die('链接数据库失败！'); mysql_query('set names utf8'); mysql_select_db('GuestBook'); if(!$_SESSION['login']){  echo "<script>alert('没有登录不能回复!');location.href='index.php';</script>";  exit(); } if($_POST['Submit']){  if(!get_magic_quotes_gpc()){   foreach ($_POST as $items){    $items = addslashes($items);   }  }  if(strlen($_POST['revert'])>400){   echo "<script>alert('回复内容过长!');history.go(-1);</script>";   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 "<script>alert('回复成功');location.href='index.php';</script>";   exit();  }  else {   echo "<script>alert('回复失败!');history.go(-1);</script>";  } } ?> 回复内容：

Copy code

session_start();
$con=mysql_connect('localhost','root','root') or die('Failed to connect to database!');
mysql_query('set names utf8');
mysql_select_db('GuestBook');

if(!$_SESSION['login']){
echo "<script>alert('Cannot reply without logging in!');location.href='index.php';</script>";
exit();
}
if($_POST['Submit']){
if(!get_magic_quotes_gpc()){
foreach ($_POST as $items){
$items = addslashes($items);
}
}
if(strlen($_POST['revert'])>400){
echo "<script>alert('Reply too long!');history.go(-1);</script>";
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 "<script>alert('reply successfully');location.href='index.php';</script>";
exit();
}
else {
echo "<script>alert('Reply failed!');history.go(-1);</script>";
}
}
?>

Reply content:

http://www.bkjia.com/PHPjc/631670.htmlwww.bkjia.com

true

http: //www.bkjia.com/PHPjc/631670.html

TechArticleThis is the most basic message board program, but it already has the basic functions of the message board program, so it is very suitable It is suitable for PHP beginners to learn, and of course it can also be used for corporate websites...