Re: [PHP-DB] PHP 4.3.8/Oracle 9i OCI call question for BLOBs

2004-10-04 Thread Christopher Jones

[EMAIL PROTECTED] wrote:
I'm trying to write text to a BLOB.  I got a valid return code but it did not write the BLOB.  
 I was able to use similar code writing to a CLOB.  Any examples I've seen for BLOBs 
are reading
 from Binary files.  Here's how I did the CLOB, but it would not work for BLOB.  Is 
this a bug in PHP?
$query = insert into  . getSchema() . attf_description  .
(id, narticid, nordertoprint, vheadertoprint, cldescription )  . 
  values( .
   $id . ,  . $articid . ,  . $ordertoprint . ,'  . $headertoprint . ', EMPTY_CLOB()) 
   . returning CLDESCRIPTION into :CLDESCRIPTION;

 $parsed = ociparse($connection,$query);
 $clob = OCINewDescriptor($connection, OCI_D_LOB);
 $bind = OCIBindByName($parsed, $clob_name, $clob, -1, OCI_B_CLOB);
 ociexecute($parsed, OCI_DEFAULT);
  $err = $clob-save($clob_data);
  $committed = ocicommit($connection, OCI_DEFAULT);
   OCIFreeStatement( $parsed );
Thanks,
Kathy

BLOB and CLOB handling is similar.  Without knowing your failing code
I cannot tell what your problem is
There is a working BLOB example at:
  
http://forums.oracle.com/forums/thread.jsp?forum=178thread=233174message=664200q=626c6f62#664200
Chris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[PHP-DB] PHP 4.3.8/Oracle 9i OCI call question for BLOBs

2004-09-22 Thread kkoehler
I'm trying to write text to a BLOB.  I got a valid return code but it did not write 
the BLOB.  I was able to use similar code writing to a CLOB.  Any examples I've seen 
for BLOBs are reading from Binary files.  Here's how I did the CLOB, but it would not 
work for BLOB.  Is this a bug in PHP?

$query = insert into  . getSchema() . attf_description  .
(id, narticid, nordertoprint, vheadertoprint, cldescription )  . 
  values( .
   $id . ,  . $articid . ,  . $ordertoprint . ,'  . $headertoprint . ', 
EMPTY_CLOB()) 
   . returning CLDESCRIPTION into :CLDESCRIPTION;

 $parsed = ociparse($connection,$query);
 $clob = OCINewDescriptor($connection, OCI_D_LOB);
 $bind = OCIBindByName($parsed, $clob_name, $clob, -1, OCI_B_CLOB);
 ociexecute($parsed, OCI_DEFAULT);
  $err = $clob-save($clob_data);
  $committed = ocicommit($connection, OCI_DEFAULT);
   OCIFreeStatement( $parsed );

Thanks,
Kathy

[PHP-DB] PHP 4.3.8/Oracle 9i OCI call question for BLOBs

2004-09-22 Thread kkoehler
One thing I left off.  I changed the Oracle field to a BLOB, replaced OCI_B_CLOB with 
OCI_B_BLOB, the insert was successful but no data was saved to the BLOB.
Kathy

[EMAIL PROTECTED] wrote:
 I'm trying to write text to a BLOB.  I got a valid return code but it did not 
write the BLOB.  I was able to use similar code writing to a CLOB.  Any examples 
I've seen for BLOBs are reading from Binary files.  Here's how I did the CLOB, 
but it would not work for BLOB.  Is this a bug in PHP?
 
 $query = insert into  . getSchema() . attf_description  .
 (id, narticid, nordertoprint, vheadertoprint, cldescription )  . 
   values( .
$id . ,  . $articid . ,  . $ordertoprint . ,'  . $headertoprint . ', 
EMPTY_CLOB()) 
. returning CLDESCRIPTION into :CLDESCRIPTION;
 
  $parsed = ociparse($connection,$query);
  $clob = OCINewDescriptor($connection, OCI_D_LOB);
  $bind = OCIBindByName($parsed, $clob_name, $clob, -1, OCI_B_CLOB);
  ociexecute($parsed, OCI_DEFAULT);
   $err = $clob-save($clob_data);
   $committed = ocicommit($connection, OCI_DEFAULT);
OCIFreeStatement( $parsed );
 
 Thanks,
 Kathy

Re: [PHP-DB] php and oracle

2004-09-14 Thread Christopher Jones
Dieter,
Can you share some of your migration experiences?  Why did you migrate
to Oracle and what problems did you face?
Miscellaneous thoughts follow:
Regarding the error, search the bdump trace files for 3114 or other
ORA-xyz errors.  You may need to get Oracle Support involved if there
are any.
Your trace file dir seems huge.  The Administrator's guide has some
info about controlling the sizes:
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10739/manproc.htm#sthref655
Effectively you delete what you don't need.
Hopefully PHP5 will stabilize quickly.
I recall a stern warning in the PHP manual about not using Apache 2.
I can't find it currently - anyone know if it has been rescinded?
The troubleshooting FAQ mentions restarting Apache occasionally to
avoid connection problems.
(See 
http://www.oracle.com/technology/tech/opensource/php/php_troubleshooting_faq.html#conmgt)
I feel that the Oracle-PHP community needs to get together and work on
through the various connection issues.  Anyone want to participate?
Chris
D.Wilkening wrote:
Hi,
we are not really trained in analyzing Oracle-logs. I've been using Mysql
and Mssql for years, but the migration was more difficult, than I thought.
In $ORACLE_HOME/admin/%database% I have Gigabytes of logs, so do not know,
where to start...
du -sch *
1.5Gbdump
166Mcdump
28K create
8.0Kpfile
282Kudump
1.7Gtotal
well, for the apache-problem, I've found an solution (not the straight
way, but it seems to work so far):
using apache_child_terminate doesn't work (probably apache2 compiled
against nptl (linux kernel 2.6), apache_child_terminate doesn't work in an
multi-threaded env)
so I cought the php-error using set_error_handler. Inside of this
error-method, I did an posix_kill(getmypid(),15);
I know, I won't win the programmers Nobel-Prize for that crap, but it
works so far; dropped connections are reconnected.
Dieter

Christopher Jones sagte:
D.Wilkening wrote:

Hi everyone,
i've a problem using php with oracle 10g.
(php 5.0.1 compiled against Oracle 10.1.0.2-libs, apache2 and apache1)
One or two days, everything looks good. Then, by pressing (once a
second)
reload in your browser, you sometimes get an
ERROR #: 2
ERROR DESC: oci_execute() [a
href='function.oci-execute'function.oci-execute/a]: OCIStmtExecute:
ORA-03114: Nicht mit ORACLE verbunden
restarting apache solves the problem, but is no real option.
My first idea was the connection pooling, so i tried a ocilogon instead
ociPlogon, but the problem dodn't solve.
Any Ideas?
Thank you in advance
Are there any clues in the database trace files?
Chris

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


