PHP with MySQL 2023: Build 5 PHP and MySQL Projects

Build Cool Projects with PHP MySQL Bootstrap and PDO

Created by : Rated :4.8 695 views

Last Updated: 2023-05-23 06:05:02 English Course Type: Self Learning

Get to know the main functions and common parts of every website
Learn password hashing and de-hashing
Learn how to create, update, delete and display data
Create a full authentication system
Learn the basics of validation and limit the user ability inside the web app
Learn to create a URL shortening service
Train your knowledge as a PHP developer
Build a complete PHP and MySQL gallery
Learn to insert and manipulate images on your app
Learn to send emails professionally and dynamically
Explore top tips and tricks about development in general

Ready to dive into practical web projects? Are you stuck in tutorial hell? want to build your own CV but don't know how and when to start? If so, this is the right project for you. This course contains five projects for a reason. It covers the most common parts of every web project out there. Even if you are experienced as a developer, you should still give it a shot. and the projects are not similar and that's the surprise. Every project covers a certain topic.

First of all, we are going to start with probably what every web project has which is the authentication system. It contains a couple of useful parts like validation, password hashing, sessions, and so on. And for the second project, we are going to take a look at the crud app which will help you manipulate data like a pro, set forms, update, delete and create data. The third project is all about building a URL shortening service and that's pretty simple and yet very practical. We are going to use a bit of Jquery on the way. For the fourth project, which is the largest one of them all, where we are going to integrate our code from the past project (auth system) and we are going to insert images and display them nicely. And that only leaves us with only one project, and that is the email sender that's one of the most important parts of any kind of development because it will teach you to send emails dynamically. And that's actually it. Enjoy every little bit of the course!!

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

Every aspiring PHP and MySQL developer
Developers who want to explore web development further
Developers who want create cool projects and to build up their CVs

Section 1 : Introduction 1 Lectures 00:06:09
Lecture 1 :
Introduction Preview
Section 2 : Installation 4 Lectures 00:16:27
Lecture 1 :
Installing Xampp
Lecture 2 :
Before you start
Lecture 3 :
Installing Visual Studio Code
Lecture 4 :
Installing Sublime
Section 3 : First Project_ Login and Registration System 6 Lectures 01:03:40
Lecture 1 :
Intro to the Project
Lecture 2 :
Code for this Project
Lecture 3 :
Config File
Lecture 4 :
Register Page
Lecture 5 :
Logging Users in
Lecture 6 :
Logging in and Checking for Sessions
Section 4 : Second Project_ Full Crud App 5 Lectures 00:46:12
Lecture 1 :
Setting Up
Lecture 2 :
Inserting into DB
Lecture 3 :
Pulling the Data
Lecture 4 :
Delete the Data
Lecture 5 :
Updating the Data
Section 5 : Third Project_ URL Shortening Service 5 Lectures 00:37:42
Lecture 1 :
Config File
Lecture 2 :
Inserting and Showing Links
Lecture 3 :
Shortening urls
Lecture 4 :
Counting Clicks pt.1
Lecture 5 :
Counting Clicks pt.2
Section 6 : Fourth Project_ PHP Gallery 7 Lectures 01:15:47
Lecture 1 :
Intro and Code for the Theme
Lecture 2 :
Setting up and Getting Ready pt.1
Lecture 3 :
Setting up and Getting Ready pt.2
Lecture 4 :
Creating Galleries
Lecture 5 :
Displaying images in the Home Page
Lecture 6 :
Displaying Details for every Gallery pt.1
Lecture 7 :
Displaying Details for every Gallery pt.2
Section 7 : Fifth Project_ Sending Emails with PHP 2 Lectures 00:30:09
Lecture 1 :
Sending Emails p1
Lecture 2 :
Sending Emails pt.2

How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
Is there any free trial?
Currently, we do not offer any free trial.
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?

Web Coding,

16449 Course Views

15 Courses

Mohamed Hassan (the founder of Web Coding) is an aspiring developer. Years ago when started learning to code, he immediately fell in love with it and it's like this is all I want to do all my life. He then started building websites and apps for fun, got his internship a few months later, but he knew all along, how he always loved teaching people from a young age, and now he is dedicated to getting you the finest, most robust, informative, and engaging content and learning experience that he can get you. He has experience with various both back-end and front-end technologies, from PHP to Python to Javascript and so much more. He explains everything with ease and clarity with practical real-world examples and mind-tackling quizzes and he is all ready to answer your questions :)