JQuery EasyUI(53)_select id,manager,date from easyui order by $sort -优快云博客

本文详细介绍了一个后台管理系统的设计与实现过程，包括使用HTML、JQuery和PHP进行管理员界面的开发，展示了如何通过这些技术实现管理员账号的展示、添加、修改、删除等功能，并提供了完整的代码示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

第三十九章：后台管理界面--管理员管理[1]

学习要点：

HTML部分
JQuery部分
PHP部分

//admin.php
<?php
 
   session_start();
 
   if(!isset($_SESSION['admin'])){
 
      header(location:login.php);
     } 
?>

//manager.php
<?php
   session_start();
   if(!isset($_SESSION['admin'])){
      header('location:login.php');
    }
?>

<table id="maneger"></table>
<div id="manager_tool" style="padding:5px;">
  <div style="margin-buttom:5px;">
     <a href="#" class="easyui-linkbutton" iconCls="icon-add" plain="true" οnclick="obj.add();">添加</a>
     <a href="#" class="easyui-linkbutton" iconCls="icon-deit" plain="true" οnclick="obj.edit();">修改</a>
     <a href="#" class="easyui-linkbutton" iconCls="icon-remove" plain="true"
οnclick="obj.remove();">删除</a>
     <a href="#" class="easyui-linkbutton" iconCls="icon-save" plain="true"  id="save">保存</a>
     <a href="#" class="easyui-linkbutton" iconCls="icon-redo" plain="true"  id="redo">取消编辑</a>
  </div>
   <div style="padding:0 0 0 7px;color='#ccc'">
       查询账号：<input type="text" name="user" class="textbox" style="width:100px">
       创建时间从：<input type="text" name="date_from" class="easyui-datebox" 
 editable="false" style="width:100px"> 到：<input type="text" name="date_to" class="easyui-datebox" editable="false" style="width:100px">
       <a href="#" class="easyui-linkbutton" iconCls="icon-search" οnclick="obj.search();">查询</a>
   </div>
 </div>


<script type="text/javascript" src="js/manager.js"></scrtpt>

//manager.js

$(function(){

  $('#manager').datagrid({
      url:'manager_data.php';
      fit:true;
      fitColumns:true;
      striped:true;
      rownumbers:true;
      border:false;
      pagination:true;
      pageSize:20;
      pageList:[10,20,30,40,50];
      pageNumber:1;
      sortName:'date';
      sortOrder:'desc';
      toolbar:'#manager_tool';
      columns:[[
         {
          field:'id';
          title:'自动编号';
          width:200px;
          checkbox:true;
         }
         {
          field:'manager';
          title:'管理员账号';
          width:200px;
         }
         {
          field:'auth';
          title:'拥有权限';
          width:200px;
         }
         {
          field:'date';
          title:'创建日期';
          width:200px;
         }
        ]]
  });
});

//manager_data.php

<?php
   require 'config.php';

   $page = $_POST['page'];
   $pageSize = $_POST['rows'];
   $first = $pageSize * ($page - 1);

   $order = $_POST['order'];
   $sort = $_POST['sort'];

   $query = mysql_query("SELECT id,manager,auth,date FROM easyui_admin ORDER BY $order $sort LIMIT $first,$pageSize") or die('SQL 错误！');
   $total = mysql_num_rows(mysql_query("SELECT id,manager,auth,date FROM easyui_admin"));

   $json = '';
 
   while(!!$row = mysql_fetch_array($query,MYSQL_ASSOC)){
     $json .= json_encode($row).',';
  }
 
  $json = substr($json,0,-1);
  echo '{"total" : '.$total.',"rows" : ['.$json.']}';
  mysql_close();

?>

//user.php
<?php

   require 'config.php';

   $page = $_POST['page'];
   $pageSize = $_POST['rows'];
   $first = $pageSize * ($page - 1);

   $order = $_POST['order'];
   $sort = $_POST['sort'];

   $sql = '';
   $user = '';
   $date_from = '';
   $date_to = '';

   if(isset($_POST['user']) && !emtpy($_POST['user'])){
    $user = "user LIKE '%{$_POST['user']}%' AND";
    $sql .= $user;
   }

   if(isset($_POST['date_from']) && !emtpy($_POST['date_from'])){
    $date_from = "date >= '{$_POST['date_from']}' AND";
    $sql .= $date_from;
   }
   
   if(isset($_POST['date_to']) && !emtpy($_POST['date_to'])){
    $date_to = "date <= '{$_POST['date_to']}' AND";
    $sql .= $date_to;
   }

   if(!emtpy($sql){
    $sql = 'WHERE '.substr($sql, 0, -4);
   }

   $query = mysql_query("SELECT id,manager,date FROM easyui_admin ORDER BY $order $sort LIMIT $first,$pageSize") or die('SQL 错误！');
   $total = mysql_num_rows(mysql_query("SELECT id,manager,date FROM easyui_admin"));

   $json = '';
 
   while(!!$row = mysql_fetch_array($query,MYSQL_ASSOC)){
     $json .= json_encode($row).',';
  }
 
  $json = substr($json, 0, -1);
  echo '{"total" : '.$total.', "rows" : ['.$json.'], "footer" : [{"user" : "统计","emial" : "统计","date" : "统计"}]}';
  mysql_close();   
?>

作者：Roger_CoderLife

链接：https://blog.youkuaiyun.com/Roger_CoderLife/article/details/106054561

本文根据网易云课堂JQuery EasyUI视频教程翻译成文档，转载请注明原文出处，欢迎转载