For those of you who are interested I have made some transactions from
my sample web application available on my website. They are described
in http://www.tonymarston.net/php-mysql...plication.html
This contains a link to where you can run the transactions online, and
there is another link where you can download all the necessary code to
run offline in your own PHP environment.
Be aware that this code is not for the novice as it contains the
following features:
- It is built around a *proper* 3 tier architecture as there are
totally separate scripts which deal with the data access, business and
presentation layers.
- The data access layer is provided by a DML object which issues all
DML/SQL statements (this version is for MySQL).
- The business layer is comprised of an abstract database class with a
separate subclass for each physical database table. The abstract class
contains a great deal of generic and reusable code, while each
subclass only contains code which is specific to its database table.
There is a separate validation object which deals with
generic/standard/declarative validation.
- The presentation layer (user interface) is comprised of two types of
script: a set of resuable dialog-type scripts which perform specific
actions on specific data structures, and a set of component scripts
which basically do nothing but call one of the dialog-type scripts
with the identity of the objects to work on.
- All HTML output is done via XML with XSL transformations . The XSL
files come in two categories: a set of component templates which deal
with each database table, plus a set of generic reusable templates
which are responsible for creating the HTML code for each type of
control.
Try it. Run it. Download it. Play with it. Examine it.
Don't applaud, just throw money!
Tony Marston
my sample web application available on my website. They are described
in http://www.tonymarston.net/php-mysql...plication.html
This contains a link to where you can run the transactions online, and
there is another link where you can download all the necessary code to
run offline in your own PHP environment.
Be aware that this code is not for the novice as it contains the
following features:
- It is built around a *proper* 3 tier architecture as there are
totally separate scripts which deal with the data access, business and
presentation layers.
- The data access layer is provided by a DML object which issues all
DML/SQL statements (this version is for MySQL).
- The business layer is comprised of an abstract database class with a
separate subclass for each physical database table. The abstract class
contains a great deal of generic and reusable code, while each
subclass only contains code which is specific to its database table.
There is a separate validation object which deals with
generic/standard/declarative validation.
- The presentation layer (user interface) is comprised of two types of
script: a set of resuable dialog-type scripts which perform specific
actions on specific data structures, and a set of component scripts
which basically do nothing but call one of the dialog-type scripts
with the identity of the objects to work on.
- All HTML output is done via XML with XSL transformations . The XSL
files come in two categories: a set of component templates which deal
with each database table, plus a set of generic reusable templates
which are responsible for creating the HTML code for each type of
control.
Try it. Run it. Download it. Play with it. Examine it.
Don't applaud, just throw money!
Tony Marston
Comment