Student ID :
$stu = $_POST["txtKeyword"]; $substuid = substr($stu,0,4); /*if($substuid == "5434") { $db_info = "self_info_2554"; $db_record = "self_record_2554"; }else { $db_info = "self_info_2555"; $db_record = "self_record_2555"; }*/ $db_info = "self_info"; $db_record = "self_record"; if($stu != "") { include('config.inc.php'); $sql = "SELECT * FROM $db_info WHERE stuid LIKE '".$_POST["txtKeyword"]."%' and year = '2562' and term = '1'"; $sqlquery = mysql_db_query($dbname, $sql); $numrow = mysql_num_rows($sqlquery); $sql_info = "SELECT * FROM $db_info WHERE stuid LIKE '".$_POST["txtKeyword"]."%' and year = '2562' and term = '1'"; $sqlquery_info = mysql_db_query($dbname, $sql_info); $info = mysql_fetch_array($sqlquery_info); $stuid_info = $info['stuid']; $name_info = $info['name']; $faculty_info = $info['faculty']; $year_info = $info['year']; $term_info = $info['term']; if($numrow != 0) { ?>
Student ID
:
Name
:
Faculty
:
Year
:
Term
:
while ($array = mysql_fetch_array($sqlquery)) { $section = $array['section']; $id = $array['id']; $tot = $array['sum']; ?>
Section
:
Date
Time
Activities
Descript
Minutes
Remarks
$info_id = $_POST['info_id']; //$section_id = '1'; $sql2 = "SELECT * FROM $db_record where info_id = '$id' ORDER by id desc"; $result2 = mysql_db_query($dbname,$sql2); $numrow2 = mysql_num_rows($result2); if($numrow2 == 0) { ?>
-- Empty Record --
} while($rs2 = mysql_fetch_array($result2)) { ?>
} $tot2 = $tot/60; $tot3 = $tot%60; ?>
Result :
if( $tot2 >= 0 ) { echo floor($tot2); }else{ echo ceil($tot2); } ?>
Hours
echo $tot3; ?>
minutes
echo "
"; } }else { exit(""); } mysql_close(); } ?>