高三<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< ;/a>");
}
?>
You can go to http://xinai.oso.com.cn/class/guesttap.php to view
[The copyright of this article is jointly owned by the author and Oso.com, if you need to reprint it , please indicate the author and source]

The above introduces the message book I wrote using php+mysql, including the content of messages. I hope it will be helpful to friends who are interested in PHP tutorials.

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
Previous article:my life would suck without you A business card library program using php+mysqlNext article:my life would suck without you A business card library program using php+mysql

Related articles

See more