[SOLVED] How to Access Database Anywhere in App

[jadedknight]

Hey, I am trying to get better at PHP by building myself a CMS but I am stuck. I am programming functionally, I know there are OOP solutions, and solutions that involve libraries such as PEAR but I am not interested in those.

 

Basically, how am I able to access a database connection anywhere in my application, for example in a function. This is my current code:

<?php require('db.php');
function preferences() {
	$query = "SELECT * FROM preferences WHERE id = 1";
	$result = mysql_query($query) or die('Query failed: ' . mysql_error());
	echo $result;
}
?>

 

I have included the database connection information but it does not connect, I am guessing due to variable scope. How do I get around this without creating a new connection inside every function.

[bilis_money]

include 'db.php';

[jadedknight]

include 'db.php';

 

Is that not the same as require?

[jadedknight]

Well, I did try include, same result. Read the PHP manual, the functions are nearly the same. Any ideas anyone?

[corbin]

When an SQL connection is not specified in a MySQL function call, the open connection is assumed.  Therefore, if you have a connection open before you call the mysql_query function, it will automatically find it.  So, I don't think it's a variable scope problem.

 

Can you post the code from db.php (remove the user/pass if you want).

[jadedknight]

Ok I was able to get it to work by including the db into my main index page. But now I get this error when retrieving a row:

Resource id #5