</h2> <form action="edit_product.php?product= <?php echo urlencode($current_product["id"]); ?> " method="post"> <p>Menu Name: <input type="text" name="menu_name" value = "<?php echo htmlentities($current_product["menu_name"]); ?> " /> </p> <p>Position : <select name = "position"> <?php $product_set = find_products_for_windows($current_product["subject_id"]); $product_count = mysqli_num_rows($product_set); // if($product_count!=0) // { for ($count = 1; $count <= $product_count + 1; $count++) { echo "<option value=\"{$count}\""; if ($current_product["position"] == $count) { echo "selected"; } echo ">{$count}</option>"; } // } // else // { // echo "<option value=" ; // echo $product_count+1;
<?php require_once "../includes/session.php"; require_once "../includes/db_connection.php"; require_once "../includes/functions.php"; $current_window = find_window_by_id($_GET["window"], false); if (!$current_window) { redirect_to("manage_content.php"); } $product_set = find_products_for_windows($current_window["id"]); if (mysqli_num_rows($product_set) > 0) { $_SESSION["message"] = "Can't delete a subject with products."; redirect_to("new_window.php?window = {$current_window["id"]}"); } $id = $current_window["id"]; $query = "DELETE FROM windows WHERE id = {$id} LIMIT 1"; $result = mysqli_query($conn, $query); if ($result && mysqli_affected_rows($conn) == 1) { $_SESSION["message"] = "Window deleted."; redirect_to("manage_content.php"); } else { $_SESSION["message"] = "Window deletion failed."; redirect_to("new_window.php?window = {$id}"); } ?>
function public_navigation($window_array, $product_array) { $output = "<ul class= \" windows \" >"; $window_set = find_all_windows(); while ($windows = mysqli_fetch_assoc($window_set)) { $output .= "<li "; $output .= " >"; $output .= "<a "; if ($window_array && $windows["id"] == $window_array["id"]) { $output .= " class=\"selected\""; } $output .= " href =\"index.php?window="; $output .= urlencode($windows["id"]); $output .= " \">"; $output .= htmlentities($windows["menu_name"]); $output .= " </a>"; if ($window_array["id"] == $windows["id"] || $product_array["subject_id"] == $windows["id"]) { $product_set = find_products_for_windows($windows["id"]); $output .= "<ul id=\"products\">"; while ($products = mysqli_fetch_assoc($product_set)) { $output .= "<li "; if ($product_array && $products["id"] == $product_array["id"]) { $output .= " class= \"selected\" "; } $output .= ">"; $output .= " <a href = \"index.php?product= "; $output .= urlencode($products["id"]); $output .= " \">"; $output .= htmlentities($products["menu_name"]); $output .= " </a></li>"; } $output .= " </ul>"; mysqli_free_result($product_set); } $output .= "</li>"; } mysqli_free_result($window_set); $output .= "</ul>"; return $output; }