24 lines
817 B
PHP
24 lines
817 B
PHP
<?php
|
|
require_once("config/db.php");
|
|
$hn = base64_decode("MDAwNTk2OQ==");
|
|
$vdate = base64_decode("MjAyNi0wNi0xOQ==");
|
|
$nn = base64_decode("NjkwNjE5MDAwMTMy");
|
|
|
|
echo "hn=$hn, vdate=$vdate, nn=$nn\n";
|
|
|
|
$sql4 = "select b.*, a.vstdate, a.vsttime, a.vn as a_vn from ovst a left outer join opdscreen b on a.vn=b.vn where a.hn='$hn' and (a.vn='$nn' or a.an='$nn')";
|
|
$result4 = mysqli_query($conn1, $sql4);
|
|
if (!$result4) {
|
|
echo "Query Error: " . mysqli_error($conn1) . "\n";
|
|
} else {
|
|
$row4 = mysqli_fetch_array($result4);
|
|
echo "Rows: " . mysqli_num_rows($result4) . "\n";
|
|
if ($row4) {
|
|
echo "vn1: " . $row4['a_vn'] . "\n";
|
|
echo "vsign: " . $row4['temperature'] . "\n";
|
|
} else {
|
|
echo "row4 is false. This means no match for a.hn='$hn' and (a.vn='$nn' or a.an='$nn').\n";
|
|
}
|
|
}
|
|
?>
|