Home >Backend Development >PHP Tutorial >The guestbook I wrote using php+mysql_PHP tutorial

The guestbook I wrote using php+mysql_PHP tutorial

WBOY
WBOYOriginal
2016-07-21 16:01:591077browse

guestbook.php:










  

  
   
   


    
      
    
  

高三<6>班留言本本


        


          
  

   

              
  
  
  
              
  
  
              
                
                
              
              
                
                
              
              
                
                
              
              
                
              
            

          姓名:
type="text" name="T1" size="13">

          EMAIL:

          个人主页:

          主题:

          留言:

                

          


                                              


        

        
        

  



  

  
    
      
    
  

include ("connect.rec");

$qh=mysql_query("SELECT COUNT(*) AS rcnt FROM guestbook");

$data=mysql_fetch_array($qh);

$nr=$data["rcnt"];

//判断偏移量参数是否传递给了脚本,如果没有就使用默认值0

if (empty($offset))

{

$offset=0;

}
//查询结果(这里是每页20条,但你自己完全可以改变它)

//$result=mysql_query("SELECT * from guestbook ORDER BY time desc LIMIT $offset, 5");
$result=mysql_query("SELECT * from guestbook LIMIT $offset, 5");

//显示返回的5条记录

while ($data=mysql_fetch_array($result))
{
printf("姓名:%s
",$data["name"]);
printf("EMAIL:%s
",$data["mail"]);
printf("个人主页:%s
",$data["url"]);
printf("来自:%s
",$data["ip"]);
printf("留言时间:%s
",$data["time"]);
printf("主题:%s
",$data["title"]);
printf("内容:%s
",$data["ly"]);
printf("
");
}  

//下一步,要写出到其它页面的链接  

if($offset) //如果偏移量是0,不显示前一页的链接  
{  
$preoffset=$offset-5;  
print "前一页 n";  
}  

//计算总共需要的页数  

$pages=ceil($nr/5); //$pages变量现在包含所需的页数  

for ($i=1; $i <= $pages; $i++)

{

$newoffset=5*$i-5;

print "$i n";  

}  

//检查是否是最后一页  
$next = $offset+5;
if ($next<$nr)
{
print "下一页 n";  
}  
printf("返回")
?>  

  





ly.php:

include ("connect.rec");
$name = $T1;
$mail = $T2;
$url = $T3;
$title = $T4;
$time = date( "Y-m-j H:i:s" );
$ip = getenv("REMOTE_ADDR");
$ly = $S1;

$result = mysql_query("insert into guestbook (name,mail,url,ip,time, title,ly) values ​​('$name','$mail','$url','$ip','$time','$title','$ly')");
if ($ result == 1)
{
echo("Message successfully!");
printf("");
}
else
{
echo("Message failed!");
printf(" Return");
}
?>

Can be found at http://xinai.oso View .com.cn/class/guesttap.php

[The copyright of this article is jointly owned by the author and Oso.com. If you need to reprint, please indicate the author and source]

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/316694.htmlTechArticleguestbook.php: head meta http-equiv=Content-Language content=zh-cn meta http-equiv=Content -Type content=text/html; charset=gb2312 title/title STYLEA:link { COLOR: #002878; TEXT-DECO...
Statement:
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