Hi There,
Got a bit of an interesting one for you.
I'm having a go at writing my very own class. (Ooooo, ahhhhhh, etc.) What it's going to do is have three functions. One to grab some data from a database, a second to filter that data and a third to put the filtered data back into a different database.
To do all my database calls, I'm using ez sql and here-in lies the problem.
Ez sql makes a $db class, which contains various functions and variables all related to database type things. I want to have on 'global' $db instance for the whole of my class, but I can't get it to work.
I can however, get it to work when I define an instance of the db class within the function. This works...
Can anyone point me in the correct direction for what I want to do?
Many thanks,
Jon
Got a bit of an interesting one for you.
I'm having a go at writing my very own class. (Ooooo, ahhhhhh, etc.) What it's going to do is have three functions. One to grab some data from a database, a second to filter that data and a third to put the filtered data back into a different database.
To do all my database calls, I'm using ez sql and here-in lies the problem.
Ez sql makes a $db class, which contains various functions and variables all related to database type things. I want to have on 'global' $db instance for the whole of my class, but I can't get it to work.
Code:
<?PHP
require_once "db/ez_sql_core.php";
require_once "db/ez_sql_mysql.php";
class export_blog
{
var $grabbed;
var $filtered;
function __contruct()
{
$db = new ezSQL_mysql('driversv_oice','keepmoving','driversv_wrdp1','localhost');
}
public function grab()
{
global $db;
$query = "SELECT * FROM wp_posts";
$blogposts = $db->get_results($query);
var_dump($blogposts);
}
public function filter()
{
}
public function import()
{
}
}
$test = new export_blog();
$test->grab();
?>I can however, get it to work when I define an instance of the db class within the function. This works...
Code:
<?PHP
require_once "db/ez_sql_core.php";
require_once "db/ez_sql_mysql.php";
class export_blog
{
var $grabbed;
var $filtered;
public function grab()
{
$db = new ezSQL_mysql('driversv_oice','keepmoving','driversv_wrdp1','localhost');
$query = "SELECT * FROM wp_posts";
$blogposts = $db->get_results($query);
var_dump($blogposts);
}
public function filter()
{
}
public function import()
{
}
}
$test = new export_blog();
$test->grab();
?>Can anyone point me in the correct direction for what I want to do?
Many thanks,
Jon
