| Server IP : 134.236.49.22 / Your IP : 216.73.216.114 Web Server : Apache/2.2.15 (Fedora) System : Linux km10.dyndns.org 2.6.31.5-127.fc12.i686.PAE #1 SMP Sat Nov 7 21:25:57 EST 2009 i686 User : apache ( 48) PHP Version : 5.3.3 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/vaccine/ |
Upload File : |
<?php
session_start();
include('dbcon02.php');
?>
<html>
<html lang="en">
<head>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="Content-Type" content="text/html;charset=utf-8" >
<title></title>
<style type="text/css">
.style2 {font-size: 16px}
</style>
</head>
<body>
<?php
mysql_query("SET character_set_results=utf8");
mysql_query("SET character_set_client=utf8");
mysql_query("SET character_set_connection=utf8");
$objDB = mysql_select_db("XLSX_DB");
$sql = "SHOW TABLES FROM XLSX_DB";
$result = mysql_query($sql);
if (!$result) {
echo "DB Error, could not list tables\n";
echo 'MySQL Error: ' . mysql_error();
exit;
}
while ($row = mysql_fetch_row($result)) {
echo "Table: {$row[0]}\n";
$strSQL = "SELECT * FROM {$row[0]} ";
$rec = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
echo $strSQL.'<br>';
while($recc = mysql_fetch_array($rec)){
echo 'ok'.$recc['B'].'<br>';
}
}
mysql_free_result($result);
/*mysql_query("SET character_set_results=utf8");
mysql_query("SET character_set_client=utf8");
mysql_query("SET character_set_connection=utf8");
$objDB = mysql_select_db("XLSX_DB");
$strSQL = "SELECT * FROM sinopharm04 ";
$rec = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
echo $strSQL.'<br>';
//echo $rec;
while($recc = mysql_fetch_array($rec)){
echo 'ok'.$recc['A'].$recc['B'].$recc['C'].'<br>';
}
/*$strSQL = "INSERT INTO register_mn";
$strSQL .="(P_ID,name_th,lastname_th";
$strSQL .=",birthdate";
$strSQL .=",sex";
$strSQL .=",addr1,moo1,province1,district1,tambol1";
$strSQL .=",tel";
$strSQL .="weight,hight,prefix,vaccine,date_time";
$strSQL .=")select";
$strSQL .="('".$_POST["P_ID"]."','".$_POST["name_th"]."','".$_POST["lastname_th"]."'";
$strSQL .=",'".$_POST["name_eng"]."','".$_POST["lastname_eng"]."','".($_POST["year"]-543)."-".$_POST["month"]."-".$_POST["date"].
"','".$_POST["age_y"]."','".$_POST["age_m"]."','".$_POST["age_d"]."'";
$strSQL .= ",'".$_POST["sex"]."','".$_POST["religion"]."','".$_POST["nation"]."','".$_POST["race"]."','".$_POST["occupa"]."'";
$strSQL .= ",'".$_POST["addr1"]."', '".$_POST["moo1"]."','".$_POST["province1"]."','".$_POST["district1"]."','".$_POST["tambol1"]."'";
$strSQL .= ",'".$_POST["tel"]."','".$_POST["goal"]."','".$_POST["name2"]."','".$_POST["relation"]."','".$_POST["addr2"]."'";
$strSQL .= ",'".$_POST["moo2"]."','".$_POST["province2"]."','".$_POST["district2"]."','".$_POST["tambol2"]."','".$_POST["name_dad"]."'";
$strSQL .= ",'".$_POST["name_mom"]."','".$_POST["name_spouse"]."','".$_POST["grp"]."','".$_POST["weight"]."','".$_POST["hight"]."','";
$strSQL .= $_POST["email"]."','".$_POST["line"]."','".$_POST["prefix"]."','".$_POST["password"]."','".$_POST["vaccine"]."','".$_POST["date_r"]."'";
if ($_POST["vaccine"]=='x'){
$strSQL .= ",'0000-00-00 00:00:00'";
} else {
if ($_POST["vaccine"]==$_SESSION['LastVac']) $strSQL .= ",'".$_SESSION['DateVac']."'";
else {
$_SESSION['DateVac']=date("Y-m-d H:i:s");
$strSQL .= ",'".date("Y-m-d H:i:s")."'";
}
}
$strSQL .= ")";
$objQuery = mysqli_query($dbq,$strSQL);
if($objQuery) {
echo '<h3><p align="center">ลงทะเบียนสำเร็จ ขอขอบคุณครับ <br>
<p align="center"><a href="รพ.ไลน์.pdf">
<strong>**คู่มือการใช้งาน**</strong></span></a></p>
<p align="center"><a href="/vaccine_19/list_vaccine_p.php">
<strong>**ตรวจสอบรายชื่อ**</strong></span></a></p>
</h3>
';
//echo '<p align="center">'.$_SESSION['date_r'].'</p>';
} else echo mysqli_error($dbq);
$_SESSION['date_time']='0000-00-00 00:00:00';
$_SESSION['LastVac']=$_POST['vaccine'];
}
}
} */
?>
</body>
</html>