create a database server

the purpose of the database server is to store an application of multiple users, using php to maintain the data.

the requirements

-xampp v3.24

MySQL Server version: 10.1.30-MariaDB- mariadb.org binary distribution

-PHP version : 7.2.1

-Chrome version 83.0.4103.116 (Official Build) (64-bit)

steps

1. start xampp and start mysql and apache service
2. access localhost /phpmyadmin via chrome
3. create a new database called my game
4. create a new table called users and add fields
5. in note pad ++ add connection string and sql to insert a new user
6. test using chrome and connect any errors

Problems/solutions:

1. errors in script due to spelling
2. duplicate primary key, to fix that, use unique username

testing/ quality

1. add a username , check phpmyadmin to see if it has inserted
2. add another, check if database primary keys work