<?php

$wherelist=array();

if(!empty($_GET['sid']))

{

$wherelist[]=" sid like '%".$_GET['sid']."%'";?

}

if(!empty($_GET['sname']))

{

$wherelist[]=" sname like '%".$_GET['sname']."%'";

}if(!empty($_GET['ssex']))

{

$wherelist[]=" ssex like '%".$_GET['ssex']."%'";

}

$where="";

if(count($wherelist)>0)

{

$where=" where ".implode(' and ',$wherelist);//implode 把數(shù)組元素組合為字符串

}

//分頁(yè)的實(shí)現(xiàn)原理

//1.獲取數(shù)據(jù)表中總記錄數(shù)

$sql="select * from student? $where ";?

$result=mysql_query($sql);

$totalnum=mysql_num_rows($result);

//每頁(yè)顯示條數(shù)

$pagesize=8;

//總共有幾頁(yè)

$maxpage=ceil($totalnum/$pagesize);

$page=isset($_GET['page'])?$_GET['page']:1;//isset函數(shù)是檢測(cè)變量是否設(shè)置。

if($page <1)

{

$page=1;

}

if($page>$maxpage)

{

$page=$maxpage;

}

$limit=" limit ".($page-1)*$pagesize.",$pagesize";//顯示當(dāng)前頁(yè)

$sql0="select yhouse from yuangong where yid='{$_COOKIE['a']}'";

$rs0=mysql_query($sql0,$link);

$row0=mysql_fetch_assoc($rs0);

$yh=$row0['yhouse'];

$sql1="select * from student $where order by sid desc $limit"; //此處加了id降序

$res=mysql_query($sql1);

?>

為甚么我$sql1="select * from student where $yh=shourse $where order by sid desc $limit"; 變成這樣搜索功能就不行了呢？求幫忙謝謝你們！