按姓名 >
ue="A">
按職位 |
table>
"query1" value="查找">
{
$db=mysql_connect("localhost","用户名","密码");
$dbname=mysql_select_db("库文件名",$db);
mysql_query('select * from 表文件名',$db);
$limit=2; //一页显示几条内容。
//global $query,$queryyy,$quer;
switch($inout)
{
case "N":
//按姓名查找
$query="select * from card where name like '%$keyword%'";
$queryyy = "select * from card where name like '%$keyword%' order by id desc limit $show, $limit";
break;
case "C":
//按地区查找
$query="select * from card where address like '%$keyword%' order by id desc";
$queryyy = "select * from card where address like '%$keyword%' order by id desc limit $show, $limit";
break;
case "A":
// 按职务查找
$query="select * from card where zw like '%$keyword%' order by id desc";
$queryyy = "select * from card where zw like '%$keyword%' order by id desc limit $show, $limit";
break;
}
$result1=mysql_query($query);
$total=mysql_num_rows($result1); //总的符合条件的记录数
$quer=mysql_query($queryyy,$db);
$pages=ceil($total/$limit);
}
}
?>
你查找的关键字是：:
echo "
查找名片如下: 共有[";
echo $total;
echo "]张名片
|
共分[";
echo $pages;
echo "]页
|
";
while ($row = mysql_fetch_array($quer))
{
echo "
$row[gs]
|
；
;
$row[name] $row[zw]
|
;
;
- 電話：$row[tel]
> - 網址：$row[http]
- 地址：$row[address]
- 郵編：$ >BP:$row[bp]
|
|
">
}
$vor = $show + $limit
> $🎜>$vor = $show + $limit
; - $limit;
列印「」;
列印「 |
"
for ($i= 1;$i {
$new_offset=$limit*($i-1);
$parameter="query1=$query1&key=$keyout&key)=$ ;
列印 " $i$$psp"; 🎜>print " |
“；
//顯示上一頁
if ($show - $limit >= 0)
{
print " 上一頁";
}
印「 |
」；
//顯示下一頁
if (($show + $limit) {
print "下一頁“;
}
print " |
";
//顯示全部留言
//print "全部名片 ";
print " |
