// 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" >
