if ($stmt === false) { trigger_error('Database error: ' . $sql . ' Error: ' . $this->conn->errno . ' ' . $this->conn->error, E_USER_ERROR); } else { $stmt->bind_param("ssss", $name, $description, $visibility, $category_id); $stmt->execute(); } $stmt->close(); } } /* *--------------------------------------------- * CONTROL *--------------------------------------------- */ $_get = new INSPIRATION_GET(); $_update = new INSPIRATION_UPDATE(); $category_id = filter_var($_REQUEST['ins_id'], FILTER_SANITIZE_NUMBER_INT); $category = $_get->get_category($category_id); $detail_category = $_get->get_category($category_id); /* --- BUTTON HANDLER --- */ if (isset($_POST['btn_detail_project_category'])) { $category_name = filter_var($_POST['category_name'], FILTER_SANITIZE_STRING); $description = ''; $visibility = filter_var($_POST['visibility_status'], FILTER_SANITIZE_STRING); $category_id = filter_var($detail_category->category_id, FILTER_SANITIZE_NUMBER_INT); $_update->update($category_name, $description, $visibility, $category_id); $page = 'self'; $type = 'success'; $msg = 'Changes has been successfully saved'; set_alert($type, $msg); safe_redirect($page);
# ---------------------------------------------------------------------- # INSPIRATION - DETAILS: CONTROL # ---------------------------------------------------------------------- */ $_get = new INSPIRATION_GET(); $inspiration_id = filter_var($_REQUEST['ins_id'], FILTER_SANITIZE_NUMBER_INT); $inspiration = $_get->get_inspiration($inspiration_id); $banner = $_get->get_inspiration_images($inspiration_id); $latest_id_img = $_get->get_latest_inspiration_image_id(); $count_images = $_get->count_inspiration_images($inspiration_id); $products = $_get->get_products(); $featured_ct = $_get->get_inspiration_featured($inspiration_id); $featured_js = $_get->get_inspiration_featured($inspiration_id); $category = $_get->get_category(); if (isset($_POST['btn_edit_inspiration'])) { $_update = new INSPIRATION_UPDATE(); /* --- INSPIRATION --- */ $name = filter_var($_POST['inspiration_name'], FILTER_SANITIZE_STRING); $name_japan = $_POST['inspiration_name_japan']; $description = $_POST['description']; $japan = $_POST['description-japan']; $date_created = date('Y-m-d'); $active = 1; $visibility = 1; $sort = $_POST['order_banner']; $category = filter_var($_POST['inspiration_category'], FILTER_SANITIZE_NUMBER_INT); if ($_POST['meta-description'] != '' && !empty($_POST['meta-description'])) { $meta_desc = filter_var($_POST['meta-description'], FILTER_SANITIZE_STRING); } else { $meta_desc = $_POST['description']; }
if ($_REQUEST['srcval'] == '1') { $class_inspiration_yes = 'selected="selected"'; $class_inspiration_no = ''; } else { $class_inspiration_yes = ''; $class_inspiration_no = 'selected="selected"'; } } } else { $class_inspiration_yes = ''; $class_inspiration_no = ''; } /* --- BUTTON HANDLER --- */ if (isset($_POST['btn_index_inspiration'])) { $inspiration_id = $_POST['inspiration_id']; $_update = new INSPIRATION_UPDATE(); /* --- DELETE --- */ if ($_POST['option-action'] == "delete") { foreach ($inspiration_id as $inspiration_id) { $inspiration_id = filter_var($inspiration_id, FILTER_SANITIZE_NUMBER_INT); $img_file = $_get->get_inspiration_image($inspiration_id); foreach ($img_file as $img_file) { if (is_file(dirname(__FILE__) . '/../../../' . $img_file->image)) { unlink(dirname(__FILE__) . '/../../../' . $img_file->image); } } $_update->delete_inspiration_image($inspiration_id); $_update->delete_inspiration_featured($inspiration_id); $_update->delete_inspiration($inspiration_id); } $page = 'self';
<?php /* # ---------------------------------------------------------------------- # INSPIRATION: CONTROL # ---------------------------------------------------------------------- */ $_get = new INSPIRATION_GET(); $_update = new INSPIRATION_UPDATE(); /* # ---------------------------------------------------------------------- # SORTING # ---------------------------------------------------------------------- */ $equal_search = array('visibility'); $default_sort_by = "category_order"; $pgdata = page_init($equal_search, $default_sort_by); // static/general.php $page = $pgdata['page']; $query_per_page = $pgdata['query_per_page']; $sort_by = $pgdata['sort_by']; $first_record = $pgdata['first_record']; $search_parameter = $pgdata['search_parameter']; $search_value = $pgdata['search_value']; $search_query = $pgdata['search_query']; $search = $pgdata['search']; if (isset($_REQUEST['src'])) { $_REQUEST['src'] = $_REQUEST['src']; } else { $_REQUEST['src'] = ''; }
<?php /* # ---------------------------------------------------------------------- # INSPIRATION - ADD: CONTROL # ---------------------------------------------------------------------- */ $_get = new INSPIRATION_GET(); /* --- CALL FUNCTIONS --- */ $category = $_get->get_category(); $products = $_get->get_products(); if (isset($_POST['btn_add_inspiration'])) { $category = $_get->get_category(); $_update = new INSPIRATION_UPDATE(); /* --- INSPIRATION --- */ $name = filter_var($_POST['inspiration_name'], FILTER_SANITIZE_STRING); $japan_name = $_POST['description-japan']; $description = $_POST['description']; $japan = $_POST['description-japan']; $date_created = date('Y-m-d'); $active = 1; $visibility = 1; $order = $_POST['order_banner']; $category = filter_var($_POST['inspiration_category'], FILTER_SANITIZE_NUMBER_INT); if ($_POST['meta-description'] != '' && !empty($_POST['meta-description'])) { $meta_desc = filter_var($_POST['meta-description'], FILTER_SANITIZE_STRING); } else { $meta_desc = $_POST['description']; } if ($_POST['meta-keywords'] != '' && !empty($_POST['meta-keywords'])) { $meta_keys = filter_var($_POST['meta-keywords'], FILTER_SANITIZE_STRING);