Re: [PHP] Re: Need help with PHP / MySQL connect problem

2005-07-18 Thread Mark Rees
Linda H [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I added the following to the top of my script: ?php echo phpinfo(); ? Got all sorts of environment and path info. Not anything about MySQL, but I didn't see anything that looked obviously wrong, though I don't understand

Re: [PHP] Re: Need help with PHP / MySQL connect problem

2005-07-18 Thread kalinga
i recently met samekind of problem, could you pls specify the OS, Apache, Php and MySQL vesrions you are using? vk On 7/18/05, Mark Rees [EMAIL PROTECTED] wrote: Linda H [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I added the following to the top of my script: ?php

Re: [PHP] Re: Need help with PHP / MySQL connect problem

2005-07-18 Thread Rick Emery
Quoting Linda H [EMAIL PROTECTED]: I added the following to the top of my script: ?php echo phpinfo(); ? Got all sorts of environment and path info. In addition to the other excellent suggestions so far, make sure (looking at the phpinfo page, under Configuration File Path) that your

Re: [PHP] Re: Need help with PHP / MySQL connect problem

2005-07-18 Thread Linda H
For those who didn't join this thread at the beginning, I'm running MySQL 4.0.21, Apache 2.0.52 and PHP 5.0.2 on a Windows XP system. I installed in the sequence - MySQL, then Apache, then PHP. MySQL was running when the others were installed (which is what the book I am using seemed to

Re: [PHP] Re: Need help with PHP / MySQL connect problem

2005-07-18 Thread Mark Rees
Linda H [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] For those who didn't join this thread at the beginning, I'm running MySQL 4.0.21, Apache 2.0.52 and PHP 5.0.2 on a Windows XP system. I installed in the sequence - MySQL, then Apache, then PHP. MySQL was running when the others

Re: [PHP] Re: SOLVED! Need help with PHP / MySQL connect problem

2005-07-18 Thread Linda H
do you have this in your php.ini extensions? extension=php_mysql.dll yes Make sure you extension path is referencing its location also so it can find it... for example: extension_dir = c:/php/ext/ I changed this and now I can connect to MySQL! Haven't runa query yet, but I think I'm

[PHP] Need help with PHP / MySQL connect problem

2005-07-17 Thread Linda H
Hi, I'm running MySQL 4.0.21, Apache 2.0.52 and PHP 5.0.2 on a Windows XP system. I can run scripts with PHP and HTML statements and see correct output in my browser. But when I try to connect to MySQL I get nothing, including no error messages. One book I have says to run the following

Re: [PHP] Need help with PHP / MySQL connect problem

2005-07-17 Thread Matt Darby
Using this at the top of your script will allow PHP and MySQL to interact. $_POST['dbconn']=mysql_select_db(database_name, mysql_connect(server_name,user_name,password)); It does sound like you have notices and warnings turned off in php.ini: Find php.ini (not sure where it installs to in

[PHP] Re: Need help with PHP / MySQL connect problem

2005-07-17 Thread Linda H
Thanks for the advice, Matt, but it doesn't seem to solve my problem. php.ini is in the C:Program Files/WINDOWS directory and error_reporting was set to E_ALL. I found php5ts.dll in the WINDOWS/system32 directory. I copied it to WINDOWS/system, just in case. My install instructions said to

Re: [PHP] Need help with PHP / MySQL connect problem

2005-07-17 Thread Mikey
Matt Darby wrote: Using this at the top of your script will allow PHP and MySQL to interact. $_POST['dbconn']=mysql_select_db(database_name, mysql_connect(server_name,user_name,password)); It does sound like you have notices and warnings turned off in php.ini: Find php.ini (not sure where it

Re: [PHP] Re: Need help with PHP / MySQL connect problem

2005-07-17 Thread Matt Darby
Try this just for kicks: ? aslkdjfalsd; ? See if this will output errors. It's rather hard to debug without error messages ;) If I remember correctly, isn't php.ini supposed to be in c:/PHP? Linda H wrote: Thanks for the advice, Matt, but it doesn't seem to solve my problem. php.ini is

Re: [PHP] Re: Need help with PHP / MySQL connect problem

2005-07-17 Thread Linda H
Try this just for kicks: ? aslkdjfalsd; ? Nope - nothing :-( See if this will output errors. It's rather hard to debug without error messages ;) No kidding! If I remember correctly, isn't php.ini supposed to be in c:/PHP? It came in c:/php5 as php.ini-recommended. My instructions

Re: [PHP] Re: Need help with PHP / MySQL connect problem

2005-07-17 Thread Linda H
I added the following to the top of my script: ?php echo phpinfo(); ? Got all sorts of environment and path info. Not anything about MySQL, but I didn't see anything that looked obviously wrong, though I don't understand a lot of it. I ried reinstalling MySQL, Apache, and PHP. No change.

Re: [PHP] Re: Need help with PHP / MySQL connect problem

2005-07-17 Thread Matt Darby
You should definitely see a listing for MySQL in phpinfo()... What order did you install MySQL/PHP/Apache? Linda H wrote: I added the following to the top of my script: ?php echo phpinfo(); ? Got all sorts of environment and path info. Not anything about MySQL, but I didn't see anything

Re: [PHP] mysql connect problem

2005-05-25 Thread Burhan Khalid
Jim Sara Feldman wrote: Hi: I have recently upgraded from a Mac G4 running OS 10.3.9 to a G5 running OS 10.4. I ported a working PHP app and upgraded from PHP 4.3.4 to 4.3.10 and MySQL 4.0.17 to 4.1.11. I am having a problem connecting to MySQL from PHP. I can connect to the

[PHP] mysql connect problem

2005-05-24 Thread Jim Sara Feldman
Hi: I have recently upgraded from a Mac G4 running OS 10.3.9 to a G5 running OS 10.4. I ported a working PHP app and upgraded from PHP 4.3.4 to 4.3.10 and MySQL 4.0.17 to 4.1.11. I am having a problem connecting to MySQL from PHP. I can connect to the database using either phpMyADMIN or

Re: [PHP] mysql connect problem

2005-05-24 Thread Richard Lynch
On Tue, May 24, 2005 2:14 pm, Jim Sara Feldman said: $result = mysql_pconnect(localhost, api_user, 97533); if (!$result) die(mysql_error()); Try it without the 'p' in pconnect, which you probably aren't using in the other connections in your testing. -- Like Music?

[PHP] MySQL Connect Problem

2004-03-17 Thread Cameron B. Prince
Hey guys, I've been developing my site on a dev server with MySQL locally installed. I've now moved the site to the production webserver and setup my databases on the production dbserver, which are two different machines. I have begin updating my connection variables and now I find I can't

Re: [PHP] MySQL Connect Problem

2004-03-17 Thread Adam Voigt
What happens when you try to use the mysql client on the web machine, to connect to the production database server? Does it work? If yes, what lines are you using to connect to your DB with PHP? On Wed, 2004-03-17 at 14:54, Cameron B. Prince wrote: Hey guys, I've been developing my site on a

RE: [PHP] MySQL Connect Problem

2004-03-17 Thread Cameron B. Prince
Hi Adam, What happens when you try to use the mysql client on the web machine, to connect to the production database server? It works: bash-2.05# pwd /usr/local/mysql/bin bash-2.05# ./mysql -h 192.168.1.44 -u web -P 3306 -p Enter password: Welcome to the MySQL monitor. Commands end with ;

RE: [PHP] MySQL Connect Problem

2004-03-17 Thread Adam Voigt
So what error prints out when you try and connect from PHP? On Wed, 2004-03-17 at 15:03, Cameron B. Prince wrote: Hi Adam, What happens when you try to use the mysql client on the web machine, to connect to the production database server? It works: bash-2.05# pwd

RE: [PHP] MySQL Connect Problem

2004-03-17 Thread Cameron B. Prince
So what error prints out when you try and connect from PHP? Could not connect : Can't connect to MySQL server on '192.168.1.44' (2) Not very helpful huh? Any ideas? Cameron -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] MySQL Connect Problem

2004-03-17 Thread Adam Voigt
Change your server address, to leave off the port number. Any different? On Wed, 2004-03-17 at 15:07, Cameron B. Prince wrote: So what error prints out when you try and connect from PHP? Could not connect : Can't connect to MySQL server on '192.168.1.44' (2) Not very helpful huh? Any

RE: [PHP] MySQL Connect Problem

2004-03-17 Thread Cameron B. Prince
Change your server address, to leave off the port number. Any different? $DBhost = 192.168.1.44; $DBuser = web; $DBpwd = user; $DBreg = registration; $DBconf = config; # setup database handle and load configuration data $dbh = mysql_connect($DBhost, $DBuser, $DBpwd) or die(Could not

RE: [PHP] MySQL Connect Problem

2004-03-17 Thread Adam Voigt
What does your MySQL error log say on your production database server? It should be in the var directory named something .err. On Wed, 2004-03-17 at 15:16, Cameron B. Prince wrote: Change your server address, to leave off the port number. Any different? $DBhost = 192.168.1.44; $DBuser

RE: [PHP] MySQL Connect Problem - Client Lib / Server Version Skew

2004-03-17 Thread Cameron B. Prince
What does your MySQL error log say on your production database server? It should be in the var directory named something .err. These are SunFire 210 Solaris boxes. The MySQL is installed from binary. It doesn't write a log by default as best I can tell, but I did find something. The MySQL on

RE: [PHP] MySQL Connect Problem - Client Lib / Server Version Skew

2004-03-17 Thread Adam Voigt
I would think the mysqlclient library would be backwards compatible, but it's possible I guess. I'm kind of out of ideas, as the can't connect error without something like a bad username or password message, seems to indicate a TCP/IP communication failure. On Wed, 2004-03-17 at 15:26, Cameron

RE: [PHP] MySQL Connect Problem - Client Lib / Server Version Skew

2004-03-17 Thread Cameron B. Prince
I would think the mysqlclient library would be backwards compatible, but it's possible I guess. I'm kind of out of ideas, as the can't connect error without something like a bad username or password message, seems to indicate a TCP/IP communication failure. Well, after thinking more