Guestbook that supports oicq avatar (2)_PHP tutorial

addnote.php

    
    
    


include ("config.php"); submit){
$time=date("Y year m month d day H:i:s A");
$ip=$REMOTE_ADDR;//The message ip address
$name=trim( $name);
$email=trim($email);
$title=strip_tags($top);
$nnote=nl2br(strip_tags($content));//Remove the html tag first, Then convert the newline character into
.
If (! $ Name ||! $ Email ||! $ Title ||! $ Nnote) {// Check whether to fill in the complete
Echo "sorry, you must fill in all the content! & Lt; br & gt;". ". "Return";
    exit; }elseif(!ereg('^[-!#$%&'*+./ 0-9=?A-Z^_`a-z{|}~]+'.'@'.'[-!#$%&'*+/0-9=?A-Z^_`a-z{|}~]+ .'.'[-!#$%&'*+./0-9=?A-Z^_`a-z{|}~]+$',$email) //email legality verification
  ){
echo "The email is invalid!
"."Return";
exit;
}
//Write to database
$sql="INSERT INTO notebook (name,email,time,face,ip,title,nnote) VALUES ('$name','$email','$time','$ face','$ip','$title','$nnote')";
$result = mysql_query($sql,$db);
mysql_close($db);
echo "Message success!";
}
?>

    
    
    
  
    
    
  

首页  
      > 留言簿  
      > 添加留言

查看留言  
    

      

        
            
            
            
          
            
            
          
            
            
          
        

	选择一个自己喜欢的头像:
名字                                              Email                                               标题                                               内容

              

    

  

delnote.php
include ("config.php");
if ($superadmin){ //如果已经进行管理员登陆，进行密码验证
if (!($user==$username)||!($psw==$password)){
echo "密码错误";
exit;
}
}else{ //管理员登陆
echo "

";
echo "

请输入管理员密码
";
echo "管理员";  
echo "
";
echo "密码";
echo "
";
echo "
";
echo "

";   
echo "

";
exit;
}
if($del==1){       //判断是否要删除
mysql_query("delete from notebook where time='$time'",$db); //以留言时间为删除标志
echo "删除成功！";
}
?>







$result = mysql_query("SELECT * FROM notebook ",$db);
$row=mysql_num_rows($result);//查看结果有多少行
$max=$row; //帖子总数
//设每页显示10篇，$p总页数，$page第几页，$low 从第几行开始读，$x 读取几行
if (!$page){$page=1;}
$p=ceil($max/10);
$low=10*($page-1);
if($page==$p&&($max%10)<>0){$x=($max%10);} else {$x=10;}//如果是最后一页，且不是10的整倍数，读取$max除以10的余数，否则取10
if($max==0){$x=0;}//如果没有帖子，$x取0
$result = mysql_query("select * from notebook ORDER BY time DESC limit $low,$x",$db);
?>

    
    
    
  


    
    

      
          
          
          
          
        
      

首页               > 留言簿

echo "帖子总数:  ",$max,"   第";           for ($n=1;$n<=$p;$n++){           echo "$n ";           }           echo "页";           ?>

查看留言

  
   for ($i=0;$i<=($x-1);$i++) {
   $email=mysql_result($result,$i,'email');
   $face=mysql_result($result,$i,'face');
   $face='image/face/icon'.$face;
   $name=mysql_result($result,$i,'name');
   $time=mysql_result($result,$i,'time');
   $ip=mysql_result($result,$i,'ip');
   $title=mysql_result($result,$i,'title');
   $nnote=mysql_result($result,$i,'nnote');
echo "";  
echo "";
echo        "";
echo        "";
echo        "";
echo        "  ";  
echo        "";
echo        "

	留言人：$name	发表于:$time		$ip
标题：$title
留言内容:$nnote

";
}
mysql_close($db);
?>     
    

http://www.bkjia.com/PHPjc/316278.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/316278.htmlTechArticleaddnote.php HTML HEAD meta http-equiv=Content-Type content=text/html; charset=gb2312 TITLE添加留言/TITLE style type=text/css !-- .white12 {font-size: 12pt; color: #FFFFFF; text-...