user_manage2

这是user_manager。php文件请于user_manage.js和user_manage.html(在源文件中也叫user_manage。php但位置不同)一同参考

USER_MANAGE.PHP <?php include '../comm.do' ?> <?php include 'mysql.class.do' ?> <?php function query() { $db=new mysql_db(); $where="1=1 "; $page=0; $pageSize=10; // foreach ($_POST as $key => $value) // { // msg_debug($key."---------".$value); //} if ($_POST["cpage"]!=null&&$_POST["cpage"]>1) $page=$_POST['cpage']-1; if ($_POST['limit']!=null) $pageSize=$_POST['limit']; if ($_POST['groupId']!=null && $_POST['groupId']>0) { $where=$where." and PARENT_ID=".$_POST['groupId']; } if ($_POST['dep_id']!=null && $_POST['dep_id']>0) { $where=$where." and ROLE_ID=".$_POST['dep_id']; } // for department if ($_SESSION['login_dep_id']!=null && $_SESSION['login_dep_id']!=0) { // $where=$where." and ROLE_ID=".$_SESSION['login_dep_id']; } if ($_GET['audit_status']!=null) { if ($_GET['audit_status']==1) $where=$where." and audit_status=1"; else $where=$where." and audit_status!=1"; } if ($_GET['audit_status']!=null) { if ($_GET['audit_status']==1) $where=$where." and audit_status=1"; else $where=$where." and audit_status!=1"; } if ($_GET['expire']!=null) $where=$where." and (enabled_end_time<now() or enabled_begin_time>now())"; if ($_GET['field']!=null) { if ($_GET['query_select']=="like") $where=$where." and ".$_GET['field']." ".$_GET['query_select']." '%".$_GET['value']."%'"; else if ($_GET['query_select']=="=") { $where=$where." and ".$_GET['field'].$_GET['query_select']."'".$_GET['value']."'"; } else if ($_GET['query_select']==">=") $where=$where." and ".$_GET['field']." ".$_GET['query_select'].$_GET['value']; else if ($_GET['query_select']=="<=") $where=$where." and ".$_GET['field']." ".$_GET['query_select'].$_GET['value']; } if ($_POST['begin_time']!=null) { $where=$where." and CREATE_TIME>'".$_POST['begin_time']."'"; } if ($_POST['end_time']!=null) { $where=$where." and CREATE_TIME<'".$_POST['end_time']."'"; } if ($_POST['query_select']!=null) { $where=$where." and ( USERNAME like '%".$_POST['query_select']."%' or PHONE like '%".$_POST['query_select']."%' or MAIL like '%".$_POST['query_select']."%' or QQ like '%".$_POST['query_select']."%' or TELLPHONE like '%".$_POST['query_select']."%')"; } msg_debug($where); $order_string="order by USER_ID desc"; if ($_POST["sort"]!=null){ $order_string="order by ".$_POST["sort"]." ".$_POST["order"]; } $db->queryByPage("*","wh_username",$where,$page,$pageSize,$order_string); $allData=$db->fetchAll(); $arr=array(); $arr["total"]=(int)$db->getTotal(); $arr["rows"]=$allData; $arr["pageSize"]=$pageSize; echo json_encode($arr); $db->close(); } //for add player function add() { foreach ($_POST as $key => $value) { // msg_debug($key."--^_^-------".$value); } $db = new mysql_db();

这是user_manager。php文件请于user_manage.js和user_manage.html(在源文件中也叫user_manage。php但位置不同)一同参考

$arr = array(); $arr["USERNAME"] = $_POST['USERNAME']; $arr["PASSWORD"] = $_POST['PASSWORD']; $arr["PHONE"] = $_POST['PHONE']; $arr["MAIL"] = $_POST['MAIL']; $arr["QQ"] = $_POST['QQ']; $arr["TELLPHONE"] = $_POST['TELLPHONE']; $arr["COMMT"] = $_POST['COMMT']; $db->executeInsert( "wh_username", $arr ); $db->close(); } function delete() { $db = new mysql_db(); $files = split ( ';', $_POST['del_list'] ); foreach( $files as $k => $v ) { if ( strlen( $v ) > 0 ) { $db->execute("delete from wh_username where USER_ID=".$v ); } } $db->close(); } function edit() { $db = new mysql_db(); $files = split ( ';', $_POST['del_list'] ); $arr = array(); $arr["USERNAME"] = $_POST['USERNAME1']; $arr["PASSWORD"] = $_POST['PASSWORD1']; $arr["PHONE"] = $_POST['PHONE1']; $arr["MAIL"] = $_POST['MAIL1']; $arr["QQ"] = $_POST['QQ1']; $arr["TELLPHONE"] = $_POST['TELLPHONE1']; $arr["COMMT"] = $_POST['COMMT1']; $db->executeUpdate( "wh_username", $arr," where USER_ID=".$_POST["USER_ID1"]); $db->close(); } msg_debug("action=".$_GET['action']); if ( $_GET['action'] != null && $_GET['action'] == "add" ) { msg_debug("add"); add(); } else if ( $_GET['action'] != null && $_GET['action'] == "delete" ) { delete(); } else if ( $_GET['action'] != null && $_GET['action'] == "edit" ) { edit(); } else if ($_GET['action']!=null && $_GET['action']=="query") { query(); } ?>