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());