PHP with MySQL 2024: Build 8 PHP and MySQL Projects

Build Projects with PHP MySQL Bootstrap and PDO

This course includes:

  • 6.5 hours on-demand video
  • 11 downloadable resources
  • Access on mobile and TV
  • Full lifetime access
  • Certificate of completion


What you’ll learn

  • Learn to Work with APIs
  • Learn to deal with PHP and MySQL in a professional way
  • Learn to combine Ajax-Jquery with PHP
  • Create a full like and dislike system
  • Train your prior knowledge with PHP and MySQL
  • Learn to deal with files and install a library for it
  • Build a simple CV creator
  • Build an auth system
  • Build a rating system
  • Learn Debugging in PHP and MySQL along the way with Ajax JQuery

Course content

10 sections • 36 lectures • 6h 28m total lengthCollapse all sections

Introduction1 lecture • 6min

  • IntroductionPreview06:26

Installation3 lectures • 13min

  • Before you Start the ProjectPreview00:25
  • Installing Xampp09:46
  • Installing VS CodePreview02:32

First Project: Building an Authentication System6 lectures • 1hr 4min

  • Intro to the Project00:27
  • Code for the Design of the Project00:37
  • Config File08:58
  • Register Page19:22
  • Logging Users in20:21
  • Logging in and Checking for Sessions13:55

Second Project: Building a Comments System9 lectures • 1hr 30min

  • Intro and Preparing02:17
  • Creating Posts14:47
  • Showing Posts in Index10:49
  • Showing a Single Post08:13
  • Inserting Comments24:00
  • Showing Comments14:09
  • Deleting Comments10:50
  • Fixing Bugs pt.103:47
  • Fixing Bugs pt.201:23


Third Project: Creating a Rating System5 lectures • 52min

  • Getting Started and Setting up the PluginPreview10:20
  • Creating the Ratings for every Post13:30
  • Showing the Rating for every Post05:01
  • Fixing Bugs pt.104:48
  • Fixing Bugs pt.218:20

Fourth Project: Creating a Weather App3 lectures • 38min

  • What is an API??12:18
  • Implementing the Weather App24:20
  • Code for the Final Version of the Project00:52

Fifth Project: Build a Cool Like and Dislike System3 lectures • 38min

  • Getting Started and Code for the Project13:35
  • Liking and Disliking pt.111:09
  • Liking and Disliking pt.213:13

Sixth Project: Building a Simple CV Builder2 lectures • 32min

  • Setting up the Project and InstallingPreview08:35
  • Building the CV Builder23:53

Seventh Project: QR Codes Generator2 lectures • 19min

  • Setting up the Package10:56
  • Generating QR Codes Dynamically07:51

Eighth Project: Build a Full Live Search System2 lectures • 37min

  • Searching through Data pt.1.24:26
  • Searching through Data pt.212:09


Requirements

  • Basic PHP, MySQL and PDO knowledge
  • Very little knowledge of Bootstrap

Description

Are you ready to skill up in programming? Do you have knowledge of PHP and MySQL and do not know what to do with them? Do you guidance on your way to building projects? If so, then this is the right place for you!! In this course, you will learn how to get out of the tutorial hell and how to approach real-world projects and get unstuck on your way to becoming a developer. After this course, you will simply be able to think like a programmer, and solving programming tasks will be no challenge for you.



First of all, We will begin by building the most common feature of every website and which is the authentication system, which will allow you to learn about various things like password hashing and unhashing, validations, and sessions. For the second project, we are getting deep and we are building a posting system with comments with a focus on the comments and we are doing the whole thing using Ajax JQuery. And the third project is also about a rating system inside the blog itself and we are going to install a plugin along the way to do the design for us and we are going to do the backend from scratch. The next Project it’s about a weather app and we are going to use an API for it, so that should be really cool. Another interesting project is also the CV creator that we are using a library for and that will allow us to deal with files within PHP

Who this course is for:

  • Every PHP and MySQL developer who want to advance their skills
  • Developers who want to explore web development further
  • Developers who want to build cool projects and to build up their CVs



Latest Free Coupons

Leave a Reply

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

Check Today's 30+ Free Courses

X