<?php require_once '../config.php'; checkLogined('../login.html'); ?> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>AdminLTE 2 | 404 Page not found</title> <meta content='width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no' name='viewport'> <!-- Bootstrap 3.3.4 --> <link href="../bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css" /> <!-- Font Awesome Icons --> <link href="../css/font-awesome.min.css" rel="stylesheet" type="text/css" /> <!-- Ionicons --> <link href="../css/ionicons.min.css" rel="stylesheet" type="text/css" /> <!-- Theme style --> <link href="../css/AdminLTE.min.css" rel="stylesheet" type="text/css" /> <!-- AdminLTE Skins. Choose a skin from the css/skins folder instead of downloading all of them to reduce the load. --> <link href="../css/skins/_all-skins.min.css" rel="stylesheet" type="text/css" /> <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries --> <!-- WARNING: Respond.js doesn't work if you view the page via file:// --> <!--[if lt IE 9]> <script src="../js/html5shiv.min.js"></script> <script src="../js/respond.min.js"></script> <![endif]--> </head> <body class="skin-blue sidebar-mini">
<?php require_once '../include.php'; error_reporting(E_ALL & ~E_NOTICE & ~E_WARNING); // !!! shutdown the reporting of notices and warnings!!! checkLogined(); $order = $_REQUEST['order'] ? $_REQUEST['order'] : null; $orderBy = $order ? "order by u." . $order : null; $keywords = $_REQUEST['keywords'] ? $_REQUEST['keywords'] : null; $where = $keywords ? "where u.username like '%{$keywords}%'" : null; //得到数据库中所有用户 $sql = "select u.id,u.username,u.pId,u.cId,u.capacity,u.address,u.phone,u.uDesc,u.pubTime,p.province, c.city from biogas_user as u join biogas_prov p on u.pId=p.id join biogas_city c on u.cId=c.id {$where}"; $totalRows = getResultNum($sql); $pageSize = 6; $totalPage = ceil($totalRows / $pageSize); $page = $_REQUEST['page'] ? (int) $_REQUEST['page'] : 1; if ($page < 1 || $page == null || !is_numeric($page)) { $page = 1; } if ($page > $totalPage) { $page = $totalPage; } $offset = ($page - 1) * $pageSize; $sql = "select u.id,u.username,u.pId,u.cId,u.capacity,u.address,u.phone,u.uDesc,u.pubTime,p.province, c.city from biogas_user as u join biogas_prov p on u.pId=p.id join biogas_city c on u.cId=c.id {$where} {$orderBy} limit {$offset},{$pageSize}"; $rows = fetchAll($sql); ?> <!doctype html> <html> <head> <meta charset="utf-8"> <title>-.-</title>
<li><a href="#">Separated link</a></li> <li role="separator" class="divider"></li> <li><a href="#">One more separated link</a></li> </ul> </li> </ul> <form class="navbar-form navbar-left" role="search"> <div class="form-group"> <input type="text" class="form-control" placeholder="Search" > </div> <button type="submit" class="btn btn-default" name="searchBtn" value="yes">Submit</button> </form> <ul class="nav navbar-nav navbar-right"> <?php if (checkLogined(1)) { ?> <li class="dropdown"> <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false"><?php echo $_SESSION['username']; ?> </a></li> <li><a href="<?php echo url('member', 'logout'); ?> ">退出</a></li> <?php } else { ?>