Most applications are CRUD based, that is, users can create data, retrieve data, update and delete data from such applications. As an experienced or a new developer, knowing how these works is important. This course is a guide to showing you how CRUD applications are built with PHP/MYSQL. You'll use
Some Main Features:.
In this lecture you will install xampp software on your computer if you don't have it installed.
In this lecture we'll go through installing brackets text editor in case the student wants to use brackets.
In this lecture we'll create our project and its required files and folders.
In this lecture we'll create mysql database in phpmyadmin.
Here we will create a connection between our project and mysql database.
We will include the required bootstrap and JQuery links in our project.
Sessions are used to stored values in variables to be used across multiple pages. We need to create the sessions in a file that will be included in all pages in our project. So we'll create sessions in our database connection file.
Add bootstrap navbar to index page.
Add bootstrap tabs on the index page that will display login and registration forms.
Add registration form and display inside the bootstrap tab.
Add css and bootstrap styles to registration form.
Add validations to check that the input fields are not empty when the user submits the form.
Add html elements with ids to display errors. Also add css property to the elements.
Add other custom validations to the form fields.
Send data from form fields to php script to be processed and saved to the database using AJAX method.
Create signup table in the database to store users registration data.
Get the data from form and query the database with mysqli select to check if user email already exist.
Check the form fields with php to make sure they are not empty.
Clean the form data and perform validations on the form data with php.
Write mysqli insert query to insert user data to signup table in database.
Add some more validations to the form fields.
Insert user data and view in the database.
In this tutorials we are making use of swiftmailer plugin to send emails to users after registration. In this lecture we download and add the plugin to our project.
Add the swiftmailer script to send email to users after registration.
Add page to display message to user after email verification.
Include bootstrap alert messages to user email verification page.
Select user activation key from url and database.
Update user data in signup table after email verification.
Including the activation script in the user email verification page and also add the alert messages.
Verifying a new user email and viewing in the database.
Add a new column to signup table in database with a default value which will be used for hashing user's password.
Get the column with default value from database and use it with php crypt() method to hash the password.
Add user login form to bootstrap tab on index page.
Change names and ids of fields in user login form.
Add JQuery validation to user login form.
Fix the problem with page reload when user login form errors are displayed.
Select user email from database which is used to check if user email exist.
Add validations to login data and fetch user data from database.
In this lecture we use the php crypt() method on the user login password and also save user data in sessions.
Here we display the user data stored in sessions when the user logs in successfully.
Add error messages to login form to be displayed if user login fails.
In this lecture we allow only users that have verified their account to login. We'll make use of a value in the signup table.
Add a form for users to add their email address so they can reset their password.
Select user's email address from the database.
Add the swiftmailer script so the user can receive a link in their inbox that will take them to the password reset form where they can add a new password.
Here we test to make sure that the password reset link is sent to the user.
Add form that will allow user reset their password.
Get the user activation key from url and also encrypt their new password.
Select user activation key from database, validate new password and update user password in database.
Update a user's password and view in the database.
In this lecture we'll add a logout script that will take the user to index page.
Add bootstrap navbar to homepage. This is the page that the user will be taken to when he/she logs in.
Add files to project that will allow users to complete their profile, display their data and as well update their data.
In this lecture we'll add bootstrap corousel to the homepage.
Add html and css to user page where they will complete their profile.
Add form to insert user data to database.
Add more fields to form
Create user profile table in the database. This table will hold user data that will be added after registration.
Fetch data from signup table in database and display in the form for inserting data to the profile table.
Get new user data from form fields.
Insert user data to profile table in database.
Add html and css to page where user data can be viewed.
Create functions that will be used to display user's data.
Add elements to hold user data inside the functions created.
Add styles to user profile page.
Add form that will be used to edit user data.
Fetch user's data that already exist in the profile table and display in form form fields.
Add mysqli update query to update the user data in the profile table.
Update a user's data and view in the database
Create a function that will fetch all users with data in the profile table.
Note that some users may be verified but don't have data in the profile table.
Add bootstrap thumbnail to display the user's image on the homepage.
View data of other users displayed on the homepage.
Display data of sign in user on homepage.
Show only update profile page link and view profile page link to a user that has data in the profile table. But for a user that is verified but has no data in the profile table, show the link to complete profile page.
Add admin login form inside the bootstrap tab in the index page.
Add admin table in the database with email and password columns which both have default values.
Add the admin login script to admin folder.
Here we insert a row to the admin login table in the database. The row which has an email and password columns will take the default values added to the email and password columns.
So the admin can only login in with the default email and password inserted into the row.
Add bootstrap navbar to admin dashboard.
Add links to sidebar in the admin dashboard. Create required files for the links.
Add css styles to sidebar links. Also add font awesome icons to the links.
Add and style admin email stored in a session to the dashboard navbar.
Add html inside the pages in the sidebar.
Display all users in the signup table using a table in the view all users page.
Display all users in the profile table using a table in the verified users page.
Note that all users with data in the profile are verified users.
Display all users in the signup table that are not verified using a table in the not veirified users page.
Add delete functionality so admin can delete a user's data from the database.
Add bootstrap panels to the admin dashboard.
Add font awesome icons to the bootstrap panels.
Add functions to get the number of rows of all users in the signup table, verified users in the profile table and not verified users in the signup table.
Add more styles to bootstrap panels.
Get chart script using google column chart and add to admin folder.
Fetch values from database and add to chart script.
Display column chart on dashboard.
Add the plugin to change the date format in the tables inside the admin.
Add the plugin to other pages in the admin.
Add logout link and script to the admin dashboard.
Add search form to navbar in the user's homepage.
Send query to mysql database to get the user's search request.
Display the user's search result if found.
Add confirm password functionality to the password reset functionality.
Add some text to the index page in the bootstrap tab.
In this lecture we write JQeury code that will make the current tab on the index page to be the active tab when the page is refreshed or reloaded.
Inserting data from the new form field to the database.
Add plugin to add some text animation on the index page.
Create a footer and add to our pages.
Add css styles to bootstrap thumbnails to make all images have same height.
Add a new column to the profile table in the database and add the form field to the respective user forms.
Adding bootstrap alerts to the client-side errors.
A brief recap of what was built in the application.
Hi, i am Uzochukwu Eddie Odozi. I am a software developer who has interest in web and game development. I have a bachelors in Mathematics and an M.Sc. in Computer Engineering from Tallinn University of Technology.
I enjoy working with php, mysql, Jquery, C# as well as nodejs. I enjoying coding a lot.
I have had many success and failures in web development and all those has contributed to where I am today.