[PHP-DB] oci8 1.3.4 working for months on my simple browser based php

2009-05-31 Thread Fred Silsbee

For months I've had a Oracle 11g1 browser based table access site/program 
working.

I do regular Fedora 9 yum updates and have seen some pecl/pear stuff whizzing 
by.

Just tried the Oracle 11g1 browser based table access site/program and NOTHING 
shows on the Firefox 3.0.10 screen. Not even an error.

/etc/httpd/logs/error_log says something about cannot open php_oracle.dll or 
php_oci8.dll

That is good...there isn't any dll on Linux.

Proble: downloaded oci8-1.3.5 and the README file says to run ./configure but 
there are 2 files config.m4 and config.w32

nothing in this README file works...is it up to date?




  


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



Re: [PHP-DB] oci8 1.3.4 working for months on my simple browser based php

2009-05-31 Thread Phpster
If I had to guess the config.w32 is the window 32 bit config file. So  
I would try the other


Bastien

Sent from my iPod

On May 31, 2009, at 15:28, Fred Silsbee fredsils...@yahoo.com wrote:



For months I've had a Oracle 11g1 browser based table access site/ 
program working.


I do regular Fedora 9 yum updates and have seen some pecl/pear stuff  
whizzing by.


Just tried the Oracle 11g1 browser based table access site/program  
and NOTHING shows on the Firefox 3.0.10 screen. Not even an error.


/etc/httpd/logs/error_log says something about cannot open  
php_oracle.dll or php_oci8.dll


That is good...there isn't any dll on Linux.

Proble: downloaded oci8-1.3.5 and the README file says to run ./ 
configure but there are 2 files config.m4 and config.w32


nothing in this README file works...is it up to date?







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



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



Re: [PHP-DB] oci8 1.3.4 working for months on my simple browser based php

2009-05-31 Thread danaketh
Look what extensions are you loading. You should find that in php.ini 
file. Maybe something nasty happened and you php.ini has 
extension=php_oracle.dll instead of extension=php_oracle.so. Also, if 
you are about to compile a module for PHP, first you have to run phpize, 
than ./configure and make ;)


Fred Silsbee napsal(a):

For months I've had a Oracle 11g1 browser based table access site/program 
working.

I do regular Fedora 9 yum updates and have seen some pecl/pear stuff whizzing 
by.

Just tried the Oracle 11g1 browser based table access site/program and NOTHING 
shows on the Firefox 3.0.10 screen. Not even an error.

/etc/httpd/logs/error_log says something about cannot open php_oracle.dll or 
php_oci8.dll

That is good...there isn't any dll on Linux.

Proble: downloaded oci8-1.3.5 and the README file says to run ./configure but 
there are 2 files config.m4 and config.w32

nothing in this README file works...is it up to date?




  



  


--

S pozdravem

Daniel Tlach
Freelance webdeveloper

Email: m...@danaketh.com
ICQ: 160914875
MSN: danak...@hotmail.com
Jabber: danak...@jabbim.cz



Re: [PHP-DB] One table, multiple queries?

2009-05-31 Thread Still Learnin'

Bastien Koert wrote:

On Fri, May 22, 2009 at 4:24 PM, Dee Ayy dee@gmail.com wrote:


It sounds like you are wanting to transpose rows and columns.  But
you used the terms convert and fields, so google may not be helping
you.

I found this:

http://forums.mysql.com/read.php?86,23026,25752#msg-25752


I had seen that, I linked it in fact. I don't want to sum the data,
just list it. Transpose is a more correct word I suppose. The issue
is that the data in the value field is different, depending on the
value in the field_id field. Therefore, I want to take each of the
three data types and convert them to new fields, or columns, so that
all of the data for one product_id is on one row, instead of three.




cross tab query?


Huh? Whuzzat? I'm off to RTFM, and ty for the pointer.

Ski

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



Fw: Re: [PHP-DB] oci8 1.3.4 working for months on my simple browser based php

2009-05-31 Thread Fred Silsbee

problem solved...don't know how!

(1) successfully installed oci8 1.3.5 (thanks)

   I wiah oci8 were updated by yum

(2) had to renew my 11g1 Oracle password since it would expire in 4 days.
  I had to : alter user (and had it backward the first time)

(3) bingo!!!  it started working with the new password

Whew!



