Problem with my Mysql and php connection

comcentury

I have been having problems connecting my mysql server to my php script,i even used this script to have a confirmation that my connection was successful to no avail;

/ Connect to the database server
$dbcnx = @mysql_connect('localhost', 'root', 'mypasswd');
if (!$dbcnx) {
exit('Unable to connect to the ' .
'database server at this time.');
} else {
echo 'Database connection established.';
}

Please test the code on your server and see if you'll see a response on your browser like 'Database connection established'

Each time i execute a php script on my server(just like the code sample above) that is meant to connect to my database,select it and retrieve data it instead gives me a blank page instead of the data i requested.

Can someone help me with that.i'm stuck!is there something i have not done or i am missing cos that's the basis of develping a php website in the first place.

I even tried to use the mysq root-username and passwordi registered the server with during my installation but to no avail.

Looking forward to hearing your responses

John

rincewind456

First of all take the @ away from the [man]mysql_connect/man call, all that does is supress errors, not really what you want at this time :-) This may help you by giving you a useful error report.

Secondly, you don't say which platform you're using but if your on Windows you have the option to install the command line client, did you? if so have you checked that you can communicate with the sql server. You can do the same on linux through the terminal.

If you can't connect via the client/terminal then check the process list(linux) or task manager(windows) to see if the mysql server is started.

comcentury

I have removed the @ on the code on my php script(work.php) and this is the error message i received;

Fatal error: Call to undefined function mysql_connect() in C:\Inetpub\wwwroot\work.php on line 10

So what next??
remember here is the code;

// Connect to the database server
$dbcnx = mysql_connect('localhost', 'root',
'mypasswd');
if (!$dbcnx) {
exit('Unable to connect to the ' .
'database server at this time.');
} else {
echo 'Database connection established.';
}

...Can i connect from my mysql command line client and produce the desired output i need...?

if not how do i correct the error statement shown above??

If it's the command line prompt on mysql,i have installed it successfully on my windows platform..how can i connect mysql with php from the command line prompt and have a confirmation that the connection has been established ??is that possible

if not how do i correct the error statement shown above??

rincewind456

Did you edit your php.ini file and enable the mysql extension? See here

Did you carry out the instructions here, regarding mysql functions on windows.

Have you run a script like this

<?php
phpinfo();
?>

to see if the mysql extension is installed?

If you have installed mysql correctly, when you open up the command line client you will get a prompt to enter your password, does this happen? If so then you know that at least mysql works.

Piranha

Why do you start 3 threads in the same forum about the same problem? The threads are 10339743, 10339634 and 10339635. One thread is enough.