static function editCollection($data)
{
$db = DataBase::getDB();
$collection = $db->{$data}['collection'];
$nuevosdatos = array('$set' => array("name" => $data['name'], "firm" => $data['firm'], "email" => $data['email'], "type" => $data['type']));
$collection->update(array('_id' => new MongoId($data['mongoid'])), $nuevosdatos);
}
public function get_data()
{
$db = DataBase::getDB();
// Создаём объект базы данных
$query = "SELECT ap_id, ap_url, ap_time, ap_title, ap_anons, ap_content FROM articles_pages WHERE `ap_enable` = '1'";
$reply = $db->select($query);
return $reply;
}
public function __construct($table_name)
{
$this->db = DataBase::getDB();
$this->format = new Format();
$this->config = new Config();
$this->check = new Check();
$this->url = new URL();
$this->table_name = $this->config->db_prefix . $table_name;
}
public function get_data_bd($page_name = 'index')
{
//Получаем данные страницы title, описание.
$db = DataBase::getDB();
// Создаём объект базы данных
$query = "SELECT id, name, url, title, description, keywords, text, show_page FROM `basic_pages` WHERE `url` = '{$page_name}'";
$reply = $db->select($query);
return $reply;
}
public static function getSiteData()
{
$DB = DataBase::getDB();
$query = " SELECT `id` " . " FROM `users` ";
$site['total_users'] = count($DB->select($query));
$query = " SELECT `username` " . " FROM `users` " . " WHERE (`login_time` + 30*60) > " . time();
$site['online_users'] = $DB->select($query);
$site['online_count'] = count($site['online_users']);
Registry::set('site', $site);
}
public function __construct($table_name)
{
$this->db = DataBase::getDB();
$this->format = new Format();
$this->config = new Config();
$this->check = new Check();
$this->url = new Url();
$this->table_name = $this->config->db_prefix . $table_name;
//определяем полное название таблицы
}
public static function getUserObj($value, $what = '*', $column = '`id`')
{
$DB = DataBase::getDB();
$query = " SELECT " . $what . " FROM `users` " . " WHERE " . $column . " = {?}";
$params = array($value);
$userData = $DB->selectRow($query, $params);
if (!empty($userData)) {
return new Users($userData);
} else {
return false;
}
}
public function get_data_table_all($mark, $model = 0)
{
$db = DataBase::getDB();
// Создаём объект базы данных
//Если выбрана марка и модель то подгружаем и марку и модель иначе марку
if ($model) {
$query = "SELECT ddl_id, ddl_mark, ddl_mark_title, ddl_model, ddl_model_title, ddl_type_engine, ddl_transmission, ddl_volume_cars, ddl_year_from, ddl_year_to, ddl_name_engine, ddl_price FROM `dvigateli_dlya_legkovyh` WHERE `ddl_mark` = '" . DataBase::mysql_prep($mark) . "' AND `ddl_model` = '" . DataBase::mysql_prep($model) . "'";
} else {
$query = "SELECT ddl_id, ddl_mark, ddl_mark_title, ddl_model, ddl_model_title, ddl_type_engine, ddl_transmission, ddl_volume_cars, ddl_year_from, ddl_year_to, ddl_name_engine, ddl_price FROM `dvigateli_dlya_legkovyh` WHERE `ddl_mark` = '" . DataBase::mysql_prep($mark) . "' GROUP BY ddl_model";
}
$reply = $db->select($query);
return $reply;
}
public function get_data_table_all($mark, $number_view = 'all')
{
$db = DataBase::getDB();
// Создаём объект базы данных
//Проверяем показывать все модели или первые 20
if ($number_view === 'all') {
$query = "SELECT kdg_id, kdg_mark, kdg_mark_title, kdg_model, kdg_model_title, kdg_year, kdg_price, kdg_images, kdg_show FROM `kabiny_dlya_gruzovyh` WHERE `kdg_mark` = '" . DataBase::mysql_prep($mark) . "'";
} else {
$query = "SELECT kdg_id, kdg_mark, kdg_mark_title, kdg_model, kdg_model_title, kdg_year, kdg_price, kdg_images, kdg_show FROM `kabiny_dlya_gruzovyh` WHERE `kdg_mark` = '" . DataBase::mysql_prep($mark) . "' GROUP BY kdg_model LIMIT " . DataBase::mysql_prep($number_view);
}
$reply = $db->select($query);
return $reply;
}
public function get_data_table_all($mark, $number_view = 'all')
{
$db = DataBase::getDB();
// Создаём объект базы данных
//Проверяем показывать все моделт или первые 20
if ($number_view === 'all') {
$query = "SELECT ddl_id, ddl_mark, ddl_mark_title, ddl_model, ddl_model_title, ddl_type_engine, ddl_transmission, ddl_volume_cars, ddl_year_from, ddl_year_to, ddl_name_engine, ddl_price FROM `dvigateli_dlya_legkovyh` WHERE `ddl_mark` = '" . DataBase::mysql_prep($mark) . "'";
} else {
$query = "SELECT ddl_id, ddl_mark, ddl_mark_title, ddl_model, ddl_model_title, ddl_type_engine, ddl_transmission, ddl_volume_cars, ddl_year_from, ddl_year_to, ddl_name_engine, ddl_price FROM `dvigateli_dlya_legkovyh` WHERE `ddl_mark` = '" . DataBase::mysql_prep($mark) . "' GROUP BY ddl_model LIMIT " . DataBase::mysql_prep($number_view);
}
$reply = $db->select($query);
return $reply;
}
public function get_data($filter_page, $filter)
{
switch ($filter_page) {
case 'dvigateli_dlya_legkovyh':
if ($filter) {
//Перебором подставляем все данные которые были выбраны
foreach ($filter as $filter_key => $filter_value) {
if (!empty($filter_value)) {
if (!isset($filter_query)) {
if ($filter_key == "ddl_year") {
$filter_query = " ('" . DataBase::mysql_prep($filter_value) . "' >= ddl_year_from AND '" . DataBase::mysql_prep($filter_value) . "' <= ddl_year_to)";
} else {
$filter_query = "`" . DataBase::mysql_prep($filter_key) . "` = '" . DataBase::mysql_prep($filter_value) . "'";
}
} else {
if ($filter_key == "ddl_year") {
$filter_query .= " AND ('" . $filter_value . "' >= ddl_year_from AND '" . $filter_value . "' <= ddl_year_to)";
} else {
$filter_query .= " AND `" . DataBase::mysql_prep($filter_key) . "` = '" . DataBase::mysql_prep($filter_value) . "'";
}
}
}
}
//Делаем запрос для фильтра
$db = DataBase::getDB();
// Создаём объект базы данных
$query = "SELECT ddl_model, ddl_model_title, ddl_type_engine, ddl_transmission, ddl_volume_cars, ddl_year_from, ddl_year_to FROM `" . DataBase::mysql_prep($filter_page) . "` WHERE " . $filter_query . " ORDER BY ddl_model, ddl_volume_cars, ddl_year_from";
$reply['data_selection'] = $db->select($query);
//Делаем запрос для таблицы
$db = DataBase::getDB();
// Создаём объект базы данных
$query = "SELECT ddl_id, ddl_mark, ddl_mark_title, ddl_model, ddl_model_title, ddl_type_engine, ddl_transmission, ddl_volume_cars, ddl_year_from, ddl_year_to, ddl_name_engine, ddl_price FROM `" . DataBase::mysql_prep($filter_page) . "` WHERE " . $filter_query . " ORDER BY ddl_model, ddl_volume_cars, ddl_year_from";
//echo $query;
$reply['data_table'] = $db->select($query);
//Если пустая выдача
if (empty($reply['data_table']) || empty($reply['data_selection'])) {
unset($reply['data_table']);
unset($reply['data_selection']);
return false;
} else {
return $reply;
}
} else {
return false;
}
break;
case 'kpp_dlya_legkovyh':
if ($filter) {
//Перебором подставляем все данные которые были выбраны
foreach ($filter as $filter_key => $filter_value) {
if (!empty($filter_value)) {
if (!isset($filter_query)) {
if ($filter_key == "kdl_year") {
$filter_query = " ('" . DataBase::mysql_prep($filter_value) . "' >= kdl_year_from AND '" . DataBase::mysql_prep($filter_value) . "' <= kdl_year_to)";
} else {
$filter_query = "`" . DataBase::mysql_prep($filter_key) . "` = '" . DataBase::mysql_prep($filter_value) . "'";
}
} else {
if ($filter_key == "kdl_year") {
$filter_query .= " AND ('" . DataBase::mysql_prep($filter_value) . "' >= kdl_year_from AND '" . DataBase::mysql_prep($filter_value) . "' <= kdl_year_to)";
} else {
$filter_query .= " AND `" . DataBase::mysql_prep($filter_key) . "` = '" . DataBase::mysql_prep($filter_value) . "'";
}
}
}
}
//Делаем запрос для фильтра
$db = DataBase::getDB();
// Создаём объект базы данных
$query = "SELECT kdl_model, kdl_model_title, kdl_type_engine, kdl_transmission, kdl_volume_cars, kdl_year_from, kdl_year_to FROM `" . DataBase::mysql_prep($filter_page) . "` WHERE " . $filter_query . " ORDER BY kdl_model, kdl_volume_cars, kdl_year_from";
$reply['data_selection'] = $db->select($query);
//Делаем запрос для таблицы
$db = DataBase::getDB();
// Создаём объект базы данных
$query = "SELECT kdl_id, kdl_mark, kdl_mark_title, kdl_model, kdl_model_title, kdl_type_engine, kdl_transmission, kdl_volume_cars, kdl_year_from, kdl_year_to, kdl_name_engine, kdl_price FROM `" . DataBase::mysql_prep($filter_page) . "` WHERE " . $filter_query . " ORDER BY kdl_model, kdl_volume_cars, kdl_year_from";
$reply['data_table'] = $db->select($query);
//Если пустая выдача
if (empty($reply['data_table']) || empty($reply['data_selection'])) {
unset($reply['data_table']);
unset($reply['data_selection']);
return false;
} else {
return $reply;
}
} else {
return false;
}
break;
case 'dvigateli_dlya_gruzovyh':
if ($filter) {
//Перебором подставляем все данные которые были выбраны
foreach ($filter as $filter_key => $filter_value) {
if (!empty($filter_value)) {
if (!isset($filter_query)) {
if ($filter_key == "ddg_year") {
$filter_query = " ('" . DataBase::mysql_prep($filter_value) . "' >= ddg_year_from AND '" . DataBase::mysql_prep($filter_value) . "' <= ddg_year_to)";
} else {
$filter_query = "`" . DataBase::mysql_prep($filter_key) . "` = '" . DataBase::mysql_prep($filter_value) . "'";
}
} else {
if ($filter_key == "ddg_year") {
$filter_query .= " AND ('" . DataBase::mysql_prep($filter_value) . "' >= ddg_year_from AND '" . DataBase::mysql_prep($filter_value) . "' <= ddg_year_to)";
} else {
$filter_query .= " AND `" . DataBase::mysql_prep($filter_key) . "` = '" . DataBase::mysql_prep($filter_value) . "'";
}
}
}
}
//Делаем запрос для фильтра
$db = DataBase::getDB();
// Создаём объект базы данных
$query = "SELECT ddg_model, ddg_model_title, ddg_volume, ddg_capacity, ddg_year_from, ddg_year_to FROM `dvigateli_dlya_gruzovyh` WHERE " . $filter_query . " ORDER BY ddg_model, ddg_volume, ddg_year_from";
$reply['data_selection'] = $db->select($query);
//Делаем запрос для таблицы
$db = DataBase::getDB();
// Создаём объект базы данных
$query = "SELECT ddg_id, ddg_mark, ddg_mark_title, ddg_model, ddg_model_title, ddg_modification, ddg_modification_tittle, ddg_model_dvs, ddg_volume, ddg_capacity, ddg_year_from, ddg_year_to, ddg_price FROM `dvigateli_dlya_gruzovyh` WHERE " . $filter_query . " ORDER BY ddg_model, ddg_volume, ddg_year_from";
$reply['data_table'] = $db->select($query);
//Если пустая выдача
if (empty($reply['data_table']) || empty($reply['data_selection'])) {
unset($reply['data_table']);
unset($reply['data_selection']);
return false;
} else {
return $reply;
}
} else {
return false;
}
break;
default:
die;
break;
}
}
function __construct()
{
if (!Registry::get('mysql_error')) {
$this->DB = DataBase::getDB();
}
}
function __construct()
{
$this->DB = DataBase::getDB();
}
public function unique($column, $value)
{
$DB = DataBase::getDB();
$query = " SELECT * " . " FROM `" . self::table() . "` " . " WHERE `" . $column . "` = {?}";
$params = array($this->{$value});
if (count($DB->select($query, $params)) == 0) {
return true;
} else {
return false;
}
}
} else {
return $this->mysqli->insert_id;
}
} else {
return false;
}
}
/* Преобразование result_set в двумерный массив */
private function resultSetToArray($result_set)
{
$array = array();
while (($row = $result_set->fetch_assoc()) != false) {
$array[] = $row;
}
return $array;
}
/* При уничтожении объекта закрывается соединение с базой данных */
public function __destruct()
{
if ($this->mysqli) {
$this->mysqli->close();
}
}
}
$db = DataBase::getDB();
// Создаём объект базы данных
$query = "SELECT * FROM `user` WHERE `id` > {?} ";
$table = $db->select($query, array(10, 1));
// Запрос явно должен вывести таблицу, поэтому вызываем метод select()
/*$query = "SELECT `login` FROM `users` WHERE `email` = {?}";
$login = $db->selectCell($query, array("*****@*****.**"));// Запрос должен вывести конкретную ячейку, поэтому вызываем метод selectCell()*/
