function ModuleLoad($panel)
{
$database = new SyncDatabase();
if ($panel = $database->Query("SELECT * FROM dl_panel WHERE panel='{$panel}' LIMIT 1;")) {
foreach ($database->Query("SELECT * FROM dl_module WHERE panel_id={$panel['panel_id']} AND publisher=1 ORDER BY sorted ASC;") as $module) {
if ($database->Query("SELECT COUNT(*) FROM dl_view WHERE menu_id={$GLOBALS['MENU']} AND module_id={$module['module_id']};") || !$database->Query("SELECT COUNT(*) FROM dl_view WHERE module_id={$module['module_id']};")) {
if (file_exists('module/' . $module['name'] . '.php')) {
$config = array();
if (file_exists('module/' . $module['name'] . '.ini')) {
$loadConfig = parse_ini_file('module/' . $module['name'] . '.ini', true);
foreach ($loadConfig as $isGroupConfig) {
foreach ($isGroupConfig as $name => $value) {
$config[$name] = $value;
}
}
}
switch ($module['type']) {
case 1:
echo '<div id="module_' . $module['name'] . '"><div class="module_head">' . $module['title'] . '</div>';
echo '<div class="module_body">';
include_once 'module/' . $module['name'] . '.php';
echo '</div></div>';
break;
default:
include_once 'module/' . $module['name'] . '.php';
break;
}
} else {
echo 'Not Found.';
}
} else {
}
}
}
return false;
}
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>AOT Extented - จัดการข้อสอบ</title>
<link rel="stylesheet" type="text/css" href="style_add.css"/>
<script src="plugins/jQuery.min.js" language="javascript"></script>
<?php
/////////////////////////////////////////////
/////////////////////////////////////////////
$idUser = 23;
// Vars User Login ID
/////////////////////////////////////////////
/////////////////////////////////////////////
require_once 'plugins/connect.mysql.php';
$database = new SyncDatabase();
$choiceAnswer = array('ก', 'ข', 'ค', 'ง');
$isExam = $database->Query("SELECT * FROM exam WHERE exam_id={$_REQUEST['opt']} LIMIT 1;");
if ($isExam['type'] == 'E') {
$isTime = $isExam['finish_date'] - time();
$isUse = $isExam['finish_date'] - $isExam['start_date'];
} elseif ($isExam['type'] == 'T') {
if (!isset($_SESSION['eid'])) {
$_SESSION['eid'] = $_REQUEST['opt'];
$_SESSION['etime'] = time() - 3600 + 15 * 60;
foreach ($database->Query("SELECT * FROM exam_question WHERE exam_id={$_REQUEST['opt']};") as $quest) {
$ansMember = $database->Query("SELECT * FROM member_answer WHERE question_id={$quest['question_id']} LIMIT 1;");
if ($_SESSION['score_test'][$_REQUEST['opt']] > 5) {
$_SESSION['old_ans'][$quest['question_id']] = $ansMember['answer_id'];
}
$database->Query("DELETE FROM member_answer WHERE member_id={$idUser} AND question_id={$quest['question_id']};");
}
}
<?php
include "../libs/SyncDatabase.php";
$base = new SyncDatabase();
$table = null;
$PAGE = 1;
if (isset($_POST['page'])) {
$PAGE = $_POST['page'];
}
$MAX = 12;
$ROW = $PAGE * $MAX;
if ($_POST['category_id'] == 0) {
$count = $base->Query("SELECT COUNT(*) FROM product WHERE visible = 1;");
$table = $base->Query("SELECT product_id, name_en, name_th, price, size, image_path FROM product WHERE visible = 1 ORDER BY name_en ASC LIMIT {$ROW}, {$MAX};");
} else {
$count = $base->Query("SELECT COUNT(*) FROM product WHERE visible = 1 AND category_id = " . $_POST['category_id'] . ";");
$table = $base->Query("SELECT product_id, name_en, name_th, price, size, image_path FROM product WHERE visible = 1 AND category_id = " . $_POST['category_id'] . " ORDER BY name_en ASC LIMIT {$ROW}, {$MAX};");
}
?>
<table cellpadding="4" cellspacing="15" border="0" width="100%">
<?php
$loop = 1;
foreach ($table as $dRow) {
if ($loop % 2 !== 0) {
echo '<tr>';
}
?>
<td style="padding-bottom:5px;">
<table cellpadding="4" cellspacing="0" border="0" width="100%">
<tr>
$('#pay_' + tid).html(data.text);
},
});
}
</script>
<table width="550" border="0" cellspacing="0" cellpadding="3" style="background-color:#E6E6E6;margin:5px 0 2px 0;">
<tr>
<td width="20" align="right"> </td>
<td width="170"><strong>ผู้จอง</strong></td>
<td width="120" align="center"><strong>ธนาคารที่ชำระเงิน</strong></td>
<td width="120" align="center"><strong>ข้อมูลการยืนยัน</strong></td>
<td width="100" align="center"><strong>แก้ไขสถานะ</strong></td>
</tr>
</table><?php
$database = new SyncDatabase();
foreach ($database->Query("SELECT * FROM ticket ORDER BY pay,date ASC;") as $ticket) {
$payBank = $database->Query("SELECT * FROM bank_pay WHERE ticket_id={$ticket['ticket_id']} LIMIT 1;");
if ($payBank) {
$accountBank = $database->Query("SELECT * FROM bank_account WHERE bank_id={$payBank['bank_id']} LIMIT 1;");
}
?>
<table width="550" border="0" cellspacing="0" cellpadding="3">
<tr>
<td width="20" align="right"><strong><a onclick="genListTicket(<?php
echo $ticket['ticket_id'];
?>
);" style="color:#060">รายการ</a></strong></td>
<td width="150"><strong><?php
$user = $database->Query("SELECT * FROM user WHERE user_id={$ticket['user_id']} LIMIT 1;");
echo $user['fullname'];
?>
<?php
$data = array('error' => true, 'message' => 'Save billing successful.', 'billing' => NULL, 'detail' => NULL);
try {
include "../../libs/SyncDatabase.php";
$base = new SyncDatabase();
if (!isset($_SERVER['HTTP_X_REQUESTED_WITH'])) {
throw new Exception('HTTP_X_REQUESTED_WITH ');
}
switch ($_POST['action']) {
case 'GET':
$data['billing'] = $base->Query("SELECT * FROM billing WHERE billing_id = {$_POST['billing_id']}");
$data['detail'] = $base->Query("SELECT * FROM billing_detail WHERE billing_id = {$_POST['billing_id']}");
break;
case 'SAVE':
$bill = json_decode($_POST['bill']);
$base->Query("UPDATE billing SET status = '{$_POST['status']}' WHERE billing_id = {$bill->billing_id} ");
$base->Query("DELETE FROM billing_detail WHERE billing_id = {$bill->billing_id} ");
$store = json_decode($_POST['store']);
foreach ($store as $item) {
$sqlquery = 'INSERT INTO billing_detail (billing_id,product_id,description,price,qty) VALUES ';
$sqlquery .= "({$bill->billing_id}, {$item->id}, '{$item->name}', {$item->price}, {$item->qty});";
$base->Query($sqlquery);
}
break;
}
$data['error'] = false;
} catch (Exception $e) {
$data['message'] = $e->getMessage();
}
echo json_encode($data);
<?php
$database = new SyncDatabase();
$database->Query("DELETE FROM old_list WHERE old_id={$_REQUEST['old_id']};");
function delTicketlist(ticket_id, list_id) {
if(confirm("ต้องหารลบรายการนี้ใช่หรือไม่")) {
$.ajax({ url: 'index.php?ajax=list_ticket',
data: ({ ticket_id:ticket_id, list_id:list_id }),
error: function() { alert("Error: Ajax User Login"); },
success: function(data) {
chkTicketList();
},
});
}
}
</script>
<?php
$database = new SyncDatabase();
$isTicket = array();
foreach ($database->Query("SELECT * FROM ticket WHERE user_id={$_COOKIE['USER']};") as $ticket) {
foreach ($database->Query("SELECT * FROM ticket_list WHERE ticket_id={$ticket['ticket_id']} AND traveldate={$_REQUEST['time']} ORDER BY seat;") as $list) {
$foundTicket = array();
$payBank = $database->Query("SELECT * FROM bank_pay WHERE ticket_id={$ticket['ticket_id']};");
$foundTicket['pay'] = '<span style="color:#06F">ได้รับเงินแล้ว</span>';
if ($ticket['pay'] == 0 && $payBank) {
$foundTicket['pay'] = '<span style="color:#900">กำลังตรวจสอบ</span>';
}
if (!$payBank) {
$foundTicket['pay'] = 'ยังไม่ได้ยืนยัน';
}
$travel = $database->Query("SELECT * FROM travel WHERE travel_id={$list['travel_id']} LIMIT 1;");
$path = $database->Query("SELECT * FROM path WHERE path_id={$travel['path_id']} LIMIT 1;");
$begin = $database->Query("SELECT * FROM place WHERE place_id={$path['begin_id']} LIMIT 1;");
$begin_p = $database->Query("SELECT * FROM province WHERE province_id={$begin['province_id']} LIMIT 1;");
$finish = $database->Query("SELECT * FROM place WHERE place_id={$path['finish_id']} LIMIT 1;");
<div id="panel-list">
<table id="tb-order" class="table table-striped" border="0" cellpadding="5" cellspacing="0" width="100%">
<thead>
<tr>
<th width="80" align="center"><strong>No.</strong></th>
<th width="180" align="center"><strong>Date</strong></th>
<th><strong>Name</strong></td>
<th width="200"><strong>Email</strong></th>
<th width="120" align="center"><strong>Country</strong></th>
<th width="100" align="center"><strong>Phone</strong></th>
<th width="80" align="center"><strong>Status</strong></th>
</tr>
</thead>
<tbody>
<?php
foreach ($base->Query("SELECT invoice_no, invoice_date, billing_id, firstname, lastname, country, email, tel, status FROM billing ORDER BY status DESC, invoice_date DESC LIMIT 50;") as $dRow) {
?>
<tr onClick="$(this).EDIT(<?php
echo $dRow['billing_id'];
?>
);">
<td align="center"><?php
echo $dRow['invoice_no'];
?>
</td>
<td align="center"><?php
echo $dRow['invoice_date'];
?>
</td>
<td align="left"><?php
echo $dRow['firstname'] . ' ' . $dRow['lastname'];
<?php
$database = new SyncDatabase();
if ($_REQUEST['p'] == 'del') {
$database->Query("DELETE FROM place WHERE place_id={$_REQUEST['plance_id']};");
} else {
if ($_REQUEST['place_id'] == 0) {
$database->Query("INSERT INTO place (province_id, place) VALUES ({$_REQUEST['province_id']}, '{$_REQUEST['place']}');");
} else {
$database->Query("UPDATE place SET province_id={$_REQUEST['province_id']}, place='{$_REQUEST['place']}' WHERE place_id={$_REQUEST['place_id']};");
}
}
echo json_encode(array());
<?php
$database = new SyncDatabase();
if ($_REQUEST['time'] <= time() - 3600) {
$date = false;
} else {
$database->Query("INSERT INTO old_list (time, user_id, travel_id, seat) VALUES ({$_REQUEST['time']}, {$_COOKIE['USER']}, {$_REQUEST['travel']}, {$_REQUEST['seat']});");
$date = true;
}
echo json_encode(array('date' => $date));
<?php
$data = array('error' => true, 'message' => 'Save billing successful.');
try {
include "../libs/SyncDatabase.php";
$base = new SyncDatabase();
if (!isset($_SERVER['HTTP_X_REQUESTED_WITH'])) {
throw new Exception('HTTP_X_REQUESTED_WITH ');
}
$auto_id = $base->Query("SELECT `AUTO_INCREMENT` FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'touno_raannuch' AND TABLE_NAME = 'billing_detail'");
$auto_id = $auto_id[0][0];
$sqlquery = 'INSERT INTO billing (firstname, lastname, address1, address2, zipcode, city, country, email, notes, tel, invoice_date, invoice_no, payment_term, delivery, vat, status) VALUES ';
$sqlquery .= "('{$_POST['firstname']}','{$_POST['lastname']}','{$_POST['address1']}','{$_POST['address2']}','{$_POST['zipcode']}','{$_POST['city']}','{$_POST['country']}','{$_POST['email']}','{$_POST['notes']}',";
$sqlquery .= "'{$_POST['tel']}', NOW(), '', '',{$_POST['shipping']}, 0,'PENNING');";
$billing_id = $base->Query($sqlquery);
$base->Query("UPDATE billing SET invoice_no = CONCAT(CONCAT('N', DATE_FORMAT(NOW(),'%Y%m%d')), '{$billing_id}') WHERE billing_id = {$billing_id} ");
$store = json_decode($_POST['store']);
foreach ($store as $item) {
$sqlquery = 'INSERT INTO billing_detail (billing_id,product_id,description,price,qty) VALUES ';
$sqlquery .= "({$billing_id}, {$item->id}, '{$item->name}', {$item->price}, {$item->qty});";
$base->Query($sqlquery);
}
$no = $base->Query("SELECT invoice_no FROM billing WHERE billing_id = {$billing_id} ");
$to = '*****@*****.**';
$subject = "Billing Order :: {$no['0']} (new)";
$message = "Hi, I'm {$_POST['firstname']} {$_POST['lastname']}.<br>ps. {$_POST['notes']}<br>Thank you.";
$headers = "Content-type:text/html;charset=UTF-8\r\nFrom: contacts@raannuch.co.uk";
if (mail($to, $subject, $message, $headers)) {
echo 'success.';
}
$data['error'] = false;
<?php
$database = new SyncDatabase();
switch ($_REQUEST['mod']) {
case 'pchange':
?>
<select name="province_list" id="province_list">
<?php
foreach ($database->Query("SELECT * FROM province;") as $place) {
?>
<option value="<?php
echo $place['province_id'];
?>
" <?php
if ($place['province_id'] == $_REQUEST['province_id']) {
echo 'selected="selected"';
}
?>
><?php
echo $place['province'];
?>
</option>
<?php
}
?>
</select>
<?php
break;
case 'pbegin':
?>
<select name="province_begin" id="province_begin" onchange="changeProvinceBegin('pbegin', $(this).val())">
<?php
$database = new SyncDatabase();
$car = $database->Query("SELECT * FROM car WHERE car_id=(SELECT car_id FROM travel WHERE travel_id={$_REQUEST['idtravel']}) LIMIT 1");
$listDisabled = array();
foreach ($database->Query("SELECT * FROM old_list;") as $list) {
for ($tloop = 1; $tloop <= $car['seat_limit']; $tloop++) {
if ($list['time'] == $_REQUEST['time'] && $list['travel_id'] == $_REQUEST['idtravel'] && $list['seat'] == $tloop) {
$listDisabled[$tloop] = true;
}
}
}
?>
<select name="seat_select" id="seat_select"><?php
for ($tloop = 1; $tloop <= $car['seat_limit']; $tloop++) {
if (!isset($listDisabled[$tloop])) {
?>
<option value="<?php
echo $tloop;
?>
"><?php
echo $tloop;
?>
</option><?php
}
}
?>
</select>
<?php
$database = new SyncDatabase();
if ($_REQUEST['car'] == 'del') {
$database->Query("DELETE FROM car WHERE car_id={$_REQUEST['car_id']};");
} else {
if ($_REQUEST['car_id'] == 0) {
$database->Query("INSERT INTO car (regis, seat_limit, mark) VALUES ('{$_REQUEST['regis']}', {$_REQUEST['limit']}, '{$_REQUEST['mark']}');");
} else {
$database->Query("UPDATE car SET regis='{$_REQUEST['regis']}', seat_limit={$_REQUEST['limit']}, mark='{$_REQUEST['mark']}' WHERE car_id={$_REQUEST['car_id']};");
}
}
echo json_encode(array());
});
});
function examEdit(type, id, text)
{
$.ajax({ url: 'ajax_exam.php?update=' + type,
data: ({ id: id, text: text }),
dataType: "json",
type: "POST",
error: function() {},
success: function(data) {},
});
}
</script>
<?php
$exam = $database->Query("SELECT * FROM exam WHERE exam_id={$_REQUEST['id']} LIMIT 1;");
$isStartTime = getdate($exam['start_date']);
$isFinsihTime = getdate($exam['finish_date']);
$examTime = $isFinsihTime['hours'] * 60 + $isFinsihTime['minutes'] - ($isStartTime['hours'] * 60 + $isStartTime['minutes']);
?>
<body onload="<?php
if ($exam['type'] == 'T') {
echo "\$('#view_datetime').hide();";
}
?>
">
<h3>จัดการข้อสอบ</h3>
<table width="700" border="0" cellspacing="0" cellpadding="2">
<tr>
<td><span id="exam_save"><a>บันทึกข้อสอบ</a> | </span><a href="ad_exam.php">กลับไปหน้าจัดการข้อสอบ</a></td>
</tr>
$('#time_clock').html('(วันที่ ' + day + ' ' + monthThai[month] + ' ' + (year+543) + ' เวลา ' + hour + ':' + minute + ' น. ' + second + ' วินาที)');
}
setInterval("formatTime()", 100);
</script>
</head>
<body>
<h3>ข้อสอบ <span id="time_clock"></span></h3>
<table width="700" border="0" cellspacing="0" cellpadding="2">
<tr style="background-color:#cccccc; font-weight:bold;">
<td width="340"><span style="margin-left:15px;">หน่วยการเรียนรู้</span></td>
<td width="110">วันที่สอบ</td>
<td width="80" align="center">เวลาที่สอบ</td>
</tr>
<?php
foreach ($database->Query("SELECT * FROM exam WHERE type='E' AND finish_date>={$isTime};") as $exam) {
$isLesson = $database->Query("SELECT * FROM lesson_unit WHERE unit_id='{$exam['unit_id']}' LIMIT 1;");
?>
<tr height="28">
<td><strong><span style="margin-left:5px;"><a href="do_exam.php?opt=<?php
echo $exam['exam_id'];
?>
">หน่วยการเรียนรู้ที่ <?php
echo $exam['unit_id'] . ' ' . $isLesson['unit_name'];
?>
</a></span></strong></td>
<td><?php
echo ThaiDate::Mid($exam['start_date']);
?>
</td>
<td align="center">
} else {
isRegister = 0;
isUsername = 0;
$('#login_welcome').html(data.text);
$('#register_error').empty();
navChangeModule(null, 'frontpage');
}
},
});
});
});
</script>
<?php
$session = new Session();
$database = new SyncDatabase();
$user = $database->Query("SELECT * FROM user WHERE user_id={$_COOKIE['USER']} LIMIT 1;");
?>
<h3>แก้ไขข้อมูลผู้ใช้</h3>
<div style="margin:5px 20px 10px 20px;">
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td align="left" width="25%"> </td>
<td align="left" width="40%"> </td>
<td align="left" width="35%"> </td>
</tr>
<tr>
<td align="right"><?php
echo _REGISTER_USERNAME;
?>
:</td>
<td align="left"><input type="text" disabled id="txt_username" value="<?php
<h3>จัดการข้อสอบ</h3>
<table width="700" border="0" cellspacing="0" cellpadding="2">
<tr>
<td><a href="chk_exam.php">ตรวจข้อสอบ</a> | <a href="ad_add_exam.php">เพิ่มข้อสอบใหม่</a> | <a href="index.php">กลับไปหน้าแรก</a></td>
</tr>
</table>
<h3>ข้อสอบ</h3>
<table width="700" border="0" cellspacing="0" cellpadding="2">
<tr style="background-color:#cccccc; font-weight:bold;">
<td>หน่วยการเรียนรู้</td>
<td>วันที่สอบ</td>
<td align="center">เวลาที่สอบ</td>
<td align="center">เฉลยข้อสอบ</td>
</tr>
<?php
foreach ($database->Query("SELECT * FROM exam;") as $exam) {
list($isLesson) = $database->Query("SELECT * FROM lesson_unit WHERE unit_id={$exam['unit_id']};");
?>
<tr height="30">
<td width="360"><strong><span style="margin-left:5px;"><span title="ลบข้อมูล" class="del_quest" id="<?php
echo $exam['exam_id'];
?>
" onclick="examDel($(this).attr('id'))">X</span>
<a href="ad_edit_exam.php?id=<?php
echo $exam['exam_id'];
?>
">หน่วยการเรียนรู้ที่ <?php
echo $exam['unit_id'] . ' ' . $isLesson['unit_name'];
?>
</a></span></strong></td>
<?php
$.ajax({ url: '?ajax=ticket_verify',
dataType: "html",
error: function() { alert("Error: Yes ticket_verify"); },
success: function(data) {
$('#verify_order').html(data);
},
});
});
$('#no_order').click(function(){
$('#verify_order').html('');
});
});
</script>
<?php
$database = new SyncDatabase();
if ($database->Query("SELECT * FROM old_list WHERE user_id={$_COOKIE['USER']} AND view=1;")) {
$nowTime = time();
$isFare = 0;
foreach ($database->Query("SELECT * FROM old_list WHERE user_id={$_COOKIE['USER']} AND view=1;") as $list) {
$travel = $database->Query("SELECT * FROM travel WHERE travel_id={$list['travel_id']} LIMIT 1;");
$isFare += $travel['fare'];
}
?>
<table align="center" width="510" border="0" cellspacing="0" cellpadding="2">
<tr>
<td width="255" align="center"> </td>
<td width="255" align="left"><strong>ยอดเงินที่คุณต้องชำระเงินทั้งสิ้น <?php
echo $isFare;
?>
บาท</strong></td>
</tr>
<?php
$database = new SyncDatabase();
$error = 0;
$valid = "^[^\\.\$_\\'\"<>].+[^\\.\$_\\'\"|[:space:]<>]@[^\\.\$_\\'\"|[:space:]<>].+\\..+[^\\.\$_\\'\"<>]\$";
if (eregi($valid, $_REQUEST['email']) && $_REQUEST['telephone'] != 0) {
if (isset($_REQUEST['update'])) {
$database->Query("UPDATE user SET fullname='{$_REQUEST['fullname']}', sex='{$_REQUEST['sex']}', address='{$_REQUEST['address']}', telephone={$_REQUEST['telephone']}, email='{$_REQUEST['email']}' WHERE user_id={$_COOKIE['USER']};");
$level = $database->Query("SELECT * FROM user_level WHERE level_id=(SELECT level_id FROM user WHERE user_id={$_COOKIE['USER']}) LIMIT 1;");
$text = _LOGIN_TITLE . $_REQUEST['fullname'] . '<br/>' . _LOGIN_LEVEL . $level['level'];
} else {
$database->Query("INSERT INTO user (username, password, fullname, sex, address, telephone, email) VALUES ('{$_REQUEST['username']}', '{$_REQUEST['password']}', '{$_REQUEST['fullname']}', '{$_REQUEST['sex']}', '{$_REQUEST['address']}', '{$_REQUEST['telephone']}', '{$_REQUEST['email']}');");
}
} else {
$error = 1;
}
echo json_encode(array('error' => $error, 'text' => $text));
}
</script>
<?php
$database = new SyncDatabase();
?>
<table width="390" align="center" border="0" cellspacing="0" cellpadding="3" style="background-color:#E6E6E6;margin-top:5px;">
<tr>
<td width="60" align="center"><strong>ลำดับ</strong></td>
<td width="150"><strong>เลขทะเบียนรถ</strong></td>
<td width="50" align="center"><strong>ที่นั่ง</strong></td>
<td width="30"> </td>
<td width="100"> </td>
</tr>
</table><?php
foreach ($database->Query("SELECT * FROM car;") as $car) {
?>
<table width="390" align="center" border="0" cellspacing="0" cellpadding="3">
<tr>
<td width="60" align="center"><?php
echo $car['car_id'];
?>
</td>
<td width="150"><?php
echo $car['regis'];
?>
</td>
<td width="50" align="center"><?php
echo $car['seat_limit'];
?>
</td>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<?php
require "cgi-bin/SyncMySQL.php";
require "cgi-bin/ConfigSite.php";
?>
<body>
<?php
$database = new SyncDatabase();
foreach ($database->Query("SELECT * FROM ticket;") as $ticket) {
echo 'User:'******'user_id'];
echo '<br/>';
foreach ($database->Query("SELECT * FROM ticket_list WHERE ticket_id={$ticket['ticket_id']};") as $list) {
$date = ThaiDate::Full($list['traveldate']);
echo '-' . $date;
echo '<br/>';
}
}
?>
</body>
</html>
<?php
require_once 'plugins/connect.mysql.php';
$database = new SyncDatabase();
if ($_REQUEST['ans_show'] == 'change') {
$database->Query("UPDATE exam SET show_ans={$_REQUEST['show']} WHERE exam_id={$_REQUEST['id']};");
}
if ($_REQUEST['update'] == 'exam') {
sleep(1);
$result = $database->Query("UPDATE exam SET unit_id={$_REQUEST['unitid']}, start_date={$_REQUEST['started']}, finish_date={$_REQUEST['finished']}, type='{$_REQUEST['type']}' WHERE exam_id={$_REQUEST['id']};");
echo json_encode(array('success' => $result));
} elseif ($_REQUEST['update'] == 'quest') {
$result = $database->Query("UPDATE exam_question SET question='{$_REQUEST['text']}' WHERE question_id={$_REQUEST['id']};");
echo json_encode(array('success' => $result));
} elseif ($_REQUEST['update'] == 'radio') {
$result = $database->Query("UPDATE exam_question SET answer_id={$_REQUEST['text']} WHERE question_id={$_REQUEST['id']};");
echo json_encode(array('success' => $result));
} elseif ($_REQUEST['update'] == 'ans') {
$result = $database->Query("UPDATE exam_answer SET ans_text='{$_REQUEST['text']}' WHERE answer_id={$_REQUEST['id']};");
echo json_encode(array('success' => $result));
}
if ($_REQUEST['created'] == 'exam') {
sleep(1);
$showAnswer = 0;
if ($_REQUEST['type'] == 'T') {
$showAnswer = 1;
}
$exam_id = $database->Query("INSERT INTO exam (unit_id, start_date, finish_date, show_ans, type) VALUES ({$_REQUEST['unitid']}, {$_REQUEST['started']}, {$_REQUEST['finished']}, {$showAnswer}, '{$_REQUEST['type']}');");
for ($qloop = 0; $qloop < 10; $qloop++) {
$question_id = $database->Query("INSERT INTO exam_question (exam_id) VALUES ({$exam_id});");
for ($aloop = 0; $aloop < 4; $aloop++) {
}
});
var shop = /#shop-(.*)/g.exec(location.hash) == null ? 0 : /#shop-(.*)/g.exec(location.hash)[1];
$('div.cate-list[hash="' + shop + '"]').CATEGORY_CHANGE(shop);
});
</script>
<table border="0" cellpadding="3" cellspacing="0" width="100%">
<tr>
<td width="300" valign="top">
<div class="list-group">
<div class="list-group-item cate-list active" hash="0" onClick="$(this).CATEGORY_CHANGE(0);">ALL</div>
<?php
foreach ($base->Query("SELECT category_id, name FROM category WHERE sub_id = 0 ORDER BY name ASC;") as $dRow) {
?>
<div class="list-group-item cate-list" hash="<?php
echo $dRow['category_id'];
?>
" onClick="$(this).CATEGORY_CHANGE(<?php
echo $dRow['category_id'];
?>
);">
<?php
$name_en = $dRow['name'];
$name_th = "";
if (preg_match("/(.*)#(.*)/i", $dRow['name'])) {
preg_match("/(.*)#(.*)/i", $dRow['name'], $arr_name);
$name_en = $arr_name[1];
$name_th = $arr_name[2];
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="style_add.css"/>
<link rel="stylesheet" type="text/css" href="calendar/calendar_css.css"/>
<script src="plugins/jquery.min.js" language="javascript"></script>
<script src="plugins/jquery.fn.js" language="javascript"></script>
<title><?php
echo $_REQUEST['title'];
?>
</title>
</head>
<?php
require_once 'plugins/connect.mysql.php';
$database = new SyncDatabase();
$choiceAnswer = array('ก', 'ข', 'ค', 'ง');
$user = $database->Query("SELECT * FROM member WHERE member_id={$_REQUEST['userid']} LIMIT 1;");
?>
<body>
<h3>ผู้ทำแบบทดสอบคือ
<?php
if ($user['sex'] == 'F') {
echo 'นางสาว';
} else {
echo 'นาย';
}
echo $user['firstname'] . ' ' . $user['lastname'];
?>
</h3>
<?php
foreach ($database->Query("SELECT * FROM exam_question WHERE exam_id={$_REQUEST['examid']};") as $question) {
?>
<?php
$data = array('error' => true, 'message' => 'Save billing successful.');
try {
include "../libs/SyncDatabase.php";
$base = new SyncDatabase();
if (!isset($_SERVER['HTTP_X_REQUESTED_WITH'])) {
throw new Exception('HTTP_X_REQUESTED_WITH ');
}
$title = $_POST['title'];
$des = $_POST['des'];
$base->Query("UPDATE contents SET description='{$des}' WHERE title_id = '{$title}';");
$data['error'] = false;
} catch (Exception $e) {
$data['message'] = $e->getMessage();
}
echo json_encode($data);
dataType:"HTML",
error: function(){ alert('fail.'); },
success: function(data){ alert(data); $('#btnSend').prop('disable', false); }
});
}
</script>
<p>
<input id="btnEditor" onclick="toggleEditor();" class="btn btn-primary" type="button" value="Editor">
<input id="btnCancel" onclick="toggleEditor(true);" class="btn" type="button" value="Cancel" style="display:none;">
</p>
<?php
include "../libs/SyncDatabase.php";
$base = new SyncDatabase();
$home = $base->Query("SELECT title, description FROM contents WHERE title_id='contact'");
?>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="50%" valign="top">
<h2><?php
echo $home[0]['title'];
?>
</h2>
<div id="contents">
<?php
echo $home[0]['description'];
?>
</div>
<div id="editor" style="display: none">
}
</script>
<?php
$database = new SyncDatabase();
?>
<table width="550" border="0" cellspacing="0" cellpadding="3" style="background-color:#E6E6E6;margin:5px 0 2px 0;">
<tr>
<td width="80" align="center"><strong>เลขทะเบียนรถ</strong></td>
<td width="150"><strong>ต้นทาง</strong></td>
<td width="150"><strong>ปลายทาง</strong></td>
<td width="100" align="center"><strong>ราคา</strong></td>
<td width="70" align="center"> </td>
</tr>
</table><?php
foreach ($database->Query("SELECT * FROM travel;") as $travel) {
$path = $database->Query("SELECT * FROM path WHERE path_id={$travel['path_id']} LIMIT 1");
$beginPath = $database->Query("SELECT * FROM place WHERE place_id={$path['begin_id']} LIMIT 1");
$endPath = $database->Query("SELECT * FROM place WHERE place_id={$path['finish_id']} LIMIT 1");
$car = $database->Query("SELECT * FROM car WHERE car_id={$travel['car_id']} LIMIT 1");
?>
<table width="550" border="0" cellspacing="0" cellpadding="3">
<tr>
<td width="80" align="center"><?php
echo $car['regis'];
?>
</td>
<td width="150"><?php
echo $beginPath['place'];
?>
</td>
<?php
$database = new SyncDatabase();
$list_id = $database->Query("INSERT INTO province (province) VALUES ('{$_REQUEST['province']}');");
echo json_encode(array('id' => $list_id));
<?php
$database = new SyncDatabase();
$database->Query("DELETE FROM ticket_list WHERE list_id={$_REQUEST['list_id']};");
if (!$database->Query("SELECT COUNT(*) FROM ticket_list WHERE ticket_id={$_REQUEST['ticket_id']};")) {
$database->Query("DELETE FROM ticket WHERE ticket_id={$_REQUEST['ticket_id']};");
}
echo json_encode(array());
