Projects in PHP and MySQL
4.5 (628 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.
10,838 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Projects in PHP and MySQL to your Wishlist.

Add to Wishlist

Projects in PHP and MySQL

Master PHP-MySQL by Building 10 Projects
4.5 (628 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.
10,838 students enrolled
Last updated 11/2015
English
English [Auto-generated]
Current price: $10 Original price: $60 Discount: 83% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 23 hours on-demand video
  • 26 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
Requirements
  • Basic knowledge of HTML and PHP
Description

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

Features/Technologies:
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

Features/Technologies:
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

Features/Technologies:
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

Features/Technologies:
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

Features/Technologies:
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

Features/Technologies:
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.

Features/Technologies:
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

Features/Technologies:
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

Features/Technologies:
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

Features/Technologies:
Wordpress Platform, Wordpress Plugin API, Wordpress Widget API, PHP OOP, PHPMyAdmin

Who is the target audience?
  • 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
Compare to Other MySQL Courses
Curriculum For This Course
88 Lectures
23:13:03
+
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
18:28
+
Project 1 - Shoutit Shoutbox
4 Lectures 57:43

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

Building the UI
22:23

Basic Database creation process

Create Database
05:34

Learn the database connectivity feature for the project

Connect and Fetch Shouts
13:13

Learn to put databse validations

Validate and Insert Shouts
16:33
+
Project 2 - PHP Quizzer
6 Lectures 01:54:02

Learn to make the UI for the Quiz app.

Quizzer UI - Part 1
22:31

Complete UI for the Quiz App.

Quizzer UI - Part 2
13:19

learn to use MySQLi to connect to the database.

Connect to database
08:21

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

Fetch data from database
21:10

Learn to write the answer processing engine for our application.

Process Answers
25:15

Adding question forms to populate our database.

Add Question Form
23:26
+
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
12:37

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

Frontend UI
22:34

Learn to create the database class for all database operations.

Create Database class
33:50

Learn to write the operations for front end database queries.

Frontend database fetch
32:15

Learn to create an Admin area for your site.

Admin UI
22:51

This module handles the database for your Admin panel.

Admin Database fetch
22:49

Adding Posts and Categories

Insert Post and Categories
17:11

Update and Deletion of blogs

Update and Delete
15:43
+
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
18:33

Learn to build the UI of the forum application.

The UI
17:03

Writing the inner page HTML of our project.

Inner page HTML
15:37

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

Adding the CSS
15:56

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

The Database
16:03

Learn to build the template class for the home page.

The Template Class
16:44

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

Inner Page Templates
16:20

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

The Topic Class
19:35

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

Topic with Category Filters
20:47

Learn to create the single topic pages.

Single Topic Pages
11:06

This class teaches you the user handling of the your app

The User Class
19:44

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

Validator class
11:26

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

Login and Logout
16:04

Learn to implement Topics in our forum website

Adding Topics
19:48
+
Project 5 - The Gaming Place - Shopping cart
11 Lectures 03:24:50

Learn to build a shopping cart using Code Igniter framework.

Install and configure Codeigniter
17:01

This lecture deals with the database structure of our shopping cart project

Database Setup
11:52

This lecture teaches you to create the UI for your shopping cart website.

The Gaming Place UI
14:36

Learn to build the inner page HTML and CSS for the project

Inner HTML and CSS
18:35

Learn to build views and layouts for our application.

Views and layouts
21:04

Learn to query for categories and popular products from the database.

Get and Display Products
23:36

This module allows adding of categories and popular products to the website.

Get categories and popular products
13:34

Learn to implement the shopping cart and payment class.

Cart & Payment
20:22

Learn to implement the user management module with this lecture.

Users
21:02

Learn to do the session management and login-logout feature for your website.

User Login and Logout
15:08

Implementing paypal checkout in our website

Paypal Checkout
28:00
+
Project 6 - Wordpress Contact Widget
5 Lectures 01:09:15

Learn to install WordPress locally in your server

Install Wordpress
06:45

Understand the Plugin structure with this comprehensive lecture.

Wordpress Plugin Structure
14:39

Learn to build the Widget class for our project

Create Widget Class
22:22

Learn to add Post with JQuery and Ajax

Post with JQuery and Ajax
14:11

Learn to implement PHP mailer in our widget.

Build PHP Mailer
11:18
+
Project 7 - Addressbook
6 Lectures 01:32:09

The lecture describes the structure for the address book website

Create Structure
07:05

This lectures teaches the creation of UI for our application

Address book foundation UI
17:15

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

Database and Config
20:46

Implement Selection and Addtion of contacts to the address book

Select and Add contacts
17:41

Implement the editing and deletion of contacts using a panel

Edit and Delete Contacts
21:26

Final lecture describing the addition and deletion of the contacts

Edit and Delete Contacts - part 2
07:56
+
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
15:54

Implement the CSS of the project

Part 2 CSS
13:02

Learn to build the Inner page HTML of the site

Inner page HTML
09:52

Create the config file for your database

Database Installation and Config
14:38

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

Jobs Display
13:29

Add layouts and elements to the Job Post page.

Layouts and Elements
19:22

This lecture shows the implementation of the browse controller and views

Browse Controller and View
19:34

Search and Filter implementation.

Search and Filter
21:52

Addition, Editing and Deletion of Jobs from the website

Add, Edit and Delete Jobs
18:00

Update and Deletion of Jobs

Update and Delete Jobs
10:29

Learn to Implement the User Aunthentication

User Aunthentication
18:31

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

Login and Access Control
12:45
+
Project 9 - Kewl CMS
14 Lectures 02:40:32

Code Igniter installation and configuration for the project

Code Igniter Install and configure
13:37

Building the UI for our CMS.

Kewl CMS UI
12:09

Implement the inner page HTML and Login UI

Inner page and Login UI
09:38

Learn to implement the database of the project

Create Kewl Database
08:11

Frontend Articles and view implementation for the CMS

Frontend Articles and Views
20:27

Front end and inner pages creation for the website.

Front end Inner pages
06:33

Learn to create the admin dashboard panel for the CMS.

Admin Dashboard and Layout
19:43

Learn to add articles and categories to your Admin panel.

Admin Articles and categories
14:01

Articles update, publish and delete through admin panel.

Articles Update , Publish and Delete
06:37

Learn to add categories logic to the CMS

Categories
10:11

Learn to implement search and filter option to your site.

Search and Filter
04:21

Build the user and groups inside the user management module.

Users and Groups
16:03

User authentication module creation.

Aunthentication
14:51

The final lecture to handle access rights of various users.

Access Control
04:10
2 More Sections
About the Instructor
Eduonix Learning Solutions
4.2 Average rating
50,258 Reviews
806,328 Students
190 Courses
1+ Million Students Worldwide | 200+ Courses

Eduonix creates and distributes high quality technology training content. Our team of industry professionals have been training manpower for more than a decade. We aim to teach technology the way it is used in industry and professional world. We have professional team of trainers for technologies ranging from Mobility, Web to Enterprise and Database and Server Administration.

Eduonix-Tech .
4.2 Average rating
48,204 Reviews
783,759 Students
145 Courses