function update($post_category_name, $post_category_description, $post_category_level, $post_category_order, $post_active, $post_visibility, $post_lang_code, $post_id_param) { $conn = connDB(); $sql = "UPDATE tbl_category_lang set `category_name` = '{$post_category_name}', \n `category_description` = '{$post_category_description}', \n\t\t\t\t\t\t\t\t\t\t `category_level` = '{$post_category_level}', \n\t\t\t\t\t\t\t\t\t\t `category_order` = '{$post_category_order}', \n\t\t\t\t\t\t\t\t\t\t `active` = '{$post_active}', \n\t\t\t\t\t\t\t\t\t\t `visibility` = '{$post_visibility}', \n\t\t\t\t\t\t\t\t\t\t `language_code` = '{$post_lang_code}'\n\t\t WHERE `id_param` = '{$post_id_param}'\n\t\t\t"; $query = mysql_query($sql, $conn) or die(mysql_error()); return $result; }
function listCategoryColor($level, $parent, $current_category, $data) { $conn = connDB(); $get_data = mysql_query("SELECT * from tbl_tag AS cat INNER JOIN tbl_tag_relation AS cat_rel ON cat.category_id = cat_rel.category_child\n\t WHERE cat.category_level = '{$level}' AND cat_rel.category_parent = '{$parent}' ORDER BY category_order", $conn); if (mysql_num_rows($get_data) != null && mysql_num_rows($get_data) != 0) { for ($counter = 1; $counter <= mysql_num_rows($get_data); $counter++) { $get_data_array = mysql_fetch_array($get_data); $new_level = $level * 1 + 1; $new_parent = $get_data_array["category_id"]; $check = get_colored($get_data_array['category_id'], $data); echo '<div class="col-xs-9 '; if ($level !== 1) { echo 'hidden'; } echo ' ">'; echo '<input type="checkbox" '; if ($check['rows'] > 0) { echo 'checked="checked" '; } echo 'class="form-control' . $level . '" data-level="' . $level . '" id="option_level_' . $level . '"value="' . $new_parent . '" style="margin-bottom:10px;" name="tag_id[]">'; echo ' '; for ($i = 0; $i < $level; $i++) { echo '-- '; } echo $get_data_array["category_name"]; echo '</div>'; listCategoryColor($new_level, $new_parent, $current_category, $data); } } }
function update_sizefit() { $conn = connDB(); $product_category = $_POST["product_category"]; $product_size_type_id = $_POST["size_type_id"]; $product_name = $_POST["product_name"]; $type_name = $_POST["type_name"]; //array $type_sizefit = $_POST["type_sizefit"]; //array $product_id = $_POST["product_id"]; if ($product_id == '') { //get the new product id $get_id = mysql_query("\n\t\t\t\t SELECT * from tbl_product\n\t\t\t\t WHERE product_category = '{$product_category}' AND product_name = '{$product_name}' AND product_size_type_id = '{$product_size_type_id}'\n\t\t\t\t ORDER BY id DESC\n\t\t\t\t ", $conn); if (mysql_num_rows($get_id) != null) { $get_id_array = mysql_fetch_array($get_id); $product_id = $get_id_array["id"]; } } //!product types for ($i = 1; $type_name[$i] != null; $i++) { echo $sql = "\n\t\t\t\t UPDATE tbl_product_type\n\t\t\t\t SET type_sizefit = '{$type_sizefit[$i]}'\n\t\t\t\t WHERE type_name = '{$type_name[$i]}' AND product_id='{$product_id}'\n\t\t\t\t "; mysql_query($sql, $conn); } }
function get_product_id_how($post_product_alias) { $conn = connDB(); $sql = "SELECT * FROM tbl_product WHERE `product_alias` = '{$post_product_alias}'"; $query = mysql_query($sql, $conn) or die(mysql_error()); $result = mysql_fetch_array($query); return $result; }
function get_order_gallery() { $conn = connDB(); $sql = "SELECT * FROM `tbl_gallery` ORDER BY `order` DESC LIMIT 1"; $query = mysql_query($sql, $conn); $result = mysql_fetch_array($query); return $result; }
function get_filtered($post_product_id, $post_filter_id) { $conn = connDB(); $sql = "SELECT COUNT(*) AS rows FROM tbl_filter_item WHERE `filter_param` = '{$post_filter_id}' AND `product_param` = '{$post_product_id}'"; $query = mysql_query($sql, $conn); $result = mysql_fetch_array($query); return $result; }
function get_how($post_product_id) { $conn = connDB(); $sql = "SELECT * FROM tbl_product_custom WHERE `product_id` = '{$post_product_id}'"; $query = mysql_query($sql, $conn); $result = mysql_fetch_array($query); return $result; }
function breadcrumbs_get_user_name($post_user_alias) { $conn = connDB(); $sql = "SELECT * FROM tbl_user WHERE `user_alias` = '{$post_user_alias}'"; $query = mysql_query($sql, $conn); $result = mysql_fetch_array($query); return $result; }
function delete_inspiration($post_ins_id) { $conn = connDB(); $sql = "DELETE FROM tbl_inspiration_image WHERE `inspiration_image_id` = '{$post_ins_id}'"; $query = mysql_query($sql, $conn); $result = mysql_fetch_array($query); return $result; }
function get_default($post_category_id) { $conn = connDB(); $sql = "SELECT * FROM tbl_news_category WHERE `category_id` = '{$post_category_id}'"; $query = mysql_query($sql, $conn); $result = mysql_fetch_array($query); return $result; }
function count_filter($post_filter_name) { $conn = connDB(); $sql = "SELECT COUNT(*) AS rows FROM tbl_filter_sub WHERE `filter_name` = '{$post_filter_name}' "; $query = mysql_query($sql, $conn); $result = mysql_fetch_array($query); return $result; }
function get_product_id_how() { $conn = connDB(); $sql = "SELECT MAX(id) as product_id FROM tbl_product"; $query = mysql_query($sql, $conn) or die(mysql_error()); $result = mysql_fetch_array($query); return $result; }
function getRecipe($post_recipe_name, $post_recipe_id) { $conn = connDB(); $sql = "SELECT * FROM tbl_recipes WHERE `recipe_name` = '{$post_recipe_name}' AND `recipe_id` = '{$post_recipe_id}'"; $query = mysql_query($sql, $conn); $result = mysql_fetch_array($query); return $result; }
function custom_get_files($post_product_id) { $conn = connDB(); $sql = "SELECT * FROM tbl_product_files WHERE `product_id` = '{$post_product_id}'"; $query = mysql_query($sql, $conn) or die(mysql_error()); $result = mysql_fetch_array($query); return $result; }
function insert_wishlist($ajx_user,$date,$ajx_type,$ajx_stock,$ajx_qty){ $conn = connDB(); $sql = "INSERT INTO tbl_wishlist(user_id,wishlist_date,type_id,stock_name,item_quantity) VALUES ('$ajx_user','$date','$ajx_type','$ajx_stock','$ajx_qty')"; $query = mysql_query($sql, $conn); }
function get_category_lang($post_id_param, $post_lang_code) { $conn = connDB(); $sql = "SELECT * FROM tbl_category_lang WHERE `id_param` = '{$post_id_param}' AND `language_code` = '{$post_lang_code}'"; $query = mysql_query($sql, $conn); $result = mysql_fetch_array($query); return $result; }
function get_admin_password_validation($password, $admin_id) { $conn = connDB(); $sql = "SELECT COUNT(*) AS rows FROM tbl_admin WHERE password = '******' AND id = '{$admin_id}'"; $query = mysql_query($sql, $conn); $result = mysql_fetch_array($query); return $result; }
function count_shipping_rate($country, $province) { $conn = connDB(); $sql = "SELECT * FROM tbl_courier_rate WHERE `courier_name` = '{$courier}' AND `active_status` = '{$status}'"; $query = mysql_query($sql, $conn); $result = mysql_fetch_array($query); return $result; }
function get_stock($stock_id){ $conn = connDB(); $sql = "SELECT * FROM tbl_product_stock WHERE `stock_id`= '$stock_id'"; $query = mysql_query($sql, $conn); $result = mysql_fetch_array($query); return $result; }
function get_username($post_username) { $conn = connDB(); $sql = "SELECT COUNT(*) AS rows FROM tbl_admin WHERE `username` = '{$post_username}'"; $query = mysql_query($sql, $conn); $result = mysql_fetch_array($query); return $result; }
function countCategory() { $conn = connDB(); $sql = "SELECT \n cat.category_id, cat.category_name, cat.category_active, cat.category_visibility,\n\t\t\t COUNT(rec.recipe_id) AS total_recipes\n\t\t\t FROM tbl_recipes_category AS cat LEFT JOIN tbl_recipes AS rec ON cat.category_id = rec.category_recipes ORDER BY category_name"; $query = mysql_query($sql, $conn); $result = mysql_num_rows($query); return $result; }
function get_customer_global($get_user_id) { $conn = connDB(); $sql = "SELECT * FROM tbl_user WHERE `user_id` = '{$get_user_id}'"; $query = mysql_query($sql, $conn); $result = mysql_fetch_array($query); return $result; }
function get_inspirations($post_category_id) { $conn = connDB(); $sql = "SELECT COUNT(*) AS rows FROM tbl_inspiration where `category` = '{$post_category_id}'"; $query = mysql_query($sql, $conn); $result = mysql_fetch_array($query); return $result; }
function count_job($post_category_id) { $conn = connDB(); $sql = "SELECT COUNT(*) AS rows FROM tbl_career WHERE `category` = '{$post_category_id}'"; $query = mysql_query($sql, $conn); $result = mysql_fetch_array($query); return $result; }
function get_detail($post_career_id) { $conn = connDB(); $sql = "SELECT * FROM tbl_career WHERE `career_id` = '{$post_career_id}'"; $query = mysql_query($sql, $conn); $result = mysql_fetch_array($query); return $result; }
function get_record_inspirations($search_query, $sort_by, $first_record, $query_per_page, $post_column_name, $post_opt_name, $post_record_name) { $conn = connDB(); $sql = "SELECT * FROM tbl_inspiration AS ins LEFT JOIN tbl_inspiration_image AS img ON ins.inspiration_id = img.param_inspiration_id\n LEFT JOIN tbl_inspiration_featured AS feat ON ins.inspiration_id = feat.param_inspiration_id\n WHERE {$search_query} AND {$post_column_name} {$post_opt_name} '{$post_record_name}'\n\t\t\t GROUP BY inspiration_id\n\t\t\t ORDER BY {$sort_by}\n\t\t\t "; $query = mysql_query($sql, $conn); $full_order['total_query'] = mysql_num_rows($query); $full_order['total_page'] = ceil($full_order['total_query'] / $query_per_page); return $full_order; }
function get_full_courier($search, $sort_by, $first_record, $query_per_page) { $conn = connDB(); $sql = "SELECT * FROM tbl_courier\n WHERE {$search}\n\t\t\t ORDER BY {$sort_by}\n\t\t\t LIMIT {$first_record}, {$query_per_page}\n\t\t\t"; $query = mysql_query($sql, $conn); $full_order['total_query'] = mysql_num_rows($query); $full_order['total_page'] = ceil($full_order['total_query'] / $query_per_page); // return $full_order; }
function get_full_recipes($search, $field, $cat, $sort_by, $first_record, $query_per_page) { $conn = connDB(); $sql = "SELECT * FROM tbl_recipes\n\t\t WHERE {$search} AND `{$field}` = '{$cat}'\n\t\t ORDER BY {$sort_by}"; $query = mysql_query($sql, $conn); $full_product['total_query'] = mysql_num_rows($query); $full_product['total_page'] = ceil($full_product['total_query'] / $query_per_page); // return $full_product; }
function get_languages() { $conn = connDB(); $sql = "SELECT * FROM tbl_language"; $query = mysql_query($sql, $conn); $row = array(); while ($result = mysql_fetch_array($query)) { array_push($row, $result); } return $row; }
function get_filter() { $conn = connDB(); $sql = "SELECT * FROM tbl_filter_sub WHERE `visibility` = '1' ORDER BY filter_name"; $query = mysql_query($sql, $conn); $row = array(); while ($result = mysql_fetch_array($query)) { array_push($row, $result); } return $row; }