need help in connnecting mysql from php

ramu_rp2005

I've a php code from which i need to connect to database.but the page is not displaying anything.mysql password is ramki.

wht do i do now?is there any probem with php connecting to mysql.how do i test it.

rincewind456

It might be an idea to use [man]mysql_error/man to see what the problem is.

$db = mysql_connect("localhost", "root", "ramki") or die(mysql_error());

if there is an error it might help point you in the right direction.

Roger_Ramjet

Writing php code would help - what you've written there will not work because it is not php so it is not going to output anything.

bradgrafelman

Roger Ramjet wrote:
Writing php code would help - what you've written there will not work because it is not php so it is not going to output anything.

Uh... yes it is PHP code? At least, the stuff between the <?PHP ?> is...

Now, you say it's not outputting ANYTHING. If you right click and view source when you view it in the browser, do you see your HTML tags being outputted?

Definitely try to debug the connection part of your script as noted in rincewind's post.

Roger_Ramjet

if($db)
echo "conn successful";
else
echo "conn not successful";

IS NOT CORRECT PHP SYNTAX: so it is not php. It is pseudo-code really because I can't think of any language where that would work as written.

bradgrafelman

Works just fine in PHP. What's wrong with it? I use code like that all the time.

EDIT: Example:

$db = TRUE;

if($db)
echo "conn successful";
else
echo "conn not successful";

Output was 'conn successful' when tested in browser.

rincewind456

Roger Ramjet wrote:
IS NOT CORRECT PHP SYNTAX.

Where in the manual does it say that?

Roger_Ramjet

While it is certainly true that you can write

 $db = TRUE;

if($db) echo "conn successful";

Nowhere do I see it say that you can write

else echo "conn not successful";

Now, it may just be that it does work like that. If so then it is undocumented, and not something that I've ever tried to do.

bradgrafelman

'Tis simply an [man]if[/man]/[man]else[/man] statement...

Roger_Ramjet

Der!! Of course it is, but as far as I know it will throw an error because the else statements are not eclosed by {}. And now I'm unsubscribing.