Posted by Henk Verhoeven on 05/15/06 00:51

Colin McKinnon wrote:
> Anybody any suggestions?

Hi Colin,

Imho a database abstraction layer is used to make the same application
code work on several databases. It sounds like what you are looking for
is more like an application framework. If you are willing to replace "an
array of data" by "an object holding data", phpPeanuts can take care of
either INSERT or UPDATE the data to MySQL, depending on the result of
$this->isNew(). The code that does it is actually situated on a class
that will serve as a database abstraction layer once a need for the
usage of several databases arises. Of course with objects you get much
more abstraction then just database abstraction, like polymorphism,
navigation over relationships. PhpPeanuts also adds navigational queries
(also available in QBE User Interface). Using SQL directly is possible
in several places, but has the disadvantage that the proper JOIN's will
not be made automatically, like it is done if you use the Query Model.

Greetings,

Henk Verhoeven,
www.phpPeanuts.org.

[Back to original message]