Take the suggested steps in the following slides to construct a database-driven web site:
MySQL and environment set-up,
Studying the exercise specifications carefully,
Database design,
Database implementation,
Web user interface construction,
Calling PHP scripts with embedded SQL, and
Testing the exercise thoroughly.
These steps and software are neither definite nor unique.
You may take other approaches.
MySQL and Environment Set-up
Follow the instructions in the MySQL Help to use the MySQL database.
Also, PHP scripts do not need to be stored in the cgi-bin directory, so the web pages and PHP scripts can be saved in the same folder.
A common mistake made by develpers is misunderstanding the specifications, and it will cause a great loss of time, effort, and budget.
Ask in advance if you have any questions about the specifications.