mysql_connect doesn' t work - no error

fetch

I am new to PHP.

I'm trying to write a simple mysql login script, just to get my feet wet with php.

I have copied most of this code from an example I found on the web, but it just doesn't seem to work.

I call it from an html page that sends the various post variables. I have tested publishing the variables and they all seem to be sent just fine.

The following code simply prints out the statement "Login Test" and that is all. I get no error message telling me that why the connect statement is not working. And the line after the ?> does not print either. Two questions:

1) any idea why this is not working?
2) how can I access the error message to get some idea of how to trouble shoot this?

<html>
<body>
Login test
<?php
$u = $POST["user"];
$d = $POST["database"];
$p = $_POST["passwd"];
$dbcnx = mysql_connect("localhost", $u, $p);
if (! dbcnx)
echo("Can't connect at this time");
else
echo("Succefully conected to $d")
?>
I can't see this line
</body>
</html>

laserlight

Ensure that error_reporting is set to E_ALL and display_errors is on

smapdi

a couple of things that I see right away is that this line
if (! dbcnx)
is missing the $
if (! $dbcnx)
php won't know what dbcnx is

you're also missing the following function
mysql_select_db ($d);

you need this after the mysql_connect function to select the database

I'm not sure without a test but I think that the page fails during the php section so the final paragraph tag never gets rendered
I can't see this line

SumitGupta

Hi..

There are few syntax mistake..

The first is already reported..
the second i will highlight

your code is ....

if (! dbcnx) 
echo("<p>Can't connect at this time</P>"); 
else 
echo("<p>Succefully conected to $d</p>") 
?>

1st mistake

Now in if statement you haven't add $ before vaiable name..

2nd mistake..

In the last echo statement you haven't close it with the semi cloumns ';'

Also you doesn't need to write <?php...
it wills imply work with <?

I just want to ask one more think that have you run simple php code like hello world in your system and they work or not..

Or you have change any setting from default installation of php and which version you are using..

Best of luck for your code though

fetch

In addition to the problems that you folks highlight, it turned out that I did not have the mysql extension enabled in php.ini. Oh, Well I guess this is how you learn. Thanks for your help everyone.