| Server IP : 182.53.201.61 / Your IP : 216.73.217.175 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/queue/Connections/ |
Upload File : |
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=1;">
<title>DBF</title>
</head>
<body>
<?php
// µÔ´µÑé§ FOXPRO ODBC driver áÅéÇ Control Panel -> Administrator tools -> ODBC Data Sources(32-bits)
// ÊÃéÒ§ System DSN ª×èÍ mit à»ç¹ Free table directory àÅ×Í¡ PATH
$odbc = odbc_connect ('mitpub','', '') or die('Could Not Connect to ODBC Database!');
$strsql= "SELECT Person_id,Name,Surname FROM PERSON.DBF where Name = 'ÊØÁÔµÃ'";
//$strsql= "SELECT Person_id,Name,Surname FROM PERSON.DBF where Person_id = '3660800260707' ";
$objExec = odbc_exec($odbc, $strsql) or die (odbc_errormsg());
while(odbc_fetch_row($objExec)){
//for($i=1;$i<=odbc_num_fields($objExec);$i++){
//echo "Result is ".odbc_result($objExec,$i);
echo odbc_result($objExec,1).' '.odbc_result($objExec,2).' '.odbc_result($objExec,3).'<br>';
//$value1 = odbc_result($objExec,2);
//$value2 = odbc_result($objExec,3);
//echo odbc_result($objExec,1).' '.iconv("tis-620","utf-8",$value1).' '.iconv("tis-620","utf-8",$value2).'<br>';
}
odbc_free_result($objExec);
/*
$result = array();
while($objResult= odbc_fetch_array($objExec))
{
$result[] = $objResult;
}
odbc_close($odbc);
foreach($result as $row) {
foreach($row as $key => $value) {
echo $key . ': '. $value;
}
}
*/
$strsql= "UPDATE PERSON.DBF SET Name='ÊØÁÔµÃ' where Person_id = '3660800260707'";
$objExec = odbc_exec($odbc, $strsql) or die (odbc_errormsg());
if ($objExec) echo 'Done<br>';
else echo 'Error<br>';
odbc_free_result($objExec);
$strsql= "SELECT Person_id,Name,Surname FROM PERSON.DBF
where person_id='3660800260707' and day(Birth) = 09 AND month(Birth) = 04 AND year(Birth) = 1964 ";
$objExec = odbc_exec($odbc, $strsql) or die (odbc_errormsg());
$totalRows_chkin = odbc_num_rows($objExec);
echo $totalRows_chkin;
while(odbc_fetch_row($objExec)){
echo odbc_result($objExec,1).' '.odbc_result($objExec,2).' '.odbc_result($objExec,3).'<br>';
}
odbc_close($odbc);
?>
</body>
</html>