?>
<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>
