挑戰最棒的留言本的源碼(五)

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

<!–
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>

<?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(和PHP搭配之最佳組合)_db_query($db_name,$str_sql_all,$id_link);

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

$record=@MySQL(和PHP搭配之最佳組合)_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(和PHP搭配之最佳組合)_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(和PHP搭配之最佳組合)_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;
       }  

發佈留言