Bug #5736: error when i connect to foxpro database
| From: | ssali at dr dot com | Date: | Sat, 22 Jul 2000 12:12:33 +0000 |
| Subject: | Bug #5736: error when i connect to foxpro database | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-25409@lists.php.net to get a copy of this message | ||
From: ssali@dr.com, saad@itcon4u.com
Operating system: unix/lynix
PHP version: 3.0.16
PHP Bug Type: ODBC related
Bug description: error when i connect to foxpro database
<? // LANGUAGE = asp2php converted
?>
<? $f_clientid=$HTTP_POST_VARS["f_clientid"];
$f_password=$HTTP_POST_VARS["f_password"];
// $clientsdb is of type "ADODB.connection"
$clientsdb=odbc_connect("host2.gxhosting.net","itcon007","SaadAli");
$sqlText="select * from clientlogin where clientid='".$f_clientid."'";
$userset_query=odbc_exec($clientsdb,($sqlText));
$userset_ptr=1;
$userset=odbc_fetch_row($userset_query,$userset_ptr++);
if (($userset==0))
{
header("Location: "."login.php?retry=clientid & password");
exit;
}
else
{
$real_password= trim(odbc_result($userset_query,"password"));
if ($f_password==$real_password)
{
?>
Clients Profile<br>
<? echo odbc_result($userset_query,"AC_CODE"); ?>
<? echo odbc_result($userset_query,"TEMP_CODE"); ?>
<? echo odbc_result($userset_query,"STATUS "); ?>
<? echo odbc_result($userset_query,"AGR_DATE"); ?>
<? echo odbc_result($userset_query,"AC_DESC"); ?>
<? echo odbc_result($userset_query,"CNT_PERSON"); ?>
<? echo odbc_result($userset_query,"ADDRESS1"); ?>
<? echo odbc_result($userset_query,"ADDRESS2"); ?>
<? echo odbc_result($userset_query,"ADDRESS3"); ?>
<? echo odbc_result($userset_query,"PHONES"); ?>
<? echo odbc_result($userset_query,"FAX"); ?>
<? echo odbc_result($userset_query,"E_MAIL"); ?>
<? echo odbc_result($userset_query,"DLVRY_ORDR"); ?>
<? echo odbc_result($userset_query,"PAY_MODE"); ?>
<? echo odbc_result($userset_query,"RATE"); ?>
<? echo odbc_result($userset_query,"DLVRY_DAYS"); ?>
<? echo odbc_result($userset_query,"REG_BOTTLS"); ?>
<? echo odbc_result($userset_query,"DISP_ON_DP"); ?>
<? echo odbc_result($userset_query,"DISP_SOLD"); ?>
<? echo odbc_result($userset_query,"COOLR_SOLD"); ?>
<? echo odbc_result($userset_query,"BOTT_DP_PD"); ?>
<? echo odbc_result($userset_query,"BOTT_DP_OS"); ?>
<? echo odbc_result($userset_query,"DISP_DP_PD"); ?>
<? echo odbc_result($userset_query,"DISP_DP_OS"); ?>
<? echo odbc_result($userset_query,"PASS_WORD"); ?>
<? }
else
{
header("Location: "."login.php?retry=clientid & password");
exit;
}
}
$userset_query=odbc_exec($clientsdb,($sqlText));
$userset_ptr=1;
$userset=odbc_fetch_row($userset_query,$userset_ptr++);
$userset=null;
odbc_close($clientsdb)
$clientsdb=null;
?>
<html>
</html>