$sel_subjects = array();
if (isset($_POST["subjects"])) {
$sel_subjects = $_POST["subjects"];
}
$list_name = mysql_real_escape_string(json_encode($list_name));
$list_desc = mysql_real_escape_string(json_encode($list_desc));
// edit list
if ($action == "edit") {
$mesaj = array();
$query = "UPDATE liste SET \n `name` = '" . $list_name . "',\n `desc` = '" . $list_desc . "', \n `public` = '" . $list_public . "' \n WHERE `list_id` = '" . $list_id . "'";
$result = mysql_query($query, $dbconnect);
confirm_query($result);
if (mysql_affected_rows() == 1) {
$mesaj[] = "The list details have been updated.";
}
$rel_subjects = get_sel_subj_for_list($list_id);
foreach ($rel_subjects as $subj_id) {
if (!in_array((int) $subj_id, $sel_subjects)) {
$query = "DELETE FROM rel_subj_list WHERE subj_id = '" . $subj_id . "' AND list_id = '" . $list_id . "'";
$result = mysql_query($query, $dbconnect);
confirm_query($result);
if (mysql_affected_rows() == 1) {
$subj_name = get_subj_name($subj_id);
$mesaj[] = "Subject {$subj_name} has been removed from list.";
}
}
}
foreach ($sel_subjects as $subj_id) {
if (!in_array((int) $subj_id, $rel_subjects)) {
$query = "INSERT INTO rel_subj_list (`list_id`, `subj_id`) VALUES ('" . $list_id . "', '" . $subj_id . "')";
$result = mysql_query($query, $dbconnect);
}
?>
/> <?php
__("Private list");
?>
<br />
</fieldset>
<fieldset>
<label for="subjects"><?php
__("Subjects included in the list");
?>
</label>
<?php
$sel_subj = get_sel_subj_for_list($list_id);
$all_subjects = get_all_subjects();
while ($row = mysql_fetch_array($all_subjects)) {
$subj_id = $row["subj_id"];
$subj_first_name = $row["first_name"];
$subj_last_name = $row["last_name"];
?>
<input type="checkbox" <?php
if (in_array($subj_id, $sel_subj)) {
echo "checked=\"checked\"";
}
?>
name="subjects[]" value="<?php
echo $subj_id;
?>
