[PHP-DB] question about

2001-05-21 Thread Michael Cheung 

Hi;
I use the following lines to get a result from database;
But It give me result 0, it is incorrect;

$sql="Select count(*) From member where email=:email";
$sth=OCIParse($dbh,$sql);
OCIBindByName($sth,"email",$email,64);
OCIExecute($sth);
OCIFetchInto($sth,$data);

but when I directly use the $email in sql, without OCIBindByName, like the
following, it give me result 5, it is correct.

$sql="Select count(*) From member where email='$email'";
$sth=OCIParse($dbh,$sql);
OCIExecute($sth);
OCIFetchInto($sth,$data);

email is char(64) in database.

where is the problem?

Thanks in advance.

Regards;
Michael


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] question about OCIBindByName(add some comment)

2001-05-21 Thread Michael Cheung 

Hi;
Linux 2.2.18 + oracle 8.1.7i + php-4.0.5 + oci8 interface.

I use the following lines to get a result from database;
But It give me result 0, it is incorrect;

$sql="Select count(*) From member where email=:email";
$sth=OCIParse($dbh,$sql);
OCIBindByName($sth,"email",$email,64);
// with or without ':' is same, and use reference or not is also same here.
OCIExecute($sth);
OCIFetchInto($sth,$data);

but when I directly use the $email in sql, without OCIBindByName, like the
following, it give me result 5, it is correct.

$sql="Select count(*) From member where email='$email'";
$sth=OCIParse($dbh,$sql);
OCIExecute($sth);
OCIFetchInto($sth,$data);

email is char(64) in database.

where is the problem?

Thanks in advance.

Regards;
Michael


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re[2]: [PHP-DB] question about OCIBindByName(add some comment)

2001-05-21 Thread Michael Cheung 


On Mon, 21 May 2001 16:39:05 +0200
"Thies C. Arntzen" <[EMAIL PROTECTED]> wrote:

> On Mon, May 21, 2001 at 11:35:36PM +0900, Michael Cheung wrote:
> > Hi;
> > Linux 2.2.18 + oracle 8.1.7i + php-4.0.5 + oci8 interface.
> > 
> > I use the following lines to get a result from database;
> > But It give me result 0, it is incorrect;
> > 
> > $sql="Select count(*) From member where email=:email";
> > $sth=OCIParse($dbh,$sql);
> > OCIBindByName($sth,"email",$email,64);
> > // with or without ':' is same, and use reference or not is also same here.
> > OCIExecute($sth);
> > OCIFetchInto($sth,$data);
> 
> have you set $email in your script (before OCIExecute)?

I have set the $email before OCIParse().

Is there any problem about the varchar2 data type in bind operation?

Regards;
Michael


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] about "PHP Warning: failed to rollback outstanding transactions!"

2001-05-22 Thread Michael Cheung 

Hi;

Linux 2.2.18 + oracle 8.1.7i + php 4.0.5 + oci8
I got a warning in log file.
"PHP Warning:  failed to rollback outstanding transactions!"

I have simplify the script.
it will cause the warning.

function ShowError($errormsg,$dbh=false)
{
if($dbh!=false) OCILogOff($dbh);
exit();
}

$dbh=OCILogon("weboracle","cyber","");
ShowError("Login Error",$dbh);


Regards;
Michael


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re[2]: [PHP-DB] question about OCIBindByName(Resolved)

2001-05-22 Thread Michael Cheung 

Thanks for all the reply.

I have resolve the problem by specified the bind type to 96(SLQT_AFC).
By explore the source, the default has been set to (SQLT_CHR).
as my data type is char(64), so I have to set it to 96, to get the correct
result.

modified source:
$sql="Select count(*) From member where email=:email";
$sth=OCIParse($dbh,$sql);
OCIBindByName($sth,"email",$email,64,96);
// ^^ change here  
OCIExecute($sth);
OCIFetchInto($sth,$data);

Thanks.

Regards;
Michael


On Tue, 22 May 2001 17:39:03 +0200
"Thies C. Arntzen" <[EMAIL PROTECTED]> wrote:

> On Tue, May 22, 2001 at 09:41:25AM +0900, Michael Cheung wrote:
> > 
> > On Mon, 21 May 2001 16:39:05 +0200
> > "Thies C. Arntzen" <[EMAIL PROTECTED]> wrote:
> > 
> > > On Mon, May 21, 2001 at 11:35:36PM +0900, Michael Cheung wrote:
> > > > Hi;
> > > > Linux 2.2.18 + oracle 8.1.7i + php-4.0.5 + oci8 interface.
> > > > 
> > > > I use the following lines to get a result from database;
> > > > But It give me result 0, it is incorrect;
> > > > 
> > > > $sql="Select count(*) From member where email=:email";
> > > > $sth=OCIParse($dbh,$sql);
> > > > OCIBindByName($sth,"email",$email,64);
> > > > // with or without ':' is same, and use reference or not is also same here.
> > > > OCIExecute($sth);
> > > > OCIFetchInto($sth,$data);
> > > 
> > > have you set $email in your script (before OCIExecute)?
> > 
> > I have set the $email before OCIParse().
> > 
> > Is there any problem about the varchar2 data type in bind operation?
> 
> it works for me - could you send me a _short_ but complete
> testcase that reproduces your problem?
> 
> tc
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 
> 



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] about "PHP Warning: failed to rollback outstanding transactions!"

2001-07-05 Thread Michael Cheung 

Hi;

Linux 2.2.18 + oracle 8.1.7i + php 4.0.5 + oci8
I got a warning in log file.
"PHP Warning:  failed to rollback outstanding transactions!"

I have simplify the script.
it will cause the warning.

function ShowError($errormsg,$dbh=false)
{
if($dbh!=false) OCILogOff($dbh);
exit();
}

$dbh=OCILogon("weboracle","cyber","");
ShowError("Login Error",$dbh);


Regards;
Michael


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]