 | Level: Intermediate Tyler Anderson (tyleranderson5@yahoo.com), Freelance writer
(syakovac@gmail.com), Software engineer, Freelance
08 May 2007 This six-part series demonstrates how to leverage the power of XForms in conjunction with MySQL and PHP to create an online accounting tool called X-Trapolate. Every good programming technology possesses a range of problems it excels at solving. The series highlights some of the problems that the XForms solves effectively, such as the need for live calculations and greater interactivity. Part 5 of this six-part series demonstrates how to create a payables form for liability and payment, and a reports form to analyze billing data and statistics.
Prerequisites
This tutorial uses a MySQL database for storage and reference. Necessary SQL commands appear throughout the article, but require a working knowledge of MySQL. PHPMyAdmin offers equivalent access to configure the MySQL database and view the entries from a menu-driven graphical interface. Though the purpose of the series is to educate the reader about the use of XForms, some background knowledge is expected of the reader. There are some very good articles and introductory series concerning XForms available on developerWorks. XForms is built on XML, and, hence, a basic understanding of XML is also assumed. Other technologies and concepts may also be involved, but they will be to a much lesser extent and should be inconsequential to the reader's comprehension of the topic.
System requirements
- A browser capable of displaying XForms, such as Firefox 2.0.1.
- A Web server with PHP enabled, such as WAMP
- An SQL server, MySQL, which is part of the WAMP package in this case.
Duration
1 hour
Formats html, pdf
About this tutorial
In this tutorial, you will be creating a payables form and a reports form. First you'll take a look at its database schema, then the payables XML structure used by the form, the input XML instance data, and lastly you'll see how to populate the payables XML.
| | | |
