Пример #1
0
}
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" />
Пример #2
0
                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>
Пример #3
0
<?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] . '" 
Пример #4
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']}");
Пример #5
0
			<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) {
Пример #6
0
<?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}");
}
Пример #7
0
<?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`");
Пример #8
0
					</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";
Пример #9
0
<?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);
}
Пример #10
0
?>
</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 
Пример #11
0
<?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;
Пример #12
0
function summmazakaza($id)
{
    $summzakaz = mysql_assoc("SELECT sum(price) as summa FROM `zakaz` WHERE nzakaz={$id}");
    return $summzakaz[0]["summa"];
}
Пример #13
0
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}");
}
Пример #14
0
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}");
}
Пример #15
0
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}");
}
Пример #16
0
$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'])) {
Пример #17
0
<?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"]);
Пример #18
0
        }
        $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']}");
                }
            }
        }
    }
}
Пример #19
0
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}");
}
Пример #20
0
<?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;
}