Projects in PHP and MySQL
3.6 (925 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
12,195 students enrolled

Projects in PHP and MySQL

Master PHP-MySQL by Building 10 Projects
3.6 (925 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
12,195 students enrolled
Last updated 12/2018
English [Auto]
Current price: $41.99 Original price: $59.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 20 hours on-demand video
  • 1 article
  • 73 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • To Learn Web Programming Technologies such as PHP, MYSQL, JavaScript and JQuery
  • Build Practical projects during the course
  • Learn about popular web frameworks
  • Learn the software development process
Course content
Expand all 78 lectures 19:48:36
+ Getting Started with PHP
3 lectures 35:58

Introduction to the Course

Preview 08:49

The lecture describe in detail the process of setting up the PHP environment for development

Preview 08:41

A quick refresher course in PHP for beginners.

PHP Basics
+ Project 1 - Shoutit Shoutbox
4 lectures 57:43

The lecture describes the process of building the UI for our App

Building the UI

Basic Database creation process

Create Database

Learn the database connectivity feature for the project

Connect and Fetch Shouts

Learn to put databse validations

Validate and Insert Shouts
+ Project 2 - PHP Quizzer
6 lectures 01:54:02

Learn to make the UI for the Quiz app.

Quizzer UI - Part 1

Complete UI for the Quiz App.

Quizzer UI - Part 2

learn to use MySQLi to connect to the database.

Connect to database

Learn the CRUD operations for the database. Connect and fetch your quiz data from the database

Fetch data from database

Learn to write the answer processing engine for our application.

Process Answers

Adding question forms to populate our database.

Add Question Form
+ Project 3 - PHP Lovers Blog
8 lectures 02:59:50

This is the first lesson identifying the structure of our Blog App. It will focus on how the app will look like.

Folder Structure

Learn to build the UI of the Blog application. It will focus on twitter bootstrap.

Frontend UI

Learn to create the database class for all database operations.

Create Database class

Learn to write the operations for front end database queries.

Frontend database fetch

Learn to create an Admin area for your site.

Admin UI

This module handles the database for your Admin panel.

Admin Database fetch

Adding Posts and Categories

Insert Post and Categories

Update and Deletion of blogs

Update and Delete
+ Project 4 - Talking Space Forum
14 lectures 03:54:46

Learn to create a forum in this project. This lecture talks about the internal file structure of the project

The File Structure

Learn to build the UI of the forum application.

The UI

Writing the inner page HTML of our project.

Inner page HTML

This lecture add the look and feel to the project using CSS.

Adding the CSS

Learn all about the database management for the forum app in this lecture.

The Database

Learn to build the template class for the home page.

The Template Class

This lecture teaches the creation of inner page template for the forum

Inner Page Templates

Learn to write the logic for handling various topics in the forum.

The Topic Class

Adding the categories to the topics. Adding more layers to our app.

Topic with Category Filters

Learn to create the single topic pages.

Single Topic Pages

This class teaches you the user handling of the your app

The User Class

learn to create the master validator class for your app. It will check for all user validations

Validator class

Implementing the sessions and login-logout feature in our App.

Login and Logout

Learn to implement Topics in our forum website

Adding Topics
+ Project 6 - Wordpress Contact Widget
5 lectures 01:09:15

Learn to install WordPress locally in your server

Install Wordpress

Understand the Plugin structure with this comprehensive lecture.

Wordpress Plugin Structure

Learn to build the Widget class for our project

Create Widget Class

Learn to add Post with JQuery and Ajax

Post with JQuery and Ajax

Learn to implement PHP mailer in our widget.

Build PHP Mailer
+ Project 7 - Addressbook
6 lectures 01:32:09

The lecture describes the structure for the address book website

Create Structure

This lectures teaches the creation of UI for our application

Address book foundation UI

Design the database and configure it as per the project specifications.

Database and Config

Implement Selection and Addtion of contacts to the address book

Select and Add contacts

Implement the editing and deletion of contacts using a panel

Edit and Delete Contacts

Final lecture describing the addition and deletion of the contacts

Edit and Delete Contacts - part 2
+ Project 8 - Job Find Jobs Board
12 lectures 03:07:28

This lecture deals with UI building and HTML creation of the Jobs Board project

HTML Layout

Implement the CSS of the project

Part 2 CSS

Learn to build the Inner page HTML of the site

Inner page HTML

Create the config file for your database

Database Installation and Config

Learn to display the Job entries. The lecture shows the Controller and Views

Jobs Display

Add layouts and elements to the Job Post page.

Layouts and Elements

This lecture shows the implementation of the browse controller and views

Browse Controller and View

Search and Filter implementation.

Search and Filter

Addition, Editing and Deletion of Jobs from the website

Add, Edit and Delete Jobs

Update and Deletion of Jobs

Update and Delete Jobs

Learn to Implement the User Aunthentication

User Aunthentication

The lecture teaches the proper implementation of session managment and user access control.

Login and Access Control
+ Project 9 - Kewl CMS
14 lectures 02:40:32

Code Igniter installation and configuration for the project

Code Igniter Install and configure

Building the UI for our CMS.


Implement the inner page HTML and Login UI

Inner page and Login UI

Learn to implement the database of the project

Create Kewl Database

Frontend Articles and view implementation for the CMS

Frontend Articles and Views

Front end and inner pages creation for the website.

Front end Inner pages

Learn to create the admin dashboard panel for the CMS.

Admin Dashboard and Layout

Learn to add articles and categories to your Admin panel.

Admin Articles and categories

Articles update, publish and delete through admin panel.

Articles Update , Publish and Delete

Learn to add categories logic to the CMS


Learn to implement search and filter option to your site.

Search and Filter

Build the user and groups inside the user management module.

Users and Groups

User authentication module creation.


The final lecture to handle access rights of various users.

Access Control
+ Project 10 - TGP Wordpress Plugin
4 lectures 52:01

Lecture teaching the creation of Plugin file and Menu item.

Create Plugin File & Menu item

Learn plugin options form creation.

Create Plugin Options Form

The lecture explains the option handling for the plugin

Storing Options value

learn to display Plugin data to user.

Display Plugin Data
  • Basic knowledge of HTML and PHP

This is the ultimate course for all web developers who want to learn web programming while building practical projects along with the instructor. This course will help both beginners and experts alike. This course will primarily teach project building using MySQL and PHP but it covers Javascript, JQuery, Ajax, web frameworks, Wordpress and various other popular technologies in great detail.

This course can be done sequentially or you can pick and select the project and start working on them directly. These projects are all independent of each other. Besides the royalty free code can be used for any of your personal projects.

Project Details:

Shoutit Shoutbox

Description: Shoutit is a PHP powered shoutbox which uses mySQL to store shouts. This is a very basic PHP/MySQL
application. It is strictly procedural coding and uses the mysqli api

PHP Syntax, PHPMyAdmin, MySQL Select, MySQL Insert, Loops, Superglobals (GET, POST), Associative Arrays, HTML/CSS

PHP Quizzer

Description: Quizzer is a simple PHP/MySQL based quiz engine. it uses multiple choices and admins can create
new quizes from within the browser

PHP Syntax, PHPMyAdmin, MySQL Select, MySQL Insert, Loops, Superglobals (GET, POST), Associative Arrays,
HTML/CSS, Includes, Math Functions

PHP Lovers Blog
Description: This blog project is much more advanced than the earlier projects. We create a fairly large blogging
system. We create an admin section to add posts, delete posts as well as update them. We take our first look
at using libraries and classes in OOP as we create a completely custom MySQLi Database class. We also create
custom helper functions

PHP OOP, PHPMyAdmin, MySQL CRUD, Loops, Superglobals (GET, POST), Associative Arrays, Bootstrap Framework

TalkingSpace Form

Description: Here we step up our coding standards and completely separate logic from display. We create a PDO
database class along with 3 or 4 other classes including Topics, Users and a Validator class for form validation

Separate Logic & Display, PHP OOP, PHPMyAdmin, PDO & Perpared Statements, MySQL CRUD, Loops, Superglobals (GET, POST), Associative Arrays,
Custom Template, User & Topic Libs, Sessions, Bootstrap Framework

The GamingPlace Shopping Cart

Description: This is an ecommerce-based MVC web application written with the Codeigniter framework. We utilize many of
Codeigniters libraries, helpers and structure. Users can register, add products to their cart and checkout using PayPal

Codeigniter, MVC, PHP OOP, PHPMyAdmin, PDO & Perpared Statements, MySQL CRUD, Sessions, PayPal Express Checkout API

Wordpress Contact Widget

Description: We will create a plugin/widget for Wordpress that will allow us to put a small contact form in any widget position in the template. It
gives users an easy way to get in touch. The widget will have options in the backend like recipient and subject

Wordpress Platform, Wordpress Plugin API, Wordpress Widget API, PHP OOP, PHPMyAdmin

AJAX Address Book

Description: A completely custom addressbook application written in PHP along with jQuery and Ajax. Ajax is used to fetch contacts as well as add and edit them.
We use the "Foundation" HTML5 framework for the application's user interface.

Foundation Framework, Ajax, jQuery, PHP OOP, PHPMyAdmin, PDO & Perpared Statements, MySQL CRUD, Superglobals (GET, POST), Associative Arrays

JobFinds Job Board

Description: This is a fairly large project in which we will be using the CakePHP framework to build a job board. Users can register and login
to add a job. We also implement search & filter to narrow down job searches by keywords, location and category. We use the Kickstart HTML5 framework for UI

CakePHP, MVC, Kickstart, PHP OOP, PHPMyAdmin, PDO & Perpared Statements, MySQL CRUD, Superglobals (GET, POST), Associative Arrays

Kewl CMS Content Management System

Description: Kewl CMS is a Codeigniter based application for managing website content. We will build both frontend and backend. Bootstrap will be used for UI

Codeigniter, Bootstrap, MVC, PHP OOP, PHPMyAdmin, PDO & Perpared Statements, MySQL CRUD, Superglobals (GET, POST), Associative Arrays

Wordpress Bridge Plugin for TGP

Description: We will build a Wordpress plugin that will allow us to connect to the "TheGamingPlace" database and display a set number of products in
a Wordpress page using a custom shortcode

Wordpress Platform, Wordpress Plugin API, Wordpress Widget API, PHP OOP, PHPMyAdmin

Who this course is for:
  • Developers who quickly want to pick up project building skills.
  • Expert programmers who want to use specific project code and build on top of it