Re: [PHP-DB] php and oracle

2004-09-10 Thread D.Wilkening
Hi,

we are not really trained in analyzing Oracle-logs. I've been using Mysql
and Mssql for years, but the migration was more difficult, than I thought.
In $ORACLE_HOME/admin/%database% I have Gigabytes of logs, so do not know,
where to start...
du -sch *
1.5Gbdump
166Mcdump
28K create
8.0Kpfile
282Kudump
1.7Gtotal

well, for the apache-problem, I've found an solution (not the straight
way, but it seems to work so far):

using apache_child_terminate doesn't work (probably apache2 compiled
against nptl (linux kernel 2.6), apache_child_terminate doesn't work in an
multi-threaded env)
so I cought the php-error using set_error_handler. Inside of this
error-method, I did an posix_kill(getmypid(),15);
I know, I won't win the programmers Nobel-Prize for that crap, but it
works so far; dropped connections are reconnected.

Dieter



Christopher Jones sagte:

 D.Wilkening wrote:

 Hi everyone,

 i've a problem using php with oracle 10g.
 (php 5.0.1 compiled against Oracle 10.1.0.2-libs, apache2 and apache1)
 One or two days, everything looks good. Then, by pressing (once a
 second)
 reload in your browser, you sometimes get an
 ERROR #: 2
 ERROR DESC: oci_execute() [a
 href='function.oci-execute'function.oci-execute/a]: OCIStmtExecute:
 ORA-03114: Nicht mit ORACLE verbunden

 restarting apache solves the problem, but is no real option.
 My first idea was the connection pooling, so i tried a ocilogon instead
 ociPlogon, but the problem dodn't solve.

 Any Ideas?

 Thank you in advance


 Are there any clues in the database trace files?

 Chris


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



[PHP-DB] php and oracle

2004-09-07 Thread D.Wilkening
Hi everyone,

i've a problem using php with oracle 10g.
(php 5.0.1 compiled against Oracle 10.1.0.2-libs, apache2 and apache1)
One or two days, everything looks good. Then, by pressing (once a second)
reload in your browser, you sometimes get an
ERROR #: 2
ERROR DESC: oci_execute() [a
href='function.oci-execute'function.oci-execute/a]: OCIStmtExecute:
ORA-03114: Nicht mit ORACLE verbunden

restarting apache solves the problem, but is no real option.
My first idea was the connection pooling, so i tried a ocilogon instead
ociPlogon, but the problem dodn't solve.

Any Ideas?

Thank you in advance

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



[PHP-DB] Re: Antwort: [PHP-DB] php and oracle

2004-09-07 Thread D.Wilkening
This sounds interesting! We'll try this.

Thanks and greetings from Essen :),
Dieter

--
Dieter Wilkening
Software-Entwickler
Baumann Technologie GmbH
[EMAIL PROTECTED]


[EMAIL PROTECTED] sagte:

 I tried to compile PHP 4.3.8 with OCI  and oracle_LIB 32bit  somewhere in
 $ORACLE_HOME/../lib32
 ant it works.
 ORACLE_HOME=/oracle/app/oracle/product/9.2.0
 TNS_ADMIN=/oracle/app/oracle/product/9.2.0/network/admin
 LD_LIBRARY_PATH=$ORACLE_HOME/lib32
 NLS_LANG=german.germany.WE8895P1
 ORACLE_BASE=/oracle/app/oracle


 after ./configure you have to edit Makefile to correct the PATH to LIB to
 LIB32.
 Try it.




 Best Regards
 Jahan Ketabchy




 D.Wilkening
 [EMAIL PROTECTED]   An: [EMAIL PROTECTED]
 kening.deKopie:
   Thema:  Re: Antwort: [PHP-DB]
 php and oracle
 07.09.2004
 09:29
 Bitte antworten
 an php






 [EMAIL PROTECTED] sagte:

 Hi !
 I have the same problem with oracle 9i.
 OCI doesn't work with  Oracle_LIB  64bit kernel.

 Do you have any ideas?
 I'd say, filing a bug @ php.net would be a possible solution. There has to
 be a way for php to find out, which connection is gone and which is still
 alive.









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



Re: [PHP-DB] PHP 4.3.4 + Oracle 9i + Apache 2.0.47 ! SOLVED !

2003-11-13 Thread Daniel Sand
Hey Folks,

in first cast their where missing .h libs from the oracle installation 
but after installing them the gmake was not working correct anymore.

I cannot realy explain why. But in some case the configure shredded the 
Make files in think, because gmake tried to make .dll libs and not .so 
libs.

So i deleted all and reconfigured all again and then it worked well.



Regards Daniel

Daniel Sand wrote:
Hello,

The system is Solaris sun4u sparc SUNW,UltraAX-i2, SunOS 5.8 i'm 
compiling this with a gcc 3.3.

I'm trying to configure a PHP 4.3.4 with oracle oci8 support.

i've pushed the vars for oracle in the enviroment

ORACLE_BASE=/opt/oracle/app/oracle
export ORACLE_BASE
ORACLE_HOME=/opt/oracle/app/oracle/product/9.2
export ORACLE_HOME
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/network/lib 

export LD_LIBRARY_PATH
PATH=$PATH:$ORACLE_HOME/bin:/usr/ccs/bin:
export PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib 

export CLASSPATH
LC_LANG=de_DE
export LC_LANG
LC_ALL=de_DE
export LC_ALL
and the configure with this options run through:

./configure \
--disable-cli \
--without-pear \
--enable-sigchild \
--prefix=${APACHE_DIR}/ext/php-4.3.4 \
--with-apxs2=${APACHE_DIR}/bin/apxs \
--enable-ftp=shared \
--with-mysql=shared \
--enable-sysvsem \
--enable-sysvshm \
--with-oracle=$ORACLE_HOME \
--with-oci8=$ORACLE_HOME
when i start to make the build all runs fine till the oci8 module 
compiling, then a whole bunch off missing functions and wrong syntaxes 
in the code showing up:

