hello buddies hope you are all doing well welcome to the channel named tuition tonight yes you are at the right place because we are going to create online gym management system using php mysql and bootstrap 4. so without wasting any time let me show you that what we are aiming to create in this video so this is the demo and this is the website just we are going to create today this is the front end of a gym management system as you can see there are many sections in the front end and multiple pages so basically the website consists of a two modules the back end and the front end so let me show you first that how many pages do we have in the front end and then we will go on to the development of a back end then we will just integrate the back end with this front end that i have already created and provide you in the description so you can easily integrate the back end code that you will develop through this video and you will be able to integrate this back in code with the front end that is already given in the description so don't worry about the source code the front-end template and the back-end all the thing is available in description so you just have to stick with us at the end of this video so this is the entire website that we are going to create okay now this time we have an agenda to create the gym management system so first of all this is a request to all the people who are new here please subscribe tuition tonight and subscribe to utafi 1.0 for those people who want a video in urdu and hindi language would you defy 1.0 channel go subscribe carlo now the first thing first download xampp from a google chrome go onto the chrome and write download xampp when you will just write and browse the link the first link will come on the screen that is actually the apache friends.org just download the most compatible version as per your system's configuration or requirement and download the zam because it is the main and important thing for this video and for this project as well all right now you have to go inside the local disk where you have downloaded this apache zoom just go into that local disk and find the folder name xem when you will just go into the zam you have to create a directory name jim and open that folder in your ide that can be visual studio code or sublime whatever you use so it depends upon you on your choice now what we have to do right here we have to create multiple php pages and one folder so first thing is to create a config.php to create the configuration the second should be admin login the third should be the third should be the billing.php the fourth should be coach.php and the fifth should be members.php and the last but not least this one should be reception nest.php all right so basically we just have to put the boilerplate in all the files so we can start the front-end view of the code right so still i am just working over a back end make sure that you have to create on the back end first then you can integrate that with front end now the thing that is important in this project is a boot strap because bootstrap is the main source through which you can make the website responsive so there are two quickest starts the css and the js these are the two links that we need to paste inside our code so we have just paste the css code inside the header and the js code should become inside the body at the bottom of that screen right now similarly do for all the pages that we have created before all right great now boys and girls the thing that is need to be sure that you have to start two services name apache and mysql from xampp control panel because this will be make you in able to search the local host on your chrome browser or whatever the browser you are using you can just find the project folder right so in order to search the project folder that in which you are working on you can just be able to search through that two services when they are started right so basically localhostgym and billing.php is the file that we are going to work on first thing is to just extract the code of navigation bar from the bootstrap 4 website when you just write the navigation bar and just scroll down there you will find this navigation barcode you just have to copy this code inside the billing.php you just have to paste inside the body before that let me just put the comment first because it is the good practice of the coding before you just have to write the code just write the comments so that the code should be visible and prominent that what sections code is there right now you just have to modify the navigation bar as per your requirement so i have just put the billing and in the hyper reference i just passed the file name that is billing.php similarly i am just going for all the links anchor tags right so you just have to follow the video till end and make sure to follow us on instagram the handle name is tuition tonight in order to stay tuned and get connected to know what the upcoming projects are coming all right guys so basically we just have just created the navigation bar and the thing that is important right here is we have to find the logo so for that logo i have a single logo for tuition tonight that we are just using in this project so this is the file that i need to copy and paste inside the gym and inside the img folder that we have created we just have to paste that inside that img folder so let's go just go into the htdocs find gem and inside the image you just have to paste that file and when you just paste the file just go into the image source and give the name all right just copy and paste this navigation bar code inside all the files because all the files have same then same navigation bar so there will be no change so make sure that all the things will be working fine and you just have to go on to config.php to create the configuration between the front end and mysql table so basically you just have to give four instances here with the name of db user name db password db server and db name the db server should be local whose the user should be root and the name should be gem but we haven't created the database so this time we have to go and create database first if you have started the apache service so you can easily go on to the phpmyadmin and when you just click new just give the database name as jim right here just click the create button and give the first table name as billing now it is asking about the columns name you just have to give the id name period and price there should be four columns and all types should be variable character the length should be 20. you can give any of the number lesser than 256 but 256 is the larger number so our our aim is to just take the simple data so for that purpose 20 length is all enough you just have to create a single variable and just write the single function name called my sqli connect all the db initiation should be um call right here one by one db server db name db password and db name right now you just have to go inside the billing.php on the top of the page you have to just create a script with the help of php code you just have to write include config.php in order to inherit the config.php file with this billing.php right now basically we have done some of our work now the thing that is really important right here is to create a form through which we can just get the data from the user and store that data in our database the table that we have created with the name of billing inside the gem database right nphpmyadmin so for that purpose you just have to go again on the bootstrap website and you will just have to write the form right on the top of the screen and when you just write the form you just have to scroll down the page just scroll down the page and find the suitable and appropriate form as per your requirement so then just down go down go down go down yes this is somehow the form that will help us to get the data from the user so i just click the copy button and just paste that code inside my file so this is the entire bootstrap form code right now we just have to put the labels before the input fields so here i have to give the id the name the type should be text and the name should be id that name attribute is very important for php to get the data from the fields make sure to follow on instagram boys and girls please subscribe our channel and follow us on instagram in order to be notified that what upcoming projects are coming in coming days all right after just giving the placeholders these some of the fields are unnecessary so i just have removed that and this is the button that we need for storing the data right so basically the type should be submit remove the label and just um after just refreshing the page there are some errors so inside the config there is a error inside the initiation of that instance with the db password so just i have done a type of mistake inside the billing.php you just have to write the code that can get the data from the field execute the query and store that data into your database table so first you have to create a if block where you have to make sure the submit button will work right so for set request and inside that you have to pass the input name that is actually you have created a submit you just have to create four variables with the name of id name date amount and you just have to create a single variable with the name of ins just pass the query right here as insert into billing put all the columns name the value should be after the value inside the parameter you just have to call all the variables name in order to fetch the data from the field and just store into the columns name that you have already given or mentioned in the first parameter now you just have to create a query just create the query mysqli query function pass the variable's name there i have just done a mistake with the name of a period so you just have to make sure that the name should be same as a variable and the column name that you have created here just pass the table name as bi double ing billing and when you just save the file and run the file you just have to pass the data inside the front and fields when you just click the save button and just refresh the page so you can see that the data has been stored in our table name called billing right so this is how easily you can insert the data from the front end to the back end we are still working over a backend module right uh and similarly you just have to search on to the next file called coach.php inside the course.php you just need some of extra fields um that can be named as date of birth or experience of that coach you just have to copy the entire source code that you have created in billing and just paste again into the course.php file just modify some of the code add some additional fields and your code will be ready to work for coach.php file as well now you just have to create the database table so i have created the coach with the help of four columns all the columns type should be variable corrector and the length should be 20 20 20 right just press the save button go on to the coach save the file just go on to the front and pause the video pass the values inside the fields and then just click the save button and go and check whether the data has been stored in your database table or not and yep we have just stored the data in coach table as well now the third thing is very important right here is to create the members database table so before just going on to the code we are just creating the members database table so you just have to write the columns that are id name date date of birth phone and coach name all should be variable character and the length should be again 20 just pass the length and the save i just forgot to puzzle and just give the length as 20 inside all the fields and after that you just have to click save button on phpmyadmin it will create the database table with the name of members all right now what we have to do is to go on to the members file just copy the forms code go on to the members.php file inside the navigation bar on the bottom of the screen you just have to paste the form and just add some additional fields all right so i have just added three more field with the name of phone the date of joining and the last should be the coach name so after passing all the details you just have to go on the top of the screen just write the php script again you just have to go and copy the code of a billing.php and again you just have to paste inside the members.php just add it or add some additional field re-edit the name of a table just give the proper variable's name inside the second parameter just save the file go on to the front end yes so all the things are now been done save the file go on to the front end inside the coach you will find you will find an error here because there is a simple mistake that we have done here as on the top of the screen it was written member.php but the file name is members.php though so there should be s after member so that's why it is not extracting the front end of my file because the file name is not same now you just have to save that file and just put all the navigation bar same as we have change the members.php right so you just have to done some modification inside all the files because all the files have same navigation bar all right so just save the entire project and just reload the page put the data here and after just putting the data you just have to click the save button and go and check whether it is working or not yes the data has been stored in your table so basically we have done all the things now this is the time you have to work over admin login.php for that purpose you just need a front end code of a login page the stylish frontend template so through this link that you will also find in the description don't worry about the link you just have to go on to the chrome and scroll down the page you will find this code you just have to copy the entire code from that website and paste inside your admin login dot php file just copy the body paste inside the boiler plates inside the body you just have to paint paste the section and after pasting the section you just have to little modify the headings of that code that you can easily done just copy the style just copy the css code and inside the header you just have to give the style and inside the cell you can just paste the css code it will work as an internal css just give the background image as gallery 5 dot img that i have created for this project so inside the navigation bar you just have to give the login page hyper reference right so inside all the file you just have to give the hyper reference as admin login.php whenever the logo should be clicked so it will redirect us onto the login page as you can see that so this is the image that has been extracted but the gradient is little bit awkward so i just have given 2 comma 2 comma 2 all right now we have to just work over the username and password right here so if the user will give admin and the password should be admin so it will be redirected onto the next page that is actually billing.php so for that purpose you just have to write the code inside the php script and you just have to extract the data from that two fields that is actually the username and password and when you just give the username and password as admin so the user will be redirected onto the billing.php page now you just have to create the if block right here and inside the f block you just have to give the field name that is actually submit create a variable with the name of username and here you have to pass the initiation of a post just pass the field name attribute right here as user and pass you just have to give the name here and the first field similarly in the second field you just have to save the code now you just have to create another f block so you have to write user name as equals to z equals to admin and the password should be add password as well here you just have to write the header and inside the header you have to pass the billing.php file name all right so the else block should have an eco printing statement like username or password is incorrect so you just have to write username and or password is incorrect when the admin and password is wrong all right guys so here is a simple mistake that you have to give the action right here as billing.php and the method should be boost and as you can see and i just gave the username and password it just redirected me on to the next page now this is the time we have to create the integration of front end with our back end so this is our front end that i have already created and the entire code of a front-end template is inside the description box so don't worry about the source code and the template code it has already exist in the description you just have to go inside the description and find there [Music] so here are some social media icon through inside these social media i can i just have passed the social media link when you just go on to the about page so this is our about page you can see just go and scroll down these are some section that we have created here inside the course you can just scroll down and see what the courses are here [Music] and as you can see that in the copyright we have already written here a station tonight so you can just edit all the thing and it is free to go right when you just create the tuition net it just redirected us on to the tuitions tonight website so go and check tuition tonight website as well you will find the many project like this on that website as well inside the gallery we just have created a section 4 storing the images inside the blog we just have put the section for a blogging [Music] so some of the articles are already there and when you just click the contact so there is a map and some details related to then organization so this is the entire front end right so we have to copy all these folder and files and just go into the folder folder that you have created of gem and just paste inside that folder so that all the file will be in the same folder of gym now as you can see that when you just go on the back of the code so you will find the admin here you have to pass the link of admin right so now you just have to write here as index dot html to see the code it is giving us an error because we haven't integrated the front end with our back end so here we have to integrate the front end with back end right so we have to give admin login.php inside the hyper reference so inside all the file you just have to search that class and just re-edit the admin hyphen login.php so it will redirect you onto the login page of backend that we have created a while before all right guys great you just have to go back and to scroll just press the inspect and just one time you just have to give the empty cache and hard reload so this is how you can easily integrate the front end with our back end it is giving me an error there will be some issue the issue is that i haven't saved the file in which we have worked on you just have to remove the cache and hard reload after doing the hard reload and all the pages you just have to save the file first i have just done a blender so i am just saving all the file and now all the things are working very fine that inside all the pages when you just click the admin so it will redirect us on to the backend only the one file that is contact that has been saved now when i just click the admin it will redirect us onto the login page so guys tell me how do you like this project if you like this project so please hit the like button and subscribe this channel because we are doing so much effort for you and the response we are just get nothing [Music] many of the people are just watching the video and escape the video um without even subscribing the channel so it is little bit i think that demotivate us so please it is a request to all of you to please subscribe this channel so we can just create so many amazing projects for you so guys as you can see on the top inside the tab we have just changed the icon before gym trainer so when you just click the tuitions tonight or when you just want to find the source code you just let me just deploy the source code for you as well in the github so let me create a repository here i am just giving the description as a project created for youtube buddies i am just creating a repository let me just copy this source code just go on to the gym open the terminal of get bash let me just add all the file and i get just commenting that file with the name of a gym management system so that you will find the entire source code easily just give the remote source name and give the push origin master all right guys so the code has now been pushed onto the github website so you can easily get the code the code the source code of entire project is under description so don't worry about that just go on to the tuition tonight.com as still the blog is not uploaded but the blog will be uploaded in a single day so when you will just see this video the blog will be uploaded into the website so when you just go onto the website you will see a post name create gym management system and inside that gym management system you will be able to find the source code inside the article so if you like this video please hit the like button and subscribe this channel and go and extract the source of code from our website and the frontend template is already there so don't worry about the code so meet you in our next amazing project this is muhammad so wish you a best of luck hit that subscribe button and hit a like button as well so meet you in the next lecture goodbye