挑战最棒的留言本的源码_php基础_脚本之家

<html>
<title>留言本</title>
<body bgcolor=white>
<head>
<meta http-equiv=”Content-Type” content=”text/html;
charset=gb2312″>
<style type=”text/css”>

留言信息

number_of_records; if ==0) { $str_sql=”select * from
$table_namelimit $initial_record,$number_records_to_display “; }
else { $str_sql=”select * from $table_name order by $sort_field
$sort_direction limit $initial_record,$number_records_to_display “;
} $result=mysql_db_query($db_name,$str_sql,$id_link); if {
affy_error_exit(‘SQL select execution has failed.’);}
$number_of_records_on_current_page=@mysql_num_rows; if {echo ‘

表中没有数据!

‘;} else { $next_index=$initial_record+$number_records_to_display;
if ($next_index>$number_of_records)
$next_index=$number_of_records;
$prev_index=$initial_record-$number_records_to_display; if {
$prev_index=0; }} echo “”; echo “

"; if { $t1="initial_record=$prev_index"; $sort="sort_field=$sort_field"; $asc="sort_direction=$sort_direction"; echo ""; echo "<"; } else { echo "|前面没有留言了"; } echo " "; $t2=$initial_record+1; echo "本页显示第 $t2 到 $next_index 条留言,共$number_of_records条留言"; echo " "; if ($next_index!=$number_of_records) { $t1="initial_record=$next_index"; $sort="sort_field=$sort_field"; $asc="sort_direction=$sort_direction"; echo ""; echo "后 $number_records_to_display 条留言>>"; }else { echo "后面没有留言了|"; } echo "

“; echo “

“; ?>

