Learn More About: York Online Exam Scripts

"Maximizing Your Efforts by Minimizing Your Workload"

York: Online Exam Scripts

About York Online Exams

NEW Files Uploaded June 4, 2008
>> Update Notes and Contact Information <<

YorkOnlineExams.com is part of a group of websites owned by York Instructional Services.

York Instructional Services is a website and database development company started in 1997 by Michael York of Sacramento California.

We wrote our first online exam script in 2003 and you will find us listed in several php directories.
Including: HotScripts.com | Php Resource Index | AdvanceScripts.com

We pride ourselves in writing scripts that are easy to use and understand and several people have commented on how easy it is to modify the coding because of the comments in the code itself.

Here is a sample of the coding :

// === Instatntiate the template class
	$tplhTestParam = new clstemplate;

// === Instatntiate the DB class
	$db_obj = new clsDB;

// === Turn debugging on|off
	$DEBUG = FALSE;
	$DEBUG1 = FALSE;

// === Pulling ExamID from Cookie
	$paperId=$SESSION_EXAMID;

// === Open template file
	$tplhTestParam->set_file("hTestParam","../templates/admin/addEditTestParam.tpl");

if(!$btn_submit){
		// === Before submit
		
		// === To handle if there is multiple tests
		if($paperId){
			$condition = " where Test_ID='$paperId'"; 
		}

$selTestQry = "select 
				     *
			       from
				     exam_test
			       	     $condition";
		if($DEBUG)	print"<font color=\"gray\">$selTestQry</font>";

// === Execute the query
		$db_obj->db_Query($selTestQry);

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////// The 'mode' will always be Edit as the add is preformed on the admin start page /////////////////
			$mode = "Edit";
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////// Setting variables based on database fields  /////////////////////////////////////////////

$paperId = $db_obj->fields("Test_ID");
			$testName = $db_obj->fields("Test_Name");
			$memberFee = $db_obj->fields("Test_Member_Fee");
			$nonMemberFee = $db_obj->fields("Test_NonMember_Fee");
			$passGrade = $db_obj->fields("Test_Pass_Grade");	
			$Open2 = $db_obj->fields("Test_Open_To");
			$Fee = $db_obj->fields("Test_Payment_Required");
			$IsLive = $db_obj->fields("Test_Status");
			$IsCert = $db_obj->fields("Test_Cert");
			$TestDesc = $db_obj->fields("Test_Desc");
			$Practice = $db_obj->fields("Test_Practice_Mode");

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////// The following sets the state of radio buttons usen in template //////////////////////////
$mFee="";
$nmFee="checked";
If($Fee=='1'){
$mFee="checked";
$nmFee="";
}

$yCert="";
$nCert="checked";
If($IsCert=='1'){
$yCert="checked";
$nCert="";
}

$yLive="";
$nLive="checked";
If($IsLive=='1'){
$yLive="checked";
$nLive="";
}

$isPractice="checked";
$noPractice="";
If($Practice=='1'){
$noPractice="checked";
$isPractice="";
}

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////  Sets display value of who can take the exam ////////////////////////////////////////
$OpenTo="ALL";

if($Open2=='1'){
$OpenTo="Members Only";
}
if($Open2=='2'){
$OpenTo="Non-Members Only";
}

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
///////////////// Below you will notice the  template  variable TXTVAL_PRESETVALUE //////////////////////////////////
///////////// This sets the 'default' value of the open to drop down to what was previously selected //////////////////
			      
		// === Replace template variables
		$tplhTestParam->set_varvalue("FRMVAL_ACTION","$PHP_SELF");
		$tplhTestParam->set_varvalue("TXTVAL_TESTNAME","$testName");
		$tplhTestParam->set_varvalue("TXTVAL_TESTDESC","$TestDesc");
		$tplhTestParam->set_varvalue("TXTVAL_MEMBERCOST","$memberFee");
		$tplhTestParam->set_varvalue("TXTVAL_NONMEMBERCOST","$nonMemberFee");
		$tplhTestParam->set_varvalue("TXTVAL_PASSGRADE","$passGrade");
		$tplhTestParam->set_varvalue("HIDVAL_MODE","$mode");
		$tplhTestParam->set_varvalue("TXTVAL_OPENTO","$OpenTo");
		$tplhTestParam->set_varvalue("TXTVAL_PRESETVALUE","$Open2");
		$tplhTestParam->set_varvalue("TXT_FEEY","$mFee");
		$tplhTestParam->set_varvalue("TXT_FEEN","$nmFee");
		$tplhTestParam->set_varvalue("TXT_LIVEY","$yLive");
		$tplhTestParam->set_varvalue("TXT_LIVEN","$nLive");
		$tplhTestParam->set_varvalue("TXT_CERTY","$yCert");
		$tplhTestParam->set_varvalue("TXT_CERTN","$nCert");
		$tplhTestParam->set_varvalue("TXT_PRACY","$isPractice");
		$tplhTestParam->set_varvalue("TXT_PRACN","$noPractice");

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////// Variables set -- Now let's display the page  ///////////////////////////////////////////////

$tplhTestParam->printform("prnInOutForm",'hTestParam');
	
		// === Print the footer
		dispADFooter("../templates/","../");
	}
	else{
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////// The form has HAS been submitted so we need to update  values ////////////////////////////////

$updTestQry = "Update 
					     exam_test
				       set
					     Test_Name='$txt_testName',
					     Test_Member_Fee='$txt_testCostMember',
					     Test_Desc='$txt_testDesc',
					     Test_NonMember_Fee='$txt_testCostNonMember',
					     Test_Status='$exam_status',
					     Test_Payment_Required='$is_fee',
					     Test_Open_To='$open2',
					     Test_Cert='$cert',
					     Test_Practice_Mode='$is_practice',
					     Test_Pass_Grade='$txt_testPassGrade'
				       where
					     Test_ID='$paperId'";
			if($DEBUG1){	
				print "<font color=\"gray\">$updTestQry</font>";
				exit;
			}

// === Execute the query
			$db_obj->db_Query($updTestQry,"U");

header("location:buildTestPage.php");
			}

Select Your Payment Preference
Pay By Credit Card	Pay By Paypal
Download immediately after paying!