I have a database in which there are teams and every team is working on different projects. Each project then further have tasks.
So, basically, there are three tables.
Now, my user interface contains two things,
I made one sample project and one sample team. I added few sample tasks for that project and also few members for that team and then created sample pages for both project and team.
The page for project displays all the tasks of that Project... Similarly, if I create another project and make page for that, it would correctly display tasks of that 2nd project. The functionality of Adding New Tasks is also working correctly.
The page for Team displays all the members of that team. Similarly, if I create another team, my webpage would show members of that particular team.
My problem is, I want to allow the user to add new projects and new teams. And then allow him to add new tasks into that newly added project and also new members into those newly added teams. This is easy because all the thing is being done on single page
But how do I make new web-pages for those newly added projects and newly added teams? I can't seem to understand this at all. Suppose the web-page for my first project is,
website/project1.php
^This web-page will display all the tasks which are being done under the project of ID = 1. Plus, it allows the user to add new tasks into this project. This much, I have done. But I want to make similar pages for new projects, that have all these functionalities
Now, If a user adds a 2nd project, I want a new web-page to be created as,
website/project2.php
I can't seem to understand how can I do this.
Plus, not only should a new web-page be created but also it should display all the tasks that have project_ID = 2. Moreover, this web-page should also allow the user to add new tasks for the same project (basically, I want to know some way to retrieve the ID of the project from the URL)
And the same should be done for the Teams.
I tried searching this problem up and I am sure it is somewhere answered as well but I couldn't find the right words to look it up. I have been searching for two days and have watched several videos as well but nothing really helped that much.
Please note that I am using XAMPP Local Host for development. I am working with Bootstrap, Jquery/Javascript, AJAX, PHP etc.
I think this one is you want to ask https://www.php.net/manual/en/reserved.variables.get.php
<?php
//header
//main
//From url get id value
$id = $_GET["id"]
include("file/$id")
//footer
?>