<!–
td {  font-family: “宋体”, “serif”; font-size: 9pt; font-weight:
normal}
a:link {  text-decoration: none}
a:hover {  color: #999999}
a:visited {  text-decoration: none; font-weight: normal}
body {  font-family: “宋体”, “serif”; font-size: 11pt}
tr {  font-family: “宋体”, “serif”; font-size: 11pt}
.unnamed1 {  font-size: 9pt; font-weight: bold}
.p9 {  font-family: “宋体”; font-size: 11pt}
.unnamed2 {  font-size: 11pt}
–>
</style>
</head>
<h1><center><font color=”green”
size=7>留言信息</font></center></h1>

[我也要留言]

“; echo “转到第”; if (($number_of_records %
$number_records_to_display)==0) {
$number_of_pages=$number_of_records / $number_records_to_display;
} else{ $number_of_pages=($number_of_records-($number_of_records %
$number_records_to_display))/$number_records_to_display+1; }
$sort=”sort_field=$sort_field”;
$asc=”sort_direction=$sort_direction”; for
($ii=1;$ii<=$number_of_pages;$ii++) {
$yeshu=*$number_澳门新葡萄京官网首页 ,records_to_display ; $t1=”initial_record=$yeshu “;
if ($initial_record!=$yeshu) { echo “”; echo “[ $ii
]”; } else
echo “[ $ii ]”; } echo “页共 $number_of_pages 页”; echo “

“; echo “

“; ?>


免费留言本由小熊提供技术支持

【本文版权归作者与奥索网共同拥有,如需转载,请注明作者及出处】

<?php  
      require(‘config.php’);  
?>

<?php

$initial_record=0;
$sort_field=’key_liuyan’;
$sort_direction=’DESC’;

if (strlen($arr_request[‘initial_record’]))
   {  
     $initial_record=$arr_request[‘initial_record’];
     $sort_field=$arr_request[‘sort_field’];
     $sort_direction=$arr_request[‘sort_direction’];

   }

$str_sql_all=”select count(*) as number_of_records from
$table_name “;

$result=mysql_db_query($db_name,$str_sql_all,$id_link);

if (!result)
   { affy_error_exit(‘SQL select execution has failed.’);}

$record=@mysql_fetch_object($result);

$number_of_records=$record->number_of_records;

if (strlen($sort_field)==0)
  {
    $str_sql=”select * from $table_name  
              limit $initial_record,$number_records_to_display “;

  }

else  
{

   $str_sql=”select * from $table_name order by $sort_field
$sort_direction
             limit $initial_record,$number_records_to_display “;
}

$result=mysql_db_query($db_name,$str_sql,$id_link);

if (!$result)
   { affy_error_exit(‘SQL select execution has failed.’);}

$number_of_records_on_current_page=@mysql_num_rows($result);

if ($number_of_records<1)
  {  echo ‘<p>表中没有数据!<p>’;}
else
  {
    $next_index=$initial_record+$number_records_to_display;

    if ($next_index>$number_of_records)
         $next_index=$number_of_records;

     

    $prev_index=$initial_record-$number_records_to_display;

    if ($prev_index<0)
       {
          $prev_index=0;
       }  

  }

echo “<center>”;
echo “<table border=0><tr bgcolor=#f1f1f1><td width=24%
align=left>”;

if ($initial_record!=0)
   {
     $t1=”initial_record=$prev_index”;
     $sort=”sort_field=$sort_field”;
     $asc=”sort_direction=$sort_direction”;
     echo “<a href=”$PHP_SELF?$asc&$sort&$t1%20″>”;
     echo “<<前 $number_records_to_display 条留言</a>”;

   }

else
  {
     echo “|前面没有留言了”;

  }

echo “</td><td width=52% align=center>”;

    $t2=$initial_record+1;

    echo “本页显示第 <font color=green>$t2</font> 到
<font color=green>$next_index</font>
条留言,共<font
color=blue>$number_of_records</font>条留言”;

echo “</td><td width=24% align=right>”;

if ($next_index!=$number_of_records)

  {
     $t1=”initial_record=$next_index”;
     $sort=”sort_field=$sort_field”;
     $asc=”sort_direction=$sort_direction”;
     echo ”    <a href=”$PHP_SELF?$asc&$sort&$t1%20″>”;
     echo “后 $number_records_to_display 条留言>></a>”;
  }  
else
  {
     echo “后面没有留言了|”;

  }

echo “</td></tr></table>”;
echo “</center><p>”;

?>

<center>

<a href=index.html><h4>[我也要留言]</h4></a>
<p>

<table border=”0″,width=”95%” cellspacing=”0″ cellpadding=”0″>
<?php
for
($iindex=0;$iindex<$number_of_records_on_current_page;$iindex++)
{
$record=mysql_fetch_object($result);
require(‘display.inc’);
}

?>
</table>
</center>

<p>
<?php  
echo “<center>”;
echo “<table border=0><tr><td>”;
echo “转到第”;

if (($number_of_records % $number_records_to_display)==0)
   {
     $number_of_pages=$number_of_records /
$number_records_to_display;

      
   }

else  
   {
     $number_of_pages=($number_of_records-($number_of_records %
$number_records_to_display))/$number_records_to_display+1;

   }

     $sort=”sort_field=$sort_field”;
     $asc=”sort_direction=$sort_direction”;

for ($ii=1;$ii<=$number_of_pages;$ii++)

{
     $yeshu=($ii-1)*$number_records_to_display ;
     $t1=”initial_record=$yeshu “;

     if ($initial_record!=$yeshu)
       {

         echo “<a href=”$PHP_SELF?$asc&$sort&$t1%20″>”;
         echo “[ $ii ]</a>”;
       }
     else
         echo “[ $ii ]”;

}

echo “页  共<font color=blue> $number_of_pages
</font>页”;
echo “</td></tr></table>”;
echo “</center><p>”;

?>

<hr></hr>
<center>免费留言本由<a href=””
>小熊</a>提供技术支持</center>

</body>
</html>

【本文版权归作者与奥索网共同拥有,如需转载,请注明作者及出处】    

发表评论

电子邮件地址不会被公开。 必填项已用*标注