[PHP-DB] Re: problem with php and unixODBC
Hello, I know its a little late, but I have only just been pointed to your posting, I would guess the error you are getting database not found is coming from the sybase driver, not the driver manager. I solved the problem a week ago. It was just when I wanted to try iODBC when I saw some putenv()-lines in the examples. I put the appropriate lines in my php-script and then it worked. What I don't unterstand is: When I'm running isql in the shell I can connect to the remote-ressource. When I start apache in the same shell I can't connect through PHP, I first have to set the ODBCINSTINI and ODBCINI env-variables. Why don't I need them in the shell? Regards Marten -- Variomedia IT-Service GmbH | Benzstrasse 22 | 14482 Potsdam http://www.variomedia.de | Hotline: 0800-5588550 | Fax: 0331-7404043 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Upgrading PHP
Hi-- I'm currently running 4.0.4pl1 on RedHat 7.0 and I want to upgrade to PHP 4.2.2is there anything special I have to do BEFORE or AFTER the install? Or is it just a straight re-install of PHP on top of the current Version? THANKS! Julio Cuz, Jr. [EMAIL PROTECTED] Information Services Riverside Community College
Re: [PHP-DB] Upgrading PHP
I'd uninstall php first...I believe its rpm -e mod_php (or you can do rpm -e `rpm -qa|grep php` and then I'd upgrade apache and PHP on your box for security reasons. Read the installation section in the php manual at www.php.net for details. Adam On Wed, 14 Aug 2002, Julio Cuz, Jr. wrote: Hi-- I'm currently running 4.0.4pl1 on RedHat 7.0 and I want to upgrade to PHP 4.2.2is there anything special I have to do BEFORE or AFTER the install? Or is it just a straight re-install of PHP on top of the current Version? THANKS! Julio Cuz, Jr. [EMAIL PROTECTED] Information Services Riverside Community College -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Upgrading PHP
I should add if you are going to upgrade apache also, to rpm -e apache first so that You will have a clean install. backup httpd.conf first though! But you might want to save /etc/logrotate.d/httpd because the rpm -e removed this, and it is what rotates the log files for /var/log/httpd/access_log and error_log Adam On Wed, 14 Aug 2002, Julio Cuz, Jr. wrote: Hi-- I'm currently running 4.0.4pl1 on RedHat 7.0 and I want to upgrade to PHP 4.2.2is there anything special I have to do BEFORE or AFTER the install? Or is it just a straight re-install of PHP on top of the current Version? THANKS! Julio Cuz, Jr. [EMAIL PROTECTED] Information Services Riverside Community College -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Upgrading PHP
Don't forget to make register_globals equal to on instead of off. Well, actually this is just a security/preference issue. Prior to PHP 4.2.0 globals were default to on, but now they're default to off meaning that you have to use _GET['query_string_value'] instead of just $query_string_value. You can read about this all over php.net in the changelogs. ~ Matthew -Original Message- From: Adam Williams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 3:52 PM To: Julio Cuz, Jr. Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Upgrading PHP I should add if you are going to upgrade apache also, to rpm -e apache first so that You will have a clean install. backup httpd.conf first though! But you might want to save /etc/logrotate.d/httpd because the rpm -e removed this, and it is what rotates the log files for /var/log/httpd/access_log and error_log Adam On Wed, 14 Aug 2002, Julio Cuz, Jr. wrote: Hi-- I'm currently running 4.0.4pl1 on RedHat 7.0 and I want to upgrade to PHP 4.2.2is there anything special I have to do BEFORE or AFTER the install? Or is it just a straight re-install of PHP on top of the current Version? THANKS! Julio Cuz, Jr. [EMAIL PROTECTED] Information Services Riverside Community College -- 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
[PHP-DB] MySQL queries
for some reason in my mysql selecct statements in my php pages, when i upload them to my web server, they just return a blank record set. no errors or anything, just blank. i can insert fine but no select. it works fine on my test win32 apache/mysql -- Regards, Georgie Casey [EMAIL PROTECTED] *** http://www.filmfind.tv Online Film Production Directory *** -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] cursors example?
Can anyone point me toward an example of using a cursor with php? I'd prefer a non-oracle example if possible :) thanks! Taylor -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL queries
George, It is likely that your win32 system did not care about case. If you are using a *nix host it is case sensitive, and its installation of MySQL, by extension, is as well. Try echo'ing the select statement to see what you have. Miles At 10:42 PM 8/14/2002 +0100, Georgie Casey wrote: for some reason in my mysql selecct statements in my php pages, when i upload them to my web server, they just return a blank record set. no errors or anything, just blank. i can insert fine but no select. it works fine on my test win32 apache/mysql -- Regards, Georgie Casey [EMAIL PROTECTED] *** http://www.filmfind.tv Online Film Production Directory *** -- 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
[PHP-DB] PHP Extensions in Win32
I'm using php_ldap.dll (PHP 4.2.2 on WIN2k/IIS) and had a strange thing happen today. The server suddenly stopped answering requests with an error Invalid Credentials. When I went to the server there were several pop-up windows visible all of which saying cannot load module php_ldap.dll file not found ... now the file was where it belonged and the credentials were fine. I checked the server for the PHP process and it wasn't there, but it refused to work correctly, just kept saying Invalid Credentials. After rebooting the server it worked fine again. Has anyone seen this behavior before? Today was perhaps the most load the application has gotten since development. My theory is the file became in use and couldn't be used for subsequent calls giving the pop-ups. I have no clue why it would not work ever after though. Since that I was motivated to implement an AD cache mechanism that cuts down on the use of the ldap calls hopefully I will not see this happen again. Ryan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] non-repeating random numbers
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 can someone give me a sample script for non-repeating random numbers? TIA' zham -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.4e (MingW32) - GPGOE 0.4.1 Comment: For info see http://www.gnupg.org iEYEARECAAYFAj1a/P4ACgkQ9/khW8BNWdQCfgCg0V8Fc7IUQzJ/uOH3+KS3GsNc hxMAnjHNAcuk9Rx7leIkPTLdzI4MZOjk =5s+J -END PGP SIGNATURE- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Lost Mysql password
I know it's a mysql question but you guys have been kind enough to answer such in the past: I made myself a brand spanking new server wik PHP, Mysql etc. I set up mysql and changed the root pass did some other work and it does not work now, there is a slight chance I mistyped. Unistalling rpms and putting them back did not work for some reason, redhat 7.3, php4.1.2, mysql 3.23.51 Thansk in advance R __D_E_S_I_G_N _ _I_S_ _ _T_H_E_ _ _M_E_S_S_A_G_E__ find finalbanana web design and consulting at: http://www.finalbanana.com e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Lost Mysql password (SOLVED)
besides rpm -e all of the packages I had to alsohad to remove manually 3 dirs that the rpm missed I know it's a mysql question but you guys have been kind enough to answer such in the past: I made myself a brand spanking new server wik PHP, Mysql etc. I set up mysql and changed the root pass did some other work and it does not work now, there is a slight chance I mistyped. Unistalling rpms and putting them back did not work for some reason, redhat 7.3, php4.1.2, mysql 3.23.51 Thansk in advance R -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] M$ Access
Is there a way to connect to M$ Access with PHP without using something like MyODBC? WIN2K, IIS5, PHP 4.2.2. I know this must have been asked before but I am wondering... Matt Babineau MCWD / CCFD - e: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] p: 603.943.4237 w: http://www.criticalcode.com/ http://www.criticalcode.com PO BOX 601 Manchester, NH 03105
Re: [PHP-DB] M$ Access
This is CorpseEater's reply on your message send to him on 8/15/2002 : Yes - ADO PHP drivers. You can download that library here : http://php.weblogs.com/adodb#downloads then you should read these : http://php.weblogs.com/discuss/msgReader$32 http://phplens.com/lens/adodb/readme.htm I think this is all you'll need - with these drivers you can connect to a lot of different databases (including ms access and others). Matt Is there a way to connect to M$ Access with PHP without using something Matt like MyODBC? WIN2K, IIS5, PHP 4.2.2. Matt I know this must have been asked before but I am wondering... -- Greets [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php