connecting to database

[jwade_m]

How can I do this in Dreamweaver? (turn on error reporting)

[LeadMagnet]

lol, you don't.
You edit the php.ini file on the server.

[jwade_m]

Ok. Slightly different question now. Look below at the two sets of code. These are from two different connection files. They are coded differently, but will both work?

first set

$server = "mysql.hostname.com"; // this is the server address and port
$username = "fakeuser"; // change this to your jimmy username
$password = "passnotreal"; // change this to your jimmy password
$dbname = "databasename";

//User u70353840 with password 'f78c8' added to d60324644.
$link = mysql_connect ($server, $username, $password,$dbname)
or die ("Could not connect");
if (!@mysql_select_db("databasename", $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";
}


?>



second set
function connect_db()
{
$DBhost = "mysql.hosthost.com";//change
$DBuser = "fakename";//change
$DBpass = "fakepassword";//change
$DBName = "nameofdatabase";//change
$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
{
die ("There was a problem connecting to the database. Please try again later.");
}
return $conn;
}

?>

[tommylogic]

explain exactly what it is you are trying to connect.. ie: MovableType, WordPress, Joomla!, etc. And are you trying to do this on a local machine or a live database on the web?

[LeadMagnet]

The first one is the more usual way of doing it, but the second will work if connect_db() is called. Since $conn isn't global, you need to type something like

PHP Code:

$foo = connect_db(); 


not 100% on that.
$foo will be your link after that. It's not a bad way of doing it if you plan on re-using the code lots.

[tommylogic]

I see from your other posts that you are trying to connect Dreamweaver to a local database on your machine... you might take a look into this...

Video Tutorial | Testing Server & Dreamweaver

[jwade_m]

thanks guys

[tommylogic]

hope that solved your problem

[LeadMagnet]

push teh buttons and teh internets works

[jontywagener]

heres my two cents:
i quite like this kind of mysql connection script, i spose u could use it for postgresql without too much difficulty.


// add your information here.
define(HOST, 'localhost');
define(USER, 'yourusername');
define(PASS, 'yourpassword');
define(BASE, 'yourdatabase');

/// --- you would not really need to edit below here --- ///
// add some connection error handling so that we get a nice error.

// check the connection string.
if(!@mysql_connect(HOST, USER, PASS)) {
echo "Database could not be connected to. Please check your settings";
}

// then we check the selection string.
if(!@mysql_select_db(BASE)) {
echo "The database selection could not be completed. Please check your settings.";
}

?>

im probably a little late but anyway :)