|
Server : Apache/2.2.2 (Fedora) System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686 User : apache ( 48) PHP Version : 5.2.9 Disable Function : NONE Directory : /var/www/html/warroom/ |
Upload File : |
<?
#
# ตรวจสอบ คนเข้า-ออก
#
#
#
#
include "db.inc.php";
/*
MYSQL_CONNECT('sapphire01', 'root', 'sapphire') OR DIE("Unable to connect to database ");
@mysql_select_db('immigrant_57') or die( "Unable to select database");
$iresult = mysql_query("SET character_set_results=tis-620");
$iresult = mysql_query("SET NAMES TIS620");
*/
echo "<?xml version=\"1.0\" encoding=\"tis-620\" ?>";
/*
echo "<imgfile>";
$dir = @opendir("incoming_images") ;
while($file= @readdir($dir)){
if (($file != ".") AND ($file != "..") AND($file != "Thumbs.db")AND($file != "backup")){
if($_GET[id]<substr($file,0,-4)){
echo "<img src=\"incoming_images/$file\"/>";
}
}
}
echo "</imgfile>";
*/
$mm = array('','มกราคม','กุมภาพันธ์','มีนาคม','เมษายน','พฤษภาคม','มิถุนายน','กรกฎาคม','สิงหาคม','กันยายน','ตุลาคม','พฤศจิกายน','ธันวาคม');
echo "<imgfile>";
if(!$_GET[id] or $_GET[id]==''){
$sql = "select id,regdate,gender from tbl_personal_picture where (regdate != '' or regdate is not NULL) and terminal_id='$_GET[tm]' order by id DESC limit 1";
//test
//$sql = "select id,regdate from tbl_personal_picture where id > '0' order by id limit 5";
//---
}else{
$sql = "select id,regdate,gender from tbl_personal_picture where id > '$_GET[id]' and (regdate != '' or regdate is not NULL) and terminal_id='$_GET[tm]' order by id limit 5";
}
//echo $sql;
$genderarr = array('','ชาย','หญิง');
$rs = mysql_query($sql);
while($ar=mysql_fetch_assoc($rs)){
$date = intval(substr($ar[regdate],9,2)).'/'.intval(substr($ar[regdate],5,2)).'/'.(substr($ar[regdate],0,4)+543).' '.substr($ar[regdate],11,8);
echo "<img id=\"$ar[id]\" src=\"showpic.php?id=$ar[id]\" date=\"$date\" gender=\"".intval($ar[gender])."\"/>";
}
echo "</imgfile>";
?>