| Server IP : 27.254.66.5 / Your IP : 216.73.217.39 Web Server : Apache/2 System : Linux cs82.hostneverdie.com 3.10.0-1160.45.1.el7.x86_64 #1 SMP Wed Oct 13 17:20:51 UTC 2021 x86_64 User : technic2 ( 1951) PHP Version : 7.4.30 Disable Function : apache_child_terminate, apache_setenv, define_syslog_variables, escapeshellarg, escapeshellcmd,exec, fp, fput, highlight_file, ini_alter, ini_restore, inject_code, passthru,phpAds_remoteInfo, phpAds_XmlRpc,phpAds_xmlrpcDecode, phpAds_xmlrpcEncode, popen, posix_getpwuid, posix_kill, posix_mkfifo, posix_setpgid, posix_setsid,posix_setuid, posix_setuid, posix_uname,proc_open,proc_close, proc_get_status, proc_nice, proc_terminate, shell_exec, syslog, system, xmlrpc_entity_decode, show_source,sleep,pcntl_exec,virtual,suexec,dbmopen,dl,symlink,disk_free_space,diskfreespace,leak MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/technic2/public_html/old-website/vecsc/ |
Upload File : |
<!doctype html>
<html lang='en'>
<head>
<meta charset='UTF-8'>
<meta name='Generator' content='EditPlus®'>
<meta name='Author' content=''>
<meta name='Keywords' content=''>
<meta name='Description' content=''>
<title>Document</title>
</head>
<body>
<br>
<br>
<center>
<h3>ระบบลงทะเบียนกรรมการแข่งขันทักษะวิชาชีพและทักษะพื้นฐาน</h3>
<h3>ดูข้อมูลการลงทะเบียนที่เคยป้อนแล้ว</h3>
<br>
<form method='post' action='viewregister3.php'>
<table border='1' width='90%' cellpadding='0' cellspacing='0' style='border-collapse:collapse;'>
<tr>
<th colspan='7'>ป้อนรหัสสถานศึกษา : <input type="text" name="college_id"> <input type="submit"></th>
</tr>
<tr>
<th>ลำดับที่</th>
<th>ทักษะที่ลงทะเบียน</th>
<th>สถานะของผู้สมัคร</th>
<th>ชื่อ - สกุล</th>
<th>ไซต์เสื้อ</th>
<th>จำนวนเงิน</th>
</tr>
<?php
$college_name = "";
$phone = "";
if (isset($_POST['college_id']) == false) {
$_POST['college_id'] = '';
}
if ($_POST['college_id'] <> '') {
// Create connection
require_once('config.php');
// Check connection
if (!$conn) {
die('Connection failed: ' . mysqli_connect_error());
}
mysqli_set_charset($conn,'utf8');
$sql = "SELECT tacsa_name.tacsa_name, tacsa_staff_position.position_name, tacsa_staff.tname, tacsa_staff.fname, tacsa_staff.lname, tacsa_staff.polo_size, tacsa_staff.amount, college.college_name, tacsa_staff.phone FROM tacsa_staff, tacsa_name, tacsa_staff_position, college WHERE tacsa_name.tacsa_id = tacsa_staff.tacsa_id AND tacsa_staff_position.position_id = tacsa_staff.position_id and college.college_id = tacsa_staff.college_id AND tacsa_staff.college_id = '" . $_POST['college_id'] . "' " . "ORDER by tacsa_staff.college_id, tacsa_staff.tacsa_id";
//echo $sql;
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
// output data of each row
$i = 0;
while($row = mysqli_fetch_assoc($result)) {
$i++;
echo "<tr>";
echo "<td align='center'>" . $i . "</td>";
echo "<td>" . $row['tacsa_name'] . "</td>";
echo "<td>" . $row['position_name'] . "</td>";
echo "<td>" . $row['tname'] . $row['fname'] . " " . $row['lname'] . "</td>";
echo "<td align='center'>" . $row['polo_size'] . "</td>";
echo "<td align='center'>" . $row['amount'] . "</td>";
echo "</tr>";
$college_name = $row['college_name'];
$phone = $row['phone'];
}
}
}
?>
<tr>
<th colspan='7'><?php echo $college_name; ?> เบอร์โทรศัพท์สำหรับใช้ประสานงาน : <?php echo $phone; ?></th>
</tr>
<tr>
<th colspan='7'></th>
</tr>
</table>
<br>
<br>
<a href="./register3.php">กลับหน้าหลัก</a>
</center>
</form>
</body>
</html>