AppML case introduction

---

This case study demonstrates how to build a complete <AppML> Internet application with capabilities for listing, editing, and searching information against several tables in a database.

---

What we will create

We will use an existing database called Demo.

For each table in the database, we will:

• Create a prototype model

• Create a prototype HTML page

• Create application model

• Create HTML template

• Create complete application

---

Demo Database

For the case study, we use a subset of the Northwind database that comes pre-installed with MS Office.

This database is well known and easy to test whether using PHP, classic ASP or ASP.NET.

The Demo database contains several tables with data, as shown below:

Customers

##Blondel père et fils 24, place KléberStrasbourgFranceBólido Comidas preparadasC/ Araquil, 67 MadridSpainBottom-Dollar Markets23 Tsawassen Blvd.TsawassenCanada

Customer	Address	City	Country
Around the Horn	120 Hanover Sq.	London	UK
Berglunds snabbkjøp	Berguvsvägen 8	Luleå	Sweden
Blauer See Delikatessen	Forsterstr. 57	Mannheim	Germany

Suppliers

SupplierAddressCityCountryExotic Liquid49 Gilbert St.LondonUKNew Orleans Cajun DelightsP.O. Box 78934New OrleansUSAGrandma Kelly's Homestead707 Oxford Rd.Ann ArborUSATokyo Traders9-8 SekimaiMusashino-shiTokyoJapanCooperativa de Quesos 'Las Cabras'Calle del Rosal 4OviedoSpainMayumi's92 Setsuko Chuo-kuOsakaJapanPavlova, Ltd.74 Rose St. Moonie PondsMelbourneAustralia##Specialty Biscuits, Ltd.##PB Kn ckebr d ABKaloadagatan 13 G teborgSwedenAv. das Americanas 12.890

29 King's Way	Manchester	UK
			##Refrescos Americanas LTDA
S ​​o Paulo	Brazil		Products Produc QuantityPerUnit UnitPrice UnitsInStock Chai 10 boxes x 20 bags 18 39 Chang 24 - 12 oz bottles 19 17 Aniseed Syrup 12 - 550 ml bottles 10 13 Chai 10 boxes x 20 bags 18 39 Chef Anton's Gumbo Mix 36 boxes 21 0 Grandma's Boysenberry Spread 12 - 8 oz jars 25 120 Uncle Bob's Organic Dried Pears 12 - 1 lb pkgs. 30 15 Northwoods Cranberry Sauce 12 - 12 oz jars 40 6 Mishi Kobe Niku 18 - 500 g pkgs. 97 29 Ikura 12 - 200 ml jars 31 31 ← AppML Reference Manual AppML case prototype → submit php.cn HomeCourseArticleQ&ADictionaryManualDownloadsearch APPDownload