| 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/domains/technicrayong.ac.th/private_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='viewregister1.php'>
<table border='1' width='90%' cellpadding='0' cellspacing='0' style='border-collapse:collapse;'>
<tr>
<th colspan='5'>ป้อนรหัสสถานศึกษา : <input type="text" name="college_id"> <input type="submit"></th>
</tr>
<tr>
<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 ongkarn_position.position_name, ongkarn.tname, ongkarn.fname, ongkarn.lname, ongkarn.amount, ongkarn.polo_size, ongkarn.phone, college.college_name FROM ongkarn, ongkarn_position, college WHERE ongkarn.position_id = ongkarn_position.position_id and ongkarn.college_id = college.college_id and ongkarn.college_id = '" . $_POST['college_id'] . "'";
$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['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='5'><?php echo $college_name; ?> เบอร์โทรศัพท์สำหรับใช้ผสานงาน : <?php echo $phone; ?></th>
</tr>
<tr>
<th colspan='5'></th>
</tr>
</table>
</center>
</form>
</body>
</html>