--- On Sun, 5/31/09, Fred Silsbee fredsils...@yahoo.com wrote:

 From: Fred Silsbee fredsils...@yahoo.com
 Subject: Re: [PHP-DB] oci8 1.3.4 working for months on my simple browser 
 based  php
 To: danaketh danak...@gmail.com
 Date: Sunday, May 31, 2009, 11:41 PM
 Thanks! I thought of that...give the
 #$% thing what it wants!
 
 However not sure that causes the problem!
 
 There is no dll (of course anywhere in my Fedora 9).
 
 Currently trying to isolate the problem by stripping out
 everything but the connect.
 
 I did this way back when I got it working late last year!
 whew!
 
 
 
 --- On Sun, 5/31/09, danaketh danak...@gmail.com
 wrote:
 
  From: danaketh danak...@gmail.com
  Subject: Re: [PHP-DB] oci8 1.3.4 working for months on
 my simple browser based  php
  To: Fred Silsbee fredsils...@yahoo.com
  Date: Sunday, May 31, 2009, 11:07 PM
  
  
  
    
  
   
  You have link to .dll somewhere.
  I however
  don't know where Fedora keeps php.ini and extension
  configs (on Debian
  I have this configured just by copying files
 module.ini and
  module.so
  to the /usr/lib/php/extensions/).
  
  
  
  But if you can't find where the problem is, you may
 try
  a little dirty
  technique - copy/rename php_oci8.so and php_oracle.so
 to
  .dll and put
  them in /usr/lib/php/modules - to see what it will do.
 Also
  look in
  that place for .ini files..
  
  
  
  Fred Silsbee napsal(a):
  
    Thanks!Did the phpize command and all
 that worked
  great...I have a new oci8.so in the right place
  
   Makes no sense, there is nothing about windows
 in my
  php.ini file
  
  /etc/httpd/logs/error_message:
  
  [Sun May 32 16:58:46 2009] [notice] suEXEC mechanism
  enabled (wrapper: /usr/sbin/suexec)
  [Sun May 31 16:58:46 2009] [notice] Digest:
 generating
  secret for digest authentication ...
  [Sun May 31 16:58:46 2009] [notice] Digest: done
  PHP Warning:  PHP Startup: Unable to load dynamic
 library
  '/usr/lib/php/modules/php_oci8.dll' -
  /usr/lib/php/modules/php_oci8.dll: cannot open shared
 object
  file: No such file or directory in Unknown on line 0
  PHP Warning:  PHP Startup: Unable to load dynamic
 library
  '/usr/lib/php/modules/php_oracle.dll' -
  /usr/lib/php/modules/php_oracle.dll: cannot open
 shared
  object file: No such file or directory in Unknown on
 line 0
  [Sun May 31 16:58:55 2009] [notice] mod_python:
 Creating 4
  session mutexes based on 256 max processes and 0 max
  threads.
  [Sun May 31 16:58:55 2009] [notice] mod_python: using
  mutex_directory /tmp
  [Sun May 31 16:58:57 2009] [notice] Apache/2.2.9
 (Unix)
  DAV/2 mod_mono/1.2.6 PHP/5.2.9 mod_python/3.3.1
 Python/2.5.1
  mod_ssl/2.2.9 OpenSSL/0.9.8g mod_perl/2.0.4
 Perl/v5.10.0
  configured -- resuming normal operations
  [Sun May 31 17:01:22 2009] [error] [client
 207.254.232.245]
  PHP Notice:  Undefined
 index:   in
  /var/www/html/handle_log_book11g1.php on line 88
  [Sun May 31 17:01:22 2009] [error] [client
 207..254.232.245]
  PHP Stack trace:
  [Sun May 31 17:01:22 2009] [error] [client
 207.254.232.245]
  PHP   1. {main}()
 /var/www/html/handle_log_book11g1.php:0
  [Sun May 31 17:01:22 2009] [error] [client
 207.254.232.245]
  PHP Notice:  Undefined
 index:   in
  /var/www/html/handle_log_book11g1.php on line 89
  [Sun May 31 17:01:22 2009] [error] [client
 207.254.232.245]
  PHP Stack trace:
  [Sun May 31 17:01:22 2009] [error] [client
 207.254.232.245]
  PHP   1. {main}()
 /var/www/html/handle_log_book11g1.php:0
  [Sun May 31 17:01:22 2009] [error] [client
 207.254.232.245]
  PHP Notice:  Undefined
 index:   in
  /var/www/html/handle_log_book_MySQL.php on line 73
  [Sun May 31 17:01:22 2009] [error] [client
 207.254.232.245]
  PHP Stack trace:
  [Sun May 31 17:01:22 2009] [error] [client
 207.254.232.245]
  PHP   1. {main}()
 /var/www/html/handle_log_book_MySQL.php:0
  [Sun May 31 17:01:22 2009] [error] [client
 207.254.232.245]
  PHP Notice:  Undefined
 index:   in
  /var/www/html/handle_log_book_MySQL.php on line 74
  [Sun May 31 17:01:22 2009] [error] [client
 207.254.232.245]
  PHP Stack trace:
  [Sun May 31 17:01:22 2009] [error] [client
 207.254.232.245]
  PHP   1. {main}()
 /var/www/html/handle_log_book_MySQL.php:0
  [Sun May 31 17:11:33 2009] [notice] child pid 2149
 exit
  signal Segmentation fault (11)
  ~
  
  
  --- On Sun, 5/31/09, danaketh danak...@gmail.com
  wrote:
  
    
    
      From: danaketh danak...@gmail.com
  Subject: Re: [PHP-DB] oci8 1.3.4 working for months on
 my
  simple browser based  php
  To: Fred Silsbee fredsils...@yahoo.com
  Cc: php-db@lists.php.net
  Date: Sunday, May 31, 2009, 8:45 PM
  
  
  
    
    
  
   
  Look what extensions are you