Hi,
I'm wanting to design an interface to the database to make it easier to save/select records to the database etc. Using an off the shelf ORM or framework isn't an option at the moment. So I'm looking to build my own so that existing code can be ported over time.
Currently I've got something like this:
$data->setTables(array('pay_support_cases'));
$data->setFields(array('firstname', 'lastname', 'email', 'question'));
$data->setRequest($_POST);
$data->save();
This simply saves the data in the $_POST array to the table and fields passed in to the set methods. Calling the save method simply generates a query and executes it.
This is going to become problematic with lots of tables etc.
So I would be looking for something like an object for each table so if I had a "user" table I could do:
$user->save();
I'm not sure how best to go about this, can anyone give me any pointers?
Cheers in advance