I have a Database class that I instantiate with credential information. The
connect method connects and creates a resource by the name $link_id. So if I
do this:

$db = new Database($server, $user, $password, $database);

To get the resource (for use by mysql_insert_id() for example), I use
$db->link_id, so to get the last inserted record:
$id = mysql_insert_id($db->link_id);

Now for my question:

I have another class for creating pages (content). I have a method called
newPage() that accepts 4 arguments: title, content, role_id, display, and

If I need to get the ID of this new page (which is inserted to a mysql table
with an id field with auto_increment), how would I access my database
object? Here is what I have, but first I should provide a brief explanation:
I am trying to pass the database object to any other object that needs to
access the database so that I am assured a connection exists before using
any query methods. So instead of  Database::query($sql), I have

Here are some code snippets:

class Page {

    private $db;                // Contains reference to instance of the
Database class
    private $notify;            // Contains reference to instance of the
Notifier class
    private $URL;

    public function __construct($dbconnection, $root, $id = null)
        $this->db = $dbconnection;
        $this->notify = Notifier::getInstance();
        $this->URL = $root . 'content/';

        if (isset($id)) {
            $result = $this->db->query('SELECT * FROM `content` WHERE
`page_id` = \''. $id .'\'');
            $data = $this->db->fetch_array($result);

$db = new Database($dbhost, $dbuser, $dbpass, $dbname);
$notify = Notifier::getInstance(); // self instantiates
$page = new Page($db, ROOT);

Does this look right? I don't think I've ever seen two -> operators together
like this before...

I don't want to keep connecting to the database, and more importantly, my
Notifier class should only be a single instance, so I need to be able to
amend to a static array variable in that class from within other classes.

Thanks for any help you can provide, and happy holidays!

Reply via email to