Goals:
Some of the goals of this site include:- Allowing the user to navigate the site cleanly
- Allow the users to digest information about the LA Angels presented cleanly.
- Allow Admins to edit and update the database throught pages on the website.
- Allow users to learn more about the Angels.
Files
cfd.php: Allows access to the database.
Header.php: Displays the top portion of the page, this includes the navigation bar with links to the other pages.
Turns into a hamburger menu when it reaches a certain breakpoint.
Index.php: This displays the homepage of the site.
Note! - AI was used to write the description paragraphs on this page (Approved by MJ).
Footer.php: Displays the bottom portion of the page, this contains links to the social media of the LA Angels.
Register.php: Allows the user to register for an account.
Login.php: Allows the user to login to their account.
Logout.php: Allows the user to logout and destroy their current session.
Userhome.php: Display page which holds links to other pages and shows the user's favorite players.
If they have admin access a separate bar will appear with links to the admin pages.
Roster.php: Displays the entire roster of the Angels, has a navigation bar to sort by letters.
Player.php: Displays the individual player and their information when selected in the roster.php page.
Has a feature that allows the user to add the player to their favorites list that can be viewed in userhome.
Unfortunately you cannot unfavorite players because the user doesn't have delete permissions.
Stat.php: Displays three tables: Pitching, Batting, and Fielding.
Each contains the respective stats for each player.
Transactions.php: Displays the transactions of the Angels. You can click on the player img and name and it will direct you to their page.
Admin Pages:
Add_Roster.php: Allows the admin to add a player to the database.
Add_Transaction.php: Allows the admin to add a transaction to the database.
Add_Stat.php: Allows the admin to add stats to a player.
Update_Player.php: Allows the admin to update a player in the database.
Update_Stat.php: Allows the admin to update a player's stats.
Update_Transaction.php: Allows the admin to update a transaction.
Here is the final ERD
Summary
This project has helped me gain a deeper understanding of how php works and how it interacts with a database. I had some difficulties in figuring out how to make certain pages work. One example would be update stats page. This page was a bit difficult since players either have batting or pitching stats. I found a way to make it work by having the page check to see if the selected player has stats in any of the three tables and if not, it won't let you update that table. Although some of the functionality of the site was a bit frustrating, it was satisfying to finally get it working. I did find the design aspect of this website quite fun to create. I ended up learning many new things about css because of this project. Looking back, there are some design layouts I wish I used but overall I am happy with the final result. I believe I have met the goals I have set out for this website. Goals such as allowing the user to learn more about the Angels, navigate easily, admins to edit the pages through the admin pages, etc.