4. I

MPLEMENTATION

4.1 Introduction 

This section describes the implementation of the whole system and is divided into four 

parts. The MySQL database section describes the structure of the database and explains 

how  it  was  populated  with  20,000  entries  for  testing.  The  sections  on queries.php  and 

multishop.php contain detailed run throughs of the code and describe some of the more 

interesting features and issues that arose along the way. 

4.2 Back end implementation  

4.2.1 The MySQL database 

The MySQL database consists of three tables: clients, category and areacode.  

clients is the table containing the details of each advertiser. Its columns are: 

  bizid   a unique identifier number of the business 

  category   category id of the business; foreign key of cid in the category table 

  bizname   the title of the business 

  street1, street2, town 

  countycode   either the name of a county or a Dublin post code 

  areacode     either  the  national  dialling  code  prefix  without  leading  zero  or   1   

followed by a 3 digit Dublin phone prefix 

  phone 

  web, email 

  picfile, pictext   file location of a picture ad, if there is one, plus some text describing 

said ad 

  shop   URL of an XML database associated with this business, if one exists. 

27