7.4 HTML-Script-SQL Design Example

In this section we will delve deeper into some details of designing a web application though a simple example using HTML, PHP, and SQL. Note that this specific combination of tools may change, and one needs to make sure that the chosen tools will interact together.

A software project that follows the MVC architectural style (see FIGURE 7.4) can be done with three main parts for the detail design:

  1. A HyperText Markup Language (HTML) interface design used for portraying the “view” and the information flow for the application

  2. A scripting language as the engine of the system (we will use PHP) serving as the “controller” for the application

  3. An SQL database that stores the information and acts as the “model” for the ...

Get Essentials of Software Engineering, 5th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial