php-mysql-website icon indicating copy to clipboard operation
php-mysql-website copied to clipboard

Database course project

PHP + MySQL Website Example

Config project

  • Edit web/config.php with your database details
$db_host = "localhost";
$db_user = "username";
$db_pass = "password";
$db_name = "database";
  • Place web/ folder in your apache server

  • Init database with init/tables.sql

$ mysql -h hostname -u username -ppassword
mysql> use database;
mysql> source tables.sql;

Run project

  • Insert example data in database (init/insert_data.sql)
$ mysql -h hostname -u username -ppassword
mysql> use database;
mysql> source insert_data.sql;
  • Browse to http://hostname/index.php