留言本

留言信息

      require('config.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 '

表中没有数据!

';}
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 "

";
echo "

";

if ($initial_record!=0)
   {
     $t1="initial_record=$prev_index";
     $sort="sort_field=$sort_field";
     $asc="sort_direction=$sort_direction";
     echo "";
     echo "<<前 $number_records_to_display 条留言";

   }

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

  }

echo "

";

$t2=$initial_record+1;

echo "This page Showing comments from $t2 to $next_index
out of $number_of_records Leave a message";

echo "

";

if ($next_index!=$number_of_records)

{
$t1="initial_record=$next_index";
$sort="sort_field=$sort_field";
$asc="sort_direction=$sort_direction";
echo " ";
echo "Last $number_records_to_display messages>>";
}
else
{
echo "There is no message behind|";

}

echo "

";
echo "

";

?>

[I want it too Message]

for ($iindex=0;$iindex<$number_of_records_on_current_page;$iindex++)
{
$record=mysql_fetch_object($result);
require(' display.inc');
}

?>

< ?php
echo "

";
echo "echo "

";

?>

The free guestbook is provided by Little Bear Technical support

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

http://www.bkjia.com/PHPjc/316159.html

Related labels：

bgcolor body head html meta title White challenge Source code of

source：php.cn

Previous article：My forum source code (3)_PHP tutorial Next article：PHP VS ASP_PHP Tutorial

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

Challenge the best guestbook source code (5)_PHP tutorial

留言信息

[I want it too Message]