\n"; $Cururl=$_SERVER["SERVER_NAME"]; //echo "server:".$Cururl; $short_site_url = short_url($Cururl); $pagenumber=10;###这是显示留言每页显示条数的控制变量### if (!$show_page) { $show_page=1; } /* $result = mysql($db_name, "SELECT * FROM $db_table_forum WHERE display = 'ON' AND dele <> 'yes' AND sign = '1' AND dspweb = '$short_site_url' ORDER BY landtime DESC "); $toto = mysql_num_rows($result); */ $query_start=($show_page-1)*$pagenumber; echo $query_start; $result = mysql($db_name, "SELECT * FROM $db_table_forum WHERE display = 'ON' AND dele <> 'yes' AND sign = '1' AND dspweb = '$short_site_url' ORDER BY landtime DESC LIMIT $query_start ,10"); $toto = 100;//直接写成100,为加快查询速度,只显示100条记录 $stop=1; $maxpage=($toto%$pagenumber); if ($maxpage != 0 || $toto == 0){ $maxpage=intval($toto/$pagenumber)+1; }else { $maxpage=($toto/$pagenumber); } $show_page_last= $show_page - 1; $i=( $show_page_last * $pagenumber ); if ( $toto > ($show_page * $pagenumber) ){ $torecno= $show_page * $pagenumber; }else{ $torecno = $toto; } $next=0; $page_last= $show_page - 1; if ($toto > ($show_page * $pagenumber)){ $next=1; }else{ $next=0; } //$totomax = $toto + 1000; ///限定查询数 $totomax = $toto; $products =<< 最新$totomax 条信息 | 共 $maxpage 页 | 当前第 $show_page 页 EOT; if ($show_page > 1) { $products .=">>首页\n"; $products .="|上页|\n"; }else{ $products .=">>首页\n"; $products .="|上页|\n"; } if ($next == 1){ $page_next= $show_page + 1; $products .="下页|\n"; $products .="尾页<<\n"; }else{ $products .="|下页|\n"; $products .="尾页<<\n"; } $products .=<< EOT; ///////就是限定查询$pagenumber条显示 $i=0; $torecno=$pagenumber-1; //////// if ($torecno <> '') { while ($i < $torecno){ $pid=mysql_result($result,$i,"id"); $surname=mysql_result($result,$i,"surname"); $surname = stripslashes($surname); $surname = ereg_replace("\"\'\;\(\)", "", "$surname"); $addr=mysql_result($result,$i,"addr"); $addr = stripslashes($addr); $addr = ereg_replace("\"\'\;\(\)", "", "$addr"); $query=mysql_result($result,$i,"query"); $query = stripslashes($query); $query = ereg_replace("\"\'\;\(\)", "", "$query"); $answer=mysql_result($result,$i,"answer"); $answer = stripslashes($answer); $answer = ereg_replace("\"\'\;\(\)", "", "$answer"); $landtime=mysql_result($result,$i,"landtime"); //$ip=mysql_result($result,$i,"ip"); //villy $ip = ''; //villy $age=mysql_result($result,$i,"age"); $mess ="$landtime "; $mess .="$addr "; $mess .="$surname"; $mess .=" "; $mess .="[来自 $ip 这个IP]问:"; $bbsanswer .= <<
$mess

$query
回复:$answer



EOT; $mess = ""; $i++; } } $bbsanswer .= <<
$products

EOT; @mysql_free_result(); @mysql_close(); $client_ip= IP(); //villy $header_file= "bbs.html"; $file = fopen($header_file, "r"); $header = fread($file, filesize($header_file)); $header = eregi_replace('#bbsanswer#', $bbsanswer, $header); $header = eregi_replace('#client_ip#', $client_ip, $header); //villy fclose($file); echo $header; exit; } ########################################################## ## 客户成功案例 ## ########################################################## if ($sign == "2"){ $bbsanswer ="\n"; $result = mysql($db_name, "SELECT * FROM $db_table_forum WHERE display = 'ON' AND dele <> 'yes' AND sign = '2' AND dspweb = '$short_site_url' ORDER BY landtime DESC "); $toto = mysql_num_rows($result); $stop=1; $pagenumber=20;###这是显示留言每页显示条数的控制变量### $maxpage=($toto%$pagenumber); if ($maxpage != 0 || $toto == 0){ $maxpage=intval($toto/$pagenumber)+1; }else { $maxpage=($toto/$pagenumber); } if (!$show_page) { $show_page=1; } $show_page_last= $show_page - 1; $i=( $show_page_last * $pagenumber ); if ( $toto > ($show_page * $pagenumber) ){ $torecno= $show_page * $pagenumber; }else{ $torecno = $toto; } $next=0; $page_last= $show_page - 1; if ($toto > ($show_page * $pagenumber)){ $next=1; }else{ $next=0; } $totomax= $toto+1000; $products =<<
共有 $totomax 条信息 | 共 $maxpage 页 | 当前第 $show_page 页 EOT; if ($show_page > 1) { $products .=">>首页\n"; $products .="|上页|\n"; }else{ $products .=">>首页\n"; $products .="|上页|\n"; } if ($next == 1){ $page_next= $show_page + 1; $products .="下页|\n"; $products .="尾页<<\n"; }else{ $products .="|下页|\n"; $products .="尾页<<\n"; } $products .=<<
EOT; if ($torecno <> '') { while ($i < $torecno){ $pid=mysql_result($result,$i,"id"); $surname=mysql_result($result,$i,"surname"); $surname = stripslashes($surname); $surname = ereg_replace("\"\'\;\(\)", "", "$surname"); $addr=mysql_result($result,$i,"addr"); $addr = stripslashes($addr); $addr = ereg_replace("\"\'\;\(\)", "", "$addr"); $query=mysql_result($result,$i,"query"); $query = stripslashes($query); $query = ereg_replace("\"\'\;\(\)", "", "$query"); $answer=mysql_result($result,$i,"answer"); $answer = stripslashes($answer); $answer = ereg_replace("\"\'\;\(\)", "", "$answer"); $landtime=mysql_result($result,$i,"landtime"); //$ip=mysql_result($result,$i,"ip"); //villy $ip = ''; //villy $age=mysql_result($result,$i,"age"); $mess = "$addr "; $mess .="$surname"; $mess .=" "; $mess .="$age"; $mess .="岁   "; $mess .="$answer - [$landtime] [IP:$ip]"; $bbsanswer .= <<
$mess

$query


EOT; $mess =""; $i++; } } $bbsanswer .= <<
$products

EOT; @mysql_free_result(); @mysql_close(); $header_file= "succeed.htm"; $file = fopen($header_file, "r"); $header = fread($file, filesize($header_file)); $header = eregi_replace('#bbsanswer#', $bbsanswer, $header); fclose($file); echo $header; exit; } ?>