Need help with creating Admin sections
Posted: Mon Dec 24, 2012 12:00 pm
Hi,
I am creating a sports league site as my first PHP project to learn PHP. I am not using any framework.
My admins are as follows
WebAdmin - Super User (God like) - Can CRUD anything
League Admins - They can CRU League that they belong to. CRUD Teams and Players that belong to their league
Team Admins - They can CRU Team that they belong to. CRUD Players that belong to their team
A league has a name, alias, type, and season. All this info is stores in tables called Leagues, LeagueTypes, and Seasons. There is a bridge table called "LeagueDetails" to store details of the league, i.e. name, alias, type and season. On the NewLeague page the Web Admin can add Name and Alias, then they go on another page to add the type and season.
I am planning to create a Dashboard for WebAdmin with following sections
Users - List of all registered admins
Leagues - List of all leagues currently active (This is a SQL JOIN statement that reads from a bridge table called LeagueDetails, Leagues, LeagueTypes, and Seasons)
That's where I am stuck right now and need help with.
Am I designing the league setup process correctly? Is there a better way?
I am having a hard time to figure out how should I assign the league admin to a league. Any suggestions?
Please guide.
Thanks.
I am creating a sports league site as my first PHP project to learn PHP. I am not using any framework.
My admins are as follows
WebAdmin - Super User (God like) - Can CRUD anything
League Admins - They can CRU League that they belong to. CRUD Teams and Players that belong to their league
Team Admins - They can CRU Team that they belong to. CRUD Players that belong to their team
A league has a name, alias, type, and season. All this info is stores in tables called Leagues, LeagueTypes, and Seasons. There is a bridge table called "LeagueDetails" to store details of the league, i.e. name, alias, type and season. On the NewLeague page the Web Admin can add Name and Alias, then they go on another page to add the type and season.
I am planning to create a Dashboard for WebAdmin with following sections
Users - List of all registered admins
Leagues - List of all leagues currently active (This is a SQL JOIN statement that reads from a bridge table called LeagueDetails, Leagues, LeagueTypes, and Seasons)
That's where I am stuck right now and need help with.
Am I designing the league setup process correctly? Is there a better way?
I am having a hard time to figure out how should I assign the league admin to a league. Any suggestions?
Please guide.
Thanks.