foreach ($questions as $question) {
$tempData[$index]['question_id'] = $question['question_id'];
$tempData[$index]['answer'] = $question['answer'];
$index++;
}
$content = "<tr><td>ข้อสอบข้อที่</td><td>หมายเลขข้อสอบจากคลังข้อสอบ</td><td>เฉลย</td></tr>";
$flag = false;
$index = 1;
foreach ($tempData as $answer) {
$content .= "<tr><td>{$index}</td><td>" . $answer['question_id'] . "</td> <td>" . $answer['answer'] . "</td></tr>";
$index++;
}
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment;Filename=เฉลยปัญหาข้อสอบ.xls");
header("Pragma: no-cache");
header("Expires: 0");
echo "<html>";
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">";
echo "<body>";
echo "<table>";
echo $content;
echo "</table>";
echo "</body>";
echo "</html>";
} else {
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">";
$text = 'ขออภัยไม่พบข้อมูลข้อสอบในระบบฐานข้อมูล';
Membership::getInstance()->sms($text);
Membership::getInstance()->redirect('list_of_exams.php');
}
//end loop of validate
public function checkUsernameAvailable()
{
$request = self::$_appInstance->request();
$username = $request->post('username');
$username = filter_var($username, FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW | FILTER_FLAG_STRIP_HIGH);
//check username in DB
$result = Membership::getInstance()->checkUsername($username);
$results = array();
if ($result[0]['valid'] > 0) {
$results['message'] = "คุณไม่สามารถใช้ชื่อบัญชีนี้ได้";
$results['image'] = '<img src="img/not-available.png" /> ' . $results['message'];
$results['error'] = true;
} else {
$results['message'] = "คุณสามารถใช้ชื่อบัญชีนี้ได้";
$results['image'] = '<img src="img/available.png" /> ' . $results['message'];
$results['error'] = false;
}
echo json_encode($results);
}
public function regis()
{
$request = self::$_appInstance->request();
$data['iedupoll_type_id'] = $request->post('iedupoll_type_id');
$data['rank_id'] = $request->post('rank');
$data['first_name'] = $request->post('first_name');
$data['last_name'] = $request->post('last_name');
$data['phone'] = $request->post('phone');
$data['email'] = $request->post('email');
$data['position_id'] = $request->post('position');
$data['division_id'] = $request->post('division');
$data['province_id'] = $request->post('province');
$data['amphur_id'] = $request->post('district');
$data['district_id'] = $request->post('subdistrict');
$result = null;
//Fetch result into arrays
if (!$this->isExist($data) || true) {
$id = PDOAdpter::getInstance()->insert($data, 'iedupoll');
if (isset($id)) {
$userdata['iedupoll_id'] = $id;
$userdata['username'] = $data['phone'];
$userdata['password'] = '******';
//default password
$uid = PDOAdpter::getInstance()->insert($userdata, 'iedupoll_usr');
//set login status
Membership::getInstance()->validate_user($userdata['username'], $userdata['password']);
$result = array('isError' => false, 'message' => 'ระบบได้บันทึกข้อมูลของท่านเรียบร้อยแล้ว', 'route' => 'index.php');
} else {
$result = array('isError' => true, 'message' => 'เกิดข้อผิดพลาด : ไม่สามารถบันทึกรายการได้', 'route' => '#');
}
} else {
$result = array('isError' => true, 'message' => 'เกิดข้อผิดพลาด : พบข้อมูลซ้ำในระบบ', 'route' => '#');
}
echo json_encode($result);
}
