>
>
>
>
>
>
user_back.php
<?php /** * Поиск пользователей на сайте. */ $page = 'spravka'; $title = 'Поиск пользователей'; require_once (__DIR__ . '/../autoloader.php'); require_once (__DIR__ . '/../inc/top_new.inc'); use app\core\helpers\DbHelper; $isSearched = false; $users = []; if (array_key_exists('nick', $_GET)) { $whereFragmentArray = []; $limit = 20; if (isset($_GET['nick']) && mb_strlen($_GET['nick'], 'UTF-8') > 0 ) { $whereFragmentArray[] = 'name like "%' . DbHelper::noQuote($_GET['nick']) . '%"'; } if (isset($_GET['fio']) && mb_strlen($_GET['fio'], 'UTF-8') > 0 ) { $whereFragmentArray[] = 'name_full like "%' . DbHelper::noQuote($_GET['fio']) . '%"'; } if (isset($_GET['email']) && mb_strlen($_GET['email'], 'UTF-8') > 0 && filter_var($_GET['email'], FILTER_VALIDATE_EMAIL)) { $whereFragmentArray[] = 'pubmail like "%' . DbHelper::noQuote($_GET['email']) . '%"'; } if (isset($_GET['sex']) && $_GET['sex'] > 0) { $whereFragmentArray[] = 'sex = ' . (int)$_GET['sex']; } $sql = ' select SQL_CALC_FOUND_ROWS id, name, name_full, pubmail, berstday, sex from `user` where '.implode(' AND ', $whereFragmentArray) .' order by user.name limit '. (int)(App::$request->get('page', 1)-1) * $limit . ', 20 '; $users = App::$command ->createCommand($sql) ->queryAll(); $total = App::$command ->createCommand(' SELECT FOUND_ROWS() as total ') ->queryOne('total', 0); $isSearched = true; } ?> <div class="uk-container uk-container-center"> <div class="uk-grid"> <div class="uk-width-xlarge-4-5 uk-width-large-7-10 uk-width-medium-6-10 uk-width-small-1-1"> <div class="uk-flex uk-flex-middle uk-flex-space-between "> <div class="page-header"> <h1><a href="/search/user.php"><span class="orange">Поиск</span> пользователей</a></h1> </div> </div> <hr class="uk-grid-divider"> <section> <form class="uk-form" method="get"> <div class="uk-form-row"> <label class="uk-form-label"> Ник </label> <div class="uk-form-controls"> <input type="text" class="uk-width-1-2" name="nick" value="<?=App::$request->get('nick');?>"> </div> </div> <div class="uk-form-row"> <label class="uk-form-label"> ФИО </label> <div class="uk-form-controls"> <input type="text" class="uk-width-1-2" name="fio" value="<?=App::$request->get('fio');?>"> </div> </div> <div class="uk-form-row"> <label class="uk-form-label"> Email </label> <div class="uk-form-controls"> <input type="email" class="uk-width-1-2" name="email" value="<?=App::$request->get('email');?>"> </div> </div> <div class="uk-form-row"> <label class="uk-form-label"> Пол </label> <div class="uk-form-controls"> <select name="sex"> <option value="0" <?php if (App::$request->get('sex', 0) == 0) { echo ' selected'; } ?>>не имеет значения</option> <option value="1" <?php if (App::$request->get('sex', 0) == 1) { echo ' selected'; } ?>>муж</option> <option value="2" <?php if (App::$request->get('sex', 0) == 02) { echo ' selected'; } ?>>жен</option> </select> </div> </div> <div class="uk-form-row"> <div class="uk-form-controls"> <button type="submit" class="uk-button btn-orange">Поиск</button> </div> </div> </form> <?php if ($isSearched == true) { ?> <!-- блок найденых пользователей --> <div class="found-users"> <table class="uk-table"> <thead> <tr> <th>Ник</th> <th>ФИО</th> <th>Email</th> <th>Дата рождения</th> <th>Пол</th> </tr> </thead> <tbody> <?php foreach ($users as $user) { ?> <tr> <td> <a href="/user_info.php?login_user=<?=$user['name'];?>"> <?=$user['name'];?> </a> </td> <td><?=$user['name_full'];?></td> <td><?=$user['pubmail'];?></td> <td> <?php if (strtotime($user['berstday']) > 0) { ?> <?=\app\core\helpers\RuDate::getDate($user['berstday']);?> <?php } ?> </td> <td><?=App::$user->getSexString($user['sex'], ['средний', 'мужской', 'женский']);?></td> </tr> <?php } ?> </tbody> </table> <?php $pagination = new \app\widgets\Pagination(); $pagination->display(ceil($total / $limit), 'user.php'); ?> </div> <!-- // --> <?php } ?> </section> </div> <div class="uk-width-large-1-5 uk-width-medium-1-5 uk-width-small-1-1"> <?php App::$banner->show('spravka', 3, 'rand'); ?> <div class="uk-margin-top"> <?php App::$view->render('sidebar/vk'); ?> </div> </div> </div> </div> <?php require_once (__DIR__ . '/../inc/bottom_new.inc'); ?>
/search/
..
2026-10-02
user.php
2023-12-21
7 .
user.php~
2019-03-04
7 .
user_back.php
2017-12-08
7 .
/search
1
2
3
..
