function PageMain() { global $TMPL, $LNG, $CONF, $db, $settings; $dir = new alumnidir(); $dir->db = $db; $dir->url = $CONF['url']; $dir->per_page = $settings['uperpage']; if (isset($_POST['search'])) { // Verification usage $dir->name = $_POST['name']; $dir->course = $_POST['course']; $dir->branch = $_POST['branch']; $dir->tyear = $_POST['tyear']; //$dir->dob = $settings['captcha']; $searchdata = ""; if (!empty($_POST['name'])) { $searchdata .= "concat_ws(' ', `first_name`, `last_name`) LIKE '%{$dir->name}%' AND "; } if (!empty($_POST['course'])) { $searchdata .= "`course`='{$dir->course}' AND "; } if (!empty($_POST['branch'])) { $searchdata .= "`branch`='{$dir->branch}' AND "; } if (!empty($_POST['tyear'])) { $searchdata .= "`join` LIKE '_____%{$dir->tyear}%' AND "; } if ($searchdata != "") { $searchdata = " WHERE " . substr($searchdata, 0, -5) . " LIMIT 0 , 10"; } else { $searchdata = $searchdata . " LIMIT 0 , 10"; } $dir->searchdata = $searchdata; $TMPL['users'] = $dir->dirgetSearch(); } else { $TMPL['users'] = $dir->dirgetUsers(0); } $skin = new skin('welcome/directory'); $page = ''; $TMPL['jyear'] = generateDateForm(0, $join[0]); $TMPL['tyear'] = generateDateForm(0, $join[1]); $TMPL['url'] = $CONF['url']; $TMPL['title'] = $LNG['Directory'] . ' - ' . $settings['title']; // Save the array returned into a list return $skin->make(); }
<?php include "../includes/config.php"; include "../includes/classes.php"; include getLanguage(null, !empty($_GET['lang']) ? $_GET['lang'] : $_COOKIE['lang'], 2); session_start(); $db = new mysqli($CONF['host'], $CONF['user'], $CONF['pass'], $CONF['name']); if ($db->connect_errno) { echo "Failed to connect to MySQL: (" . $db->connect_errno . ") " . $db->connect_error; } $db->set_charset("utf8"); $resultSettings = $db->query(getSettings()); $settings = $resultSettings->fetch_assoc(); if (isset($_POST['start'])) { $dir = new alumnidir(); $dir->db = $db; $dir->url = $CONF['url']; $dir->per_page = $settings['uperpage']; echo $dir->dirgetUsers($_POST['start']); }