这是数据库查询结果的页面!怎么分页啊?谁给改改!
时间:2011-03-09
来源:互联网
<?php
$lnk = mysql_connect('localhost', 'root', '') or die ('Not connected : ' . mysql_error());
mysql_select_db('guestbook', $lnk) or die ('Can\'t use zhangmeng : ' . mysql_error());
mysql_query("SET NAMES utf8");
if(@$_GET[key]){
@$k=explode(" ",$_GET[key]);
@$sql = "SELECT * FROM message WHERE content like '%$k[0]%' and content like '%$k[1]%'";
$query=mysql_query($sql);
echo '<h4>'.'您搜索的内容包含<font color="#FF0000">'.@$_GET[key].'</font>共有'.mysql_num_rows($query).'条记录'.'</h4>';
echo "<hr width=0>";
while ($row = mysql_fetch_array($query)) {
//@$row[content]=preg_replace("/($k[0])/i","<font color=red><b>\\1</b></font>", $row[content]);
//@$row[content]=preg_replace("/($k[1])/i","<font color=red><b>\\1</b></font>", $row[content]);
echo "<table width='1000' border='0' cellspacing='0' cellpadding='0'>";
$j = 1;
{
$bgcolor = ( $row["sub"] == '<font color="red">【招聘】</font>' ) ? '#d5f2a6' : '#FFFFFF';
echo '<tr height="30" bgcolor="'.$bgcolor.'">';
echo "<td class='a'><i>";
echo $row["sub"] . strip_tags($row["content"]);
echo "</td></i>";
echo "<td align='center' class='b' bgcolor='#d5f2a6' width='100'>";
echo " ".$row["date"];
echo "</td></tr>";
$j++;
}
echo "</table>";
}
}
?>
$lnk = mysql_connect('localhost', 'root', '') or die ('Not connected : ' . mysql_error());
mysql_select_db('guestbook', $lnk) or die ('Can\'t use zhangmeng : ' . mysql_error());
mysql_query("SET NAMES utf8");
if(@$_GET[key]){
@$k=explode(" ",$_GET[key]);
@$sql = "SELECT * FROM message WHERE content like '%$k[0]%' and content like '%$k[1]%'";
$query=mysql_query($sql);
echo '<h4>'.'您搜索的内容包含<font color="#FF0000">'.@$_GET[key].'</font>共有'.mysql_num_rows($query).'条记录'.'</h4>';
echo "<hr width=0>";
while ($row = mysql_fetch_array($query)) {
//@$row[content]=preg_replace("/($k[0])/i","<font color=red><b>\\1</b></font>", $row[content]);
//@$row[content]=preg_replace("/($k[1])/i","<font color=red><b>\\1</b></font>", $row[content]);
echo "<table width='1000' border='0' cellspacing='0' cellpadding='0'>";
$j = 1;
{
$bgcolor = ( $row["sub"] == '<font color="red">【招聘】</font>' ) ? '#d5f2a6' : '#FFFFFF';
echo '<tr height="30" bgcolor="'.$bgcolor.'">';
echo "<td class='a'><i>";
echo $row["sub"] . strip_tags($row["content"]);
echo "</td></i>";
echo "<td align='center' class='b' bgcolor='#d5f2a6' width='100'>";
echo " ".$row["date"];
echo "</td></tr>";
$j++;
}
echo "</table>";
}
}
?>
作者: a262131247 发布时间: 2011-03-09
limt
作者: zmzkkk 发布时间: 2011-03-18
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28