Home > Article > Backend Development > Challenge the best guestbook source code (5)_PHP tutorial

Challenge the best guestbook source code (5)_PHP tutorial

WBOYOriginal: 2016-07-21 16:03:55922browse

留言本

留言信息

      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

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 forum source code (3)_PHP tutorialNext article：My forum source code (3)_PHP tutorial

See more

";
echo "Go to page";

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 "";
echo "[ $ii ]";
}
else
echo "[ $ii ]";

}

echo "Pages of $number_of_pages pages";
echo "

Challenge the best guestbook source code (5)_PHP tutorial

留言信息

[I want it too Message]

Related articles