| 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/car/ |
Upload File : |
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link href="css/style.css" rel='stylesheet' type='text/css' />
<title>พิมพ์บัตรเข้า-ออกวิทยาลัยเทคนิคระยอง</title>
</head>
<body>
<?php
if ($_POST['carid'] <> '' && $_POST['officename'] <> '' ) {
// Create connection
$conn = mysqli_connect('localhost', 'technicray_root', 'JoeMan99', 'technicray_car');
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
mysqli_set_charset($conn,"utf8");
$sql1 = "INSERT INTO carpass (carid, officename, datetime) VALUES ('" . $_POST['carid'] . "', '" . $_POST['officename'] . "', Now())";
//echo $sql1;
if (mysqli_query($conn, $sql1)) {
echo "<div align=center><br><br><h1>บันทึกข้อมูลเรียบร้อยแล้ว</h1></div>";
} else {
echo "Error: " . $sql1 . "<br>" . mysqli_error($conn);
}
$sql2 = "SELECT * FROM carpass WHERE carid = '" . $_POST['carid'] . "'";
$result = mysqli_query($conn, $sql2);
if (mysqli_num_rows($result) > 0) {
// output data of each row
while($row = mysqli_fetch_assoc($result)) {
$number = $row["carpassid"];
}
} else {
echo "0 results";
}
mysqli_close($conn);
echo "<br><br><br>";
}
require('./fpdf/fpdf.php');
$pdf=new FPDF();
$pdf->AddPage();
$pdf->AddFont('THSarabun','','THSarabun.php');
$pdf->AddFont('THSarabun','b','THSarabun Bold.php');
$pdf->AddFont('THSarabun','i','THSarabun Italic.php');
$pdf->AddFont('THSarabun','bi','THSarabun BoldItalic.php');
$pdf->Image('rtccarpass.png',30,30,-300);
$pdf->SetFont('THSarabun','b',40);
$pdf->SetY(131);
//$pdf->SetX(54);
$pdf->Cell(0,0,iconv('UTF-8','cp874', $_POST['carid']), 0, 0, 'C');
$pdf->SetFont('THSarabun','b',28);
$pdf->SetY(167);
//$pdf->SetX(54);
$pdf->Cell(0,0,iconv('UTF-8','cp874', $_POST['officename']), 0, 0, 'C');
$pdf->SetFont('THSarabun','b',16);
$pdf->SetY(233);
$pdf->SetX(130);
$pdf->Cell(0,0,iconv('UTF-8','cp874', sprintf("No.%04d",$number)), 0, 0, 'C');
$report = './carreport' . $number . '.pdf';
//$pdf->Output('./carreport.pdf', 'f');
$pdf->Output($report, 'f');
?>
<div align=center>
กด <a href=<?php echo $report; ?>><img src="down-button.png"></a> เพื่อดาวน์โหลดไฟล์บัตรจอดรถ
</div>
</body>
</html>