php 搜索

最新推荐文章于 2021-03-11 21:20:20 发布

heavii

最新推荐文章于 2021-03-11 21:20:20 发布

阅读量417

点赞数

本文链接：https://blog.csdn.net/heavii/article/details/23207791

版权

<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

</head>

<body>
<form form action="" method="post">
            <table align="center" border="1" width="300" cellspacing ="0">
           <tr>
            <td colspan="5" align="center">需要查询的内容:</td></tr><tr>
           <td> <input type="checkbox" name="check[]" value="nam"/>姓名<input type="text" name="nam"/></td>
           <td><input type="checkbox" name="check[]" value="pho"/>电话<input type="text" name="pho"/></td>


           <td><input type="checkbox" name="check[]"value="tim"/>入网时间<input type="text" name="tim"/></td>
           </tr>
           <tr>
           <td><input type="checkbox" name="check[]"value="act"/>角色<input type="text" name="act"/></td>

           <td><input type="checkbox" name="check[]"value="sch"/>所属学校<input type="text" name="sch"/></td>



           <td><input type="checkbox" name="check[]"value="are"/>区局<input type="text" name="are"/></td>

           
           </tr>
            </table>
           <h2 align="center"><input name="submit1" type="submit" value="提交" ></h2>

<?php
session_start();
if($_POST["submit1"]=='提交')
{
$_SESSION['page']=1;
$_SESSION['sql']="";
}
if($_POST["submit1"]=='下一页')
{$_SESSION['page']=(int)$_SESSION['page']+20;}
if($_POST["submit1"]=='上一页'&&(int)$_SESSION['page']>20)
{$_SESSION['page']=(int)$_SESSION['page']-20;}

/*
if(!isset($_SESSION['page'])){
$_SESSION['page']=1;}
$_SESSION['flag']=1;
header("Content-Type:textml;charset=UTF-8");

function sub()
{
      $_SESSION['page']=1;
}

function nextpage()
{
     $_SESSION['page']=(int)$_SESSION['page']+20;

}*/

   //echo "<h2 align='center'><input type='submit' οnclick='nextpage()' ></h2>";
      if($_POST)
   {
   //echo implode($_POST['check'])."</br>";
   //echo $_POST['check'][0];



    $con=mysql_connect('****','****','******') ;

   if(!$con)
   {
        echo "connect error</br>";
        die('Could not connect:'.mysql_error());
   }

   mysql_select_db("jxt",$con);

   $sql="select u.uname as '姓名',u.mobile as '电话',FROM_UNIXTIME(u.ctime) AS '入网时间',
(select group_concat(ts_group.name) from ts_group,ts_group_member where ts_group_member.gid=ts_group.id and ts_group_member.uid=u.uid and ts_group.cid0=1) as '所属学校',
(select group_concat(ts_group.name) from ts_group,ts_group_member where ts_group_member.gid=ts_group.id and ts_group_member.uid=u.uid and ts_group.cid0=6) as '所属班级',
(select count(1) from ts_login_record where uid=u.uid) as '登录次数',
(select group_concat(ts_user_group_link.user_group_title) from ts_user_group_link where ts_user_group_link.uid=u.uid) as '角色',
u.company as '区局' from ts_user u where 1=1 ";

   $count = count($_POST['check']);
   //echo $count;

   for($i=0;$i<$count;$i++)
   {
        //if($i!=0)
       //   $sql=$sql." and ";
       if($_POST['check'][$i]=="nam")
       {
       //echo "-------------";
            $sql=$sql." and u.uname like '%$_POST[nam]%'";
       }else if($_POST['check'][$i]=="pho")
       {$sql=$sql." and u.mobile='$_POST[pho]'";}
       else if($_POST['check'][$i]=="tim")
       {$sql=$sql." and ctime=UNIX_TIMESTAMP('$_POST[tim]')";}
       else if($_POST['check'][$i]=="act")
       {
       if($_POST[act]=="用户") $act="1";
       elseif($_POST[act]=="机构") $act="2";
       elseif($_POST[act]=="客服") $act="3";
       elseif($_POST[act]=="校园指挥长") $act="4";
       elseif($_POST[act]=="校园管理经理") $act="5";
       elseif($_POST[act]=="校园总协调") $act="6";
       elseif($_POST[act]=="兼职客户经理") $act="7";
       elseif($_POST[act]=="网络支援经理") $act="8";
       elseif($_POST[act]=="系统功能使用反馈班") $act="784";

       $sql=$sql." and u.uid IN (SELECT uid from ts_user_group_link where ts_user_group_link.user_group_id='".$act."')";
       }
       else if($_POST['check'][$i]=="sch")
       {$sql=$sql." and u.uid IN (SELECT uid FROM ts_group_member WHERE gid in (SELECT id FROM ts_group WHERE `name` LIKE ('%%$_POST[sch]%%')))";}
       else if($_POST['check'][$i]=="are")
       {$sql=$sql." and u.company LIKE '%%$_POST[are]%%'";}
       /*
        switch($_POST['check'][$i])
        {
        case nam:$sql=$sql."tu.uname like '%$_POST[nam]%'";break;
        case pho:$sql=$sql."tu.uname like '%$_POST[pho]%'";break;
        case tim:$sql=$sql."tu.uname like '%$_POST[tim]%'";break;
        case cou:;
        case act:$sql=$sql."tu.uname like '%$_POST[act]%'";break;
        case sch:$sql=$sql."tu.uname like '%$_POST[sch]%'";break;
        case cla:;
        case sum:;
        case are:$sql=$sql."tu.uname like '%$_POST[are]%'";break;
        case lim:;

        }*/
   }
   if($_SESSION['sql']=="")
   {
   $_SESSION['sql']=$sql;
   }
    $sql=$_SESSION['sql']." limit ".$_SESSION['page'].",20";

   echo $sql;


   mysql_query("SET NAMES 'UTF8'");
    mysql_query("SET CHARACTER SET UTF8");
    mysql_query("SET CHARACTER_SET_RESULTS=UTF8");
   $result = mysql_query($sql);

   echo "<table border='1'>
<tr>
<th>姓名</th>
<th>电话</th>
<th>入网时间</th>
<th>所属学校</th>
<th>所属班机</th>
<th>登陆次数</th>
<th>角色</th>
<th>区局</th>
</tr>";
if(is_resource($result)){
//print_r($result);
while($row= mysql_fetch_array($result))
{
   echo "<tr>";
   echo "<td>" . $row['姓名'] . "</td>";
   echo "<td>" . $row['电话'] . "</td>";
   echo "<td>" . $row['入网时间'] . "</td>";
   echo "<td>" . $row['所属学校'] . "</td>";
   echo "<td>" . $row['所属班级'] . "</td>";
   echo "<td>" . $row['登录次数'] . "</td>";
   echo "<td>" . $row['角色'] . "</td>";
   echo "<td>" . $row['区局'] . "</td>";
   echo "</tr>";
}
}
else
{
     echo "</br>------------无数据----------------";
}
echo "</table>";


    mysql_close($con);

}else
    {
         echo "<h2 align='center'>请先选择需要添加的字段</h2>";

   }

//echo "<a href="s2.php">登陆</a>"
//$_SESSION['page']=(int)$_SESSION['page']+20;
echo $_SESSION['page'];
//session_destroy()
?>
<input type= "submit" name="submit1" " value="上一页"/>
<input type= "submit" name="submit1" " value="下一页"/>


</form>

</body>
</html>