|
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 : /home/pathumthani_integration/integration/application/Elderly_gis/ |
Upload File : |
<?php
function getAmphurTumbonName($id){
$queryName = mysql_query("SELECT ccName FROM ccaa WHERE ccDigi = '".$id."' ");
$rowsName = mysql_fetch_array($queryName);
return $rowsName['ccName'];
}
function getVillageName($id){
$query_v = mysql_query("SELECT ccName,ccMoo FROM ccaa_village WHERE ccDigi ='".$id."' ");
$rows_v = mysql_fetch_array($query_v);
return "หมู่ ".$rows_v['ccMoo']." ".$rows_v['ccName'];
}
function getDrugType( $id = "" ){
$sql = " SELECT * FROM drug_type WHERE drug_id='".$id."' ";
$query = mysql_query($sql);
$row = mysql_fetch_assoc($query);
return $row["drug_name"];
}
function getPreName( $id = "" ){
$sql = " SELECT prename_th FROM tbl_prename WHERE id='".$id."' ";
$query = mysql_query($sql);
$row = mysql_fetch_assoc($query);
return $row["prename_th"];
}
function getOccupation( $id = "" ){
$sql = " SELECT occupation FROM tbl_occupation WHERE occ_id ='".$id."' ";
$query = mysql_query($sql);
$row = mysql_fetch_assoc($query);
return $row["occupation"];
}
function TimeShot($day){
$y = substr($day,0,4);
$m = substr($day,5,2);
$d = substr($day,8,2);
$ty = (int)$y + 543;
$str = $d."/".$m."/".$ty;
echo $str;
}//end function
function swapDate($d = "", $type = "en", $tag = "-" ){
if(strpos($d, "-") === false){
$arrD = split("-", $d);
}else{
$arrD = split("-", $d);
}
$arr_position = ((strlen($arrD[2])==4)?2:0);
if($type == "en"){
$arrD[$arr_position] = $arrD[$arr_position] - ($arrD[$arr_position] > (date("Y"))?543:0);
}else{
$arrD[$arr_position] = $arrD[$arr_position] + 543;
}
$result = array_reverse($arrD);
return ((!empty($d))?implode($tag,$result):"");
}
function setPoint($id = ""){
$query_v = mysql_query("SELECT g_point FROM ccaa_village WHERE ccDigi ='".$id."' ");
$rows_v = mysql_fetch_assoc($query_v);
if($rows_v["g_point"] != ""){
return explode(",",$rows_v["g_point"]);
}else{
return false;
}
}
?>