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;
 }
Ejemplo n.º 2
0
    // Создание помошника базы данных
    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 "Нет Результатов";
    }
}
?>