/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1191: 
error: request for member `pError' in something not a structure or union
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1191: 
error: request for member `error' in something not a structure or union
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1196: 
error: invalid type argument of `-'
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1196: 
warning: passing arg 1 of `zend_list_insert' makes pointer from integer 
without a cast
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1197: 
error: invalid type argument of `-'
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1200: 
error: invalid type argument of `-'
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1202: 
warning: return makes pointer from integer without a cast
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c: 
At top level:
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1210: 
error: parse error before '*' token
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c: 
In function `_oci_get_ocicoll':
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1212: 
error: invalid operands to binary *
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1214: 
error: `id' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1218: 
error: `collection' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1218: 
error: invalid type argument of `unary *'
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1223: 
error: invalid type argument of `unary *'
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c: 
At top level:
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1234: 
error: parse error before '*' token
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c: 
In function `_oci_get_ocidesc':
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1236: 
error: `desc' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1238: 
error: `id' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1243: 
error: `descriptor' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c: 
At top level:
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1255: 
error: parse error before '*' token
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c: 
In function `_oci_make_zval':
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1258: 
error: `ub4' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1258: 
error: parse error before loblen
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1262: 
error: `column' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1267: 
error: `statement' undeclared (first use in this function)

Re: [PHP-DB] PHP 4.3.4 + Oracle 9i + Apache 2.0.47

2003-11-09 Thread Christopher Jones
I don't have this combo to test unfortunately.

It may be an include path problem.  Check the Makefile has a
valid -I path for the Oracle headers.
An unrelated issue to be aware of is http://bugs.php.net/bug.php?id=25980

Chris

Daniel Sand wrote:

Hello,

The system is Solaris sun4u sparc SUNW,UltraAX-i2, SunOS 5.8 i'm 
compiling this with a gcc 3.3.

I'm trying to configure a PHP 4.3.4 with oracle oci8 support.

i've pushed the vars for oracle in the enviroment

ORACLE_BASE=/opt/oracle/app/oracle
export ORACLE_BASE
ORACLE_HOME=/opt/oracle/app/oracle/product/9.2
export ORACLE_HOME
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/network/lib 

export LD_LIBRARY_PATH
PATH=$PATH:$ORACLE_HOME/bin:/usr/ccs/bin:
export PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib 

export CLASSPATH
LC_LANG=de_DE
export LC_LANG
LC_ALL=de_DE
export LC_ALL
and the configure with this options run through:

./configure \
--disable-cli \
--without-pear \
--enable-sigchild \
--prefix=${APACHE_DIR}/ext/php-4.3.4 \
--with-apxs2=${APACHE_DIR}/bin/apxs \
--enable-ftp=shared \
--with-mysql=shared \
--enable-sysvsem \
--enable-sysvshm \
--with-oracle=$ORACLE_HOME \
--with-oci8=$ORACLE_HOME
when i start to make the build all runs fine till the oci8 module 
compiling, then a whole bunch off missing functions and wrong syntaxes 
in the code showing up:

/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1191: 
error: request for member `pError' in something not a structure or union
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1191: 
error: request for member `error' in something not a structure or union
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1196: 
error: invalid type argument of `-'
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1196: 
warning: passing arg 1 of `zend_list_insert' makes pointer from integer 
without a cast
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1197: 
error: invalid type argument of `-'
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1200: 
error: invalid type argument of `-'
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1202: 
warning: return makes pointer from integer without a cast
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c: 
At top level:
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1210: 
error: parse error before '*' token
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c: 
In function `_oci_get_ocicoll':
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1212: 
error: invalid operands to binary *
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1214: 
error: `id' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1218: 
error: `collection' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1218: 
error: invalid type argument of `unary *'
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1223: 
error: invalid type argument of `unary *'
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c: 
At top level:
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1234: 
error: parse error before '*' token
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c: 
In function `_oci_get_ocidesc':
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1236: 
error: `desc' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1238: 
error: `id' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1243: 
error: `descriptor' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c: 
At top level:
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1255: 
error: parse error before '*' token
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c: 
In function `_oci_make_zval':
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1258: 
error: `ub4' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1258: 
error: parse error before loblen
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1262: 
error: `column' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1267: 
error: `statement' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1268: 
error: `value' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1276: 

[PHP-DB] PHP 4.3.4 + Oracle 9i + Apache 2.0.47

2003-11-07 Thread Daniel Sand
Hello,

The system is Solaris sun4u sparc SUNW,UltraAX-i2, SunOS 5.8 i'm 
compiling this with a gcc 3.3.

I'm trying to configure a PHP 4.3.4 with oracle oci8 support.

i've pushed the vars for oracle in the enviroment

ORACLE_BASE=/opt/oracle/app/oracle
export ORACLE_BASE
ORACLE_HOME=/opt/oracle/app/oracle/product/9.2
export ORACLE_HOME
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/network/lib
export LD_LIBRARY_PATH
PATH=$PATH:$ORACLE_HOME/bin:/usr/ccs/bin:
export PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib
export CLASSPATH
LC_LANG=de_DE
export LC_LANG
LC_ALL=de_DE
export LC_ALL
and the configure with this options run through:

./configure \
--disable-cli \
--without-pear \
--enable-sigchild \
--prefix=${APACHE_DIR}/ext/php-4.3.4 \
--with-apxs2=${APACHE_DIR}/bin/apxs \
--enable-ftp=shared \
--with-mysql=shared \
--enable-sysvsem \
--enable-sysvshm \
--with-oracle=$ORACLE_HOME \
--with-oci8=$ORACLE_HOME
when i start to make the build all runs fine till the oci8 module 
compiling, then a whole bunch off missing functions and wrong syntaxes 
in the code showing up:

/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1191: 
error: request for member `pError' in something not a structure or union
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1191: 
error: request for member `error' in something not a structure or union
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1196: 
error: invalid type argument of `-'
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1196: 
warning: passing arg 1 of `zend_list_insert' makes pointer from integer 
without a cast
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1197: 
error: invalid type argument of `-'
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1200: 
error: invalid type argument of `-'
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1202: 
warning: return makes pointer from integer without a cast
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c: 
At top level:
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1210: 
error: parse error before '*' token
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c: 
In function `_oci_get_ocicoll':
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1212: 
error: invalid operands to binary *
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1214: 
error: `id' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1218: 
error: `collection' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1218: 
error: invalid type argument of `unary *'
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1223: 
error: invalid type argument of `unary *'
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c: 
At top level:
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1234: 
error: parse error before '*' token
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c: 
In function `_oci_get_ocidesc':
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1236: 
error: `desc' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1238: 
error: `id' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1243: 
error: `descriptor' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c: 
At top level:
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1255: 
error: parse error before '*' token
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c: 
In function `_oci_make_zval':
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1258: 
error: `ub4' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1258: 
error: parse error before loblen
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1262: 
error: `column' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1267: 
error: `statement' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1268: 
error: `value' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1276: 
error: `SQLT_RDD' undeclared (first use in this function)
/park/pub/source/www-rom/modules/php4/build/php-4.3.4/ext/oci8/oci8.c:1276: 
error: `mode' undeclared (first use in this function)

[PHP-DB] PHP and Oracle

2003-02-17 Thread Y Al Hinai

helloo Everyone...

A new guest to the list needs your hlep!!.  I am about to start working on a project 
in which im going to use Oralce with PHP4.  I am new to PHP.  I am looking for a good 
book about working with PHP4 and Oracle to help me pick up the basics as well as get 
the depth that i am looking for.  To give you a better idea regaring depth, I'll be 
working on a Web-enabled college registration system.  Students log into a web page to 
view, choose, and register courses.  They should be able to view their time tables, 
grades, personal information ...etc.  I need help as soon as possible.  Please help.

Thanks

 



-
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day


Re: [PHP-DB] PHP and ORACLE conection error

2003-01-30 Thread Maxim Maletsky

xxx  [EMAIL PROTECTED] wrote... :

 hy,
 i'm having a problem with my project
 i have an oracle server on a computer named oracle and in apache htdocs files i have 
a directory special for my project...
 
 1 in that dir i have a html file named index.html
 here i get the username and the password and post it to the validate.php file
 
 in the validate.php file:
 the first i have is 
 ?php session_start(); 
  header(Cache-control:private); ?
 then
 
 1. i get the variables
  $name=$_POST['username'];
  $password=$_POST['pass'];
 
 2. i register the variables 
   session_register(name) and session_register(password),
 
 3. i verify if they can acces to the database 
 if( ociplogon($name,$password))
  $ok='true';
 else $ok='false';

oops... You are assigning $ok to a *string* of a readable values 'true'
or 'false'.


 4. in the body of the validate.php i have a script in order to load a new page
 
 script
 var ok=?php echo $ok; ?
 if(ok==true) 
  window.location.href=good_page.php;
 else
 window.location.href=error.php
 window.reload();
 /script

The string $ok is not empty, and thus will always evaluate as TRUE. You
need to assign it the boolean value a few lines above. Not a string.

 well
 that's it
 it works but not finei know it isn't the best way but it worked 
 till some days i have any problems but since today i don't know what is happening...
 
 sometimes it works loading the good_page but sometimes it loads the error page
 i think it is something with authentification and session but i need a solution 
quickly...i have no time to rethink all...
 
 if you have a solution or another type of making all i have made send me a reply
 thanks a lot...
 cybercop78
 
 http://www.idilis.ro - Stiri, e-mail gratuit, download,
 SMS, server de counter-strike, hosting gratuit, servicii internet...
 Fii cu un pas inaintea celorlati!




--
Maxim Maletsky
[EMAIL PROTECTED]



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




[PHP-DB] PHP and ORACLE conection error

2003-01-28 Thread xxx xxxx
hy,
i'm having a problem with my project
i have an oracle server on a computer named oracle and in apache htdocs files i have a 
directory special for my project...

1 in that dir i have a html file named index.html
here i get the username and the password and post it to the validate.php file

in the validate.php file:
the first i have is 
?php session_start(); 
 header(Cache-control:private); ?
then

1. i get the variables
 $name=$_POST['username'];
 $password=$_POST['pass'];

2. i register the variables 
  session_register(name) and session_register(password),

3. i verify if they can acces to the database 
if( ociplogon($name,$password))
 $ok='true';
else $ok='false';

4. in the body of the validate.php i have a script in order to load a new page

script
var ok=?php echo $ok; ?
if(ok==true) 
 window.location.href=good_page.php;
else
window.location.href=error.php
window.reload();
/script


well
that's it
it works but not finei know it isn't the best way but it worked 
till some days i have any problems but since today i don't know what is happening...

sometimes it works loading the good_page but sometimes it loads the error page
i think it is something with authentification and session but i need a solution 
quickly...i have no time to rethink all...

if you have a solution or another type of making all i have made send me a reply
thanks a lot...
cybercop78

http://www.idilis.ro - Stiri, e-mail gratuit, download,
SMS, server de counter-strike, hosting gratuit, servicii internet...
Fii cu un pas inaintea celorlati!


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




[PHP-DB] PHP and Oracle

2003-01-08 Thread Ha Duy Thien
Hi Everybody

Does anyone have a sample code that read each page of data from Oracle like
OLEDB in windows?

I don't want to read the whole table into my webpage, each time i only want
to read 20 rows. And list all of the remaining pages for choosing

How can I do that.

If someone has done it or has a sample code, please show me

Thanks in advance

Thien



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




[PHP-DB] PHP and Oracle 7.0

2002-07-16 Thread Chip Atkinson

Greetings,

Has anyone gotten oracle 7.0 to work with the latest php?  I'm having
trouble reliably getting anything back.

Thanks in advance,

Chip



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




[PHP-DB] PHP and Oracle

2001-12-11 Thread GEORGINA ELAINE BAILEY

Can anybody help me! I've been getting a error message like this for the last few days.

Warning: OCIStmtExecute: ORA-01722: invalid number on line 49
Array

Every time I try to enter a project using a HTML form

Line 49 in apparently the line that says:
$result = OCIExecute(ins_statement);

Below is the code I am trying to use:
//insert relevant values into the project table

$insert = insert into PROJECT values ('$projectID', '$moduleID', $keyID, '$title', 
'$originator', '$softwareHardware', '$specialSkills', '$status', '$externalAgreement', 
'$background',  '$tasks', '$steps', '$references');

 //formulate the query

$query = select projectID, moduleID, title, originator, softwareHardware, 
specialSkills, status, externalAgreement, 

background, tasks, steps, references from PROJECT WHERE 
projectID='$projectID'; 



  

//parse the two statements

$ins_statement = OCIParse ($connection, $insert);

$qry_statement = OCIParse ($connection, $query);

 



//execute the first insert statement and print error message if there is 
an error

$result = OCIExecute($ins_statement);



if (!$result)

{

echo OCIError($ins_statement).p;

exit;

}

  //execute the query statement

OCIExecute($qry_statement);

 //retrieve the results of the query statement and present them in the 
following way

while (ocifetch($qry_statement))

{ etc.etc.



[PHP-DB] php and oracle

2001-10-24 Thread Marco Orsuni

Hallo,
I have problems installing php in Linux Mandrake 7.2.

Php work, but I can't see the oracle funcions. I guessed I had to recompile
the source.

I have downloaded the latest version of php from php.net.

I unzipped the file in /tmp but when I write ./configure the program go in
abend with this message:

creating cache ./config.cache
checking for a BSD compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking whether make sets ${MAKE}... yes
checking for working aclocal... missing
checking for working autoconf... missing
checking for working automake... missing
checking for working autoheader... missing
checking for working makeinfo... missing
Updated php_version.h
checking whether to enable maintainer-specific portions of Makefiles... no
checking host system type... i586-pc-linux-gnu
checking for gawk... gawk
checking for bison... no
checking for byacc... no
configure: warning: You will need bison if you want to regenerate the PHP
parsers.
checking for gcc... gcc
checking whether the C compiler (gcc  ) works... yes
checking whether the C compiler (gcc  ) is a cross-compiler... no
checking whether we are using GNU C... yes
checking whether gcc accepts -g... yes
checking how to run the C preprocessor... gcc -E
checking for AIX... no
checking for gcc option to accept ANSI C... none needed
checking for ranlib... ranlib
checking whether gcc and cc understand -c and -o together... yes
checking whether ln -s works... yes
checking for flex... lex
checking for yywrap in -ll... no
checking lex output file root... ./configure: lex: command not found
configure: error: cannot find output from lex; giving up

what is lex??? and where I did wrong?

thank you very much. Bye

Marco R.




-- 
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: [PHP-DB] PHP and Oracle

2001-10-22 Thread Michiel_Lange


You use // to  comment, that is quite fine, but it could be that I can't
see the layout of the file rightly, but when I opened the file it looked
like this:

// echo (
; // echo ...

etc...
that won't work if you want to comment a block out you can much better
use this kind of commenting out:
/*
 echo ( );
 echo (blah);
*/

check out if that works...

Met vriendelijke groet,

Michiel Lange
ActuEra B.V.


   

GEORGINA   

ELAINE BAILEYTo: [EMAIL PROTECTED]  

[EMAIL PROTECTED]   cc:   

.uk Fax to:   

 Subject: [PHP-DB] PHP and Oracle  

19-10-2001 

19:26  

   

   





Can anyone tell me why my results will display when I just use text, but
won't display when I try to put them into a table. I keep getting a message
saying there is a parse error on line 50 of my script, but as far as I acn
see, line 50 is commented out.

Georgina(See attached file: search1.php4)(See attached file: search1.html)

--
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] PHP and Oracle

2001-10-20 Thread GEORGINA ELAINE BAILEY

Just a cosmetic question really. Why are the three links I have put in at
the bottom of the script appearing at the top on the WEb page, just beneath
the comp sci banner. How do I get them to appear beneath the table?

Georgina

html
head
titleProject Database - Search Results/title
/head

body bgcolor=#9966FF link=lime vlink=yellow
div align=centerimg src=compSciPageBanner.gif//div



?php


if ($submit == Submit)
{
// The submit button was clicked!
// Get the input and use it to retrieve information from the database.

//make a connection to the database
PutEnv(ORACLE_HOME=/usr/local/applic/oracle/816);
$connection = OCILogon(geb97,f8s0g99,trdb);

//if a connection to the database is not made output a message
if (!$connection)
{
echo I couldn't make a connection!;
exit;
}

//formulate the query
$query = SELECT PROJECT.originator, PROJECT.title, PROJECT.projectID, 
PROJECT.status, PROJECT.specialSkills, PROJECT.moduleID from PROJECT, PROJKEY, KEYWORD 
WHERE PROJECT.projectID=PROJKEY.projectID AND KEYWORD.keyID=PROJKEY.keyID AND 
PROJECT.moduleID='$moduleID' AND KEYWORD.keyword='$keyword';


//parse the statement
$qry_statement = OCIParse ($connection, $query); //or die (Couldn't parse 
statement);


//execute the query statement
OCIExecute($qry_statement);  //or die (Couldn't execute query);

//create a table into which the results can be placed
echo table align=\center\ border=\1\ cellpadding=\8\ cellspacing=\2\ 
bgcolor=\silver\;
echo tr valign=\center\thORIGINATOR/ththTITLE/ththPROJECT 
NUMBER/ththAVAILABILITY/ththSPECIAL SKILLS/th/tr;


//retrieve the results of the query statement and present them in the 
following way
while (ocifetch($qry_statement))
{

//insert the results into teh table
echo tr align =\center\;

echo td .OCIresult($qry_statement, 'ORIGINATOR'). /td;

echo td .OCIresult($qry_statement, 'TITLE'). /td;

echo td .OCIresult($qry_statement, 'PROJECTID'). /td;

echo td .OCIresult($qry_statement, 'STATUS'). /td;

echo td .OCIresult($qry_statement, 'SPECIALSKILLS'). /td;

echo /tr;

}//end of while statement


//log off the database
OCILogoff ($connection);

}//end of if statement

//provide a link back to teh UWA home page
echo div align=\center\
pre
a href = \http://www.aber.ac.uk\;Return to UWA Home Page/a

/pre/div;

//provide a link to the Computer Science Home Page
echo div align=\center\
pre
a href = \http://www.aber.ac.uk/compsci\;Return to Computer Science Home Page/a

/pre/div;

//provide a link back to the Project Database main menu
echo div align=\center\
pre
a href = \mainMenu.html\Return to Project Database Main Menu/a
/pre/div;



? ! end of PHP script


/body
/html






-- 
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: [PHP-DB] PHP and Oracle

2001-10-20 Thread DL Neil

 Just a cosmetic question really. Why are the three links I have put in at
 the bottom of the script appearing at the top on the WEb page, just beneath
 the comp sci banner. How do I get them to appear beneath the table?



Georgina,

It may look cosmetic but a browser's job is to display mark-up logic!
If things 'jump' outside/above a table, it is because the table is incomplete.
You close off the db stuff neatly, where's the /TABLE?

=dn   


-- 
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] PHP and Oracle

2001-10-19 Thread GEORGINA ELAINE BAILEY

Can anyone tell me why my results will display when I just use text, but
won't display when I try to put them into a table. I keep getting a message
saying there is a parse error on line 50 of my script, but as far as I acn
see, line 50 is commented out.

Georgina

html
head
titleProject Database - Search Results/title
/head

body bgcolor=#9966FF link=lime vlink=yellow
div align=centerimg src=compSciPageBanner.gif//div



?php


if ($submit == Submit)
{
// The submit button was clicked!
// Get the input and use it to retrieve information from the database.

//make a connection to the database
PutEnv(ORACLE_HOME=/usr/local/applic/oracle/816);
$connection = OCILogon(geb97,f8s0g99,trdb);

//if a connection to the database is not made output a message
if (!$connection)
{
echo I couldn't make a connection!;
exit;
}

//formulate the query
$query = SELECT PROJECT.originator, PROJECT.title, PROJECT.projectID, 
PROJECT.status, PROJECT.specialSkills, PROJECT.moduleID from PROJECT, PROJKEY, KEYWORD 
WHERE PROJECT.projectID=PROJKEY.projectID AND KEYWORD.keyID=PROJKEY.keyID AND 
PROJECT.moduleID='$moduleID' AND KEYWORD.keyword='$keyword';


//parse the statement
$qry_statement = OCIParse ($connection, $query); //or die (Couldn't parse 
statement);


//execute the query statement
OCIExecute($qry_statement);  //or die (Couldn't execute query);


echo table align=\center\ border=\1\ cellpadding=\8\ cellspacing=\2\ 
bgcolor=\silver\;
echo  tr valign=\center\thORIGINATOR/ththTITLE/ththPROJECT 
NUMBER/ththAVAILABILITY/ththSPECIAL SKILLS/th/tr


//retrieve the results of the query statement and present them in the 
following way
while (ocifetch($qry_statement))
{

//echo p;

//echo The Originator is: .OCIresult($qry_statement, 
'ORIGINATOR').br /;

//echo The title is: .OCIresult($qry_statement, 'TITLE').br /;

//echo The projectID is: . OCIresult($qry_statement, 
'PROJECTID').br /;

//echo The availabilty is: . OCIresult($qry_statement, 
'AVAILABILITY').br /;

//echo The special skills are: . OCIresult($qry_statement, 
'SPECIALSKILLS').br /;

//echo /p;


echo tr align =\center\;

echo td .OCIresult($qry_statement, 'ORIGINATOR'). /td/tr;

echo td .OCIresult($qry_statement, 'TITLE'). /td;

echo td .OCIresult($qry_statement, 'PROJECTID'). /td;

echo td .OCIresult($qry_statement, 'AVAILABILITY'). /td;

echo td .OCIresult($qry_statement, 'SPECIALSKILLS'). /td;

echo /tr;

}


//log off the database
OCILogoff ($connection);

}


?


div align=center
pre
a href = http://www.aber.ac.uk;Return to UWA Home Page/a

/div


div align=center
pre
a href = http://www.aber.ac.uk/compsci;Return to Computer Science Home Page/a

/pre/div

div align=center
pre
a href = mainMenu.htmlReturn to Project Database Main Menu/a
/pre/div


/body
/html


html
head
titleProject Database - Project Search/title
/head

body bgcolor=#9966FF link=lime vlink=yellow
div align=centerimg src=compSciPageBanner.gif//div

h1 align=centerProject Search/h1

form action=http://users.aber.ac.uk/geb97/search1.php4; method=POST

h2 align=centerPlease select the relevant module and then check the area(s) that 
may interest you/h2
h4 align=center If, for example, you would like to see all projects that involve 
Java,
check the Java box. If you would like only those that involve both Java and databases, 
check both boxes.
You must check at least one box/h4

p
input type=radio name=moduleID value=CS39030 
checked=checkedbigCS39030/bigbr/
input type=radio name=moduleID value=CS39110bigCS39110/bigbr/
input type=radio name=moduleID value=CS49060bigCS49060/bigbr/
input type=radio name=moduleID value=CSM9060bigCSM9060/bigbr/
input type=radio name=moduleID value=CSM9260bigCSM9260/bigbr/
/p

p
input type=radio name=keyword value=java checked=checkedbigJava/bigbr/
input type=radio name=keyword value=telematicsbigTelematics/bigbr/
input type=radio name=keyword value=artificialIntelligencebigArtificial 
Intelligence/bigbr/
input type=radio name=keyword value=databasesbigDatabases/bigbr/
input type=radio name=keyword value=68HC11big68HC11 Assembly 
Language/bigbr/
input type=radio name=keyword value=webbigWeb Development/bigbr/
input type=radio name=keyword value=othersbigOther Programming 
Languages/bigbr/
/p

p
div align=centerinput type=submit name=submit value=Submit/

input type=reset value=Reset//div
/p

/form

div align=center
pre
a href = http://www.aber.ac.uk;Return to UWA Home Page/a

/pre/div


div align=center
pre
a href = http://www.aber.ac.uk/compsci;Return to Computer Science Home Page/a

/pre/div

div align=center
pre
a href = 

Re: [PHP-DB] PHP and Oracle

2001-10-19 Thread DL Neil

Imbalance of double-quotes on line 43!
Thus // comments have all been included in quoted string and hence strange text output.
=dn


- Original Message - 
From: GEORGINA ELAINE BAILEY [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 19 October 2001 18:26
Subject: [PHP-DB] PHP and Oracle


 Can anyone tell me why my results will display when I just use text, but
 won't display when I try to put them into a table. I keep getting a message
 saying there is a parse error on line 50 of my script, but as far as I acn
 see, line 50 is commented out.
 
 Georgina





 
 
 





 -- 
 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] php and Oracle database

2001-09-27 Thread GEORGINA ELAINE BAILEY

I am very new to PHP and databases and have not really had very much
programming practice. However, I am trying to create a Web page that
retrieves data from an Oracle database and uses php to display the content
in a HTML format. For some reason though my script just doesn't seem to
work, despite the fact that I know there is data in teh database that
matches the criteria, and only prints the final three HTML links at the
bottom of the script.

Any ideas? But please make them easy enough for a 3 year old to understand.

Georgina Bailey


html
head
titleProject Database - Project Search/title
/head

body bgcolor=#9966FF link=lime vlink=yellow
div align=centerimg src=compSciPageBanner.gif//div

h1 align=centerProject Search/h1

form action=http://users.aber.ac.uk/geb97/search1.php4; method=POST

h2 align=centerPlease select the relevant module and then check the area(s) that 
may interest you/h2
h4 align=center If, for example, you would like to see all projects that involve 
Java,
check the Java box. If you would like only those that involve both Java and databases, 
check both boxes.
You must check at least one box/h4

p
input type=radio name=moduleID value=CS39030 
checked=checkedbigCS39030/bigbr/
input type=radio name=moduleID value=CS39110bigCS39110/bigbr/
input type=radio name=moduleID value=CS49060bigCS49060/bigbr/
input type=radio name=moduleID value=CSM9060bigCSM9060/bigbr/
input type=radio name=moduleID value=CSM9260bigCSM9260/bigbr/
/p

p
input type=radio name=keyword value=java checked=checkedbigJava/bigbr/
input type=radio name=keyword value=telematicsbigTelematics/bigbr/
input type=radio name=keyword value=artificialIntelligencebigArtificial 
Intelligence/bigbr/
input type=radio name=keyword value=databasesbigDatabases/bigbr/
input type=radio name=keyword value=68HC11big68HC11 Assembly 
Language/bigbr/
input type=radio name=keyword value=webbigWeb Development/bigbr/
input type=radio name=keyword value=othersbigOther Programming 
Languages/bigbr/
/p

p
div align=centerinput type=submit value=Submit/

input type=reset value=Reset//div
/p

/form

div align=center
pre
a href = http://www.aber.ac.uk;Return to UWA Home Page/a

/pre/div


div align=center
pre
a href = http://www.aber.ac.uk/compsci;Return to Computer Science Home Page/a

/pre/div

div align=center
pre
a href = mainMenu.htmlReturn to Project Database Main Menu/a
/pre/div


/body
/html



html
head
titleProject Database - Search Results/title
/head

body bgcolor=#9966FF link=lime vlink=yellow
div align=centerimg src=compSciPageBanner.gif//div



?php


if ($submit == Submit)
{
// The submit button was clicked!
// Get the input and use it to retrieve information from the database.

//make a connection to the database
PutEnv(ORACLE_HOME=/usr/local/applic/oracle/816);
$connection = OCILogon(geb97,f8s0g99,trdb);

//if a connection to the database is not made output a message
if (!$connection)
{
echo I couldn't make a connection!;
exit;
}

//formulate the query
$query = SELECT PROJECT.originator, PROJECT.title, PROJECT.projectID, 
PROJECT.status, PROJECT.specialSkills, PROJECT.moduleID from PROJECT, PROJKEY, 
KEYWORD, MODULE WHERE PROJECT.projectID=PROJKEY.projectID AND 
KEYWORD.keyID=PROJKEY.keyID AND PROJECT.moduleID='CS39030' AND KEYWORD.keyword='java';


//parse the statement
$qry_statement = OCIParse ($connection, $query); //or die (Couldn't parse 
statement);


//execute the query statement
OCIExecute($qry_statement);  //or die (Couldn't execute query);


//echo table align=\center\ border=\1\ cellpadding=\8\ 
cellspacing=\2\ bgcolor=\silver\;
//echo  tr valign=\center\thORIGINATOR/ththTITLE/ththPROJECT 
NUMBER/ththAVAILABILITY/ththSPECIAL //SKILLS/th/tr


//retrieve the results of the query statement and present them in the 
following way
while (ocifetch($qry_statement))
{
echo The Originator is: .OCIresult($qry_statement, 'ORIGINATOR');

echo The title is: .OCIresult($qry_statement, 'TITLE');

echo The projectID is: . OCIresult($qry_statement, 'PROJECTID');

echo The availabilty is: . OCIresult($qry_statement, 'AVAILABILITY');

echo The special skills are: . OCIresult($qry_statement, 
'SPECIALSKILLS');


//echo tr align =\center\td .OCIresult($qry_statement, 
'ORIGINATOR'). /td/tr;

//echo tr align=\center\td .OCIresult($qry_statement, 
'TITLE'). /td/tr;

//echo tr align=\center\td .OCIresult($qry_statement, 
'PROJECTID'). /td/tr;

//echo tr align=\center\td .OCIresult($qry_statement, 
'AVAILABILITY'). /td/tr;

//echo tr align=\center\td .OCIresult($qry_statement, 
'SPECIALSKILLS'). /td/tr;
}


//log off the database
OCILogoff ($connection);

}


?


div 

Re: [PHP-DB] php and Oracle database

2001-09-27 Thread Anthony Carlos

Georgina:

Based on your 2 enclosures, it appears that you have an html file called
search1.html. When the user hits the submit button, it calls search1.php4.
My question, therefore, is do you have output from search1.php4? Do you see
any error messages?

Thanks,

Anthony Carlos

 From: GEORGINA ELAINE BAILEY [EMAIL PROTECTED]
 Date: Thu, 27 Sep 2001 12:20:17 +0100
 To: [EMAIL PROTECTED]
 Subject: [PHP-DB] php and Oracle database
 
 I am very new to PHP and databases and have not really had very much
 programming practice. However, I am trying to create a Web page that
 retrieves data from an Oracle database and uses php to display the content
 in a HTML format. For some reason though my script just doesn't seem to
 work, despite the fact that I know there is data in teh database that
 matches the criteria, and only prints the final three HTML links at the
 bottom of the script.
 
 Any ideas? But please make them easy enough for a 3 year old to understand.
 
 Georgina Bailey
 
 
 
 
 -- 
 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] PHP 4.05 Oracle 8

2001-09-19 Thread Ricky Theil

I need to set up PHP to work on a Windows 2000 machine with IIS 5, PHP 4.05
and Oracle 8.0.5 installed.  I was having problems with the connection and
kept getting all kinds of errors about the TNSNAMES file, but now I'm
getting this error.
 
Warning: _oci_open_server: ORA-12699: Native service internal error in
c:\inetpub\wwwroot\radar\index.php on line 6
 
Here's the code I'm using:
 
?
$db = (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = 206.195.70.231)(PORT = 1522))
 (CONNECT_DATA = (SID = radw))
);
$dbh = ocilogon(system,manager,$db);
?
 
Can anyone help with this problem??
 
Thanks



[PHP-DB] PHP and Oracle Stored Functions

2001-07-25 Thread Laurence Veale

Hi, 

I can call stored procedures no problem, but when it comes to functions, I've hit a 
brick wall. Can anyone help? 

Am I binding correctly? 
Is it right to declare the PL/SQL variable first? 

All help appreciated greatly. 


Code is included below 

PHP Code: 
// logon 
$conn = OCILogon ($usr, $pwd, $sid); 

$strSQL = DECLARE  . result NUMBER;  . 
BEGIN  . 
:result :=package_name_pkg.function1( . 
1, '10-JUN-2001', '23-JUL-2001'); . 
 END;; 
// parse 
$stmt = OCIParse($conn, $strSQL); 

// bind 
OCIBindByName($stmt, :result, $answer, 22); 

// execute 
OCIExecute($stmt); 

// result 
OCIResult($stmt,$answer); 

echo Value returned: . $answer; 

PL/SQL declaration of function (within package_name_pkg): 
FUNCTION function1 
(myval IN NUMBER 
,P_STARTDATE IN DATE 
,P_ENDDATE IN DATE) 
RETURN NUMBER; 

The error I get back on screen is: 
Warning: OCIStmtExecute: ORA-06550: line 1, column 69: PLS-00201: identifier 
'CALC.package_name_pkg' must be declared ORA-06550: line 1, column 44: PL/SQL: 
Statement ignored in /home/isadlve/public_html/phptesting/file.php on line 28 

Laurence Veale

Regards,

Laurence Veale
Tel: 9689 6172
Email: [EMAIL PROTECTED]



--
This message is intended for the addressee named  and may contain 
confidential information. If you are not the intended recipient,  please
delete it and notify the sender. Views expressed in this  message are
those of the individual sender, and  are not necessarily  the views of 
the Office of State  Revenue.
--




--
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: [PHP-DB] php accessing oracle

2001-06-20 Thread Philippe Saladin

If you use PHP on Windows NT, you have to uncomment extension=php_oracle.dll
in your php.ini file, and copy php_oracle.dll to winnt\system32.
If you have installed Oracle8 client, you can also use php_oci8.dll (even
with a 7.3 database), with the OCILogon functions, etc...
I don't know what to do on another platform, sorry.
Best regards,
Philippe

Martin Langlois [EMAIL PROTECTED] a écrit dans le message news:
9go9fn$1e3$[EMAIL PROTECTED]
I want to make a query from a oracle database with php. That's what I do:

$link=Ora_Logon(user,1234);
$query = select * from sales;
$cursor = ora_do($link,$query);
while(ora_fetch($cursor))
{
print $cursor;
}

I have an arror, it's doesn't recongnize ora_logon() function.

Do i have to include something special?




--
Martin Langlois
Programmeur-analyste
Inter.net Canada
5252, boul. de Maisonneuve Ouest
bureau 200
Montréal,Qc
H4A 3S5

http://www.ca.inter.net




-- 
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: [PHP-DB] php accessing oracle

2001-06-20 Thread Philippe Saladin

If you use PHP on Windows NT, you have to uncomment extension=php_oracle.dll
in your php.ini file, and copy php_oracle.dll to winnt\system32.
If you have installed Oracle8 client, you can also use php_oci8.dll (even
with a 7.3 database), with the OCILogon functions, etc...
I don't know what to do on another platform, sorry.
Best regards,
Philippe

Martin Langlois [EMAIL PROTECTED] a écrit dans le message news:
9go9fn$1e3$[EMAIL PROTECTED]
I want to make a query from a oracle database with php. That's what I do:

$link=Ora_Logon(user,1234);
$query = select * from sales;
$cursor = ora_do($link,$query);
while(ora_fetch($cursor))
{
print $cursor;
}

I have an arror, it's doesn't recongnize ora_logon() function.

Do i have to include something special?




--
Martin Langlois
Programmeur-analyste
Inter.net Canada
5252, boul. de Maisonneuve Ouest
bureau 200
Montréal,Qc
H4A 3S5

http://www.ca.inter.net






-- 
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: [PHP-DB] php accessing oracle

2001-06-20 Thread Jimmy Brake

Hi!

did you compile php with oci or ora functions?

this is a really good tutorial...

http://www.devshed.com/Server_Side/PHP/SoothinglySeamless/page1.html

here are the commands I use .. you need to adjust for versions...

php config
./configure --with-apache=../apache_1.3.19 --with-oracle=/opt/oracle/product/8.1.6/ 
--with-oci8=/opt/oracle/product/8.1.6/ --enable-sigchild --enable-track-vars

apache config --- remove the php3/php4 respectively
./configure --prefix=/usr/local/apache --with-layout=GNU --enable-shared=max 
--enable-module=most --activate-module=src/modules/php4/libphp4.a --enable-module=php4

Jimmy Brake

On Tue, 19 Jun 2001, Martin Langlois wrote:

 I want to make a query from a oracle database with php. That's what I do:
 
 $link=Ora_Logon(user,1234);
 $query = select * from sales;
 $cursor = ora_do($link,$query);
 while(ora_fetch($cursor))
 {   
 print $cursor;
 }
 
 I have an arror, it's doesn't recongnize ora_logon() function.
 
 Do i have to include something special?
 
 
 
 
 -- 
 Martin Langlois
 Programmeur-analyste
 Inter.net Canada
 5252, boul. de Maisonneuve Ouest
 bureau 200
 Montréal,Qc
 H4A 3S5
 
 http://www.ca.inter.net
 


--
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] php accessing oracle

2001-06-19 Thread Martin Langlois

I want to make a query from a oracle database with php. That's what I do:

$link=Ora_Logon(user,1234);
$query = select * from sales;
$cursor = ora_do($link,$query);
while(ora_fetch($cursor))
{   
print $cursor;
}

I have an arror, it's doesn't recongnize ora_logon() function.

Do i have to include something special?




-- 
Martin Langlois
Programmeur-analyste
Inter.net Canada
5252, boul. de Maisonneuve Ouest
bureau 200
Montréal,Qc
H4A 3S5

http://www.ca.inter.net



[PHP-DB] PHP and Oracle

2001-05-09 Thread Lokesh Wuluvarana

Hi,
I just wanted to know if there are any known issues with PHP working
with Oracle database. We are currently configuring Oracle to make PHP
work with Oracle. Let me know.
Thanks
Lokesh

-- 
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] php 4 + Oracle 8 + FreeBSD w/ Linux Emulation

2001-05-07 Thread Theodore Hope

We're looking into getting PHP under FreeBSD (4.3) to talk to
a remote Oracle server that runs on NT.  In the past we have
used OpenLink, but we'd rather not touch anything on the NT
side.

It's apparent that one can install Oracle 8.x for Linux under
Linux emulation on FreeBSD.  My question is, will the link
(ld) of PHP + Apache + Oracle(Linux) work correctly under
this platform?

Thanks.  -T.H.

-- 
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] PHP and Oracle

2001-04-18 Thread Lester June Cabrera



Hi,

How would I install PHP with Oracle support if Oracle is on another 
machine, not in the web server machine?

Thanks,
Lester


-
Lester June Cabrera
Chief Web Programmer
I-Quest Corporation

Tel: (632) 867 8460 local 32
Fax: (63 2) 867 8077
E-mail: [EMAIL PROTECTED]

Visit the most comprehensive on-line business travel resource at 
http://www.worldroom.com

Successful events start here. Visit http://www.worldroomevents.com .
The one-stop online exchange for event planners and suppliers to the MICE 
industry.


-- 
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: [PHP-DB] PHP and Oracle

2001-04-18 Thread Brian S. Dunworth

At 03:43 PM 4/18/01 +0800, Lester June Cabrera wrote:

How would I install PHP with Oracle support if Oracle is on another 
machine, not in the web server machine?

  1.  Install the Oracle Net8 client on your web server...

  2.  Configure the Oracle Net8 client on your web server...

  3.  Compile PHP with OCI8 support...

  Now, the next thing that usually happens is that I'll get an email asking 
me "where do I get the Oracle Net8 client?"  then, "how do I install the 
Net8 client?"  still later, I'll get another email asking "how do I 
configure the Net8 client?"  then...

  So, to avoid all that...

   The Oracle Net8 client is available from Oracle Corporation.  There is a 
client available for just about every platform imaginable.  Call Oracle 
support with your CSI number and they'll gladly ship whichever client 
platform software you need for free.  Sometimes, the client software isn't 
available as a stand-alone disk, and they'll send you an entire Oracle 8i 
installation set - fear not, it contains the Net8 client for that architecture.

   To configure the Net8 client, follow the directions provided with the 
installation.  Basically, you need to set up your tnsnames.ora file to 
locate the oracle server.  There are utilities installed with the client to 
help you configure and test it.  It probably wouldn't be a bad idea for you 
to *also* install the SQL*Plus software, which operates through the Net8 
interface as well...

  - Brian

  -
Brian S. Dunworth
Sr. Software Development Engineer
Oracle Database Administrator
The Printing House, Ltd.

(850) 875-1500  x225
[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]