$rowCount++; $objPHPExcel->getActiveSheet()->SetCellValue('A' . $rowCount, $times[1]); $rowCount++; $objPHPExcel->getActiveSheet()->SetCellValue('A' . $rowCount, $times[2]); $colCount = 1; //populate the colums with data foreach ($days as $day) { $rowCount = 3; foreach ($slots as $slot) { $group_string = ""; $sql_group = "SELECT groups.id_group, topics.subject, topics.grade FROM topics\n\t\t\t\t\t\t\t\t\t\t\tJOIN groups ON groups.id_topic = topics.id_topic\n\t\t\t\t\t\t\t\t\t\t\tJOIN slots ON topics.id_slot = slots.id_slot\n\t\t\t\t\t\t\t\t\t\t\tWHERE slots.day = '{$day}' AND slots.slot = {$slot} AND groups.id_room = " . $room['id_room'] . ";"; $groups = get_sql_result($sql_group); $group = mysqli_fetch_assoc($groups); if ($group['grade']) { //<---- find the right function $group_string = "Klasse: " . $group['grade'] . " " . $group['subject'] . "\n\nTeilnehmer:"; echo $group_string; $sql_students = "SELECT firstname, lastname FROM students\n\t\t\t\t\t\t\t\t\t\t\t\t\tJOIN students_groups ON students.id_student = students_groups.id_student\n\t\t\t\t\t\t\t\t\t\t\t\t\tJOIN groups ON groups.id_group = students_groups.id_group\n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE groups.id_group = '" . $group['id_group'] . "';"; $students = get_sql_result($sql_students); while ($student = mysqli_fetch_assoc($students)) { $group_string = $group_string . "\n" . $student['firstname'] . " " . $student['lastname']; } $objPHPExcel->getActiveSheet()->SetCellValue($cells[$colCount] . $rowCount, $group_string); } $rowCount++; } $colCount++; } } $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); $objWriter->save('../../lists/Raumbelegungsplan.xlsx');
<?php $objPHPExcel->getProperties()->setTitle("Statistik")->setSubject("Ferienschule")->setDescription("Zahlen und Daten"); $objPHPExcel = new PHPExcel(); $objPHPExcel->setActiveSheetIndex(0); $grades = array(6, 7, 8, 9, 10); $students_total = get_sql_result("SELECT COUNT(*) from students"); foreach ($grades as $grade) { $students_per_grade = get_sql_result("SELECT COUNT(*) WHERE grade = {$grade}"); } $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); $objWriter->save('../../lists/Statistik.xlsx');
<?php $objPHPExcel->getProperties()->setTitle("Emailadressen")->setSubject("Ferienschule")->setDescription("Liste mit den Mailadressen aller Angemeldeten Schüler"); $sql = "SELECT students.lastname, students.firstname, students.email\n\tFROM students\n\torder by students.lastname, students.firstname;"; $result = get_sql_result($sql); $objPHPExcel = new PHPExcel(); $objPHPExcel->setActiveSheetIndex(0); $rowCount = 1; $objPHPExcel->getActiveSheet()->SetCellValue('A' . $rowCount, 'Nachname'); $objPHPExcel->getActiveSheet()->SetCellValue('B' . $rowCount, 'Vorname'); $objPHPExcel->getActiveSheet()->SetCellValue('C' . $rowCount, 'Email'); while ($row = mysqli_fetch_array($result)) { $rowCount++; $objPHPExcel->getActiveSheet()->SetCellValue('A' . $rowCount, $row['0']); $objPHPExcel->getActiveSheet()->SetCellValue('B' . $rowCount, $row['1']); $objPHPExcel->getActiveSheet()->SetCellValue('C' . $rowCount, $row['2']); } $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); $objWriter->save('../../lists/Mailadressen.xlsx');
$isalter = 1; } update_order_res($_POST['orid'], $prod, $isalter); header("location:" . $_SERVER['HTTP_REFERER']); } if (isset($_POST['deleter'])) { delete_order_res($_POST['orid']); header("location:" . $_SERVER['HTTP_REFERER']); } if (isset($_POST['execsql'])) { $sql = $_POST['query']; $lnk = dbConnect('', '', ''); $res = exec_query($sql); $add = ""; if (strtolower(substr($sql, 0, strpos($sql, ' '))) == 'select') { $add = get_sql_result($res); } dbDisconnect($lnk); $body = get_sql_form($sql) . $add; $finish = true; } if (isset($_GET['mode'])) { $finish = false; $mode = 1; if ($_GET['mode'] == 'orddetail') { $isauth = is_auth(); if ($isauth) { $body = get_order_details($_GET['id']); } else { $body = pageBody(1); }