?> <input type="hidden" size = 60 name="subject_id" value = "<?php echo $subject_id; ?> "></input></td> </tr> <tr> <td>Page Name : </td> <td><input type = "text" size = 60 name = "page_name" value = "" /></td> </tr> <tr> <td>Position : </td> <td><select name = "position"> <?php $page_set = find_page_per_subject($subject_id); $page_count = mysqli_num_rows($page_set); for ($count = 1; $count <= $page_count + 1; $count++) { echo "<option value = \"{$count}\" selected>{$count}</option>"; } ?> </select> </td> </tr> <tr> <td>Visible : </td> <td><input type = "radio" name = "visible" value = "1" checked="checked"/> Yes <input type = "radio" name = "visible" value = "0"/> No </td> </tr>
<?php require_once "../../includes/sessions.php"; require_once "../../includes/db_connect.php"; require_once "../../includes/functions.php"; logged_in(); $current_subject = find_subject_by_id($_GET["subject"]); if (!$current_subject) { redirect_to("manage_content.php"); } else { $id = $current_subject["id"]; $pages_set = find_page_per_subject($current_subject["id"]); if (mysqli_num_rows($pages_set) > 0) { $_SESSION["message"] = "Can't delete a subject with existing page/s."; redirect_to("manage_content.php?subject={$current_subject["id"]}"); } else { $delete_query = "DELETE FROM subjects "; $delete_query .= "WHERE id = {$id} "; $delete_query .= "LIMIT 1"; $result = mysqli_query($connection, $delete_query); if ($result && mysqli_affected_rows($connection) == 1) { $_SESSION["message"] = "Subject deletion success."; redirect_to("manage_content.php"); } else { $_SESSION["message"] = "Subject deletion failed."; redirect_to("manage_content.php?subject={$id}"); } } //if (mysqli_num_rows($pages_set) > 0 ) { } //if (!$current_subject) {
echo $current_page["subject_id"]; ?> "></input> <table border=1> <tr> <td>Page Name : </td> <td><input type = "text" name = "page_name" size = 60 value = "<?php echo ucfirst($current_page["page_name"]); ?> " /></td> </tr> <tr> <td>Position : </td> <td><select name = "position"> <?php $page_set = find_page_per_subject($current_page["subject_id"]); $page_count = mysqli_num_rows($page_set); for ($count = 1; $count <= $page_count; $count++) { echo "<option value = \"{$count}\""; if ($current_page["position"] == $count) { echo " selected"; } echo ">{$count}</option>"; } ?> </select> </td> </tr> <tr> <td>Visible : </td>