|
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/labor/ |
Upload File : |
<?php
session_start();
set_time_limit(0);
include_once("../../config/config_epm.inc.php");
include_once("manage_user.inc.php");
header("Content-Type: text/html; charset=windows-874");
if($_GET['id']){
$strSQL = "SELECT *
FROM labor_master_company
WHERE company_taxid = '".$_GET['id']."'
";
$rsConn = mysql_db_query($dbname,$strSQL);
$Row = mysql_fetch_assoc($rsConn);
$sqlCOLUMNS_1=" SELECT
`COLUMNS`.COLUMN_NAME,
`COLUMNS`.COLUMN_COMMENT
FROM COLUMNS
WHERE `COLUMNS`.TABLE_NAME = 'labor_master_company' AND `COLUMNS`.TABLE_SCHEMA = 'pathumthani_integration' ";
$rsCOLUMNS_1=mysql_db_query("information_schema",$sqlCOLUMNS_1);
$str='';
while($resCOLUMNS_1=mysql_fetch_assoc($rsCOLUMNS_1)){
if($resCOLUMNS_1['COLUMN_NAME']!='d_zipcode' && $resCOLUMNS_1['COLUMN_NAME']!='date_add' && $resCOLUMNS_1['COLUMN_NAME']!='user_add' && $resCOLUMNS_1['COLUMN_NAME']!='date_update' && $resCOLUMNS_1['COLUMN_NAME']!='user_update'){
$str.=$Row[$resCOLUMNS_1['COLUMN_NAME']].':';
}
}
$str=substr($str,0,strlen($str)-1);
}
echo $str;
/*if ( $_GET['IDCard'] ) {
$IDCard = str_replace("-", "", $_GET['IDCard']);
$strSQL = "SELECT
`id_card`,
`prename`,
`fname`,
`lname`
FROM labor_personal
WHERE id_card = '".$IDCard."'
"; #echo $strSQL;
$rsConn = mysql_query($strSQL);
$Row = mysql_num_rows($rsConn);
if ( $Row > 0 ) {
$Obj = mysql_fetch_object($rsConn);
echo "$Obj->id_card,$Obj->prename,$Obj->fname,$Obj->lname";
} else {
echo ",,,";
}
}*/
?>