$query = mysql_query("SELECT parentid FROM parents WHERE userid='{$_POST['username']}'") or die("Unable to get the newly entered parentid - " . mysql_error()); $parentid = mysql_result($query, 0); // Also insert the "registered" grouping of parent and student // $query = mysql_query("INSERT INTO parent_student_match (parentid, studentid) VALUES( '{$parentid}', '{$_POST['student']}')") or die("ManageParents.php: Unable to insert the parent to student match - " . mysql_error()); } } // Edit the parent if one is being edited // if ($_POST["editparent"] == 1 && $_POST["username"] != "" && $_POST["fname"] != "" && $_POST["lname"] != "" && $_POST["student"] != "") { $query = mysql_query("UPDATE `parents` SET `userid`='{$_POST['username']}', `fname`='{$_POST['fname']}', `lname`='{$_POST['lname']}' WHERE `parentid`='{$_POST['parentid']}' LIMIT 1") or die("ManageParents.php: Unable to update the parent information - " . mysql_error()); } // Delete the parent(s) that the parent has requested as well as the classes belonging to those parents // if ($_POST["deleteparent"] == 1) { require_once "DeleteFunctions.php"; $delete = $_POST["delete"]; for ($i = 0; $i < sizeof($delete); $i++) { deleteParent($delete[$i]); } } print "<script language='JavaScript'>\n\n // Function to make sure the parent wants to delete the parent(s) //\n function validate()\n {\n if( document.parents.selectparent.value > 0 )\n {\n\tvar confirmed = confirm(\"Are you sure you want to delete this parent?\");\n\n\tif( confirmed == true )\n\t{\n\t document.parents.submit();\n\t}\n }\n else\n {\n\talert('You must select a parent to delete.');\n }\n }\n\n\n // Function to make sure only one checkbox has been selected //\n function checkboxes()\n {\n if( document.parents.selectparent.value == 1 )\n {\n\tdocument.parents.submit();\n }\n else\n {\n\tif( document.parents.selectparent.value > 1 )\n\t{\n\t alert('You can only edit one parent at a time.');\n\t}\n\telse\n\t{\n\t alert('You must select a parent to edit.');\n\t}\n }\n }\n\n\n // Function to keep track of how many checkboxes are checked //\n function updateboxes(row)\n {\n row = row + 2;\n\n if(document.parents.elements[row].checked)\n {\n\tdocument.parents.selectparent.value = Math.round(document.parents.selectparent.value) + 1;\n }\n else\n {\n\tdocument.parents.selectparent.value = Math.round(document.parents.selectparent.value) - 1;\n }\n }\n </script>\n\n <h1>Manage Parents</h1>\n <br><br>\n <table align='center' width='500' cellspacing='0' cellpadding='0' border='0'>\n <tr>\n <td>\n <form name='parents' action='./index.php' method='POST'>\n <input type='button' value='Add' onClick='document.parents.page2.value=23;document.parents.submit();'>\n <input type='button' value='Edit' onClick='document.parents.page2.value=24;checkboxes();'>\n <input type='button' value='Delete' onClick='document.parents.deleteparent.value=1;validate();'>\n <br><br>\n <table cellspacing='0' width='500' cellpadding='8' class='dynamiclist'>\n <tr class='header'>\n\t<td> </td>\n\t<th>First Name</th>\n\t<th>Last Name</th>\n\t<th>Student Name</th>\n\t<th>Username</th>\n </tr>"; // Get the total number of parents to know how many pages to have // $query = mysql_query("SELECT COUNT(*) FROM parents") or die("ManageParents.php: Unable to retrieve total number of parents - " . mysql_error()); $numrows = mysql_result($query, 0); $numpages = ceil($numrows / 25); if ($_POST["onpage"] == "") { $_POST["onpage"] = 1; } // Get and display the parents // $query = mysql_query("SELECT p.parentid,p.fname,p.lname,u.username FROM parents p, users u WHERE p.userid = u.userid") or die("ManageParents.php: Unable to get a list of parents - " . mysql_error()); $row = 0; $actualrow = 0; while ($parent = mysql_fetch_row($query)) {
function deleteUser($userid) { $query = mysql_query("SELECT type FROM users WHERE userid = {$userid}"); $type = @mysql_result($query, 0); $query = mysql_query("DELETE FROM users WHERE userid = {$userid} LIMIT 1") or die("DeleteFunction.php: Unable to delete selected User(s) - " . mysql_error()); switch ($type) { case "Teacher": // Get the list of teachers/substitutes that will also be deleted and delete them // $query = mysql_query("SELECT teacherid FROM teachers WHERE userid = {$userid}") or die("DeleteFunctions.php: Unable to get list of teachers to delete for deleteUser() - " . mysql_error()); while ($teacherid = mysql_fetch_row($query)) { deleteTeacher($teacherid[0]); } break; case "Student": // Get the list of students that will also be deleted and delete them // $query = mysql_query("SELECT studentid FROM students WHERE userid = {$userid}") or die("DeleteFunctions.php: Unable to get list of students to delete for deleteUser() - " . mysql_error()); while ($studentid = @mysql_result($query, 0)) { deleteStudent($studentid); } break; case "Parent": // Get the list of parents that will also be deleted and delete them // $query = mysql_query("SELECT parentid FROM parents WHERE userid = {$userid}") or die("DeleteFunctions.php: Unable to get list of parents to delete for deleteUser() - " . mysql_error()); while ($parentid = @mysql_result($query, 0)) { deleteParent($parentid); } break; case "Admin": // Get the list of administration staff that will also be deleted and delete them // $query = mysql_query("SELECT adminid FROM adminstaff WHERE userid = {$userid}") or die("DeleteFunctions.php: Unable to get list of admins to delete for deleteUser() - " . mysql_error()); while ($adminid = @mysql_result($query, 0)) { deleteAdmin($adminid); } break; } }