방명록 최고의 방명록 소스코드에 도전하세요 (5)-PHP 튜토리얼-php.cn

留言信息

      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="$table_name에서 number_of_records로 개수(*)를 선택하세요. ";
$result=mysql_db_query($db_name,$str_sql_all,$id_link);
if (!result)
   { affy_error_exit('SQL 선택 실행에 실패했습니다.');}
$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
             $initial_record,$number_records_to_display 제한 ";
}
$result=mysql_db_query($db_name,$str_sql,$id_link);
if (!$result)
   { affy_error_exit('SQL 선택 실행이 실패했습니다.');}
$number_of_records_
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 "이 페이지는 $을 표시합니다. t2 ~
메시지, 총 $number_of_records ;

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

";
?>

< ;a href=index.html>

[나도 메시지를 남기고 싶습니다]

for ($iindex=0;$iindex<$number_of_records_on_current_page;$iindex )
{
$record =mysql_fetch_object($result);
}
?>
>

echo "

"
echo "

>"
echo " "페이지로 이동;
if (($number_of_records % $number_records_to_display)==0)
{
$number_of_pages=$number_of_records / $number_records_to_display; { $ NUMBER_OF_PAGES = ($ Number_of_records- ($ Number_OF_RECORDS % $ Number_Records_TO_DISPLAY))/$ Number_Records_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 ]"
| /font>page";
echo "

";
echo "

";
?>

留言信息

[나도 메시지를 남기고 싶습니다]

관련 기사