function hocvien($kh, $lh, $gv) { $data = array(); $data[] = array('STT', 'Mã HV', 'Họ & tên', 'Ngày sinh', 'Giới tính', 'Điện thoại', 'Email', 'Địa chỉ', 'Mã lớp', 'Lớp học', 'Cấp độ', 'Giảng viên'); if ($kh != 0) { if ($gv != 0) { $qr_gv = " AND id_giangvien='{$gv}' "; } if ($lh != 0) { $qr_lh = " AND daotao_lophoc.id='{$lh}' "; } $qr_lh = "SELECT daotao_lophoc.id,daotao_lophoc.name,capdo,daotao_giangvien.name as giangvien \r\n\t\t\tFROM daotao_lophoc,daotao_giangvien \r\n\t\t\tWHERE daotao_lophoc.`delete`=0 AND id_khoahoc='{$kh}' AND id_giangvien=daotao_giangvien.id {$qr_lh} {$qr_gv}\r\n\t\t\tORDER BY daotao_lophoc.`name` "; $qr_lh = mysql_query($qr_lh); while ($row_lh = mysql_fetch_array($qr_lh)) { $i = 0; $qr = mysql_query("SELECT id,name,ngaysinh,gioitinh,phone,email,diachi FROM daotao_hocvien WHERE `delete`=0 AND ds_lophoc LIKE '%,{$row_lh['id']},%' ORDER BY `name` "); while ($row = mysql_fetch_array($qr)) { $i++; if ($row['gioitinh'] == 1) { $gioitinh = 'Nam'; } else { $gioitinh = 'Nữ'; } $data[] = array($i, $row['id'], $row['name'], date('m/d/Y', strtotime($row['ngaysinh'])), $gioitinh, $row['phone'], $row['email'], $row['diachi'], $row_lh['id'], $row_lh['name'], $row_lh['capdo'], $row_lh['giangvien']); } } } elseif ($gv != 0) { $qr_lh = "SELECT daotao_lophoc.id,daotao_lophoc.name,capdo,daotao_giangvien.name as giangvien \r\n\t\t\tFROM daotao_lophoc,daotao_giangvien \r\n\t\t\tWHERE daotao_lophoc.`delete`=0 AND id_giangvien=daotao_giangvien.id AND id_giangvien='{$gv}'\r\n\t\t\tORDER BY daotao_lophoc.`name` "; $qr_lh = mysql_query($qr_lh); while ($row_lh = mysql_fetch_array($qr_lh)) { $i = 0; $qr = mysql_query("SELECT id,name,ngaysinh,gioitinh,phone,email,diachi FROM daotao_hocvien WHERE `delete`=0 AND ds_lophoc LIKE '%,{$row_lh['id']},%' ORDER BY `name` "); while ($row = mysql_fetch_array($qr)) { $i++; if ($row['gioitinh'] == 1) { $gioitinh = 'Nam'; } else { $gioitinh = 'Nữ'; } $data[] = array($i, $row['id'], $row['name'], date('m/d/Y', strtotime($row['ngaysinh'])), $gioitinh, $row['phone'], $row['email'], $row['diachi'], $row_lh['id'], $row_lh['name'], $row_lh['capdo'], $row_lh['giangvien']); } } } export_excel($data, 'hocvien-' . date('His')); }
return false; } else { $i = 0; $str = "SELECT daotao_hocvien.* FROM daotao_hocvien,daotao_khoahoc WHERE daotao_hocvien.`delete`=0 AND daotao_hocvien.status=1 AND id_hocvien=daotao_hocvien.id AND id_lophoc='{$lophoc}'"; $qr = mysql_query($str); while($row = mysql_fetch_array($qr)){ $i++; $data[] = array($i,$row['name'],$row['email'],$row['phone'],$row['diachi'],$row['username']); } mysql_free_result($qr); } export_excel($data,'lophoc-');*/ } else { if ($type == 2 || $type == 4) { $khoahoc = $_GET['danhsach']; export_excel($data, 'bangdiem-'); } } } ?> <div style="margin:30px"> <form name="export_excel" action="export_excel/export_excel.php" method="get"> <p><span style="display:block; color:#F00; font-weight:bold; font-size:120%; padding-bottom:10px">Chọn thông tin muốn xuất ra excel</span> <select name="type_export_excel" style="width:300px; padding:3px 10px" id="type_export_excel"> <option value="0">-- Chọn loại muốn xuất --</option> <optgroup label="Xuất thông tin học viên" > <option value="1">Theo lớp học</option> <option value="2">Theo khóa học</option> </optgroup>
$seperator = "Sno."; $comma = ","; foreach ($row as $name => $value) { $seperator .= $comma . '' . str_replace('', '""', $name); $comma = ","; } $seperator .= "\n"; fputs($fp, $seperator); $db->data_seek($sql, 0); $row_number = 1; while ($row = $db->fetch_as_associate_array($sql)) { $seperator = "{$row_number}"; $comma = ","; foreach ($row as $name => $value) { $seperator .= $comma . '' . str_replace('', '""', $value); $comma = ","; } $row_number++; $seperator .= "\n"; fputs($fp, $seperator); } fclose($fp); echo "Your file is ready. You can download it from <a href='{$filename}'>here!</a>"; } else { echo "There is no record in your Database"; } } $test_name = $_GET["test_name"]; $table = $test_name . "_users"; export_excel($table);
function bangdiem_theokhoa($khoahoc) { $qr = mysql_query("SELECT name FROM info WHERE id='{$khoahoc}' AND `delete`=0 "); $row = mysql_fetch_array($qr); $data = array(); $data[] = array('Tên khóa: ', $row['name']); $data[] = array(); $data[] = array('STT', 'Họ & tên', 'Lớp học', 'Cấp độ', 'Giảng viên', 'Cột 1', 'Cột 2', 'Cột 3', 'Cột 4', 'Cột 5', 'Cột 6', 'Cột 7', 'Cột 8'); if ($khoahoc == '' || $khoahoc == '0') { echo 'Ban chua chon lop hoc de xuat du lieu'; return false; } else { $i = 0; $str = "SELECT daotao_lophoc.id,daotao_lophoc.name as lophoc,capdo,daotao_giangvien.name as giangvien FROM daotao_lophoc,daotao_giangvien WHERE daotao_lophoc.`delete`=0 AND id_khoahoc='{$khoahoc}' AND id_giangvien=daotao_giangvien.id"; $qr = mysql_query($str); while ($row = mysql_fetch_array($qr)) { $str = "SELECT daotao_hocvien.name,diem1,diem2,diem3,diem4,diem5,diem6,diem7,diem8 FROM daotao_hocvien,daotao_bangdiem WHERE daotao_bangdiem.`delete`=0 AND daotao_bangdiem.status=1 AND id_lophoc='{$row['id']}' AND daotao_hocvien.id=id_hocvien ORDER BY daotao_hocvien.`name`"; $qr1 = mysql_query($str); while ($row1 = mysql_fetch_array($qr1)) { $i++; $data[] = array($i, $row1['name'], $row['lophoc'], $row['capdo'], $row['giangvien'], $row1['diem1'], $row1['diem2'], $row1['diem3'], $row1['diem4'], $row1['diem5'], $row1['diem6'], $row1['diem7'], $row1['diem8']); } } mysql_free_result($qr); } export_excel($data, 'khoahoc-'); }