Problems connecting to webserver

[NetRoam]

Hey all

For some reason the webserver I have don't like my connection code because I can't get access to my database at all.

I know that the provider has put register_globals = off and I'm not sure if it's possible to change, because I have had to change a lot of code to make the site work with register_globals at off.

In the top of the code in my index.php is this:

<?
include ("common.php");
connectDatabase();
?>

Common.php includes this:

<?
$dbHost = "";
$dbUser = "";
$dbPass = "";
$dbName = "";

function connectDatabase()
{
global $dbHost, $dbUser, $dbPass, $dbName;

if (!($link = @mysql_connect($dbHost, $dbUser, $dbPass))) exit("Couldn't connect to database server");

if (!@mysql_select_db($dbName)) exit("Couldn't select $dbName database");
}
?>

The way I see it it should work quite fine - which it also does when I view it locally, but the problems come when I upload it to the webserver. Anyone have an idea why?

/// NetRoam

[Norman_Graham]

Hi Netroam

Why have you written a function to do what PHP does already? The only function you need is mysql_connect():

 
$dbHost = "***"; 
$dbUser = "***"; 
$dbPass = "***"; 
$dbName = "***"; 

$link = @mysql_connect($dbHost, $dbUser, $dbPass) or die("Couldn't connect");

$db_link = @mysql_select_db($dbName) or die("Couldn't select $dbName database"); 

HTH

Norm

[NetRoam]

Not sure why I made it a function but that doesn't matter because even though I made it the way you wrote - it still didn't work, so it didn't have anything to say

[NetRoam]

Never mind - I figured it out through a great friend of mine. Turns out the provider screwed up big time when supplying me with the information for the databasehost and username/password so we found out after looking in the phpinfo(); that the host had changed and that I needed to use different usernames and passwords

Thanx anyway 🙂