Code: Select all
$date="2016-09-12";
$enddate="2016-09-27";
$datef=date_create($date);
$table_name = "Attend_SF_2016-2017_Form1A_Term1";
$attend_table = "CREATE TABLE ".$table_name." (";
$attend_table .= "id INT(9) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT PRIMARY KEY,";
$attend_table .= "studentsid VARCHAR(9),";
while($date != $enddate){
date_add($datef,date_interval_create_from_date_string("1 day"));
$date = date_format($datef,"Y-m-d");
$day = date_format($datef,"D");
if (($day != "Sat")&&($day != "Sun")){
$attend_table .= $date." ENUM('-','NA','H','A','P') NOT NULL DEFAULT '-',";
}
}
$attend_table = rtrim($attend_table,",");
$attend_table .= ")";
mysql_query( $attend_table, $conn);