Prashanth Sivoththaman (8693247)
Rafi Biouss (300018927)
Gabrelle Duenas (300081950)

G-inder is an online gamer database where different players from different games can put up posts looking for other people to play with. In each of these posts players will discuss what kind of players they’re looking for whether it be purely to have fun with others, or it be skilled based if someone is looking for a person of similar ranks in their game.

This project utilizes html and css to create the front end of this website.

Php is the server language used to communicate, write data, and fetch data from the databases on the backend

html is used in create_post.php, createprofile.php, find_gamers.php, homepage.html, report.php

css is used in: styles.css

php is used in : create_post.php, createprofile.php, find_gamers.php, report.php and post.php

The database langauages used are mysql and sql

This project requires php 8.1.3 to be installed https://windows.php.net/download#php-8.1

The server technology we chose to integrate was php.

Install XAMP so that website can be run from local host XAMP server https://www.apachefriends.org/index.html

Install files for phpmyAdmin https://www.phpmyadmin.net/

The database technology we chose use was MySQL

MySQL was run using phpmyadmin

(instalation instructions for phpMyadmin)

Install files for phpmyAdmin https://www.phpmyadmin.net/

the other databse we used was pgAdmin

link to install

https://www.pgadmin.org/download/pgadmin-4-windows/

move GINDER project into XAMP\htdocs in your C directory

open XAMP, and click start for both APACHE and MySQL

on your webbrowser type this link: http://localhost/Ginder/homepage.html

Setup postgres database

1.open Pgadmin 2. Right click "Database" 3. Click Create.. 4. Click Databse 5. Name the database GinderDB 6. right click on GinderDB 7. click restore 8. select "GinderDatabase"

Background gradient goes from top to bottom from dark blue to light blue

Letters are white with a dark grey background for easibility to read

Grey background boxes are bordered with black for organizing and easier to distinguish sections

Font is Calibri in order to make the words very easy to read

Title of website is size h1 to draw your attention first

Subsections is size h2 to draw attention second

Paragraphs are wrriten with size 12 for easibility to read and not too big to take up too much space

Icons-REPORT A PROBLEM.png was used for the report a problem icon

th.png was used in the homepage.html page in the website details section

radio inputs, and drop downs inputs were used in createprofile.php and create_post.php

The dropdown inputs allows for users to select their skill level

A navigation bar is used to go from website section to another efficiently.

Setup phpmyadminDB

open XAMP, and click start for both APACHE and MySQL Click the "Admin" button for the mySQL row

Setup postgres database

1.open Pgadmin 2. Right click "Database" 3. Click Create.. 4. Click Databse 5. Name the database GinderDB 6. right click on GinderDB 7. click restore 8. select "GinderDatabase"

The table profile contains the attributes fname (first name), lname (last name), email, gender, gtag (gamertag), console, skill, and description the values are inputted and processed by createprofile.php

The table entitygamerposts contains the attributes gamertag, console, rank, skill, and descriptipn,
the values are inputted by the create_post.php

This feature allows a user to register their profile to the website.

On page createprofile.php, user inputs their information, then clicks submit.

The data is processed by the php page and posted to the database

This feature allows a user to report a problem they may have with either the site, or the users on it.

On page report.php, user inputs the problem they have, then clicks submit.

The data is then processed by the php page and posted to the database

This feature allows a user to create posts under their gamertag

first user navigates to create_post.php

next user inputs the required fields in the create post form and clicks submit

The form then posts to the database

This feature allows the user to find the information and post of a desired game once the user types in the gamertag ame, the webpage displays the information of the gamertag

user navigates to find gamer page (find_gamers.php)

user inputs gamertag of desired gamer that the user wants infomation for and hits submit

the webpage then displays the info of that specifc gamer (fetching values from the database)

link to commit history

https://github.com/GDuenas/Ginder/commits/deliverable04

Prashanth Sivoththaman (8693247)
Rafi Biouss (300018927)
Gabrelle Duenas (300081950)