Build A Complete CRUD Application With PHP, MYSQL & JQUERY
4.2 (115 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
11,150 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Build A Complete CRUD Application With PHP, MYSQL & JQUERY to your Wishlist.

Add to Wishlist

Build A Complete CRUD Application With PHP, MYSQL & JQUERY

CRUD Application: You will learn how to build a complete crud application with step by step guide
4.2 (115 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
11,150 students enrolled
Last updated 2/2017
English
English [Auto-generated]
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 13.5 hours on-demand video
  • 5 Supplemental Resources
  • 3 Coding exercises
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • At the end of this course, you will be able to build a fully functional CRUD application.
  • Create custom client-side validations with Jquery for sign up and login forms.
  • Create custom server-side validations with PHP for sign up and login forms.
  • Use swiftmailer to send emails to users for verification after sign up.
  • Implement password reset functionality.
  • Create your own simple admin dashboard.
  • Use google charts to display data.
  • Add, read, update and delete data from MYSQL database.
  • Hash users password with a PHP hashing algorithm.
  • Implement search and confirm password functionalities.
View Curriculum
Requirements
  • A text editor of your choice (But we will go through downloading and installing brackets text editor if you want to use something different.
  • XAMPP software
  • Basic HTML/CSS: Tags, forms, buttons, inputs
  • Basic PHP/MYSQL: Things like variables, conditional statements, loops
Description

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

  • HTML: to structure our pages
  • CSS: to add basic styling
  • Bootstrap: to also structure and add styles
  • JQuery: to validate forms fields and sending data to be processed using PHP
  • PHP: to validate form fields from the server side and send users data to and from database
  • MYSQL: database to hold user information
  • Swiftmailer: to send mails to user

Some Main Features:.

  • Registration and login forms validation on client-side and server-side.
  • Email verification after user sign up.
  • Password recovery/reset functionality.
  • Password hashing with PHP password hashing algorithm.
  • Search functionality
  • Update user data
  • Admin dashboard
  • Graphical display of data
Who is the target audience?
  • This course is for anyone who wants to level up php skills and learn something new
Compare to Other PHP Courses
Curriculum For This Course
112 Lectures
13:30:09
+
Course Setup
3 Lectures 10:22

In this lecture you will install xampp software on your computer if you don't have it installed. 

Preview 02:31

In this lecture we'll go through installing brackets text editor in case the student wants to use brackets.

Install Brackets Text Editor
06:27
+
Project and Database Setup
5 Lectures 27:52

In this lecture we'll create our project and its required files and folders.

Create Project
05:56

In this lecture we'll create mysql database in phpmyadmin.

Create Database
02:13

Here we will create a connection between our project and mysql database.

Preview 10:28

We will include the required bootstrap and JQuery links in our project.

Add Bootstrap Links
05:06

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 Session to Connection File
04:09
+
CRUD - Building Registration System
26 Lectures 03:23:06

Add bootstrap navbar to index page.

Add Simple Navbar to Index Page
10:07

Add bootstrap tabs on the index page that will display login and registration forms.

Using Bootstrap Tabs on Index Page
08:00

Add registration form and display inside the bootstrap tab.

Adding User Registration Form
14:35

Add css and bootstrap styles to registration form.

Adding Styles to User Registration Form
11:42

Get the javascript document object model (DOM) ready, add a click event to the submit button and also get the user values from input fields and store in variables.

Client-Side Validation With JQuery - Part 1
07:41

Add validations to check that the input fields are not empty when the user submits the form.

Client-Side Validation With JQuery - Part 2
07:13

Add html elements with ids to display errors. Also add css property to the elements.

Client-Side Validation With JQuery - Part 3
05:36

Add other custom validations to the form fields.

Client-Side Validation With JQuery - Part 4
14:33

Send data from form fields to php script to be processed and saved to the database using AJAX method.

Client-Side Validation With JQuery - Part 5
08:03

Create signup table in the database to store users registration data.

Adding Sign Up Table in the Database
05:41

Get the data from form and query the database with mysqli select to check if user email already exist.

PHP Sign Up Script With Validations - Part 1
08:20

Check the form fields with php to make sure they are not empty.

PHP Sign Up Script With Validations - Part 2
07:07

Clean the form data and perform validations on the form data with php.

PHP Sign Up Script With Validations - Part 3
08:16

Write mysqli insert query to insert user data to signup table in database.

PHP Sign Up Script With Validations - Part 4
09:09

Add some more validations to the form fields.

PHP Sign Up Script With Validations - Part 5
08:56

Insert user data and view in the database.

PHP Sign Up Script With Validations - Part 6
05:47

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.

Adding Swiftmailer Plugin
03:34

Add the swiftmailer script to send email to users after registration.

Email Verification Swiftmailer Script
09:29

Add page to display message to user after email verification.

User Email Verification Page - Part 1
06:03

Include bootstrap alert messages to user email verification page.

User Email Verification Page - Part 2
01:19

Select user activation key from url and database.

Email Activation PHP Script - Part 1
08:32

Update user data in signup table after email verification.

Email Activation PHP Script - Part 2
06:24

Including the activation script in the user email verification page and also add the alert messages.

Adding Alert Message to User Email Activation Page
04:19

Verifying a new user email and viewing in the database.

Sending Message To New User
06:22

Add a new column to signup table in database with a default value which will be used for hashing user's password.

Password Hashing - Part 1
06:27

Get the column with default value from database and use it with php crypt() method to hash the password.

Password Hashing - Part 2
09:51
+
CRUD - Building Login System
19 Lectures 02:09:00
Add User Login Form To Login tab
1 question

Add user login form to bootstrap tab on index page.

User Login Form - Part 1
05:31

Change names and ids of fields in user login form.

User Login Form - Part 2
04:38

Login Form Validation
1 question

Add JQuery validation to user login form.

Login Form validation With JQuery - Part 1
08:48

Fix the problem with page reload when user login form errors are displayed.

Login Form validation With JQuery - Part 2
05:27

Select user email from database which is used to check if user email exist.

PHP Script For Login Form
08:36

Add validations to login data and fetch user data from database.

Adding Server-Side Validation in PHP Script
09:43

In this lecture we use the php crypt() method on the user login password and also save user data in sessions.

Saving User Data in Sessions
08:35

Here we display the user data stored in sessions when the user logs in successfully.

Using Session Variables To Display Data
08:04

Add error messages to login form to be displayed if user login fails.

Add Error Message Variables To Login Form
03:25

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.

Allowing Only Verified Users To Login
06:15

Add a form for users to add their email address so they can reset their password.

Forgot Password Reset Form
06:59

Select user's email address from the database.

Forgot Password Reset PHP Script
08:26

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.

Adding Password Reset Email Link
08:20

Here we test to make sure that the password reset link is sent to the user.

Testing Password Reset Link
05:17

Add form that will allow user reset their password.

Reset Password Form
03:16

Get the user activation key from url and also encrypt their new password.

Reset Password PHP Script - Part 1
09:17

Select user activation key from database, validate new password and update user password in database.

Reset Password PHP Script - Part 2
07:59

Update a user's password and view in the database.

Updating A User's Password
04:56

In this lecture we'll add a logout script that will take the user to index page.

Adding Logout Script
05:28
+
CRUD - User Profile
23 Lectures 03:00:54

Add bootstrap navbar to homepage. This is the page that the user will be taken to when he/she logs in.

Adding Navbar To Homepage
06:04

Add files to project that will allow users to complete their profile, display their data and as well update their data.

Creating Files To Create, Display and Update User's Data
09:36

In this lecture we'll add bootstrap corousel to the homepage.

Adding Sliders Using Bootstrap Corousel
06:28

Add html and css to user page where they will complete their profile.

Add Html and Css To User Page
07:45

Add form to insert user data to database.

Adding Form To Insert User Data To Database - Part 1
09:17

Add more fields to form

Adding Form To Insert User Data To Database - Part 2
07:13

Create user profile table in the database. This table will hold user data that will be added after registration.

Create User Profile Table in The Database
04:58

Fetch data from signup table in database and display in the form for inserting data to the profile table.

Fetch User Data Form Database Table and Display in The Input Fields
09:21

Get new user data from form fields. 

Insert User Data Into Profile Table - Part 1
06:21

Insert user data to profile table in database.

Insert User Data Into Profile Table - Part 2
11:44

Add html and css to page where user data can be viewed.

Adding View User Profile Page
08:28

Create functions that will be used to display user's data. 

Creating Functions To Display User's Profile - Part 1
05:41

Add elements to hold user data inside the functions created.

Creating Functions To Display User's Profile - Part 2
09:23

Add styles to user profile page.

Adding Styles to User Profile Page
09:05

Add form that will be used to edit user data.

Adding Form To Update User Data
05:04

Fetch user's data that already exist in the profile table and display in form form fields.

Fetch User Data From Profile Table and Display in Update Form
09:06

Add mysqli update query to update the user data in the profile table.

Updating User Data - Part 1
06:41

Update a user's data and view in the database

Updating User Data - Part 2
08:51

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.

Fetching All Users From The Profile Table
10:27

Add bootstrap thumbnail to display the user's image on the homepage.

Displaying All Users Image on Homepage
05:14

View data of other users displayed on the homepage.

Viewing Profile of Other Users
07:54

Display data of sign in user on homepage.

Displaying Sign In User's Image
07:08

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.

Showing Certain Links To Sign In User
09:05
+
CRUD - Admin
23 Lectures 02:36:20
Admin Login and Sign Up Form
1 question

Add admin login form inside the bootstrap tab in the index page.

Adding Admin Login Form
04:55

Add admin table in the database with email and password columns which both have default values.

Adding Admin Table in Database
03:58

Add the admin login script to admin folder.

Admin Login PHP Script - Part 1
10:05

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.

Admin Login PHP Script - Part 2
05:40

Add bootstrap navbar to admin dashboard.

Admin Dashboard
06:12

Add links to sidebar in the admin dashboard. Create required files for the links.

Adding Side Links to Admin Dashboard
05:54

Add css styles to sidebar links. Also add font awesome icons to the links.

Styling Admin Dashboard Side Links - Part 1
07:19

Add and style admin email stored in a session to the dashboard navbar.

Styling Admin Dashboard Side Links - Part 2
06:30

Add html inside the pages in the sidebar.

Navigating Side Nav Links
06:18

Display all users in the signup table using a table in the view all users page.

Displaying All Users
10:49

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.

Displaying Verified Users
08:28

Display all users in the signup table that are not verified using a table in the not veirified users page.

Displaying Not Verified Users
05:49

Add delete functionality so admin can delete a user's data from the database.

Delete Functionality
08:12

Add bootstrap panels to the admin dashboard.

Adding Dashboard Panels
11:05

Add font awesome icons to the bootstrap panels.

Adding Styles To Dashboard Panels
08:10

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. 

Creating Functions To Display Values on Dashboard Panels
08:41

Add more styles to bootstrap panels.

Adding More Styles To Dashboard Panels
01:42

Get chart script using google column chart and add to admin folder.

Adding Basic Chart Script
08:04

Fetch values from database and add to chart script.

Adding Database Values To Chart Script
08:38

Display column chart on dashboard.

Displaying Chart on Dashboard
06:20

Add the plugin to change the date format in the tables inside the admin.

Timeago Plugin - Part 1
07:51

Add the plugin to other pages in the admin.

Timeago Plugin - Part 2
02:07

Add logout link and script to the admin dashboard.

Admin Logout
03:33
+
CRUD - Adding More Functionalities
13 Lectures 01:42:35

Add search form to navbar in the user's homepage.

Search Functionality - Part 1
07:20

Send query to mysql database to get the user's search request.

Search Functionality - Part 2
08:43

Display the user's search result if found.

Search Functionality - Part 3
10:04

Add confirm password functionality to the password reset functionality.

Confirm Password Functionality
09:13

Add some text to the index page in the bootstrap tab.

Adding Text To The Index tab
07:46

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.

Making Current Tab To Be The Active Tab on Page Reload
09:12

Inserting data from the new form field to the database.

Adding A New Column To User Profile Table - Part 2
09:02

Add plugin to add some text animation on the index page.

Using TypedJS Plugin
08:27

Create a footer and add to our pages.

Adding Footer
06:09

Add css styles to bootstrap thumbnails to make all images have same height.

Styling Bootstrap Thumbnails
10:08

Add a new column to the profile table in the database and add the form field to the respective user forms.

Adding A New Column To User Profile Table - Part 1
06:53

Adding bootstrap alerts to the client-side errors.

Using Bootstrap Alert For Client-Side Errors
07:32

A brief recap of what was built in the application.

Conclusions
02:06
About the Instructor
Uzochukwu Eddie Odozi
4.1 Average rating
517 Reviews
34,543 Students
6 Courses
Software Developer

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.