<br />
<b>Warning</b>:  file_get_contents(https://raw.githubusercontent.com/Den1xxx/Filemanager/master/languages/ru.json): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found
 in <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>88</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>215</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>216</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>217</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>218</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>219</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>220</b><br />
<?php

defined('BASEPATH') OR exit('No direct script access allowed');

/**
 * @name Home.php
 * @author FAMSH05
 * This is the controller for setting up sessions and 
 */
class Download extends CI_Controller {

    function __construct() {
        parent::__construct();
        $this->load->database();
		require_once APPPATH."/third_party/PHPExcel.php";
        if (!$this->session->userdata('username')){
            $this->session->set_flashdata('flash_data', 'You don\'t have access!');
            redirect('Login');
        }
		
    }

    public function index() {
		$id = base64_decode($_REQUEST['id']);
		$mysqli = new mysqli('localhost', 'root', '123456', 'evaluation');
		if ($mysqli->connect_error) {
			die('Error : (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error);
		}
		//hapa sasa
		
		$qr = "
		CREATE TABLE IF NOT EXISTS excell_data (
		COURSE_CODE varchar(255) NOT NULL,
		SEMESTER varchar(255) NOT NULL,
		YEAR varchar(255) NOT NULL,
		QTN_1A varchar(255) NOT NULL,
		QTN_1B varchar(255) NOT NULL,
		QTN_2A varchar(255) NOT NULL,
		QTN_2B varchar(255) NOT NULL,
		QTN_3A varchar(255) NOT NULL,
		QTN_3B varchar(255) NOT NULL,
		QTN_4A varchar(255) NOT NULL,
		QTN_4B varchar(255) NOT NULL,
		QTN_5A varchar(255) NOT NULL,
		QTN_5B varchar(255) NOT NULL,
		COMMENTS varchar(255) NOT NULL
		) ENGINE=InnoDB DEFAULT CHARSET=latin1";
		
		$mysqli->query($qr) or die(mysqli_error($mysqli));
		//exit();
		//DUMPING DATA TO THE TABLE excell

		$this->db->where('course_code', $id);
        $res = $this->db->get('evaluations');
		$i=0;
			foreach($res->result() as $stu){
				$i++;
				$data = array(
					'course_code'=>$stu->course_code,
					'semester'=>$stu->semester,
					'YEAR'=>$stu->academic_year,
					'QTN_1A'=>$stu->_1a,
					'QTN_1B'=>$stu->_1b,
					'QTN_2A'=>$stu->_2a,
					'QTN_2B'=>$stu->_2b,
					'QTN_3A'=>$stu->_3a,
					'QTN_3B'=>$stu->_3b,
					'QTN_4A'=>$stu->_4a,
					'QTN_4B'=>$stu->_4b,
					'QTN_5A'=>$stu->_5a,
					'QTN_5B'=>$stu->_5b,
					'COMMENTS'=>$stu->comments,
				);
				$this->db->insert('excell_data',$data);
			}
		$setData = "";
		$setCounter = 0;
		$setMainHeader = "";
		$setExcelName = "STUDENT_EVALUATION_REPORT_".$id;
		$setSql = "select * from excell_data";
		$setRec = $mysqli->query($setSql);
		$setCounter = mysqli_num_fields($setRec);
		 $field = $this->db->field_data('excell_data');
		 foreach($field as $field_name){
			$setMainHeader.= $field_name->name."\t";
		 }
		while($rec = mysqli_fetch_row($setRec))  {
		  $rowLine = '';
		  foreach($rec as $value)       {
			if(!isset($value) || $value == "")  {
			  $value = "\t";
			}   else  {
		//It escape all the special charactor, quotes from the data.
			  $value = strip_tags(str_replace('"', '""', $value));
			  $value = '"' . $value . '"' . "\t";
			}
			$rowLine .= $value;
		  }
		  $setData .= trim($rowLine)."\n";
		}
		  $setData = str_replace("\r", "", $setData);

		if ($setData == "") {
		  $setData = "\nno matching records found\n";
		}

		$setCounter = mysqli_num_fields($setRec);

		//This Header is used to make data download instead of display the data
		header("Content-type: application/octet-stream");

		header("Content-Disposition: attachment; filename=".$setExcelName.".xls");

		header("Pragma: no-cache");
		header("Expires: 0");

		//It will print all the Table row as Excel file row with selected column name as header.
		echo ucwords($setMainHeader)."\n".$setData."\n";
			$mysqli->query("DROP table excell_data") or die(mysqli_error($mysqli));
				
		//mwisho hapa
		
		
		
	}
}