| Database Applications |
We assume that one of the reasons you are interested in heitml is because of the ease with which it allows you to access information stored in an SQL Database. For this reason we present here a simple Guestbook Application to demonstrate some of the Tags you could use to perform common Database operations such as inserting, updating, or deleting records, as well as to submit queries that return groups of records from the Database.
We have added a view link to the bottom of each page in this section to make it easier for you to examine the original Source Code that created them. This link invokes the Pretty Printing option of the $debug parameter. It shows everything heitml processes in blue. HTML Tags and text are black, and comments to the Source Code (if any) are red.
The first view of any Source Code file shows the "hei-level" view of the Tags used to create the page. If you click on the underlined link in the include file, or the <BODY> Tag, you will be digging down into the sub-component level where you'll see all of the petty little details you have learned to hate when creating HTML-coded pages. Don't be surprised or bewildered if you don't understand everything going on in the sub-levels at this point. We just wanted to give you a preview of heitml features that will help you to build and manage complex projects of your own.
As you work through the pages in this section, you should keep in mind that there are alternative ways of creating such applications, which we will touch upon in the Advanced section later on.
The Creating SQL Tables example shows how the guestbook was created. You can not execute it because the table was already created during installation. The Source Code shows how different create statements can be used to take advantage of specific Data Types used by various Database Systems.
Creating SQL Tables view Guest Insert / Sign Guestbook execute view Guest Display - Tables execute view Guest Display - Lists view Updating SQL Tables - Insert view Updating SQL Tables - Delete view Guestbook Display by Country execute view Perform SQL-Queries and show Result execute view
© 1996-2008 H.E.I. All Rights Reserved.
