Re: [PHP-DB] PHP 4.3.8/Oracle 9i OCI call question for BLOBs
[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
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
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
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
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
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
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 !
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Re: [PHP-DB] php accessing oracle
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
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
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
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
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
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
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
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]
