Designing the database for our site
We are going to build an example application, so that you will be able to give all this a try. In this case we are going to build a website monitoring program, to help you test websites, keep reports of what has been done in each one, and so on. Firstly, let's set some objectives. These are:
- To manage one or more remote websites with a minimum of human intervention
- To run regular tests on the remote sites
- To generate reports on demand, giving details of the site and of tests conducted
So, the first thing you will need is a database of websites to check. Set up a database called websites in MySQL or whatever RDBMS you're using. You can get all the SQL necessary to create the tables needed in your application in ...
Get CodeIgniter 1.7 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.
