Can't connect to database

Ewwa

I use the following code.I run it on the server, there is a parse error. I don't know why.Thank you!

<html>
<head>
<title>
</title>
</head>
<body>
<?php
$user="llama";
$pass="osti"
$db="llama";
$link=mysql_connect("localhost", $user,$pass);
if( ! $link)
die("couldn't connect to MySOL");
print "successfully connected to server<p>";
mysql_select_db($db)
or die ("couldn't open $db:".mysql_error() );
print "successfully selected database\"$db\"<p>";
mysql_close($link);

?>
</body>
</html>

Moonglobe

well, personally, i don't like that style of coding......... try this:


<html>
<head>
<title>
</title>
</head>
<body>
<?php
$user="llama";
$pass="osti"
$db="llama";
$link=mysql_connect("localhost", $user,$pass);
if( ! $link) {
    die("couldn't connect to MySOL");
}

print "successfully connected to server<p>";

mysql_select_db($db) or die ("couldn't open " . $db . ":" . mysql_error() );
print "successfully selected database\"" . $db "\"<p>";
mysql_close($link);


?>
</body>
</html>

alanzhao

your script seems to be right, so double check your username, password, database and host name with your server.:rolleyes:

frog

You need a semi-colon after $pass = "osti"

<html>
<head>
<title>
</title>
</head>
<body>
<?php
$user="llama";
$pass="osti";
$db="llama";
$link=mysql_connect("localhost", $user,$pass);
if( ! $link)
die("couldn't connect to MySOL");
print "successfully connected to server<p>";
mysql_select_db($db)
or die ("couldn't open $db:".mysql_error() );
print "successfully selected database\"$db\"<p>";
mysql_close($link);

?>
</body>
</html>

Don't worry about your code, it will get tidier as you learn more🙂

Elizabeth

You should also add an "else" line, otherwise "successfully connected to server" will print every time, regardless. (And I would move the if line to one line, personally.

if( ! $link) die("couldn't connect to MySOL"); 
else print "successfully connected to server<p>";

hth-
Elizabeth

Moonglobe

um... doesn't die stop executing the page as soon as it's called?

cgraz

yes, die does stop the executing of the script.

But on another note, when running mysql_query and running into problems, it would be much better to use

or die(mysql_error());

then

or die("query doesn't work");

The first error is MUCH more useful in discovering the problem than is the latter error message. The first one actually tells you what the problem is. The second one just outputs what you want. You can change the query to the 2nd one when your site goes live and it's all up and running.

Cgraz

Elizabeth

LOL- yes, you're right- how did I not see that "die" there? Thanks for correcting me, guys-

...going back to the Echo Lounge where I belong 😃
-Elizabeth

p0pb0b

hey alanzhao, I think I know you from somewhere, can you contact me? my e-mail: playa4real6969@yahoo.com