View Student Information

0){ while($row = mysql_fetch_array($sql444)){ foreach( $row AS $key => $val ){ $$key = stripslashes( $val ); } // echo $row; // echo $key; // echo $$key; $EnrollmentID = $enrollmentID; // echo $UserID; // echo $StudentId; } } // &&&&&&&&&&&&&&&&& END THE ENROLLMENT ID &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& // ***************************************************************************** $theSQL = "SELECT enrollment.EnrollmentID, classes.ClassName, enrollment.ClassID, enrollment.StudentID, enrollment.FinalGrade, enrollment.CreditsEarned, enrollment.StartDate, enrollment.EndDate, enrollment.CreditsPotential, enrollment.CreditsActual, enrollment.Status, enrollment.class, enrollment.subject FROM enrollment LEFT JOIN classes ON enrollment.ClassID = classes.ClassId WHERE enrollment.EnrollmentID ='$EnrollmentID'"; $sql444 = mysql_query($theSQL); // echo $theSQL; $record_found = mysql_num_rows($sql444); // echo $record_found; if($record_found > 0){ while($row = mysql_fetch_array($sql444)){ foreach( $row AS $key => $val ){ $$key = stripslashes( $val ); } // echo $row; // echo $key; // echo $$key; $StudentId = $StudentID; $theClassName = $ClassName; // echo $UserID; // echo $StudentId; } } // **************************************************************************** $theStudentID = $StudentId; $sql = mysql_query("SELECT * FROM users WHERE userid='$theStudentID'"); $record_found = mysql_num_rows($sql); if($record_found > 0){ while($row = mysql_fetch_array($sql)){ foreach( $row AS $key => $val ){ $$key = stripslashes( $val ); } // END FOR echo "View Student Information

"; $query="SELECT * FROM reports WHERE (StudentID ='$theStudentID' AND CreditsTOTAL > 0) ORDER BY EndDate DESC LIMIT 1"; // print "$query"; $result=mysql_query($query); $num=mysql_numrows($result); $i=0; while ($i < $num) { $row99=mysql_fetch_array($result); $CC = $row99["CreditsTPGP"]; // print "$CC"; $CO = $row99["CreditsOTHER"]; // print "$CO"; $CT = $row99["CreditsTOTAL"]; $CG = $row99["CreditsGOAL"]; // CODE echo ''; $i++; } // END WHILE INNER LOOP RECORDSET - last report } // END WHILE echo '

STUDENT INFORMATION :

Name : $first_name $last_name

Email : $email_address

Credits Completed (TPGP) : '.$CC.'

Credits Completed (OTHER) : '.$CO.'

Credits Total : '.$CT.'

Credits Goal : '.$CG.'

'; } // END IF else { echo "Session Variables Timed Out - Please login again."; } // ****************************************************************** $sql3="SELECT unit.unitID, unit.classID, classes.ClassName, unit.unit, unit.lesson FROM unit INNER JOIN classes ON unit.classID = classes.ClassId WHERE unit.unitID=" .$UnitIDENT; $result3 = mysql_query($sql3); $nrows = mysql_num_rows($result3); $row = mysql_fetch_array($result3); $list_comp = $row["classID"]; $sql4="SELECT ClassId,ClassName from classes"; $result4 = mysql_query($sql4) or die("error in SQL"); echo '

Edit Unit

'; } print "Click here to return to the main classes page!";?>

Class	'; echo ""; echo '
Unit
Lesson