RE: Johnh
| From: | sun99_c | Date: | Fri, 27 Oct 2000 03:07:36 +0000 |
| Subject: | RE: Johnh | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-3982@lists.php.net to get a copy of this message | ||
//in ainclude file include
/*
$username="ndb";
$password="ndb";
$servername="ndb";
$EnvavlutionOracle="ORACLE_HOME=/usr/local/oracle/OraHome1";
*/
putenv($EnvavlutionOracle);
$gConn=ocilogon( $username,$password, $servername);
if($gConn==false)
{
Header("Location:./error.php?errorcode=11&backvalue=0");
exit;
}
$stmt = OCIParse($gConn,"BEGIN
Pro_ShowAD(0,'__NDB',9,:v_ADID,:v_fileName,:v_URL,:v_alttext,:v_error,:v_text,:v_text1);
END;");
if($stmt==false)
{
Header("Location:./error.php?errorcode=13&backvalue=0");
exit;
}
OCIBindByName($stmt,":v_ADID",&$v_ADID,10);
OCIBindByName($stmt,":v_fileName",&$v_fileName,10);
OCIBindByName($stmt,":v_URL",&$v_URL,64);
OCIBindByName($stmt,":v_alttext",&$v_alt,60);
OCIBindByName($stmt,":v_error",&$v_error,10);
OCIBindByName($stmt,":v_text",&$v_showtext1,1024);
OCIBindByName($stmt,":v_text1",&$v_showtext2,1024);
$result=OCIExecute($stmt);
if($result==false)
{
Header("Location:./error.php?errorcode=14&backvalue=0");
exit;
}
OCICommit($gConn);
OCILogoff($gConn);
**************************************
you had better install oracle server not only client in your web server
______________________________________
===================================================================
ÐÂÀËÃâ·Ñµç×ÓÓÊÏä http://mail.sina.com.cn
ÐÂÀËÍƳö°ÂÔ˶ÌÐÅÏ¢ÊÖ»úµã²¥·þÎñ
http://sms.sina.com.cn/