PHP+MYSQL多条件选一通用搜索系统功能单文件7KB

通用功能: 快速填写参数用于自己的mysql数据表搜索,ajax载入数据

header("content-Type: text/html; charset=UTF-8");
//error_reporting(0);
 
$dbhost = "localhost";	//数据库地址本地localhost
$dbuser = "chalidecom";	//数据库账号
$dbpass = "7b4ZEGJTKy";	//数据库密码
$dbname = "chalidecom";	//数据库名称
$dbport = "3306";		//数据库端口号
$dbcode = "UTF8";		//数据库编码  UTF8 GB2312
$biao = "chafenba";    //数据表名称
 
$pagesize = 10;		//每页数量
$maxp = 10;		//最大显示页数
$title = "某某查询系统";		//页面标题
 
$b = array();
 
$b[$biao]["name"]= "成绩表"; //表格名称
$b[$biao]["duan"]= "姓名,学号,身份证号,科目1,科目2,科目3,科目4,科目5,科目,科目N";//显示字段
$b[$biao]["sox"] = "姓名,学号,身份证号";//查询条件
 
/*
//可以连续多组以上数据用于多表
$b["biao2"]["name"]= "其他表"; //表格名称
$b["biao2"]["duan"]= "姓名,学号,身份证号,科目1,科目2,科目3,科目4,科目5,科目,科目N";//显示字段
$b["biao2"]["sox"] = "姓名,学号,身份证号";//查询条件
*/
 
$biao = (isset($_GET['biao']))?addslashes($_GET['biao']):$biao;
if($_GET['Act']=="cha"){
$stime=microtime(true);
$biao = (isset($_POST['biao']))?addslashes($_POST['biao']):$biao;
$search = (isset($_POST["rame"]))?addslashes($_POST["rame"]):'';
$sort = (isset($_POST['sort']))?addslashes($_POST['sort']):"id";//
$order = (isset($_POST['orda']))?addslashes($_POST['orda']):"desc";
$duan = (isset($_POST['duan']))?addslashes($_POST['duan']):"";
$iduan = $b[$biao]["duan"]; $sox = $b[$biao]["sox"];
 $duanx=explode(",", $iduan);
 $duans = "`".join("`,`",$duanx)."`";
 $soxs=explode(",", $sox);
if (!$b[$biao]) exit("该表【{$biao}】不可查(未授权)!"); 
if (!stristr("-desc-asc-","-$order-")) $order = "DESC";
if (!stristr(",$iduan,","-$sort-")) $sort=$soxs[0]; //排序字段:条件1
$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname);
if ($conn->connect_error) { die("Conn.Error: " . $conn->connect_error);}
$sql = "SELECT $duans FROM `{$biao}` ";
$tips = "字段[{$duan}]";
$sqlw = "WHERE `{$duan}` LIKE '%$search%' ";
$sql .= "$sqlw ORDER BY $sort $order ";
$sqc = "SELECT COUNT($sort) AS count FROM `{$biao}` $sqlw ";
$result = $conn->query($sqc);
if (!$result) exit("连接失败信息:".mysqli_error($conn));
$row = $result->fetch_assoc();
$count = $row["count"];
if($count<1) exit("查 表[$biao] => $tips => 关键词[$search]无结果");
$pagecount = ceil($count / $pagesize);
$page = 1;
if (isset($_POST["page"])) { $page = $_POST["page"];}
if ($page < 1) { $page = 1;}
if ($page > $maxp) { exit("[Most $maxp Page]");}
if ($page > $pagecount) { $page = $pagecount;}
if ($pagecount > $maxp) { $pagecount = $maxp;}
$start = ($page - 1) * $pagesize;
$end = $start + $pagesize;
$sql .= " LIMIT $start, $pagesize";
$result = $conn->query($sql);
if (!$result) exit("连接失败信息:".mysqli_error($conn));
echo "";
foreach ($result as $i=>$row) {
if(!$isti){
echo "
\r\n\r\n\r\n\r\n";
$isti="Y";
}
 echo "
\r\n\r\n\r\n\r\n";
}
echo "
".join("
",array_keys($row))."
".join("
",$row)."
";
$etime=microtime(true);
$total = $etime-$stime;
echo "
结果: $count, 页数: $pagecount 耗时: ".round($total,3)." \r\n";
if ($page > 1) { echo "首页 ";}
for ($i = 1; $i <= $pagecount; $i++) {
 if($i == $page){ echo "$i ";}else{ echo "$i,'');\">$i ";}
}
if ($page < $pagecount) { echo "$pagecount,'');\">尾页 ";}
if($count> $maxp*$pagesize) echo "结果{$count}较多:推荐优化输入!";
echo "
";
$conn->close();
exit();
}
?>
"UTF-8">
"viewport" content="width=device-width,minimum-scale=1.0,maximum-scale=1.0">
"apple-mobile-web-app-capable" content="yes" />
  
    
class="logo">php echo $title; ?>div>
    <nav>
      <ul>
php
foreach ($b as $tt=>$vvv) {echo "
$tt\">{$vvv["name"]}
\r\n";}