<?php
foreach ($category as $catname) {
?>
<li style="color:#000;"><?php
echo $catname->name;
?>
<?php
echo "({$total_sub1_ad})";
?>
<?php
}
?>
<ul>
<?php
$subcat = Category_Class::find_by_sql("SELECT * FROM categories WHERE parent_off='" . $catname->id . "' order by name asc LIMIT 0,5 ");
foreach ($subcat as $subcatlist) {
//Total CAt1 Ad//
$total_subsub_add = "SELECT id, COUNT(sub_sub_cat) FROM postcode_location WHERE sub_sub_cat='" . $catname->id . "' AND status='1'";
$result_subsub_add = mysql_query($total_subsub_add) or die(mysql_error());
$row_subsub_add = mysql_fetch_array($result_subsub_add);
$total_subsub_add = $row_subsub_add['COUNT(sub_sub_cat)'];
//End//
?>
<li style="font-size:12px;"><a <?php
if ($cat_id == $sub_cat_id) {
?>
class="leftside_selected" href="#"<?php
}
if ($cat_id != $sub_cat_id) {
?>
<?php
session_start();
include 'index.php';
require_once 'class.Database.php';
require_once 'class.blogData.php';
require_once 'class.CRUDE.php';
//This makes it so it doesn't try and create a new entry everytime you refresh
$check = strlen($_POST["name"]);
if ($check != 0) {
$callClass = new Data_Class();
$callClass->createData($_POST["name"], $_POST["comments"]);
$callOther = new Category_Class();
$art = FALSE;
$left_brain = FALSE;
$diversity = FALSE;
if (isset($_POST["art"])) {
$art = TRUE;
}
if (isset($_POST["left_brain"])) {
$left_brain = TRUE;
}
if (isset($_POST["diversity"])) {
$diversity = TRUE;
}
$callOther->createCategory($art, $left_brain, $diversity);
}
if (isset($_POST["delete"])) {
$callClass->deleteData($_POST["delete"]);
}
if (isset($_POST["sort"]) && !empty($_POST["sort"])) {
" ><?php
echo $subcatlist->name;
?>
<?php
echo "({$total_subsub_add})";
?>
</a></li>
<?php
}
?>
<li id='more' style="cursor:pointer;">View more</li>
<?php
$subhidecat = Category_Class::find_by_sql("SELECT * FROM categories WHERE parent_off='" . $catname->id . "' ORDER BY name asc LIMIT 5,300");
foreach ($subhidecat as $subhid) {
//Total CAt1 Ad//
$total_subsub_add = "SELECT id, COUNT(sub_sub_cat) FROM postcode_location WHERE sub_sub_cat='" . $subhid->id . "' AND status='1'";
$result_subsub_add = mysql_query($total_subsub_add) or die(mysql_error());
$row_subsub_add = mysql_fetch_array($result_subsub_add);
$total_subsub_add = $row_subsub_add['COUNT(sub_sub_cat)'];
//End//
?>
<li id="<?php
echo $subhid->id;
?>
" style="font-size:12px; display:none;"><a style="color:#FFF;" href="http://elaxy.co.uk/cat/<?php
echo $subhid->cat_url;
?>
"><?php
$callClass = new Data_Class();
switch ($_POST["method"]) {
case "Prime (5 days)":
$due_date = date('Y-m-d', strtotime("+5 days"));
break;
case "Regular (10 days)":
$due_date = date('Y-m-d', strtotime("+10 days"));
break;
case "Economy (15 days)":
$due_date = date('Y-m-d', strtotime("+15 days"));
break;
default:
$due_date = date('Y-m-d', strtotime("+300 days"));
}
$callClass->createData($_POST["name"], $_POST["address"], $_POST["item"], $due_date);
$callOther = new Category_Class();
$date = date('Y-m-d');
$callOther->createDelivery($date);
}
if (isset($_POST["delete"])) {
$callClass->deleteData($_POST["delete"]);
}
if (isset($_POST["update"]) && !empty($_POST["update"])) {
$callForm = new Data_Class();
$changeID = $callForm->getID($_POST["update"]);
}
if (isset($_POST["status"]) && $_POST["status"] != "--Get Status--") {
$callClass = new Data_Class();
switch ($_POST["status"]) {
case "Still Assembling":
$callClass->displayData(3);