// Execute the prepared query. $stmt->store_result(); $stmt->bind_result($name); if ($stmt->num_rows > 0) { while ($row = $stmt->fetch()) { //now we fetch all rows from db $i = 0; if (preg_match_all("/(?<=-)(.*?)(?=-)/s", $string, $result)) { if ($_SERVER['QUERY_STRING'] == "deleted-" . $result[0][0] . "-" . $name) { $_SESSION['deleted_category'] = "deleted-" . $result[0][0] . "-" . $name; // include_once $_SERVER["DOCUMENT_ROOT"] . site_name . '/admin/includes/add_categories.php'; break; } } $subcategory_names = get_all_subcategories_from_category_db($mysqli, $name); if ($_SERVER['QUERY_STRING'] == "new-category" || $_SERVER['QUERY_STRING'] == "change-" . $name) { include_once $_SERVER["DOCUMENT_ROOT"] . site_name . '/admin/includes/add_categories.php'; break; } if (preg_match_all("/(?<=-)(.*?)(?=-)/s", $string, $result)) { while (count($subcategory_names) > $i) { if (preg_match("/(\r|\n|\t|\\s)/", $subcategory_names[$i])) { $subcategory_names[$i] = str_replace(" ", "%20", $subcategory_names[$i]); } if ($_SERVER['QUERY_STRING'] == "deleted/subcategory-" . $result[0][0] . "-" . $subcategory_names[$i]) { $_SESSION['deleted'] = "deleted/subcategory-" . $result[0][0] . "-" . $subcategory_names[$i]; include_once $_SERVER["DOCUMENT_ROOT"] . site_name . '/admin/includes/add_categories.php'; break; } $i = $i + 1;
if ($stmt) { $stmt->execute(); // Execute the prepared query. $stmt->store_result(); $stmt->bind_result($subcategory_id, $name); $i = 0; if ($stmt->num_rows > 0) { while ($row = $stmt->fetch()) { $subcategory_id_all[$i] = $subcategory_id; $subcategory_names[$i] = $name; $i = $i + 1; } if (update_subcategories($mysqli, 'update_subcategories', $subcategory_id_all)) { echo "<script>setTimeout(function() { alert('Subcategory updated'); }, 1); </script>"; } $get_subcategories = get_all_subcategories_from_category_db($mysqli, $get); //we take all subcategories form database $i = 0; while (count($get_subcategories) > $i) { ?> <li><a href='#' onclick="return confirm_it('?deleted/subcategory-<?php echo $subcategory_id_all[$i]; ?> -<?php echo $get_subcategories[$i]; ?> ','Do you want to delete this subcategory?');"><img src='<?php echo site_name; ?> /img/DeleteRed.png' width='12px'> </a><input type='text' name='sub<?php echo $i;
echo "<option value='{$cat}'"; if ($cat == $actual_category) { echo "selected='true'"; } echo ">{$cat}</option>"; } ?> </select> </div> <div> Subcategory:<select name="subcategory" id="subcategories"> <?php $subcategory = get_product_row($mysqli, $p_id, "subcategory"); $subcategories = get_all_subcategories_from_category_db($mysqli, $actual_category); foreach ($subcategories as $sub) { echo "<option value='{$cat}'"; if ($sub == $subcategory) { echo "selected='true'"; } echo ">{$sub}</option>"; } ?> </select> </div> <div> Size:<select name="size" >