Add Students
'student', 'private' => 'private' ); echo '
'; // prepare the next student_id $query = "select max(student_id) as student_id from students where domain_id = $domain_id and teacher_id = $teacher_id"; $result = @mysql_query($query); if ($result){ while ($row = mysql_fetch_array($result,MYSQL_ASSOC)){ $student_id = $row['student_id']; $student_id = $student_id + 1; } mysql_free_result($result); } else { echo "
Problem: Unable to get next student_id number.
Try starting from login again.
\n"; } echo "
DID: $domain_id TID: $teacher_id NID:$student_id
"; //check entered values if (isset($_POST['submitted'])){ //if (empty($_POST['student_id'])){$errors[] = 'Please enter StudentID';} else {$ri = $_POST['recid'];} //if (empty($_POST['teacher_id'])){$errors[] = 'Please enter Cantor name';} else {$ca = $_POST['teacher'];} $errors = array(); if (empty($_POST['student_name'])){$errors[] = "Please enter Student Name
\n";} else {$student_name = $_POST['student_name'];} if (empty($_POST['student_pw'])){$errors[] = "Please enter Student Password
\n";} else {$student_pw = $_POST['student_pw'];} $student_category = $_POST['student_category']; $book = 'book'; if (empty($errors)){ require_once('mysql_connect.php'); $query = "insert into students (domain_id,teacher_id,student_id,student_name,student_pw,student_category) values('$domain_id','$teacher_id','$student_id','$student_name','$student_pw','$student_category')"; $result = @mysql_query($query); if ($result){ echo "\n
A new record was added for $student_name.
\n"; } else { echo "\n
Unable to add new record for student $student_name
\n"; } require_once('mysql_connect.php'); $query = "insert into allusers (domain_id,user_id,user_name,user_pw,user_category) values('$domain_id','$student_id','$student_name','$student_pw','$student_category')"; $result = @mysql_query($query); if ($result){ echo "\n
A new record was added for $student_name.
\n"; } else { echo "\n
Unable to add new record for student $student_name
\n"; } } else{ //report errors echo "
Error!
"; foreach ($errors as $msg){echo "- $msg";} } } // end submitted // this code appears whether submitted already or not echo "
Add New Student
Student Name
Password
Category
"; foreach ($category as $key => $value){ echo "
$value
\n"; } echo "
"; mysql_close(); ?>