|
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 : |
<?php
include "db.inc.php";
mysql_select_db("eoffice_master") or die("Can't select database.");
$iresult = mysql_query("SET character_set_results=tis-620");
$iresult = mysql_query("SET NAMES TIS620");
$sid = $_GET['id'];
/*
$link = mysql_connect("sapphire01", "root", "sapphire") or die("Can't connect.");
mysql_select_db("immigrant_57") or die("Can't select database.");
$iresult = mysql_query("SET character_set_results=tis-620");
$iresult = mysql_query("SET NAMES TIS620");
*/
$mm = array('','มกราคม','กุมภาพันธ์','มีนาคม','เมษายน','พฤษภาคม','มิถุนายน','กรกฎาคม','สิงหาคม','กันยายน','ตุลาคม','พฤศจิกายน','ธันวาคม');
function showxml($row){
global $mm;
$farray = array();
echo "<setdata>";
foreach($row as $key => $val ){
echo "<$key>$val</$key>";
$farray[$key] = '';
}
$age = date("Y")-substr($row[DOB],0,4);
$DOB_text = intval(substr($row[DOB],9,2)).' '.$mm[intval(substr($row[DOB],5,2))].' '.(substr($row[DOB],0,4)+543);
echo "<age>$age</age>";
echo "<DOB_text>$DOB_text</DOB_text>";
echo "<address>$row[address_no] $row[road_address] ต.$row[t_new_address] อ.$row[a_new_address] จ.$row[p_new_address]</address>";
echo "</setdata>";
}
echo "<datablacklist>";
$result = mysql_query("SELECT * FROM tbl_personal_info WHERE face_id ='$sid'");
//echo "SELECT * FROM tbl_personal_info WHERE face_id ='$sid'";
while($row = mysql_fetch_assoc($result)) {
showxml($row);
}
$result = mysql_query("SELECT * FROM tbl_face_image WHERE person_id ='$sid'");
echo "<imagebl>";
while($pic = mysql_fetch_assoc($result)) {
for($i=1;$i<6;$i++){
if($pic['pic'.$i]){
echo "<img src=\"showpic_blacklist.php?id=$id&pid=".($i-1)."\" />";
}
}
}
echo "</imagebl>";
echo "</datablacklist>";
mysql_close($link);
?>