} if (isset($_POST["save"])) { if ($_POST["save"] == "save") { mysql_query("INSERT INTO `koreacars`.`pages` (`id`, `section`, `subsection`, `title`, `title_b`, `meta_description`, `meta_keywords`, `text`, `onoff`) \n\t\t\t\tVALUES (NULL, '{$_GET['section']}', '{$_GET['subsection']}', '{$_POST['title']}', '{$_POST['title_b']}', '{$_POST['meta_description']}',\n\t\t\t\t\t'{$_POST['meta_keywords']}', '{$_POST['text']}', 'off');"); header("Location: " . $_SERVER['REQUEST_URI']); } else { mysql_query("UPDATE `pages` SET `title`='{$_POST['title']}', `title_b`='{$_POST['title_b']}', `meta_description`='{$_POST['meta_description']}'\n\t\t\t, `meta_keywords`='{$_POST['meta_keywords']}', `text`='{$_POST['text']}' WHERE `id`={$_POST['save']}"); header("Location: " . $_SERVER['REQUEST_URI']); } } if (isset($_GET['section']) and isset($_GET['subsection']) and isset($_GET['name'])) { $count_pages = mysql_assoc("SELECT count(*) as count FROM `pages` WHERE section={$_GET['section']} and subsection={$_GET['subsection']}"); if ($count_pages[0]["count"] == 0) { $pages = null; } else { $pages = mysql_assoc("SELECT * FROM `pages` WHERE section={$_GET['section']} and subsection={$_GET['subsection']}"); } } else { $pages = "none"; } include "fns/models/list.php"; ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8" /> <title><?php echo $settings[0]['name']; ?> </title> <meta name="description" content="Angularjs, Html5, Music, Landing, 4 in 1 ui kits package" />
mysql_query("INSERT INTO `cat_model` (`id`, `parent`, `value`, `url`) VALUES (NULL, '{$_POST['marka']}', '{$value}', '{$url}')"); header("Location: " . $_SERVER['REQUEST_URI']); } else { mysql_query("UPDATE `cat_model` SET `parent`='{$_POST['marka']}', `value`='{$value}',`url`='{$url}' WHERE `id`={$_POST['edit']}"); header("Location: " . $_SERVER['REQUEST_URI']); } } } } if (isset($_GET['marka']) and isset($_GET['model'])) { $count_product = mysql_assoc("SELECT count(*) as count FROM `cat_price` WHERE marka={$_GET['marka']} and model={$_GET['model']}"); if ($count_product[0]["count"] == 0) { $product_count = null; } else { $product_count = 1; $product = mysql_assoc("SELECT * FROM `cat_price` WHERE marka={$_GET['marka']} and model={$_GET['model']}"); } } else { $product = false; $product_count = 1; } include "fns/models/catalog.php"; ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8" /> <title><?php echo $settings[0]['name']; ?> </title>
<?php $count = mysql_assoc("SELECT count(*) as count FROM `list_section`"); $count = $count[0]["count"]; if ($count == 0) { $section = false; } else { $item = ceil($count / 10); if (isset($_GET['item'])) { $itemNow = $_GET['item']; } else { $itemNow = 1; } $dataItem = limitItem($itemNow, $item); $limit = $dataItem["limit"]; $section = mysql_assoc("SELECT * FROM `list_section` {$limit}"); } function subsection($id) { $ul = ""; $res = mysql_query("SELECT count(*) FROM `list_subsection` WHERE `parent`={$id}"); while ($row = mysql_fetch_array($res, MYSQL_NUM)) { if ($row[0] > 0) { $ul .= '<ul>'; $res1 = mysql_query("SELECT id,value FROM `list_subsection` WHERE `parent`={$id} ORDER BY `value` ASC"); while ($row1 = mysql_fetch_array($res1, MYSQL_NUM)) { $ul .= '<li data-id="' . $row1[0] . '"> <span> <span class="children">' . $row1[1] . '</span> <i class="fa fa-pencil editSubsection text-info" data-id="' . $row1[0] . '"
<?php mysql_query("UPDATE `zakaz` SET `check` = 1 WHERE nzakaz={$_GET['id']}"); $zakaz_name = mysql_assoc("SELECT * FROM `zakaz` WHERE nzakaz={$_GET['id']} limit 1"); $zakaz = mysql_assoc("SELECT * FROM `zakaz` WHERE nzakaz={$_GET['id']}");
<div class="name_item"><?php echo $product[0]["name"]; ?> </div> <?php $kol_arr = array('1' => $product[0]["k1"], '2' => $product[0]["k2"], '3' => $product[0]["k3"], '4' => $product[0]["k4"], '5' => $product[0]["k5"], '6' => $product[0]["k6"], '7' => $product[0]["k7"], '8' => $product[0]["k8"], '9' => $product[0]["k9"]); ?> <div class="attr"> <div class="attr_item">Номер:</div><div class="value_item"><?php echo $product[0]["nomer"]; ?> </div> <?php foreach ($kol_arr as $k => $v) { if ($v != 0) { $contact_name = mysql_assoc("SELECT value FROM contacts WHERE `id`={$k}"); foreach ($contact_name as $name_key => $name_value) { ?> <div class="attr_item"><?php echo $contact_name[$name_key]["value"]; ?> :</div><div class="value_item"><?php echo $v; ?> шт.</div><?php } } } if ($product[0]["attr"]) { $array = unserialize($product[0]["attr"]); foreach ($array as $key => $value) {
<?php $count = mysql_assoc("SELECT count(*) as count FROM `cat_group`"); $count = $count[0]["count"]; if ($count != 0) { $item = ceil($count / 10); if (isset($_GET['item'])) { $itemNow = $_GET['item']; } else { $itemNow = 1; } $dataItem = limitItem($itemNow, $item); $limit = $dataItem["limit"]; $data_group = mysql_assoc("SELECT * FROM `cat_group` ORDER BY `cat_group`.`value` ASC {$limit}"); }
<?php if (isset($_POST["marka_set"])) { $marka_set = $_POST["marka_set"]; } else { $marka_set = "1"; } $marka = mysql_assoc("SELECT * FROM `cat_marka`"); $model = mysql_assoc("SELECT * FROM `cat_model` WHERE parent ={$marka_set}"); $group = mysql_assoc("SELECT * FROM `cat_group`");
</table> <?php } else { if ($sort == "model") { $item = 4; $sql = "SELECT cat_price.id as id, nomer, name, price,cat_marka.value as marka,cat_model.value as model FROM `cat_price` LEFT JOIN cat_marka on cat_marka.id = cat_price.marka LEFT JOIN cat_model on cat_model.id = cat_price.model WHERE model=" . $model_cat[0]["id"] . " AND " . $rest; } else { if ($sort == "same") { $item = 4; $sql = "SELECT cat_price.id as id, nomer, name, price,cat_marka.value as marka,cat_model.value as model FROM `cat_price` LEFT JOIN cat_marka on cat_marka.id = cat_price.marka LEFT JOIN cat_model on cat_model.id = cat_price.model WHERE model=" . $model_same . " AND " . $rest; } else { $item = 8; $sql = "SELECT cat_price.id as id, nomer, name, price,cat_marka.value as marka,cat_model.value as model FROM `cat_price` LEFT JOIN cat_marka on cat_marka.id = cat_price.marka LEFT JOIN cat_model on cat_model.id = cat_price.model WHERE " . $rest; } } $data = mysql_assoc($sql); shuffle($data); $cat_price = array_slice($data, 0, $item); foreach ($cat_price as $k => $v) { ?> <li class="view__list-item"> <?php $dir = ""; if ($sort == "model") { $dir = "../../"; } else { if ($sort == "same") { $dir = "../"; } } $filename = "photo/" . $cat_price[$k]["nomer"] . ".jpg";
<?php include "../../../bower_components/php/config/bd.php"; if (isset($_POST["id"])) { $model = mysql_assoc("SELECT * FROM `cat_price` WHERE model ={$_POST["id"]}"); echo json_encode($model); }
?> </div> <div class="catalog"> <?php $j = 0; foreach ($marka as $k => $v) { ?> <ul class="catalog__list item<?php echo $marka[$k]["id"]; ?> <?php echo $j == 0 ? 'active' : ''; ?> "> <?php $model = mysql_assoc("SELECT * FROM cat_model WHERE parent={$marka[$k]['id']} ORDER BY `value` ASC"); foreach ($model as $key => $value) { ?> <li class="catalog__list-item"><a href="<?php echo $path; ?> /catalog/<?php echo $marka[$k]["url"]; ?> /<?php echo $model[$key]["url"]; ?> "><?php echo $model[$key]["value"]; ?> </a></li><?php
<?php $marka = mysql_assoc("SELECT * FROM `cat_marka`"); function get_cat() { //запрос к базе данных $sql = "SELECT * FROM cat_menu"; $result = mysql_query($sql); if (!$result) { return NULL; } $arr_cat = array(); if (mysql_num_rows($result) != 0) { //В цикле формируем массив for ($i = 0; $i < mysql_num_rows($result); $i++) { $row = mysql_fetch_array($result, MYSQL_ASSOC); //Формируем массив, где ключами являются адишники на родительские категории if (empty($arr_cat[$row['parent_id']])) { $arr_cat[$row['parent_id']] = array(); } $arr_cat[$row['parent_id']][] = $row; } //возвращаем массив return $arr_cat; } } function view_cat($arr, $parent_id = 0) { //Условия выхода из рекурсии if (empty($arr[$parent_id])) { return;
function summmazakaza($id) { $summzakaz = mysql_assoc("SELECT sum(price) as summa FROM `zakaz` WHERE nzakaz={$id}"); return $summzakaz[0]["summa"]; }
if (isset($_GET["check"])) { switch ($_GET["check"]) { case 'nofeed': $check = "WHERE `check`=0"; break; case 'feed': $check = "WHERE `check`=1"; break; default: $check = ""; break; } } else { $check = ""; } $count = mysql_assoc("SELECT count(*) as count FROM `callback` {$check}"); $count = $count[0]["count"]; if ($count == 0) { $callback = false; } else { $item = ceil($count / 10); if (isset($_GET['item'])) { $itemNow = $_GET['item']; } else { $itemNow = 1; } $dataItem = limitItem($itemNow, $item); $limit = $dataItem["limit"]; $callback = mysql_assoc("SELECT * FROM `callback` {$check} ORDER BY `date` DESC {$limit}"); }
if (isset($_GET["check"])) { switch ($_GET["check"]) { case 'nofeed': $check = "WHERE `type` LIKE 'none'"; break; case 'feed': $check = "WHERE `type` LIKE 'active'"; break; default: $check = ""; break; } } else { $check = ""; } $count = mysql_assoc("SELECT count(*) as count FROM `base_klient` {$check}"); $count = $count[0]["count"]; if ($count == 0) { $callback = false; } else { $item = ceil($count / 10); if (isset($_GET['item'])) { $itemNow = $_GET['item']; } else { $itemNow = 1; } $dataItem = limitItem($itemNow, $item); $limit = $dataItem["limit"]; $callback = mysql_assoc("SELECT * FROM `base_klient` {$check} GROUP BY `phone` {$limit}"); }
if (isset($_GET["check"])) { switch ($_GET["check"]) { case 'nofeed': $check = "WHERE `check`=0"; break; case 'feed': $check = "WHERE `check`=1"; break; default: $check = ""; break; } } else { $check = ""; } $count = mysql_assoc("SELECT count(*) as count FROM `zakaz` {$check}"); $count = $count[0]["count"]; if ($count == 0) { $zakaz = false; } else { $item = ceil($count / 10); if (isset($_GET['item'])) { $itemNow = $_GET['item']; } else { $itemNow = 1; } $dataItem = limitItem($itemNow, $item); $limit = $dataItem["limit"]; $zakaz = mysql_assoc("SELECT * FROM `zakaz` {$check} GROUP BY `nzakaz` ORDER BY `date` DESC {$limit}"); }
$phone = $_POST['phone']; $email = $_POST['email']; $ques = $_POST['ques']; $ref = $_POST['ref']; $utm = $_POST['utm']; $sitename = $_POST['sitename']; $formname = $_POST['formname']; $oform = $_POST['oform']; $td1_style = "border: 1px solid #000; max-width: 140px; padding: 5px 10px; font-weight: bold; background-color: #e8e8e8;"; $td2_style = "border: 1px solid #000; max-width: 460px; min-width: 300px; padding: 5px 10px;"; $msg_top = "\n\t\t<html>\n\t\t\t<body>\n\t\t\t\t<table style=\"border-collapse: collapse;\">\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td style=\"{$td1_style}\">Имя</td>\n\t\t\t\t\t\t<td style=\"{$td2_style}\">{$name}</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td style=\"{$td1_style}\">Номер телефона</td>\n\t\t\t\t\t\t<td style=\"{$td2_style}\">{$phone}</td>\n\t\t\t\t\t</tr>"; $msg_bot = "\n\t\t\t</body>\n\t\t</html>"; if ($oform == 1) { $type = "active"; $zakaz_arr = mysql_assoc("SELECT cat_marka.value as marka, cat_model.value as model , cat_price.name, cat_price.nomer , cat_price.price FROM `basket` LEFT JOIN cat_price on cat_price.id = basket.cat_price_id LEFT JOIN cat_marka on cat_marka.id = cat_price.marka LEFT JOIN cat_model on cat_model.id = cat_price.model WHERE `ip` LIKE '{$ip}'"); $nzakaz = mysql_assoc("SELECT zakaz+1 as countzakaz FROM count"); $zakaz_msg = "<br><br>\n\t\t\t\t<table style=\"border-collapse: collapse;\">\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td style=\"{$td1_style}\">Марка / Модель</td>\n\t\t\t\t\t\t<td style=\"{$td1_style}\">Наименование</td>\n\t\t\t\t\t\t<td style=\"{$td1_style}\">Цена</td>\n\t\t\t\t\t</tr>"; foreach ($zakaz_arr as $k => $v) { $zakaz_msg .= "\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td style=\"{$td2_style}\">" . $zakaz_arr[$k]["marka"] . " / " . $zakaz_arr[$k]["model"] . "</td>\n\t\t\t\t\t\t<td style=\"{$td2_style}\">" . $zakaz_arr[$k]["name"] . "</td>\n\t\t\t\t\t\t<td style=\"{$td2_style}\">" . $zakaz_arr[$k]["price"] . "</td>\n\t\t\t\t\t</tr>"; mysql_query("INSERT INTO `zakaz` (`id`, `marka`, `model`, `nomer`, `name`, `price`, `klient`, `phone`, `email`, `comment`, `date`, `nzakaz`, `check`) VALUES (NULL, '{$zakaz_arr[$k]['marka']}', '{$zakaz_arr[$k]['model']}', '{$zakaz_arr[$k]['nomer']}', '{$zakaz_arr[$k]['name']}', '{$zakaz_arr[$k]['price']}', '{$name}', '{$phone}', '{$email}', '{$ques}', '{$date}', '{$nzakaz[0]['countzakaz']}',0)"); } $zakaz_msg .= "</table>"; mysql_query("DELETE FROM `basket` WHERE `ip` LIKE '{$ip}'"); mysql_query("UPDATE `count` SET zakaz = '{$nzakaz[0]['countzakaz']}' WHERE id =1"); } else { $type = "none"; $zakaz_msg = ""; } $msg_mail = "\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td style=\"{$td1_style}\">Электронный адрес</td>\n\t\t\t\t\t\t<td style=\"{$td2_style}\">{$email}</td>\n\t\t\t\t\t</tr>"; $msg_ques = "\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td style=\"{$td1_style} vertical-align: top;\">Коментарий</td>\n\t\t\t\t\t\t<td style=\"{$td2_style}\">{$ques}</td>\n\t\t\t\t\t</tr>"; if (!empty($_POST['callback'])) {
<?php include "fns/function.php"; if (isset($_GET["id"])) { $product = mysql_assoc("SELECT * FROM `cat_price` WHERE id={$_GET["id"]}"); $marka_view = view_marka($product[0]["marka"]); $model_view = view_model($product[0]["model"]); $group_view = view_group($product[0]["group"]); } if (isset($_POST["save"])) { $marka = trimStr($_POST["addProduct_marka"]); $model = trimStr($_POST["addProduct_model"]); $group = trimStr($_POST["addProduct_group"]); $nomer = trimStr($_POST["nomer"]); $names = trimStr($_POST["names"]); $url = del_extra(translitIt($names)); $price = trimStr($_POST["price"]); $k1 = trimStr($_POST["k1"]); $k2 = trimStr($_POST["k2"]); $k3 = trimStr($_POST["k3"]); $k4 = trimStr($_POST["k4"]); $k5 = trimStr($_POST["k5"]); $k6 = trimStr($_POST["k6"]); $k7 = trimStr($_POST["k7"]); $k8 = trimStr($_POST["k8"]); $k9 = trimStr($_POST["k9"]); $text = trimStr($_POST["text"]); $attr = $_POST["attr"]; $val = $_POST["val"]; $data_attr = serialize(array_combine($attr, $val)); $title = trimStr($_POST["title"]);
} $pages[0]["desc_b"] = $product[0]["description"]; $pages[0]["keyw_b"] = $product[0]["keywords"]; } else { if ($url == "basket") { if ($count_basket[0]["count"] != 0) { $basket = mysql_assoc("SELECT \n\t\t\t\tbasket.id as id, \n\t\t\t\tcat_price.id as id_product, \n\t\t\t\tcat_marka.value as marka, \n\t\t\t\tcat_model.value as model,\n\t\t\t\tcat_price.nomer as nomer,\n\t\t\t\tcat_price.name as name,\n\t\t\t\tcat_price.price as price\n\t\t\tFROM basket \n\t\t\tLEFT JOIN cat_price on cat_price.id=basket.cat_price_id\n\t\t\tLEFT JOIN cat_marka on cat_marka.id=cat_price.marka\n\t\t\tLEFT JOIN cat_model on cat_model.id=cat_price.model\n\t\t\tWHERE ip like '{$ip}'"); } $pages[0]["title_b"] = "Корзина"; } else { if ($url == "404.php") { $pages = true; } else { $submenu = null; $idsection = mysql_assoc("SELECT id FROM list_section WHERE `url` like '{$url}'"); if ($catParent) { $idsubsection = mysql_assoc("SELECT id FROM list_subsection WHERE `url` like '{$catParent}'"); } $count_sub = mysql_assoc("SELECT count(*) as count FROM list_subsection WHERE `parent` like '{$idsection[0]['id']}'"); if ($count_sub[0]["count"] != 0) { $submenu = mysql_assoc("SELECT * FROM list_subsection WHERE `parent` like '{$idsection[0]['id']}'"); } if ($catParent) { $pages = mysql_assoc("SELECT * FROM pages WHERE `subsection`={$idsubsection[0]['id']}"); } else { $pages = mysql_assoc("SELECT * FROM pages WHERE `section`={$idsection[0]['id']}"); } } } } }
if (isset($_GET["check"])) { switch ($_GET["check"]) { case 'nofeed': $check = "WHERE `check`=0"; break; case 'feed': $check = "WHERE `check`=1"; break; default: $check = ""; break; } } else { $check = ""; } $count = mysql_assoc("SELECT count(*) as count FROM `question` {$check}"); $count = $count[0]["count"]; if ($count == 0) { $question = false; } else { $item = ceil($count / 10); if (isset($_GET['item'])) { $itemNow = $_GET['item']; } else { $itemNow = 1; } $dataItem = limitItem($itemNow, $item); $limit = $dataItem["limit"]; $question = mysql_assoc("SELECT * FROM `question` {$check} ORDER BY `date` DESC {$limit}"); }
<?php include "../bower_components/php/config/bd.php"; $ip = $_SERVER["REMOTE_ADDR"]; $page = $_POST['page']; switch ($page) { case 'delCart': $id = $_POST['id']; mysql_query("DELETE FROM `basket` WHERE `id`={$id}"); break; case 'addCart': $id = $_POST['id']; $date = date("Y-m-d"); mysql_query("INSERT INTO `basket` (`id`, `cat_price_id`, `kol`, `ip`, `date`) VALUES (NULL, {$id}, 1, '{$ip}', '{$date}')"); break; case 'countB': $count_basket = mysql_assoc("SELECT count(*) as count FROM basket WHERE ip like '{$ip}'"); echo json_encode($count_basket); break; }