[PHP-DB] what version of Oracle does php_oci8.dll support?

2002-03-17 Thread Jay Glanville 

Good morning all.

I'm a relative newbie to PHP, not to mention Oracle, and I need some help
trying to get the two to talk together.

My first question is in the subject: what version of Oracle does the
php_oci8.dll library support?  8.0.x? 8.1.x? 8i?

The reason that I'm asking is because I setup a new installation of PHP (v.
4.1.2) to use Apache (v. 1.3.20) and talk to Oracle (v. 8.0.6).  (Just for
completeness, my OS is win2000, sp 2.)  If I use the php_oracle.dll,
everything works fine.  However, the moment that I include the
extension=php_oci8.dll directive in the php.ini file, I get the following
error when I start my Apache service:
The procedure entry point OCILobClose could not be located in the
dynamic link library OCI.dll

Does this mean I can't use the php_oci8.dll functionality?

Thanks.

--
Jay Dickon Glanville


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] How does mysql_fetch_array() work?

2002-03-17 Thread Glenn Holden 

In the following example, does the while loop with mysql_fetch_array() query
the server each time through the loop?  Or does it do everything, while
parsing, using $result?  Or is there some other subtlety I'm missing?  How
is this working and where is the work being done?

Thanks, Glenn.


?php
mysql_connect($host, $user, $password);
mysql_select_db(database);
$result = mysql_query(select user_id, fullname from table);
while ($row = mysql_fetch_array($result)) {
   echo user_id: .$row[user_id].br\n;
   echo user_id: .$row[0].br\n;
   echo fullname: .$row[fullname].br\n;
   echo fullname: .$row[1].br\n;
}
mysql_free_result($result);
?







-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] I can't get Oracle record structure from PHP

2002-03-17 Thread Csillag Zsolt 


Hi,


I want to call a Pl/Sql function from Php ( I'm using oci8 functions).

If the Pl/Sql function returns with VarChar2, number etc. it works perfectly.
However when I use the following record for return it doesn't work:

Type T_CegTabla IS TABLE OF VarChar2(80) INDEX BY BINARY_INTEGER;
Type T_CimTabla IS TABLE OF VarChar2(110) INDEX BY BINARY_INTEGER;

  TYPE T_CegLista_REK IS RECORD

  ( Cegnev T_CegTabla ,
Cim T_CimTabla
 );

Function DoSomething (KeresoStr Varchar2,MinRow Integer, MaxRow Integer) 
Return T_CegLista_REK ;


Is there a way in Php to workaround this?
I noticed that there isn't record structure in Php.


Thank you in advance




Zsolt Csillag,
Hungary


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] sql problem

2002-03-17 Thread its me 

i want an sql statment that select from table where prefer has the word auction or cash

i tried:
$sql=select * from products where prefer like '%cash%' ;

and it worked biut i tried:
$sql=select * from products where prefer like '%cash%'  or prefer like '%auction%'  ;

but didn't work !!!



Rehab M.Shouman





-
Express yourself with a super cool email address from BigMailBox.com.
Hundreds of choices. It's free!
http://www.bigmailbox.com
-

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] How to add 2 years to todays date ?

2002-03-17 Thread Dave Carrera 

Hi All
I think the subject line says it all.
 
How to add 2 years to today's date ?
 
Any helps as always most appreciated.
 
 
 
Dave Carrera
Php Developer
http://davecarrera.freelancers.net
http://www.davecarrera.com