Install XAMPP from https://www.apachefriends.org/index.html.
You would need only those components: Apache, MySQL, PHP, phpMyAdmin.
Download project files and place them at the XAMPP's website root.
In the case of default setup it should be C:\xampp\htdocs\, but you can have any specific location via step 2.1.
vHost is normally needed if you plan to have multiple apps/websites on the XAMPP, so if PeopleDB would be the only one you can safely skip this step.
2.1.1. Set your desired application URL in the Windows hosts file.
You would need to put string like
127.0.0.1 peopledb.localhost
at C:\WINDOWS\system32\drivers\etc\ file.
You can use any name instead of peopledb.localhost
2.1.2. Create vHost in XAMPP
You would need to put
<VirtualHost *:80>
DocumentRoot 'C:/xampp/htdocs/peopledb/'
ServerName peopledb.localhost
</VirtualHost>
at C:\xampp\apache\conf\extra\httpd-vhosts.conf file.
DocumentRoot can be any folder, it does not required to be inside of the XAMPP folder
2.1.3. Check that C:\xampp\apache\conf\httpd.conf has vHost configuration applied.
Its lines should look like that (without # in front of second line):
#Virtual hosts
Include conf/extra/httpd-vhosts.conf`
2.1.4. In case of choosing directory out of XAMPP htdocs folder you should also add these lines (with directory replaced by the DocumentRoot from step 2.1.2) to the httpd.conf file:
<Directory "D:/PeopleDB/">
Options Indexes FollowSymLinks MultiViews
AllowOverride all
Order Deny,Allow
Allow from all
Require all granted
</Directory>
2.2.1. Setup port (optional)
If you want to MySQL to run on another port you can change it from default value 3306 to another one
2.2.1.1. Change port number at C:\xampp\mysql\bin\my.ini. Replace port number at two places:
# The following options will be passed to all MySQL clients
[client]
# password = your_password
port=3306
socket="C:/xampp/mysql/mysql.sock"
and
# The MySQL server
default-character-set=utf8mb4
[mysqld]
port=3306
socket="C:/xampp/mysql/mysql.sock"
2.2.1.2. Add info about port for the C:\xampp\phpMyAdmin\config.inc.php.
Add string with new port value to the file:
$cfg['Servers'][$i]['port'] = '3307';
2.2.2. Create user
2.2.2.1. Launch XAMPP and MySQL through XAMPP control panel, then open phpMyAdmin via SQL's Admin button.
2.2.2.2. Create user through user accounts tab.
By default you should create user with user name php_test, password password and all privileges, but you can adjust login information in a way it is needed.
Create new schema peopledb and import peopledb.sql file from source code there through SQL tab.
If you had change mysql port, schema name, username or password - adjust connection.php file to corresponding values. e.g.
<?php
$host = 'peopledb.localhost:3307';
$database = 'peopledb';
$user = 'php_test';
$pass = 'password';
?>
Launch XAMPP and re-/start Apache and MySQL.
Open localhost (or any name you could have setup at step 2.1., e.g. peopledb.localhost) and you are ready to go
Download project files and replace the one you have with the new ones
Import all migrations files migration/migration-YYYY-MM-DD-vX-X-X-X.sql which were added after the release you were
using through SQL tab of XAMPP's phpMyAdmin
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent