Variables problem

[Anon]

Hello. I'm trying to make a script which uses variables throughout the script and functions like this:

<?php
$host = "localhost";
$database = "database";
$username = "username";
$password = "password";

function connect_to_db() {
$db = mysql_connect("$host", "$username", "$password");
mysql_select_db("$database",$db);
}

?>
but it doesn't work.
I've tried to add
global $host,$database,$username,$password;
at the top, but that doesn't work either. How to i do that?

Tnx. Marius

[Anon]

You dont need these "" around you mysql_connect try this

<?php
$host = "localhost";
$database = "database";
$username = "username";
$password = "password";

function connect_to_db() {
$db = mysql_connect( $host, $username, $password );
mysql_select_db("$database",$db);
}

Lee

[Anon]

Your variables holding the database host, username, password, and database, are all outside of the function, thus they are not a part of the function's scope. There are two ways you can get those variables into your function. One is to have them called as global variables. The other is to add them to the function arguments.

/ Pass by arguments /
function connect_to_db($host,$database,$username,$password) {
$db = mysql_connect($host,$username,$password);
mysql_select_db($database);
return $db;
}

/ Global Variables /
function connect_to_db() {
global $host,$username,$password,$database;
$db = mysql_connect($host,$username,$password);
mysql_select_db($database);
return $db;
}

Hope this helps.

-Josh