This is the ultimate course for anyone who wants to learn web programming, while building practical projects along with the instructor. This course will help both beginners and experts alike, and will primarily teach project-building using MySQL and PHP. The course will also cover JavaScript, jQuery, Ajax, frameworks, WordPress, and various other popular technologies in great detail.
- Build practical projects to round out your programming knowledge w/ over 88 lectures & 23 hours of content
- Study programming technologies such as PHP, MYSQL, JavaScript & JQuery
- Work on the projects in any order you want
- Utilize the royalty-free code on any future project
- Use the MySQL API w/ PHP to power a Shoutbox
- Create a MySQL/PHP-based quiz engine
- Make a WordPress plug-in & much more!
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
