Projects in PHP and MySQL

Master PHP and MySQL by building 10 practical projects. Ideal for beginners and experts to enhance their web programming skills.

  • Overview
  • Curriculum
  • Instructor
  • Review

Brief Summary

This course is all about learning web development by building cool projects! You'll get your hands dirty with PHP, MySQL and even a sprinkle of JavaScript. It's designed for everyone, from newbies to pros, and you'll finish with real skills and impressive projects to show off.

Key Points

  • Master PHP and MySQL through hands-on projects.
  • Build 10 unique projects, each teaching different skills.
  • Explore additional technologies like JavaScript, jQuery, and various web frameworks.
  • Projects like Shoutit Shoutbox and PHP Quizzer for practical learning.
  • Flexible learning path: sequential or pick-n-choose projects.

Learning Outcomes

  • Develop functional web applications using PHP and MySQL.
  • Understand object-oriented programming concepts through practical application.
  • Gain experience with popular frameworks like CodeIgniter and CakePHP.
  • Create custom WordPress plugins and widgets.
  • Utilize AJAX for dynamic web applications.

About This Course

Master PHP-MySQL by Building 10 Projects

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

  • To Learn Web Programming Technologies such as PHP, MYSQL, JavaScript and JQuery

  • Build Practical projects during the course

  • Learn about popular web frameworks

Course Curriculum

3 Lectures

Instructors

Profile photo of Eduonix Learning Solutions
Eduonix Learning Solutions

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.

Instructors

Profile photo of Eduonix-Tech .
Eduonix-Tech .

More Courses By Eduonix Learning Solutions, Eduonix-Tech ., Eduonix Support
Review
4.9 course rating
4K ratings
ui-avatar of Raman Kumar
Raman K.
5.0
8 months ago

It is amazing.

  • Helpful
  • Not helpful
ui-avatar of Mouhamad Ramadan
Mouhamad R.
4.0
1 year ago

good job

  • Helpful
  • Not helpful
ui-avatar of James
James
5.0
1 year ago

Yes, the projects have provide a valuable learning experience!

  • Helpful
  • Not helpful
ui-avatar of Okonji Emmanuel
Okonji E.
5.0
1 year ago

this is the best so far I have come across, God bless you for bringing Justice to php newbies .

  • Helpful
  • Not helpful
ui-avatar of Marvin Denson II
Marvin D. I.
5.0
1 year ago

Go

  • Helpful
  • Not helpful
ui-avatar of Marcin Starszuk
Marcin S.
5.0
1 year ago

Good course.

  • Helpful
  • Not helpful
ui-avatar of Anuradha Cherukuri
Anuradha C.
5.0
1 year ago

I enjoyed doing the PHP and SQL projects in the Course. Brad guided us effortlessly through the course. Some of the projects as the JobFindsBoard and the Blog , The Address book were pretty interesting. I look forward to working with Brad on more PHP and SQL Projects in the future. Thanks. Anuradha Cherukuri.

  • Helpful
  • Not helpful
ui-avatar of Jerad Horning
Jerad H.
1.5
3 years ago

Everything was great until I got to Project 8 and 9, which were by far, the main reasons I wanted the course. The PHP version, the CakePHP version, and the CodeIgniter version are so old that nothing works and I don't see any help for those.

  • Helpful
  • Not helpful
ui-avatar of Darren Jewell
Darren J.
5.0
4 years ago

I have worked through the tutorials on W3c and wanted to build a few projects before I take the exam and this course is great. It's hard to think of ideas sometimes so this is brilliant. Well done Brad

  • Helpful
  • Not helpful
ui-avatar of Ehiremen Isaiah
Ehiremen I.
4.0
4 years ago

Nice course. Easy to follow up.

  • Helpful
  • Not helpful
Leave A Reply

Your email address will not be published. Required fields are marked *

Ratings

Courses You May Like

Lorem ipsum dolor sit amet elit
Show More Courses