PHP Demos - My Site

You are logged in as user $user

\n"; // get the user details from the cookie } else { print "

You are not logged in. If you wish to log in, please visit the members home page.

\n"; } $centre=$_COOKIE["DEMOCentreName"]; $centrenum=$_COOKIE["DEMOCentreNo"]; $usertype=$_COOKIE["DEMOUserType"]; // display centre details, if there are any if ($centre != "") { print ("

Centre name: " . $centre . " Centre number: " . $centrenum . " User type: " . $usertype . "

\n"); } ?>

This page lists all of the resources you or your students have saved in the Site database. This includes candidate, witness and testimony details. The answers to any of the interactive excercises completed by the student can also be viewed here. (As long as the student saved them!)

SQL = " . $query); $row=mysql_fetch_array($sth, MYSQL_ASSOC) or die("fetch failed: " . mysql_error()); $centre=$row["centre_name"]; $centrenum=$row["centre_no"]; print ("

Centre address: " . $row["address"] . "
Telephone number: " . $row["telno"] . "
Other details: " . $row["other"] . "

\n"); print ("

Amend centre details

\n"); print ("

Existing resources for centre:

\n"); $query="select * from bscandidates where centre_name='" . $centre . "' order by candidate_name"; $sth=mysql_query($query) or die("Query failed: " . mysql_error() . "
SQL = " . $query); $num_rows = mysql_num_rows($sth); if ($num_rows==0) { print ("

No candidates found.

\n"); } else { print ("

". $num_rows . " candidates found.

\n\n"); while ($row=mysql_fetch_array($sth, MYSQL_ASSOC)) { print ("\n"); // now list any answers for the student $query2="select * from bsanswers where centre='" . $centre . "' and name='" . $row["candidate_name"] . "' order by page"; $sth2=mysql_query($query2) or die("Query on answers failed: " . mysql_error() . "
SQL = " . $query2); $num_rows2 = mysql_num_rows($sth2); if ($num_rows2==0) { print ("\n"); } else { print ("\n"); } } print ("

Candidate: " . $row["candidate_name"] . " Ref: " . $row["reference"] . "	Candidate details \| Witness details \| Testimony details
This candidate has not stored any answers.
Stored answers: \n"); while ($row2=mysql_fetch_array($sth2, MYSQL_ASSOC)) { print (" Page: " . $row2["page"] . " - View \n"); } print ("

\n"); } mysql_close($dbh) or die("Couldn't close db connection: " . mysql_error()); } ?>

Resources

PHP Demos - My Site