The data wizard creates a nice CRUD application. However, I
want to create an application probably using a Singleton approach (
probably with Cairngorm ) that can gather data from multiple tables
. For example, if I want to gather data from a Project Table, and
provide the user with a data entry form that also contains a list
of Charge Codes associated with a project.
I am very new to MySQL or any RDMS for that matter as I have
been a Lotus Notes guy for the last 10+ years. I like the approach
the wizard takes in creating one .php file and .as file to handle
the various requests but I'm not sure how best to translate that
into a Singleton approach.
Has anyone done this before? Any good sample code to deal
with a SQL back end?