12.8. Project

The PHP project is a simple journal-entry manager. Several PHP pages are implemented: a launching point, a page to add an entry, a page to view the last ten entries with the option of searching for matching entries, and a page to view the details about a specific entry. The journal entries are stored in a MySQL database and dynamically displayed in the PHP pages.

12.8.1. Journal MySQL Database

First, the database is created. The database is named journal, and there is one table named entries. The entries table has four fields:

  • id This is a unique integer to identify the entry that the user wants to see displayed; it is an auto_increment field (discussed later) and the key into the table.

  • date This is the date and time the item ...

Get Open Source Web Development with LAMP: Using Linux, Apache, MySQL, Perl, and PHP 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.