connecting to database

[jwade_m]

Shouldn't there be a $db name = in this code somewhere to connect to a database?



$server = "servername"; // this is the server address and port
$username = "*****"; // change this to your jimmy username
$password = "********"; // change this to your jimmy password


$link = mysql_connect ($server, $username, $password)
or die ("Could not connect");
if (!@mysql_select_db("heartland_meds", $link)) { // leave the database name as anydb for now
echo "

There has been an error. This is the error message:

";
echo "

" . mysql_error() . "

";
echo "Please Contant Your Systems Administrator with the details";
}


?>

[lolly]

I would say yes, without a doubt and not usually a servername but localhost

[LeadMagnet]

It is there

PHP Code:

$link = mysql_connect ($server, $username, $password) 


$db is just a variable name, it can be anything. It can be $catpiss if you want. In this case, he chose $link instead. $server is the server name which is set on the first line.

[jwade_m]

Look at this one and compair the two:

function connect_db()
{
$DBhost = "servername";//change this line
$DBuser = "****";//change this line "****"
$DBpass = "********";//change this line "********"
$DBName = "nameofdatabase";//change this line ""
$conn = mysql_connect($DBhost , $DBuser, $DBpass,$DBName)
or die("There was a problem connecting to MySQL. Please try again later.");

if (!@mysql_select_db("nameofdatabase", $conn))//change this line ""
{
die ("There was a problem connecting to the database. Please try again later.");
}
return $conn;
}

?>




Notice that he has a variable there for the database name.

[Toon]

Originally Posted by LeadMagnet

It can be $catpiss if you want.

Someone's trying to hack my database! Username: usethelittertray!

[LeadMagnet]

Sorry, mis-read it and misunderstood the confusion. Yeah, the database isn't being specified there, you're right.

[coloroutsidethelines!]

Originally Posted by jwade_m

Shouldn't there be a $db name = in this code somewhere to connect to a database?

yes ( Y )

[jwade_m]

Ok. Now when I go to my website and click on a link, I get a blank page. For eample go here HeartlandMeds.com, anesthesia systems support company, anesthesia machines, medical supplies and click on new products. See the blank page. What can be causing this? It's probably something to do with the database.

[Toon]

there's nothing in the source code?

[LeadMagnet]

That could indicate an error in your php code that's causing the script to fail. I recommend turning on error reporting while you're developing code to spot these kinda things.