using my database class inside other functions - "Fatal error: Call to a member"

[dougans]

Hey there,

Hope someone can help me, completely stuck with immigrating from php4 to OOP based php5.



==
index.php
--
[PHP]include(databas e.inc.php);
include(functio ns.inc.php);
include(game.in c.php);[/PHP]
====

==
database.inc.ph p
--
[PHP]$query_count = 0;

class database extends mysqli
{
// Redefine the parent method
function query($query)
{
global $query_count,$q uery_log,$confi g;
$query_count++;
if ($config['query_logging'])
{
$query_log .= '<li>'.$query;
}
//echo "<br>counte d query: total $query_count<br >\n";
return parent::query($ query);
}

function return_first_re sult($query)
{

//
// EXAMPLE USAGE
//
//$test = $db->return_first_r esult("SELECT * FROM user_sleep");
//echo $test['assoc_id'];

return $this->query($query )->fetch_assoc( ); // THIS IS LINE 45!!!!!!!!!!!!! !!!!!!!!!!!!!!
}
}

$db = new database("local host", "db", "pass", "db");
/* check connection */

# Check the connection and print an error and stop the page if it can't connect
if (mysqli_connect _errno()) {
printf("Connect failed: %s\n", mysqli_connect_ error());
exit();
}[/PHP]
====

==
functions.inc.p hp
--
[PHP]function government_sett ing($setting)
{
global $db;
//$test = $db->return_first_r esult("SELECT * FROM user_sleep");
//echo $test['assoc_id'];
$gov_info = $db->return_first_r esult("SELECT $setting FROM `government_set tings`");
return $gov_info[$setting];
}[/PHP]
====


==
game.inc.php
--
[PHP]echo government_sett ing('treasury_n ame');[/PHP]
====


Fatal error: Call to a member function fetch_assoc() on a non-object in /var/www/vhosts/europa100ad.com/includes/database.inc.ph p on line 45


I know the problem (or at least I think I do). The problem is with using the $db class inside my functions. I've tried adding global $db, or using the $GLOBALS['db'] and nothing seems to work...

My question is how can I use my $db class inside my functions?? I'm hoping I don't have to declare a new DB class in every function I plan to use the databse connection.

And I would prefer not to make my functions an extension of the DB class because I have currently 376 functions that are all split up and seperated evenly and neatly across the whole site. Just doing the tedious task of re-writting the site in PHP5, and I know most of my code would work in php5 but I want to give this Object Orientated Programming a bash for later use in other projects.

Thanks in advance, hope someone can help!

KD

[dougans]

Well I took it upon myself to add some debugging code and wallah, i'm now getting somewhere... my SQL query was failing, and because I was too lazy to add in some error checking I got a really unhelpful error.

I recommend the following to everyone:

[PHP]$result = $db->query($query );
if($result === FALSE)
{
die("Query failed: $query <br>\n".$db->error);
} [/PHP]

[pbmods]

Heya, dougans. Welcome to TSDN!

Were you able to get it working?

[dougans]

thanks for the welome and yeah, i got it going, got a new problem though and going to post it in a couple of minutes.

[pbmods]

Heya, Dougans.

Sounds good. We'll be ready for you :)