<?php
if (!empty($keyword)){
$page = intval($_GET['page']);
echo $page;
if(!empty($page)) {
$start_limit = ($page - 1) * $page_num;
} else {
$start_limit = 0;
$page = 1;
}
$db=mysql_connect($servername,$dbusername,$dbpassword) or die ("数据库连接失败");
mysql_select_db($dbname,$db);
$search = "title LIKE '%$keyword%' || content LIKE '%$keyword%'";
$query=mysql_query("SELECT COUNT(*) FROM $article_table WHERE $search");
$tatol = mysql_result($query,0); //$tatol=4
$multipage = multi($tatol, $page_num, $page, "search.php?keyword=$keyword");
$result = mysql_query("SELECT * FROM $article_table WHERE $search ORDER BY id DESC LIMIT $start_limit, $page_num");
// 如果没有记录
if ($tatol <=0){
echo "| 未找到您需要的记录 - \n";
echo "点击这里返回 | \n";
exit;
}
while ($row=mysql_fetch_array($result))
{
if($bgcolor == "$first_color"){
$bgcolor="$second_color";
}else{
$bgcolor="$first_color";
}
// 显示列表记录
echo "\n";
echo "\n";
echo "".htmlspecialchars($row[title])." - \n";
echo "$row[date] - by ".htmlspecialchars($row[author])." \n";
echo "".htmlspecialchars($row[description])."\n";
echo " | \n";
} // while
echo "\n";
echo "| 共搜索到 ".$tatol." 篇文章 | \n";
echo "\n";
echo $multipage;
echo " | \n";
echo " \n";
echo "\n";
}
?>
|
| <?php include("foot.php"); ?>
|
想把分页函数那一段单独写成一个文件,用require引用,但实验了一下不行,只能显示第一页,但如果照上面的程序执行,就没问题。请问为什么?
提问者:calex 08-17 11:11
答复
| 我也来回答: |
不管你有没有帮助我们,瓦岗寨8万村民将感谢你。。。。。
|
[]
©2007 PhpRes.COM |