Content

2023 LA Angels API Documentation

This API is meant to retrieve data from the database I created about the 2023 Los Angeles Angels. It contains the tables Players, Chart (Depth Chart), Batting, Pitching, Fielding, and Staff. The Players table contains all the players on the Angels' roster in 2023. The Chart table contains information on how each player ranks in terms of their position and playing time. The Batting table contains information on the batting stats of each player that had at bats. The Pitching table contains information on the pitching stats of each player that pitched. The Fielding table contains information on the fielding stats of each player that played the field. The Staff table contains information on the coaching staff of the Angels.

Link:

Angel API App

List of Files:

  • /config/core.php
  • /config/database.php
  • /objects/players.php
  • /objects/chart.php
  • /objects/batting.php
  • /objects/pitching.php
  • /objects/fielding.php
  • /objects/staff.php
  • /product/readplayer.php
  • /product/readplayerone.php
  • /product/readchart.php
  • /product/readchartone.php
  • /product/readbatting.php
  • /product/readbatterone.php
  • /product/readpitching.php
  • /product/readpitcherone.php
  • /product/readfielding.php
  • /product/readfielderone.php
  • /product/readstaff.php
  • /product/readstaffone.php

Players Table

This table contains information of the players on the Angels roster. It contains The pitching ID (Jersey Number), country, position, height, weight, date of birth, age, games played, games started, a description of the player, and the date the player was added to the database.

List of Files:

  • players.php
  • readplayer.php
  • readplayerone.php

players.php

This file retrieves the data from the Players table in the database and is where the read function and readone function is called.

readplayer.php

This file calls the read function and displays all the content in the players table.

Sample Command:

https://matthewsareaofwork.com/AT/angelAPI/product/readplayer.php

Output:

sample output

readplayerone.php

This file calls the read function and displays the data for a specific player from the table using the player ID.

Sample Command:

https://matthewsareaofwork.com/AT/angelAPI/product/readplayerone.php?id=P27

Output:

sample output

Chart Table

This table contains information of depth chart of the Angels in the 2023 MLB season. A depth chart is a where the players on the active roster are ranked based on their playing time per position. This table contains the chart ID, player ID, player firstname, player lastname, position, rank, and date the player was added to the table.

List of Files:

  • chart.php
  • readchart.php
  • readchartone.php

chart.php

This file retrieves the data from the Chart table in the database and is where the read function and readone function is called.

readplayer.php

This file calls the read function and displays all the content in the chart table.

Sample Command:

https://matthewsareaofwork.com/AT/angelAPI/product/readchart.php

Output:

sample output

readchartone.php

This file calls the read function and displays the data for a specific player from the table using the player ID.

Sample Command:

https://matthewsareaofwork.com/AT/angelAPI/product/readchartone.php?id=P27

Output:

sample output

Batting Table

This table contains information of the batting stats of the Angels in the 2023 MLB season. This table contains the batting ID, player ID, player firstname, player lastname, games played, at bats, runs, hits, doubles, triples, homeruns, rbi, walks, strikeouts, stolen bases, hit by pitches, batting average, on base percentage, slugging, ops, and when the player was added to the table.

List of Files:

  • batting.php
  • readbatting.php
  • readbatterone.php

batting.php

This file retrieves the data from the Batting table in the database and is where the read function and readone function is called.

readbatting.php

This file calls the read function and displays all the content in the batting table.

Sample Command:

https://matthewsareaofwork.com/AT/angelAPI/product/readbatting.php

Output:

sample output

readbatterone.php

This file calls the read function and displays the data for a specific player from the table using the player ID.

Sample Command:

https://matthewsareaofwork.com/AT/angelAPI/product/readbatterone.php?id=P27

Output:

sample output

Pitching Table

This table contains information of the pitching stats of the Angels in the 2023 MLB season. This table contains the pitching ID, player ID, player firstname, player lastname, wins, losses, era, games played, games started, complete games, shut outs, saves, save opportunities, innings pitched, hits, runs, earned runs, homeruns, hit batters, walks, strikeouts, WHIP, BAA.

List of Files:

  • pitching.php
  • readpitching.php
  • readpitcherone.php

pitching.php

This file retrieves the data from the Pitching table in the database and is where the read function and readone function is called.

readpitching.php

This file calls the read function and displays all the content in the pitching table.

Sample Command:

https://matthewsareaofwork.com/AT/angelAPI/product/readpitching.php

Output:

sample output

readpitcherone.php

This file calls the read function and displays the data for a specific player from the table using the player ID.

Sample Command:

https://matthewsareaofwork.com/AT/angelAPI/product/readpitcherone.php?id=P17

Output:

sample output

Fielding Table

This table contains information of the fielding stats of the Angels in the 2023 MLB season. This table contains the fielding ID, player ID, player firstname, player lastname, games played, games started, innings, total chances, putouts, assists, fielding percentage, errors, double plays, the date the player was added to the table

List of Files:

  • fielding.php
  • readfielding.php
  • readfielderone.php

fielding.php

This file retrieves the data from the Fielding table in the database and is where the read function and readone function is called.

readfielding.php

This file calls the read function and displays all the content in the fielding table.

Sample Command:

https://matthewsareaofwork.com/AT/angelAPI/product/readfielding.php

Output:

sample output

readfielderone.php

This file calls the read function and displays the data for a specific player from the table using the player ID.

Sample Command:

https://matthewsareaofwork.com/AT/angelAPI/product/readfielderone.php?id=P27

Output:

sample output

Staff Table

This table contains information of the coaching staff of the Angels in the 2023 MLB season. This table contains the staff ID, player ID, staff name, staff jersey number, staff title, date the staff was added to the table.

List of Files:

  • staff.php
  • readstaff.php
  • readstaffone.php

staff.php

This file retrieves the data from the Staff table in the database and is where the read function and readone function is called.

readfielding.php

This file calls the read function and displays all the content in the fielding table.

Sample Command:

https://matthewsareaofwork.com/AT/angelAPI/product/readstaff.php

Output:

sample output

readfielderone.php

This file calls the read function and displays the data for a specific staff member from the table using the staff ID.

Sample Command:

https://matthewsareaofwork.com/AT/angelAPI/product/readstaffone.php?id=1

Output:

sample output