[RESOLVED] [PHP] Database interface

[TheBigB]

Have you considered using PDO?

I haven't, but I might, now that I've read that.
Should I be worried about webhosters not having PDO enabled?

I would personally suggest writing methods that allow you to create prepared statements; they are absolutely invaluable and remove the chance of a user opening themselves up to SQL injection.

I've never worked with them in PHP but I see PDO has support for prepared queries, so I might consider that.

try taking a look at CodeIgniter http://codeigniter.com/ look through their Database Class in the User Guide ... should give you a pretty good idea of what to look for.

-tg

After a quick glance I at least found one function I really like;

$data = array(
               'title' => $title,
               'name' => $name,
               'date' => $date
            );

$this->db->insert('mytable', $data);

// Produces: INSERT INTO mytable (title, name, date) VALUES ('{$title}', '{$name}', '{$date}')

PDO would be awesome, but the only question that remains is scale of deployment.
Thanks for the suggestions so far.