Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Backend Development > PHP Tutorial > Classmate Xinglin's Record 9

Classmate Xinglin's Record 9

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release： 2016-07-29 08:33:48
Original
1113 people have browsed it

班级成员留言簿管理： class/notebook/delnote.php
session_start();
if(!session_is_registered("superlogin"))//检查是否注册
{
echo "请重新进行管理员登陆
";
exit;
}
include ("../config.php");
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++) {
   $user=mysql_result($result,$i,'user');
   $time=mysql_result($result,$i,'time');
   $ip=mysql_result($result,$i,'ip');
   $title=mysql_result($result,$i,'title');
   $nnote=mysql_result($result,$i,'nnote');
   $yresult = mysql_query("SELECT * FROM user where user='$user'",$db);//读取成员数据库
   $name=mysql_result($yresult,0,'name');
   $signature=mysql_result($yresult,0,'signature');//读取个人签名
   $email=mysql_result($yresult,0,'email');
   $face=mysql_result($yresult,0,'face');
   $face='../image/face/icon'.$face;
  echo "";  
echo "";
echo        "";
echo        "";
echo        "";
echo        "  ";  
echo        "";
echo        "
 留言人：$name发表于:$time  $ip
标题：$title
留言内容:$nnote
";
}
mysql_close($db);
?>     
    



客人留言簿管理： class/notebookg/delnote.php
session_start();
if(!session_is_registered("superlogin"))//检查是否注册
{
echo "请重新进行管理员登陆
";
exit;
}
include ("../config.php");
if($del==1){       //判断是否要删除
mysql_query("delete from notebookg where time='$time'",$db); //以留言时间为删除标志
echo "删除成功！";
}
?>



删除留言



$result = mysql_query("SELECT * FROM notebookg ",$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 notebookg 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);
?>
The above is an introduction to Classmate Xinglin’s Nine Recordings, including various aspects. I hope it will be helpful to friends who are interested in PHP tutorials.


Related labels：
gt height lt nbsp quot
Previous article：PHP FTP learning four Next article：Classmate Xinglin’s Record 8
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
[0] Fatal error: Class '\think\cache\driver\File' not found[D:\myphp_www\PHPTutorial\WWW\tp5\thinkphp\library\think\Cache.php:65]. What is the reason?
From 1970-01-01 08:00:00
0
0
0
Now only one piece of data is returned. How to return all data that meets the conditions?
From 1970-01-01 08:00:00
0
0
0
Please tell me how to convert this kind of array
From 1970-01-01 08:00:00
0
0
0
Does a member function without a self parameter mean it has become private?
From 1970-01-01 08:00:00
0
0
0
PHP constants and variables external variables code problems in the textbook
From 1970-01-01 08:00:00
0
0
0
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template

Public welfare online PHP training，Help PHP learners grow quickly！

About us Disclaimer Sitemap

© php.cn All rights reserved