Re: Need help with PHP / MySQL connect problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 Windows version), and set error_reporting = E_ALL. This will show all notices and warnings generated by your PHP code; extremely usefull in debugging.

Matt Darby

Linda H wrote:

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 scrip to test the connection. It should print either the Resource name or an error message:

<?php
echo mysql_connect ('localhost','calendar','pass1234'); # host, user, password
?>

I get no output at all, and if the statement is placed in a larger script, above html/PHP output, it suppresses that as well.

Using the mysql monitor from the DOS command prompt, I can connect as user 'calendar' with password 'pass1234', select a database and execute SQL statements successfully.

Can anyone help me figure out why I can't seem to connect, please?

Linda

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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux