function RESULTNEW($link,$query){
$result = mysqli_query($link,$query) or die ("Error in query: $query. ".mysqli_error());
if (mysqli_num_rows($result) > 0) {
echo '
';
$cols=16;
while($row = mysqli_fetch_row($result)) {
for($i = 0; $i<= $cols; $i++){
if($i==0)echo '
ID: '.$row[0].' | Title: '.$row[2].'
File Type: '.$row[5].'
Subtopic: '.$row[9].'
Topic: '.$row[10].' |
Reference: '.$row[11].'
Minor Subject: '.$row[8].'
Subject: '.$row[12].'
';
}
echo "\n";
}
}
//echo '';
}
function RESULT2($link,$query){
$result =mysqli_query($link,$query) or die ("Error in query: $query. ".mysqli_error());
if (mysqli_num_rows($result) > 0) {
echo '';
echo '';
$cols=16;
while($row =mysqli_fetch_row($result)) {
for($i = 0; $i<= $cols; $i++){
if($i==0)echo 'No: '.$row[0].' Title: '.$row[1].'
 Type: '.$row[4].' Transcript: Yes Audio: Yes Topic: '.$row[7].' Reference: '.$row[8].' Subject: '.$row[9].' |
';
}
echo "\n";
}
}
echo '
';}
function RESULT($link,$query){
$result =mysqli_query($link,$query) or die ("Error in query: $query. ".mysqli_error());
if (mysqli_num_rows($result) > 0) {
echo '';
echo '';}
//--------------------
function RESULT_TOTAL($link,$query,$sid){
global $sid;
$nrows=1;
$result = mysqli_query($link,$query) or die ("Error in query: $query. ".mysqli_error());
if (mysqli_num_rows($result) > 0) {
$cols=16;
while($row = mysqli_fetch_row($result)) {
$ROW[$nrows]=$nrows++;
// echo 'number of rows: '.$nrows;
for($i = 0; $i<= $cols; $i++){
if($i==0){
$ROW[$nrows]=$row[0];
}
}
echo "\n";
}
}
$Nrows=$nrows;
$Nrows=$Nrows-1;
$rownumber=rand(1,$Nrows);
//echo 'rownumber: '.$rownumber.'| |'.$ROW[$rownumber];
$sid=$ROW[$rownumber];
}
//-----------
function RESMCQ($link, $query){
$result =mysqli_query($link, $query) or die ("Error in query: $query. ".mysqli_error());
if (mysqli_num_rows($result) > 0) {
echo '';
echo '';
echo 'No | Problem | Ans | Ans (a) | Ans(b) | Ans (c) | Ans (d) | Solution | Topic |
';
$cols=16;
while($row =mysqli_fetch_row($result)) {
for($i = 0; $i<= $cols; $i++){
if($i==0)echo ''.$row[0].' | '.$row[1].' | ('.$row[2].') | (a). '.$row[3].' | (b). '.$row[4].' | (c). '.$row[5].' | (d). '.$row[6].' | '.$row[7].' | '.$row[8].' |
';
}
echo "\n";
}
}
echo '
';}
?>
define ("DB_HOST", "localhost"); // set database host
define ("DB_USER", "chepe"); // set database user
define ("DB_PASS","F@r@h1952"); // set database password
define ("DB_NAME","chepe");
$link = mysqli_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME) or die("Couldn't make connection.");
$db = mysqli_select_db($link, DB_NAME) or die("Couldn't select database: " . mysqli_connect_error());
$SUBJECTS=array('','f_chemistry','f_material_and_energy_balance','f_chemical_thermodynamics','f_fluid_dynamics','f_heat_transfer','f_mass_transfer','f_chemical_reaction_engineering','f_process_design_and_economics', 'f_computer_usage','f_process_control','f_safety_health_and_environment');
//$SUB_TITLE=array('','Chemistry','Material and Energy Balances','Thermodynamics','Fluid Dynamics','Heat Transfer','Mass Transfer and Separation','Chemical Reaction Engineering', 'Process Design and Economics','Computer Usage', 'Process Control','Safety, Health and Environment');
$SUB_TITLE=array('','Biology','Chemical Reaction Engineering', 'Chemistry','Computers', 'Computational Tools', 'Direct-Current Circuits','Economics', 'Electric Circuits','Engineering Mechanics','Engineering Sciences', 'Fluid Mechanics', 'Heat Transfer','Mass Transfer', 'Mass Transfer and Separation','Mathematics','Materials Science','Mechanics of Materials','Probability and Statistics', 'Safety, Health, and Environment', 'Statics','Strength of Materials', 'Thermodynamics','Unit Processes');
$SUBJECT=array('','chemistry','mass_and_energy_balance','thermodynamics','fluid_dynamics','heat_transfer','mass_transfer_and_separation','chemical_reaction_engineering', 'process_design_and_economics','computer_usage', 'process_control','safety_health_and_environment');
//$FILE_TYPE=array('','f_figure','f_table','f_example','f_module');
//$TYPE_TITLE=array('','Figures','Tables','Examples','Modules');
echo '
';
echo '