| 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 : |
<?php
Ob_start();
session_start();
$_SESSION["counter"] = 1;
?>
<!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>
<?php
if (isset($_POST['college_id']) == false) {
$_POST['college_id'] = '';
$college_id = '';
}
if (isset($_POST['tacsa_id']) == false) {
$_POST['tacsa_id'] = '';
$tacsa_id = '';
}
if (isset($_POST['level_id']) == false) {
$_POST['level_id'] = '';
$level_id = '';
}
$i = 0
?>
<body>
<?php
// Create connection
require('config.php');
// Check connection
if (!$conn) {
die('Connection failed: ' . mysqli_connect_error());
}
mysqli_set_charset($conn,'utf8');
$sql1 = 'SELECT college.college_id, college.college_name FROM college';
$sql2 = 'SELECT tacsa_name.tacsa_id, tacsa_name.tacsa_name FROM tacsa_name';
$sql3 = 'SELECT tacsa_level.level_id, tacsa_level.level_name FROM tacsa_level';
$result1 = mysqli_query($conn, $sql1);
$result2 = mysqli_query($conn, $sql2);
$result3 = mysqli_query($conn, $sql3);
if (mysqli_num_rows($result1) > 0) {
// output data of each row
?>
<form name='form1' method='post' action="<?php echo $_SERVER['PHP_SELF']; ?>">
<center>
<h3>ระบบรับสมัครการแข่งขันทักษะวิชาชีพและทักษะพื้นฐาน</h3>
<br>
<table border='1' width='90%' cellpadding='0' cellspacing='0' style='border-collapse:collapse;'>
<tr>
<th colspan='2'>
ส่วนที่ 1
</th>
</tr>
<tr>
<td align='right'>
<b>เลือกชื่อวิทยาลัย : </b>
</td>
<td>
<select name='college_id'>
<option value=''>โปรดเลือก</option>
<?php while($row = mysqli_fetch_assoc($result1)) { ?>
<?php echo "<option value='" . $row['college_id'] . "'>" . $row['college_name'] . '</option>'; ?>
<?php
}
}
?>
</select>
</td>
</tr>
<?php
if (mysqli_num_rows($result2) > 0) {
?>
<tr>
<td align='right'>
<b>ทักษะ ฯ ที่ต้องการลงทะเบียน : </b>
</td>
<td>
<select name='tacsa_id'>
<option value=''>โปรดเลือก</option>
<?php while($row = mysqli_fetch_assoc($result2)) { ?>
<?php echo "<option value='" . $row['tacsa_id'] . "'>" . $row['tacsa_name'] . '</option>'; ?>
<?php
}
}
?>
</select>
</td>
</tr>
<?php
if (mysqli_num_rows($result3) > 0) {
?>
<tr>
<td align='right'>
<b>เข้าแข่งขันในระดับ : </b>
</td>
<td>
<select name='level_id' onChange='this.form.submit()'>
<option value=''>โปรดเลือก</option>
<?php while($row = mysqli_fetch_assoc($result3)) { ?>
<?php echo "<option value='" . $row['level_id'] . "'>" . $row['level_name'] . '</option>'; ?>
<?php
}
} else {
echo '0 results';
}
$conn->close();
?>
</select>
</td>
</tr>
</table>
</center>
</form>
<?php
if ($_POST['college_id'] <> '') {
// Create connection
require('config.php');
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
mysqli_set_charset($conn,"utf8");
$sql4 = "SELECT * FROM college WHERE college.college_id = '" . $_POST['college_id'] . "'";
$result4 = mysqli_query($conn, $sql4);
if (mysqli_num_rows($result4) > 0) {
// output data of each row
while($row = mysqli_fetch_assoc($result4)) {
$college_name = $row['college_name'];
}
} else {
echo "0 results";
}
mysqli_close($conn);
}
?>
<?php
if ($_POST['tacsa_id'] <> '') {
// Create connection
require('config.php');
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
mysqli_set_charset($conn,"utf8");
$sql5 = "SELECT * FROM tacsa_name WHERE tacsa_id = '" . $_POST['tacsa_id'] . "'";
$result5 = mysqli_query($conn, $sql5);
if (mysqli_num_rows($result5) > 0) {
// output data of each row
while($row = mysqli_fetch_assoc($result5)) {
$tacsa_name = $row['tacsa_name'];
}
} else {
echo "0 results";
}
mysqli_close($conn);
}
?>
<?php
if ($_POST['level_id'] <> '') {
// Create connection
require('config.php');
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
mysqli_set_charset($conn,"utf8");
$sql6 = "SELECT * FROM tacsa_level WHERE level_id = '" . $_POST['level_id'] . "'";
$result6 = mysqli_query($conn, $sql6);
if (mysqli_num_rows($result6) > 0) {
// output data of each row
while($row = mysqli_fetch_assoc($result6)) {
$level_name = $row['level_name'];
}
} else {
echo "0 results";
}
mysqli_close($conn);
}
?>
<?php
if ($_POST['college_id'] <> '' And $_POST['tacsa_id'] <> '' And $_POST['level_id'] <> '') {
$college_id = $_POST['college_id'];
$tacsa_id = $_POST['tacsa_id'];
$level_id = $_POST['level_id'];
// Create connection
require('config.php');
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
mysqli_set_charset($conn,"utf8");
$sql7 = "SELECT college.college_id, college.college_name, tacsa_name.tacsa_id, tacsa_name.tacsa_name, tacsa_level.level_id, tacsa_level.level_name, tacsa_position.position_id, tacsa_position.position_name, tacsa.order_id, tacsa.tname, tacsa.fname, tacsa.lname, tacsa.polo_size, tacsa.amount, tacsa.phone FROM college, tacsa_name, tacsa_level, tacsa_position, tacsa WHERE tacsa.college_id = college.college_id AND tacsa.tacsa_id = tacsa_name.tacsa_id AND tacsa.level = tacsa_level.level_id AND tacsa.position_id = tacsa_position.position_id AND tacsa.college_id = '" . $_POST['college_id'] . "' AND tacsa.tacsa_id = '" . $_POST['tacsa_id'] . "' AND tacsa.level = '" . $_POST['level_id'] . "'";
$result7 = mysqli_query($conn, $sql7);
if (mysqli_num_rows($result7) > 0) {
while($row = mysqli_fetch_assoc($result7)) {
$college_name = $row['college_name'];
$tacsa_name = $row['tacsa_name'];
$level_name = $row['level_name'];
$position_id[] = $row['position_id'];
$position_name[] = $row['position_name'];
$order_id[] = $row['order_id'];
$tname[] = $row['tname'];
$fname[] = $row['fname'];
$lname[] = $row['lname'];
$polo_size[] = $row['polo_size'];
$phone = $row['phone'];
$amount[] = $row['amount'];
$i = $i + 1;
}
} else {
echo "0 results";
}
}
?>
<br>
<br>
<?php
if ($_POST['college_id'] <> '' and $_POST['tacsa_id'] <> '' and $_POST['level_id'] <> '') {
?>
<center>
<table border='1' width='90%' cellpadding='0' cellspacing='0' style='border-collapse:collapse;'>
<tr>
<th colspan='3'>ส่วนที่ 2 ป้อนรายละเอียดการสมัคร</th>
</tr>
<tr>
<th colspan='3'>ชื่อวิทยาลัย : <?php if ($college_id <> '') { echo $college_name; } ?></th>
</tr>
<form name='form2' method='post' action='save_edit_register2.php'>
<tr>
<th colspan='3'>ทักษะที่ต้องการสมัคร : <?php if ($tacsa_id <> '') { echo $tacsa_name; } ?> ระดับ : <?php if ($level_id <> '') { echo $level_name; } ?>
</th>
</tr>
<tr>
<th>ลำดับที่</th>
<th>ตำแหน่งของผู้สมัคร</th>
<th>ชื่อ - สกุล</th>
</tr>
<tr>
<input type='hidden' name='college_id' value="<?php echo $college_id; ?>">
<input type='hidden' name='tacsa_id' value="<?php echo $tacsa_id; ?>">
<input type='hidden' name='level_id' value="<?php echo $level_id; ?>">
<input type='hidden' name='count_member' value="<?php echo $i; ?>">
<td align='center'>1</td>
<input type='hidden' name='order_id1' value="<?php if ($i >= 1) { echo $order_id[0]; } ?>">
<td align='center'>โปรดเลือก : <select name="position_id1">
<option value='<?php if ($i >= 1) { echo $position_id[0]; } ?>'><?php if ($i >= 1) { echo $position_name[0]; } ?></option>
<option value="">-------------</option>
<option value="1">ครูผู้ควบคุมการแข่งขัน</option>
<option value="2">ผู้แข่งขัน</option>
</select></td>
<td align='center'>คำนำหน้า : <input type='text' name='tname1' size='10' value='<?php if ($i >= 1) { echo $tname[0]; } ?>'> ชื่อ : <input type='text' name='fname1' value='<?php if ($i >= 1) { echo $fname[0]; } ?>'> สกุล : <input type='text' name='lname1' value='<?php if ($i >= 1) { echo $lname[0]; } ?>'> ไซต์เสื้อ : <select name='polo_size1'>
<option value='<?php if ($i >= 1) { echo $polo_size[0]; } ?>'><?php if ($i >= 1) { echo $polo_size[0]; } ?></option>
<option value='--'>--</option>
<option value='SS'>SS</option>
<option value='S'>S</option>
<option value='M'>M</option>
<option value='L'>L</option>
<option value='XL'>XL</option>
<option value='2XL'>2XL</option>
<option value='3XL'>3XL</option>
<option value='4XL'>4XL</option>
</select></td>
</tr>
<tr>
<td align='center'>2</td>
<input type='hidden' name='order_id2' value="<?php if ($i >= 2) { echo $order_id[1]; } ?>">
<td align='center'>โปรดเลือก : <select name="position_id2">
<option value='<?php if ($i >= 2) { echo $position_id[1]; } ?>'><?php if ($i >= 2) { echo $position_name[1]; } ?></option>
<option value="">-------------</option>
<option value="1">ครูผู้ควบคุมการแข่งขัน</option>
<option value="2">ผู้แข่งขัน</option>
</select></td>
<td align='center'>คำนำหน้า : <input type='text' name='tname2' size='10' value='<?php if ($i >= 2) { echo $tname[1]; } ?>'> ชื่อ : <input type='text' name='fname2' value='<?php if ($i >= 2) { echo $fname[1]; } ?>'> สกุล : <input type='text' name='lname2' value='<?php if ($i >= 2) { echo $lname[1]; } ?>'> ไซต์เสื้อ : <select name='polo_size2'>
<option value='<?php if ($i >= 2) { echo $polo_size[1]; } ?>'><?php if ($i >= 2) { echo $polo_size[1]; } ?></option>
<option value='--'>--</option>
<option value='SS'>SS</option>
<option value='S'>S</option>
<option value='M'>M</option>
<option value='L'>L</option>
<option value='XL'>XL</option>
<option value='2XL'>2XL</option>
<option value='3XL'>3XL</option>
<option value='4XL'>4XL</option>
</select></td>
</tr>
<tr>
<td align='center'>3</td>
<input type='hidden' name='order_id3' value="<?php if ($i >= 3) { echo $order_id[2]; } ?>">
<td align='center'>โปรดเลือก : <select name="position_id3">
<option value='<?php if ($i >= 3) { echo $position_id[2]; } ?>'><?php if ($i >= 3) { echo $position_name[2]; } ?></option>
<option value="">-------------</option>
<option value="1">ครูผู้ควบคุมการแข่งขัน</option>
<option value="2">ผู้แข่งขัน</option>
</select></td>
<td align='center'>คำนำหน้า : <input type='text' name='tname3' size='10' value='<?php if ($i >= 3) { echo $tname[2]; } ?>'> ชื่อ : <input type='text' name='fname3' value='<?php if ($i >= 3) { echo $fname[2]; } ?>'> สกุล : <input type='text' name='lname3' value='<?php if ($i >= 3) { echo $lname[2]; } ?>'> ไซต์เสื้อ : <select name='polo_size3'>
<option value='<?php if ($i >= 3) { echo $polo_size[2]; } ?>'><?php if ($i >= 3) { echo $polo_size[2]; } ?></option>
<option value='--'>--</option>
<option value='SS'>SS</option>
<option value='S'>S</option>
<option value='M'>M</option>
<option value='L'>L</option>
<option value='XL'>XL</option>
<option value='2XL'>2XL</option>
<option value='3XL'>3XL</option>
<option value='4XL'>4XL</option>
</select></td>
</tr>
<tr>
<td align='center'>4</td>
<input type='hidden' name='order_id4' value="<?php if ($i >= 4) { echo $order_id[3]; } ?>">
<td align='center'>โปรดเลือก : <select name="position_id4">
<option value='<?php if ($i >= 4) { echo $position_id[3]; } ?>'><?php if ($i >= 4) { echo $position_name[3]; } ?></option>
<option value="">-------------</option>
<option value="1">ครูผู้ควบคุมการแข่งขัน</option>
<option value="2">ผู้แข่งขัน</option>
</select></td>
<td align='center'>คำนำหน้า : <input type='text' name='tname4' size='10' value='<?php if ($i >= 4) { echo $tname[3]; } ?>'> ชื่อ : <input type='text' name='fname4' value='<?php if ($i >= 4) { echo $fname[3]; } ?>'> สกุล : <input type='text' name='lname4' value='<?php if ($i >= 4) { echo $lname[3]; } ?>'> ไซต์เสื้อ : <select name='polo_size4'>
<option value='<?php if ($i >= 4) { echo $polo_size[3]; } ?>'><?php if ($i >= 4) { echo $polo_size[3]; } ?></option>
<option value='--'>--</option>
<option value='SS'>SS</option>
<option value='S'>S</option>
<option value='M'>M</option>
<option value='L'>L</option>
<option value='XL'>XL</option>
<option value='2XL'>2XL</option>
<option value='3XL'>3XL</option>
<option value='4XL'>4XL</option>
</select></td>
</tr>
<tr>
<td align='center'>5</td>
<input type='hidden' name='order_id5' value="<?php if ($i >= 5) { echo $order_id[4]; } ?>">
<td align='center'>โปรดเลือก : <select name="position_id5">
<option value='<?php if ($i >= 5) { echo $position_id[4]; } ?>'><?php if ($i >= 5) { echo $position_name[4]; } ?></option>
<option value="">-------------</option>
<option value="1">ครูผู้ควบคุมการแข่งขัน</option>
<option value="2">ผู้แข่งขัน</option>
</select></td>
<td align='center'>คำนำหน้า : <input type='text' name='tname5' size='10' value='<?php if ($i >= 5) { echo $tname[4]; } ?>'> ชื่อ : <input type='text' name='fname5' value='<?php if ($i >= 5) { echo $fname[4]; } ?>'> สกุล : <input type='text' name='lname5' value='<?php if ($i >= 5) { echo $lname[4]; } ?>'> ไซต์เสื้อ : <select name='polo_size5'>
<option value='<?php if ($i >= 5) { echo $polo_size[4]; } ?>'><?php if ($i >= 5) { echo $polo_size[4]; } ?></option>
<option value='--'>--</option>
<option value='SS'>SS</option>
<option value='S'>S</option>
<option value='M'>M</option>
<option value='L'>L</option>
<option value='XL'>XL</option>
<option value='2XL'>2XL</option>
<option value='3XL'>3XL</option>
<option value='4XL'>4XL</option>
</select></td>
</tr>
<tr>
<td align='center'>6</td>
<input type='hidden' name='order_id6' value="<?php if ($i >= 6) { echo $order_id[5]; } ?>">
<td align='center'>โปรดเลือก : <select name="position_id6">
<option value='<?php if ($i >= 6) { echo $position_id[5]; } ?>'><?php if ($i >= 6) { echo $position_name[5]; } ?></option>
<option value="">-------------</option>
<option value="1">ครูผู้ควบคุมการแข่งขัน</option>
<option value="2">ผู้แข่งขัน</option>
</select></td>
<td align='center'>คำนำหน้า : <input type='text' name='tname6' size='10' value='<?php if ($i >= 6) { echo $tname[5]; } ?>'> ชื่อ : <input type='text' name='fname6' value='<?php if ($i >= 6) { echo $fname[5]; } ?>'> สกุล : <input type='text' name='lname6' value='<?php if ($i >= 6) { echo $lname[5]; } ?>'> ไซต์เสื้อ : <select name='polo_size6'>
<option value='<?php if ($i >= 6) { echo $polo_size[5]; } ?>'><?php if ($i >= 6) { echo $polo_size[5]; } ?></option>
<option value='--'>--</option>
<option value='SS'>SS</option>
<option value='S'>S</option>
<option value='M'>M</option>
<option value='L'>L</option>
<option value='XL'>XL</option>
<option value='2XL'>2XL</option>
<option value='3XL'>3XL</option>
<option value='4XL'>4XL</option>
</select></td>
</tr>
<tr>
<td align='center'>7</td>
<input type='hidden' name='order_id7' value="<?php if ($i >= 7) { echo $order_id[6]; } ?>">
<td align='center'>โปรดเลือก : <select name="position_id7">
<option value='<?php if ($i >= 7) { echo $position_id[6]; } ?>'><?php if ($i >= 7) { echo $position_name[6]; } ?></option>
<option value="">-------------</option>
<option value="1">ครูผู้ควบคุมการแข่งขัน</option>
<option value="2">ผู้แข่งขัน</option>
</select></td>
<td align='center'>คำนำหน้า : <input type='text' name='tname7' size='10' value='<?php if ($i >= 7) { echo $tname[6]; } ?>'> ชื่อ : <input type='text' name='fname7' value='<?php if ($i >= 7) { echo $fname[6]; } ?>'> สกุล : <input type='text' name='lname7' value='<?php if ($i >= 7) { echo $lname[6]; } ?>'> ไซต์เสื้อ : <select name='polo_size7'>
<option value='<?php if ($i >= 7) { echo $polo_size[6]; } ?>'><?php if ($i >= 7) { echo $polo_size[6]; } ?></option>
<option value='--'>--</option>
<option value='SS'>SS</option>
<option value='S'>S</option>
<option value='M'>M</option>
<option value='L'>L</option>
<option value='XL'>XL</option>
<option value='2XL'>2XL</option>
<option value='3XL'>3XL</option>
<option value='4XL'>4XL</option>
</select></td>
</tr>
<tr>
<td align='center'>8</td>
<input type='hidden' name='order_id8' value="<?php if ($i >= 8) { echo $order_id[7]; } ?>">
<td align='center'>โปรดเลือก : <select name="position_id8">
<option value='<?php if ($i >= 8) { echo $position_id[7]; } ?>'><?php if ($i >= 8) { echo $position_name[7]; } ?></option>
<option value="">-------------</option>
<option value="1">ครูผู้ควบคุมการแข่งขัน</option>
<option value="2">ผู้แข่งขัน</option>
</select></td>
<td align='center'>คำนำหน้า : <input type='text' name='tname8' size='10' value='<?php if ($i >= 8) { echo $tname[7]; } ?>'> ชื่อ : <input type='text' name='fname8' value='<?php if ($i >= 8) { echo $fname[7]; } ?>'> สกุล : <input type='text' name='lname8' value='<?php if ($i >= 8) { echo $lname[7]; } ?>'> ไซต์เสื้อ : <select name='polo_size8'>
<option value='<?php if ($i >= 8) { echo $polo_size[7]; } ?>'><?php if ($i >= 8) { echo $polo_size[7]; } ?></option>
<option value='--'>--</option>
<option value='SS'>SS</option>
<option value='S'>S</option>
<option value='M'>M</option>
<option value='L'>L</option>
<option value='XL'>XL</option>
<option value='2XL'>2XL</option>
<option value='3XL'>3XL</option>
<option value='4XL'>4XL</option>
</select></td>
</tr>
<tr>
<th colspan='3'>เบอร์โทรศัพท์สำหรับใช้ประสานงาน : <input type='text' name='phone' value='<?php echo $phone; ?>'></th>
</tr>
<tr>
<th colspan='3'><input type='submit'> <input type='reset'></th>
</tr>
</table>
</center>
</form>
<br>
<br>
<center>
<b>ไม่จำเป็นต้องกรอกครบทั้ง 8 คน เนื่องจากแต่ละทักษะมีการกำหนดจำนวนผู้ควบคุม และจำนวนผู้แข่งขันไว้แล้ว</b>
</center>
<br>
<?php
}
?>
<br>
<center>
<a href="./viewregister2.php">ตรวจสอบข้อมูลที่เคยป้อนไปแล้ว</a> | <a href="editregister2.php">แก้ไขข้อมูลที่เคยป้อนไปแล้ว</a>
</center>
</body>
</html>