Esempi in PHP per excel::close

Esempio n. 1

File: excel_teacher.php Progetto: raptrovic20/scheduling

    $assignedto = $leader['time'];
    $worksheet1->write_string($j, 0, "{$day}");
    $worksheet1->write_string($j, 1, "{$project}-{$time_end}");
    $worksheet1->write_string($j, 2, "{$CYS}");
    $worksheet1->write_string($j, 3, "{$subject}");
    $worksheet1->write_string($j, 4, "{$room}");
}
/////////////////
$qryreport1 = mysql_query("SELECT * FROM schedule where teacher='{$id_get}' and type='' and day1='TTH' and semester='{$semester}' and sy='{$sy}'") or die(mysql_error());
$sqlrows = mysql_num_rows($qryreport1);
$j = 20;
while ($reportdisp = mysql_fetch_array($qryreport1)) {
    $j = $j + 1;
    $day = $reportdisp['day'];
    $project = $reportdisp['time'];
    $time_end = $reportdisp['time_end'];
    $CYS = $reportdisp['CYS'];
    $subject = $reportdisp['subject'];
    $room = $reportdisp['room'];
    $leaderid = $reportdisp['teacher'];
    $qryleader = mysql_query("SELECT * FROM schedule WHERE teacher='" . $leaderid . "' and type='' and day1='TTH' and semester='{$semester}' and sy='{$sy}'") or die(mysql_error());
    $leader = mysql_fetch_assoc($qryleader);
    $assignedto = $leader['time'];
    $worksheet1->write_string($j, 0, "{$day}");
    $worksheet1->write_string($j, 1, "{$project}-{$time_end}");
    $worksheet1->write_string($j, 2, "{$CYS}");
    $worksheet1->write_string($j, 3, "{$subject}");
    $worksheet1->write_string($j, 4, "{$room}");
}
$workbook->close();