Projects in PHP and MySQL

via Udemy

Go to Course: https://www.udemy.com/course/the-complete-web-development-course-learn-by-building-apps/

Introduction

Certainly! Here's a comprehensive review and recommendation for the Coursera course: --- **Course Review and Recommendation: Comprehensive Web Development Project Course** If you are a web developer eager to enhance your skills through hands-on experience and practical projects, this course on Coursera is an excellent choice. Designed to cater to both beginners and seasoned developers, it offers an in-depth journey through web development using popular technologies such as PHP, MySQL, JavaScript, JQuery, Ajax, Wordpress, and more. **What You Will Learn:** This course emphasizes building real-world applications step-by-step under the guidance of an experienced instructor. You will gain proficiency in server-side scripting with PHP (both procedural and object-oriented), database management with MySQL and PDO, front-end styling with Bootstrap, and modern web frameworks like Codeigniter and CakePHP. Additionally, you'll explore Wordpress plugin development, eCommerce implementation, and client-side scripting with Ajax and Foundation framework. **Course Structure:** The course is modular, allowing you to choose complete projects or select individual ones to work on. The projects are independent, enabling flexibility to target specific skill areas: - *Shoutit Shoutbox:* Creating a simple PHP/MySQL shoutbox. - *PHP Lovers Blog:* Developing a comprehensive blogging system with admin controls. - *TalkingSpace Form:* Building a robust form with logic separation and security. - *The GamingPlace Shopping Cart:* Constructing an MVC eCommerce app with PayPal integration. - *Wordpress Contact Widget:* Developing a customizable contact form plugin. - *Address Book:* Implementing a jQuery-powered, AJAX-enabled contact management system. - *JobFinds Job Board:* Building a full-featured job portal with filtering. - *Kewl CMS:* Creating a content management system with Bootstrap. - *Wordpress Bridge:* Connecting Wordpress with external databases via custom plugins. **Strengths:** - **Practical Focus:** The emphasis on project-building mirrors real-world scenarios, equipping you with applicable skills. - **Diverse Technologies:** Exposure to core web development tools and frameworks ensures a well-rounded skill set. - **Flexibility:** You can either follow the sequence or pick projects that align with your interests. - **Reusable Code:** The course provides royalty-free code snippets that you can adapt for personal projects. **Who Should Enroll:** - Aspiring web developers aiming for a comprehensive, project-based learning experience. - Developers seeking to strengthen their PHP, MySQL, and Wordpress skills. - Experienced programmers interested in expanding into MVC frameworks and eCommerce platforms. **Final Recommendation:** This course is highly recommended for anyone serious about becoming a proficient web developer. Whether you're starting fresh or looking to deepen your existing knowledge with real-world projects, this course offers valuable insights, practical skills, and flexible learning paths. Its detailed projects not only reinforce learning but also serve as a portfolio for your future employment or freelance work. --- If you enjoy learning by doing and want to build a solid foundation in web development with an emphasis on project-based learning, this Coursera course is an investment worth making! --- Let me know if you'd like me to tailor this further or include additional details!

Overview

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

Skills

Reviews