Take this
course

Software Development / Programming Languages

Projects in PHP and MySQL

Master PHP-MySQL by Building 10 Projects

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 quizzes 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 & Prepared 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 & Prepared 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:
Foundation Framework, Ajax, jQuery, PHP OOP, PHPMyAdmin, PDO & Prepared 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 & Prepared 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 

Full details

Curriculum

  • Getting Started with PHP
    Course Intro
    Introduction to the Course
    8:50
    Environment Setup
    The lecture describe in detail the process of setting up the PHP environment for development
    8:42
    PHP Basics
    A quick refresher course in PHP for beginners.
    18:29
    Getting Started with PHP Files
  • Shoutit Shoutbox
    Building the UI
    The lecture describes the process of building the UI for our App
    22:24
    Create Database
    Basic Database creation process
    5:35
    Connect & Fetch Shouts
    Learn the database connectivity feature for the project
    13:14
    Validate & Insert Shouts
    Learn to put databse validations
    16:34
    Project 1 Program Files
    Chapter Quiz Questions
  • PHP Quizzer
    Quizzer UI - Part 1
    Learn to make the UI for the Quiz app.
    22:32
    Quizzer UI - Part 2
    Complete UI for the Quiz App.
    13:20
    Connect to Database With MySQLi
    Learn to use MySQLi to connect to the database.
    8:22
    Fetch Quiz Data
    Learn the CRUD operations for the database. Connect and fetch your quiz data from the database
    21:11
    Process Answers
    Learn to write the answer processing engine for our application.
    25:16
    Add Question Form
    Adding question forms to populate our database.
    23:27
    Project 2 Program Files
    Chapter Quiz Questions
  • PHP Lovers Blog
    Blog Folder Structure
    This is the first lesson identifying the structure of our Blog App. It will focus on how the app will look like.
    12:38
    Frontend UI
    Learn to build the UI of the Blog application. It will focus on twitter bootstrap.
    22:35
    Create Database Class
    Learn to create the database class for all database operations.
    33:51
    Frontend Database Fetch
    Learn to write the operations for front end database queries.
    32:16
    Admin Area UI
    Learn to create an Admin area for your site.
    22:52
    Admin Database Fetch
    This module handles the database for your Admin panel.
    22:50
    Insert, Update and Delete Part 1
    Adding Posts and Categories
    17:12
    Insert, Update and Delete Part 2
    Update and Deletion of blogs
    15:44
    Project 3 Program Files
    Chapter Quiz Questions
  • TalkingSpace Forum
    Creating The File Structure
    18:34
    The UI Part 1 - Index Page and Base HTML
    Learn to build the UI of the forum application.
    17:04
    The UI Part 2 - Inner Page HTML
    Writing the inner page HTML of our project.
    15:38
    The UI Part 3 - Adding The CSS
    This lecture add the look and feel to the project using CSS.
    15:57
    The Database
    Learn all about the database management for the forum app in this lecture.
    16:04
    The Template Class Part 1
    Learn to build the template class for the home page.
    16:45
    The Template Class Part 2 - Inner Page Templates
    This lecture teaches the creation of inner page template for the forum
    16:21
    The Topic Class Part 1
    Learn to write the logic for handling various topics in the forum.
    19:36
    The Topic Class Part 2 - Topics With Category Filters
    Adding the categories to the topics. Adding more layers to our app.
    20:48
    The Topic Class Part 3 - Single Topic Pages
    Learn to create the single topic pages.
    11:07
    The User Class Part 1 - User Registration
    This class teaches you the user handling of the your app
    19:45
    The User Class Part 2 - Validator Class
    Learn to create the master validator class for your app. It will check for all user validations
    11:27
    The User Class Part 3 - Login and Logout
    Implementing the sessions and login-logout feature in our App.
    16:05
    Adding Topics
    Learn to implement Topics in our forum website.
    26:04
    Project 4 Program Files
    Chapter Quiz Questions
  • TheGamingPlace Shopping Cart
    Install & Configure Codeigniter Part 1
    Learn to build a shopping cart using Code Igniter framework.
    17:02
    Install & Configure Codeigniter Part 2 - Database Setup
    This lecture deals with the database structure of our shopping cart project
    11:53
    TheGamingPlace UI Part 1 - Base HTML
    This lecture teaches you to create the UI for your shopping cart website.
    14:37
    TheGamingPlace UI Part 2 - Inner HTML and CSS
    Learn to build the inner page HTML and CSS for the project
    18:36
    Views and Layouts
    Learn to build views and layouts for our application.
    21:05
    Get and Display Products Part 1
    Learn to query for categories and popular products from the database.
    23:37
    Get and Display Products Part 2 - Get Categories and Popular Products
    This module allows adding of categories and popular products to the website.
    13:36
    Cart & Payment
    Learn to implement the shopping cart and payment class.
    20:23
    Users Part 1 - User Registration
    Learn to implement the user management module with this lecture.
    21:03
    Users Part 2 - User Login and Logout
    Learn to do the session management and login-logout feature for your website.
    15:09
    PayPal Checkout
    Implementing PayPal checkout in our website.
    28:01
    Project 5 Program Files
    Chapter Quiz Questions
  • Wordpress Contact Widget
    Install Wordpress
    Learn to install WordPress locally in your server.
    6:46
    Wordpress Plugin Structure
    Understand the Plugin structure with this comprehensive lecture.
    14:40
    Create Widget Class
    Learn to build the Widget class for our project.
    22:23
    POST with jQuery AJAX
    Learn to add Post with JQuery and Ajax.
    14:12
    Build PHP Mailer
    Learn to implement PHP mailer in our widget.
    11:19
    Project 6 Program Files
    Chapter Quiz Questions
  • Addressbook Using PHP, AJAX & jQuery
    Create Application Structure
    The lecture describes the structure for the address book website.
    7:06
    Addressbook UI
    This lectures teaches the creation of UI for our application.
    17:16
    Database and Config
    Design the database and configure it as per the project specifications.
    20:47
    Select and Add Contacts
    Implement Selection and Addition of contacts to the address book.
    17:42
    Edit and Delete Contacts Part 1 - Creating The Edit Form Modal
    Implement the editing and deletion of contacts using a panel.
    21:27
    Edit and Delete Contacts Part 2
    Final lecture describing the addition and deletion of the contacts.
    7:57
    Project 7 Program Files
    Chapter Quiz Questions
  • JobFinds Job Board
    JobFinds UI Part 1 - HTML Layout
    This lecture deals with UI building and HTML creation of the Jobs Board project.
    15:55
    JobFinds UI Part 2 - CSS
    Implement the CSS of the project.
    13:03
    JobFinds UI Part 3 - Inner Page HTML
    Learn to build the Inner page HTML of the site.
    9:53
    Database, Installation and Config
    Create the config file for your database.
    14:39
    Jobs Display Part 1 - Controller and View Basics
    Learn to display the Job entries. The lecture shows the Controller and Views.
    13:30
    Jobs Display Part 2 - Layouts and Elements
    Add layouts and elements to the Job Post page.
    19:23
    Jobs Display Part 3 - Browse Controller and View
    This lecture shows the implementation of the browse controller and views.
    19:35
    Jobs Display Part 4 - Search and Filter
    Search and Filter implementation.
    21:53
    Add, Edit and Delete Jobs Part 1 - Adding Jobs
    Addition, Editing and Deletion of Jobs from the website.
    18:01
    Add, Edit and Delete Jobs Part 2 - Update & Delete Jobs
    Update and Deletion of Jobs.
    10:30
    User Authentication Part 1 - User Registration
    Learn to Implement the User Authentication.
    18:32
    User Authentication Part 2 - Login and Access Control
    The lecture teaches the proper implementation of session management and user access control.
    12:46
    Project 8 Program Files
    Chapter Quiz Questions
  • Kewl CMS
    Codeigniter Install and Configure
    Code Igniter installation and configuration for the project.
    13:38
    Kewl CMS UI Part 1 - Frontend and Dashboard Index UI
    Building the UI for our CMS.
    12:10
    Kewl CMS UI Part 2 - Inner Page and Login UI
    Implement the inner page HTML and Login UI.
    9:39
    Create Kewl Database
    Learn to implement the database of the project.
    8:12
    Frontend Articles and Views Part 1 - Frontend Articles Index
    Frontend Articles and view implementation for the CMS
    20:28
    Frontend Articles and Views Part 2 - Frontend Inner Pages
    Front end and inner pages creation for the website.
    6:34
    Admin Dashboard and Layout
    Learn to create the admin dashboard panel for the CMS.
    19:44
    Admin Articles & Categories Part 1 - Articles Index and Add
    Learn to add articles and categories to your Admin panel.
    14:02
    Admin Articles & Categories Part 2 - Articles Update, Publish and Delete
    Articles update, publish and delete through admin panel.
    6:38
    Admin Articles & Categories Part 3 - Categories
    Learn to add categories logic to the CMS.
    10:12
    Admin Articles & Categories Part 4 - Search and Filter
    Learn to implement search and filter option to your site.
    4:22
    Users & Groups
    Build the user and groups inside the user management module.
    16:04
    Authentication Part 1 - Login and Logout
    User authentication module creation.
    14:52
    Authentication Part 2 - Access Control
    The final lecture to handle access rights of various users.
    4:11
    Chapter Quiz Questions
    Project 9 Program Files
  • TGP Wordpress Plugin
    Create Plugin File and Menu Item
    Lecture teaching the creation of Plugin file and Menu item.
    10:45
    Create Plugin Options Form
    Learn plugin options form creation.
    12:24
    Storing Option Values
    The lecture explains the option handling for the plugin.
    11:54
    Displaying Plugin Data
    Learn to display plugin data to user.
    17:02
    Project 10 Program Files
    Chapter Quiz Questions
  • Course Summary
    Course Summary
    4:30
  • Quiz Answers
    Quiz Answers

Skills

  • PHP Tool
  • MySQL

Similar Courses

More Courses by this Instructor