open db conenction from function??

mykg4orce

why doesnt this work when i call to it???

function OpenDBConnection() {
	require('mysql_config.php');
	$dbconn = mysql_connect("localhost", "$dbuser", "$dbpassword") or dbError();
	$result = mysql_select_db("$dbname", $dbconn) or dbError();	
}

PHP] 

i basically dont wanna be using those 3 lines everytime i need to open a connection so i wrote it to a functions.php file and i am calling it from another file in the same directory like this "OpenDBConnection() ;" followed by the query.

thanks in advance...

TTT

doesn't return anything

edon

You need to either include a return statement to pass the the result to your main script or declare as global any variables you want to pass back to your main script.

I got the above from my php book. I did not post any examples because I an a newbie and did not want to make any mistakes that might cause you confusion.

Regards,
Edon

ahundiak

Actually, you probably don't really need to return anything unless you plan on having multiple database connections. And I assume you are not trying to use $dbconn elsewhere in your code.

The problem is that $dbuser,$dbpassword and $dbname are not in scope and thus cannot be used by the function.

You need to pass them as arguments or use
global $dbuser; inside of the function.

Now it may be that mysql_config.php is supposed to take care of these values. Try echoing out $dbuser as include files can be a bit tricky inside of functions.

mykg4orce

k thx...im gonna see wats goin on...