Udemy - The Complete Web Development Course - Learn By Build https://www.udemy.com/the-complete-web-development-course-learn-by-buil https://www.udemy.com/the-complete-web-develop ment-course-learn-by-building-apps ding-apps / Projects in PHP and MySQL Master PHP-MySQL by Building 10 Projects COURSE DESCRIPTION This is the ultimate course for all web developers who want to learn web program ming while building practical projects along with the instructor. This course wi ll help both beginners and experts alike. This course will primarily teach proje ct building using MySQL and PHP but it covers Javascript, JQuery, Ajax, web fram eworks, 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, PO ST), Associative Arrays, HTML/CSS PHP Quizzer Description: Quizzer is a simple PHP/MySQL based quiz engine. it uses multiple c hoices and admins can create new quizes from within the browser Features/Technologies: PHP Syntax, PHPMyAdmin, MySQL Select, MySQL Insert, Loops, Superglobals (GET, PO ST), 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 Da tabase class. We also create custom helper functions Features/Technologies: PHP OOP, PHPMyAdmin, MySQL CRUD, Loops, Superglobals (GET, POST), Associative Ar rays, 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 Val idator 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 Cod eigniter 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, Se ssions, 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 bac kend like recipient and subject Features/Technologies: Wordpress Platform, Wordpress Plugin API, Wordpress Widget API, PHP OOP, PHPMyAd min AJAX Address Book Description: A completely custom addressbook application written in PHP along wi th 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 Statemen ts, MySQL CRUD, Superglobals (GET, POST), Associative Arrays JobFinds Job Board Description: This is a fairly large project in which we will be using the CakePH P 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 k eywords, location and category. We use the Kickstart HTML5 framework for UI Features/Technologies: CakePHP, MVC, Kickstart, PHP OOP, PHPMyAdmin, PDO & Perpared Statements, MySQL C RUD, Superglobals (GET, POST), Associative Arrays Kewl CMS Content Management System Description: Kewl CMS is a Codeigniter based application for managing website co ntent. We will build both frontend and backend. Bootstrap will be used for UI Features/Technologies:
Codeigniter, Bootstrap, MVC, PHP OOP, PHPMyAdmin, PDO & Perpared Statements, MyS QL 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 t he "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, PHPMyAd min Category: Development / Web Development What are the requirements? Basic knowledge of HTML and PHP What am I going to get from this course? Over 88 lectures and 23.5 hours of content! 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 What 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 THE UDEMY GUARANTEE 30 day money back guarantee Lifetime access Available on Desktop, iOs and Android Certificate of completion Preview this course CURRICULUM SECTION 1: Getting Started with PHP 1 Course Intro 08:49 Preview Introduction to the Course 2 Environment Setup 08:41 The lecture describe in detail the process of setting up the PHP environment for development 3 PHP Basics 18:28 A quick refresher course in PHP for beginners. SECTION 2: Project 1 - Shoutit Shoutbox
4 Building the UI 22:23 The lecture describes the process of building the UI for our App 5 Create Database 05:34 Basic Database creation process 6 Connect and Fetch Shouts 13:13 Learn the database connectivity feature for the project 7 Validate and Insert Shouts 16:33 Learn to put databse validations SECTION 3: Project 2 - PHP Quizzer 8 Quizzer UI - Part 1 22:31 Learn to make the UI for the Quiz app. 9 Quizzer UI - Part 2 13:19 Complete UI for the Quiz App. 10 Connect to database 08:21 learn to use MySQLi to connect to the database. 11 Fetch data from database 21:10 Learn the CRUD operations for the database. Connect and fetch your quiz data fro m the database 12 Process Answers 25:15 Learn to write the answer processing engine for our application. 13 Add Question Form 23:26 Adding question forms to populate our database. SECTION 4: Project 3 - PHP Lovers Blog 14 Folder Structure 12:37 This is the first lesson identifying the structure of our Blog App. It will focu s on how the app will look like.
15 Frontend UI 22:34 Learn to build the UI of the Blog application. It will focus on twitter bootstra p. 16 Create Database class 33:50 Learn to create the database class for all database operations. 17 Frontend database fetch 32:15 Learn to write the operations for front end database queries. 18 Admin UI 22:51 Learn to create an Admin area for your site. 19 Admin Database fetch 22:49 This module handles the database for your Admin panel. 20 Insert Post and Categories 17:11 Adding Posts and Categories 21 Update and Delete 15:43 Update and Deletion of blogs SECTION 5: Project 4 - Talking Space Forum 22 The File Structure 18:33 Learn to create a forum in this project. This lecture talks about the internal f ile structure of the project 23 The UI 17:03 Learn to build the UI of the forum application. 24 Inner page HTML 15:37 Writing the inner page HTML of our project. 25 Adding the CSS 15:56 This lecture add the look and feel to the project using CSS.
26 The Database 16:03 Learn all about the database management for the forum app in this lecture. 27 The Template Class 16:44 Learn to build the template class for the home page. 28 Inner Page Templates 16:20 This lecture teaches the creation of inner page template for the forum 29 The Topic Class 19:35 Learn to write the logic for handling various topics in the forum. 30 Topic with Category Filters 20:47 Adding the categories to the topics. Adding more layers to our app. 31 Single Topic Pages 11:06 Learn to create the single topic pages. 32 The User Class 19:44 This class teaches you the user handling of the your app 33 Validator class 11:26 learn to create the master validator class for your app. It will check for all u ser validations 34 Login and Logout 16:04 Implementing the sessions and login-logout feature in our App. 35 Adding Topics 26:03 Learn to implement Topics in our forum website SECTION 6: Project 5 - The Gaming Place - Shopping cart 36 Install and configure Codeigniter 17:01 Learn to build a shopping cart using Code Igniter framework. 37 Database Setup
11:52 This lecture deals with the database structure of our shopping cart project 38 The Gaming Place UI 14:36 This lecture teaches you to create the UI for your shopping cart website. 39 Inner HTML and CSS 18:35 Learn to build the inner page HTML and CSS for the project 40 Views and layouts 21:04 Learn to build views and layouts for our application. 41 Get and Display Products 23:36 Learn to query for categories and popular products from the database. 42 Get categories and popular products 13:35 This module allows adding of categories and popular products to the website. 43 Cart & Payment 20:22 Learn to implement the shopping cart and payment class. 44 Users 21:02 Learn to implement the user management module with this lecture. 45 User Login and Logout 15:08 Learn to do the session management and login-logout feature for your website. 46 Paypal Checkout 28:00 Implementing paypal checkout in our website SECTION 7: Project 6 - Wordpress Contact Widget 47 Install Wordpress 06:45 Learn to install WordPress locally in your server 48 Wordpress Plugin Structure 14:39 Understand the Plugin structure with this comprehensive lecture.
49 Create Widget Class 22:22 Learn to build the Widget class for our project 50 Post with JQuery and Ajax 14:11 Learn to add Post with JQuery and Ajax 51 Build PHP Mailer 11:18 Learn to implement PHP mailer in our widget. SECTION 8: Project 7 - Addressbook 52 Create Structure 07:05 The lecture describes the structure for the address book website 53 Address book foundation UI 17:15 This lectures teaches the creation of UI for our application 54 Database and Config 20:46 Design the database and configure it as per the project specifications. 55 Select and Add contacts 17:41 Implement Selection and Addtion of contacts to the address book 56 Edit and Delete Contacts 21:26 Implement the editing and deletion of contacts using a panel 57 Edit and Delete Contacts - part 2 07:56 Final lecture describing the addition and deletion of the contacts SECTION 9: Project 8 - Job Find Jobs Board 58 HTML Layout 15:54 This lecture deals with UI building and HTML creation of the Jobs Board project 59 Part 2 CSS 13:02 Implement the CSS of the project 60
Inner page HTML 09:52 Learn to build the Inner page HTML of the site 61 Database Installation and Config 14:38 Create the config file for your database 62 Jobs Display 13:29 Learn to display the Job entries. The lecture shows the Controller and Views 63 Layouts and Elements 19:22 Add layouts and elements to the Job Post page. 64 Browse Controller and View 19:34 This lecture shows the implementation of the browse controller and views 65 Search and Filter 21:52 Search and Filter implementation. 66 Add, Edit and Delete Jobs 18:00 Addition, Editing and Deletion of Jobs from the website 67 Update and Delete Jobs 10:29 Update and Deletion of Jobs 68 User Aunthentication 18:31 Learn to Implement the User Aunthentication 69 Login and Access Control 12:45 The lecture teaches the proper implementation of session managment and user acce ss control. SECTION 10: Project 9 - Kewl CMS 70 Code Igniter Install and configure 13:37 Code Igniter installation and configuration for the project 71 Kewl CMS UI 12:09
Building the UI for our CMS. 72 Inner page and Login UI 09:38 Implement the inner page HTML and Login UI 73 Create Kewl Database 08:11 Learn to implement the database of the project 74 Frontend Articles and Views 20:27 Frontend Articles and view implementation for the CMS 75 Front end Inner pages 06:33 Front end and inner pages creation for the website. 76 Admin Dashboard and Layout 19:43 Learn to create the admin dashboard panel for the CMS. 77 Admin Articles and categories 14:01 Learn to add articles and categories to your Admin panel. 78 Articles Update , Publish and Delete 06:37 Articles update, publish and delete through admin panel. 79 Categories 10:11 Learn to add categories logic to the CMS 80 Search and Filter 04:21 Learn to implement search and filter option to your site. 81 Users and Groups 16:03 Build the user and groups inside the user management module. 82 Aunthentication 14:51 User authentication module creation. 83 Access Control 04:10
The final lecture to handle access rights of various users. SECTION 11: Project 10 - TGP Wordpress Plugin 84 Create Plugin File & Menu item 10:44 Lecture teaching the creation of Plugin file and Menu item. 85 Create Plugin Options Form 12:23 Learn plugin options form creation. 86 Storing Options value 11:53 The lecture explains the option handling for the plugin 87 Display Plugin Data 17:01 learn to display Plugin data to user. SECTION 12: Course Summary 88 Summary 04:29 The complete course summary.
