| 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
// Create connection
require_once('config.php');
$i = 0;
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
mysqli_set_charset($conn,"utf8");
//$sql1 = "SELECT * FROM carpass WHERE carid = '" . $_POST['carid'] . "'";
$sql = "SELECT DISTINCT college.college_id, college.college_name, tacsa_name.tacsa_id, tacsa_name.tacsa_name FROM college, tacsa_name, tacsa_staff WHERE college.college_id = tacsa_staff.college_id AND tacsa_name.tacsa_id = tacsa_staff.tacsa_id ORDER BY college.college_id";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
// output data of each row
while($row = mysqli_fetch_assoc($result)) {
$i = $i + 1;
echo $i . ". " . "<a href=bill_other1.php?college_id=" . $row['college_id'] . "&tacsa_id=" . $row['tacsa_id'] . ">" . $row['college_name'] . " | " . $row['tacsa_name'] . " | " . $row['level_name'] . "</a>" . " | " . "<a href=polo_size_other1.php?college_id=" . $row['college_id'] . "&tacsa_id=" . $row['tacsa_id'] . ">เอกสารรับเสื้อ</a>";
echo "<br>";
}
} else {
echo "0 results";
}
mysqli_close($conn);
?>