PHP and MYSQL from Scratch with projects

Learn how to code with PHP and how connect PHP to MYSQL. This course contains huge projects

Created by : Rated :4.1 62942 views

Last Updated: 2023-03-22 08:03:48 English Course Type: Self Learning

Writing PHP code
Connect PHP to MYSQL server
Undrestand how to work with MYSQL
How to add data to MYSQL
Form validation
Validate user and password
How to upload image
how to use reCAPTCHA
Table pagination
Sending E-mail

PHP is one of the most important programming language in the world that can work on client and server side. . PHP can connect to MYSQL database to make web applications. MYSQL is a database that can store data in tables.This course starts from the beginning of setting up your server and writing your first line of PHP code. You will gain understanding on how to send and receive information to and from a database.You will learn how to validate your form too. After that i talk about advanced features in PHP and MYSQL and you will learn about how to create register,login and logout system and also how to make image upload system.

This course contains useful project that help you to understand better PHP & MYSQL too.

Projects include:

Table pagination
Sending E-Mail
User Login to system and upload their private photo without access other users to them
how to use Google reCAPTCHA system and how to make it for your own website.

Why should you take this course?

This course helps you to make online web application and can get big projects and also spend much money in your job.
Personal contact with me, the course tutor
Lifetime access to course materials
A friendly, informal community to support you every step of the way
A deep understanding of how to code,work with data base and make web applications

You don't need to learn anything. i will teach you everything form Zero to Hundred
Desire for learning is very important for you
If you want to earn money from design website and want to learn web design take this course
If you want work from server side take this course

Those People love Coding and Programming
hose people want write program and make attractive website

Section 1 : Introduction 5 Lectures 00:17:48
Lecture 1 :
What will you learn in Section One Preview
Lecture 2 :
What does the course cover
Lecture 3 :
Install WAMP SERVER
Lecture 4 :
Install XAMPP SERVER
Lecture 5 :
Text Editors
Section 2 : Start your PHP coding 13 Lectures 01:16:39
Lecture 1 :
What will you learn in Section Two
Lecture 2 :
What is PHP
Lecture 3 :
Display Hello World
Lecture 4 :
Variables
Lecture 5 :
Data Types
Lecture 6 :
Strings
Lecture 7 :
GET&POST
Lecture 8 :
If Statements
Lecture 9 :
Switch-Case Statement
Lecture 10 :
While Loops
Lecture 11 :
For Loops
Lecture 12 :
Arrays
Lecture 13 :
Function
Section 3 : MYSQL 16 Lectures 02:17:29
Lecture 1 :
What will you learn in Section Three
Lecture 2 :
What is MYSQL Database
Lecture 3 :
MYSQL Create Database and Tables
Lecture 4 :
MYSQL Connect PHP to MYSQL
Lecture 5 :
MYSQL Insert DATA to MYSQL Database
Lecture 6 :
MYSQL INSERT DATA to MYSQL Database via Form
Lecture 7 :
MYSQL Prepare Insert Data
Lecture 8 :
MYSQL SELECT Data
Lecture 9 :
MYSQL LIMIT Data
Lecture 10 :
MYSQL DELETE Data
Lecture 11 :
MYSQL UPDATE Data
Lecture 12 :
PROJECT- Table Pagination (Preview)
Lecture 13 :
PROJECT - Table Pagination (Part 1)
Lecture 14 :
PROJECT - Table Pagination (Part 2)
Lecture 15 :
PROJECT - Table Pagination (Part 3)
Lecture 16 :
PROJECT - Table Pagination (Part 4)
Section 4 : Form Validation 10 Lectures 01:32:13
Lecture 1 :
Create Form
Lecture 2 :
Username Validation
Lecture 3 :
Password Validation
Lecture 4 :
E-Mail Validation
Lecture 5 :
Display error messages on main page
Lecture 6 :
Project - Send E-Mail (Preview)
Lecture 7 :
Project - Send E-Mail (Part 1)
Lecture 8 :
Project - Send E-Mail (Part 2)
Lecture 9 :
Project - Send E-Mail (Part 3)
Lecture 10 :
What will you learn in Section Four
Section 5 : Advanced in PHP and MYSQL 11 Lectures 02:30:11
Lecture 1 :
What will you learn in Section Five
Lecture 2 :
Session
Lecture 3 :
User Registration
Lecture 4 :
User Login & Logout System
Lecture 5 :
Hash Password
Lecture 6 :
Roles
Lecture 7 :
Upload Image
Lecture 8 :
Mini Project - Users Upload Image with Login to System
Lecture 9 :
Relation between Database
Lecture 10 :
Project - Google reCAPTCHA (preview)
Lecture 11 :
Project - Google reCAPTCHA
Section 6 : What is your next step? 2 Lectures 00:01:21
Lecture 1 :
What is the next step
Lecture 2 :
All Projects Files

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?

Aatef Jaberi,

62942 Course Views

1 Courses

Hi, my name is Aatef. I am engineer in Information Technology and Web Development Designer. I have experience in Information Technology and Web Development Designer for 5 years. I have worked as an online supporter and I also work as a networking in companies and online Web Designer and also manager social marketing I love information Technology (IT) and programming. I study very much to learn more and add to my knowledge then I help myself and other people to improve together. My Slogan: The key to success is perseverance, effort and Do Not Stop