private function getEmailAdress($shop) { $this->feedbackEmail = ''; $sqlHelper = new MysqliHelper(); $query = "SELECT `feedbackEmail` FROM `ContactsUnits` WHERE `unit`= '" . $shop . "' ;"; $email = $sqlHelper->select($query, 1); if (is_array($email) && isset($email['feedbackEmail'])) { $this->feedbackEmail = $email['feedbackEmail']; return true; } return false; }
// Создание помошника базы данных global $_SQL_HELPER; $_SQL_HELPER = new MysqliHelper(); // Поулчение параметров ссылки $urlParams = new UrlParams(); global $_URL_PARAMS; $_URL_PARAMS = $urlParams->getUrlParam(); $urlHelper = new UrlHelper(); $search = $_POST['search']; $search = addslashes($search); $search = htmlspecialchars($search); $search = stripslashes($search); if ($search == '') { exit(""); } $sqlHelper = new MysqliHelper(); $query = "SELECT * FROM `Users` WHERE `login` LIKE '{$search}%';"; $result = $sqlHelper->select($query); 'http://jiyuu-fest.ru/accounts/rus/Makson/'; $page = 'accounts'; if ($result != null) { foreach ($result as $user) { $params[0] = $user['login']; $url = $urlHelper->pageUrl($page, $params); echo "<div class='searchResultElement'><a href='{$url}'>" . $user['login'] . "</a></div>"; } } else { echo "Нет Результатов"; } } ?>