- Verify that your PHP has MySQL extensions installed
- Set up a MySQL server to run on the same machine as the web server
- Create a database called "sample" in your MySQL server
- Create an account with username "test" and password "test" that can be used
to access "sample".
- Import the table "sample.sql" (located in the "phpdemo" subdirectory) into the "sample" database
Column Name | Type |
---|---|
TimeStamp | Date/Time |
Hardware | Number |
Software | Number |
Services | Number |
Each row in the database table contains monthly revenues for the business units, where the date is stored in the "TimeStamp" column. The sample database contains rows from Jan 1990 to Dec 2001.