Software Engineering Practical using PHP/MySQL

Software project: Desktop / Web based
Platform: any

Backend Language: PHP/MYSQL
Frontend: HTML + CSS + JS
Server: Local server (XAMPP/WAMP) / Web Server
Text Editor: Notepad++ / Sublime Text/ VS code etc.

1. Install XAMPP. Download from:
2. Start xampp control panel
3. Start PHP (Apache) and MySQL service
4. Click ‘Explorer’ >> htdocs folder (server root)
5. Create project folder ’21q’
6. Create index.html / index.php file in ’21q’ folder
7. Write some html code in index file
8. Browse http://localhost/21q from any browser e.g. Google chrome
Note: browsing localhost/21q will automatically run the index file.
9. Create a php file test.php and write some php code then browse http://localhost/21q/test.php
Note: to run php program file we must use Local/web server. PHP code must be written in php tag (<?php //program code here… ?> )
10. Create a database and a table in database server by browsing http://localhost/phpmyadmin from any browser
11. Write php code using php/mysql functions to connect and query in database

1. ICT book chapter – 4
2. HTML tutorial / or anywhere