Specifications

Because we have used an event-driven approach again, the backbone of the application is con-
tained in one file, index.php, which calls on a set of function libraries. An overview of the files
in this application is shown in Table 28.1.
TABLE 28.1 Files in the Mailing List Manager Application
Filename Type Description
index.php Application The main script that runs
the entire application.
include_fns.php Functions Collection of include files
for this application.
data_valid_fns.php Functions Collection of functions for
validating input data.
db_fns.php Functions Collection of functions
for connecting to the mlm
database.
mlm_fns.php Functions Collection of functions spe-
cific to this application.
output_fns.php Functions Collection of functions for
outputting HTML.
upload.php Component Script that manages the file
upload component of the
administrator role. Sepa-
rated out to make security
easier.
user_auth_fns.php Functions Collection of functions for
authenticating users.
create_database.sql SQL SQL to set up the mlm data-
base and set up a Web user
and an administrative user.
We will work our way through the project implementation, beginning with the database in
which we will store subscriber and list information.
Setting Up the Database
For this application we will need to store details of
• Lists: Mailing lists available for subscription.
• Subscribers: Users of the system and their preferences.
Building Practical PHP and MySQL Projects
P
ART V
660
34 7842 CH28 3/6/01 3:46 PM Page 660