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);
