off original price!

The coupon code was not applied because it has already been redeemed or expired. Please click on "My Courses" to see if the course is already on your account.

off original price!

The coupon code was not applied because it has already been redeemed or expired. Please click on "My Courses" to see if the course is already on your account.

PHP MySQL Fundamentals from Scratch with Examples & Projects

Learn PHP procedural programming with MySQL database. Design dynamic websites with PHP & MySQL.

What's Inside

Course Curriculum

Section 1: PHP MySQL Installation & Run Your First PHP Program

Lecture 1: Requirements for PHP & MySQL Installation - 4:50
Preview
Lecture 2: Download & Install WAMP on Windows 10 Operating System - 12:01
Preview
Lecture 3: Download & Install MAMP on MAC Operating System - 11:15
Start
Lecture 4: Download & Install LAMP on Linux Operating System - 11:12
Start
Lecture 5: Your First PHP Program: "Hello World!" - 11:29
Preview
Lecture 6: A brief overview of Bitnami WAMP/MAMP/LAMP stack manager tool - 32:10
Start
Lecture 7: Download and Install Text Editor for PHP - 4:33
Start
Assignment 1 Question: Setup a local development server on your computer (Do It Yourself Challenge) - 1:01
Start
Assignment 1 Solution: Setup a local development server on your computer (Do It Yourself Challenge) - 0:46
Start

Section 2: Introduction to PHP and Basic Configuration Settings

Lecture 8: What is PHP? - 3:33
Start
Lecture 9: History of PHP! - 2:30
Preview
Lecture 10: Let's understand PHP Syntax - 1:53
Start
Lecture 11: Understand how PHP codes are executed on a web server - 2:05
Start
Lecture 12: View & modify PHP configuration setting, Display PHP errors and disable cache - 13:26
Start
Lecture 13: The echo & print functions in PHP - 13:01
Start
Lecture 14: Embed HTML tags in PHP - 6:22
Preview
Lecture 15: Whitespace in PHP - 4:13
Start
Lecture 16: Define and use PHP Variables - 8:21
Start
Lecture 17: Define and use PHP Constants - 6:22
Start
Lecture 18: Single quotes vs Double quotes - 7:55
Start
Lecture 19: Are PHP codes case sensitive? - 5:45
Start
Lecture 20: How to add comments in PHP Program? - 6:21
Start

Section 3: PHP Data Types

Lecture 21: Data types in PHP - 1:23
Start
Lecture 22: Boolean data type in PHP - 5:06
Start
Lecture 23: Integer data type in PHP - 5:14
Preview
Lecture 24: Float or Double data type in PHP - 3:55
Start
Lecture 25: String data type in PHP - 4:10
Start
Lecture 26: Array data type in PHP - 3:40
Start
Lecture 27: Object data type in PHP - 4:57
Start
Lecture 28: Resource data type in PHP - 3:08
Start
Lecture 29: NULL data type in PHP - 4:49
Start

Section 4: PHP Operators

Lecture 30: What are operators & types of operators in PHP? - 1:30
Start
Lecture 31: PHP Arithmetic operators - 3:41
Preview
Lecture 32: PHP Assignment operators - 4:50
Start
Lecture 33: PHP Comparison operators - 9:07
Start
Lecture 34: Error Control Operators - 3:26
Start
Lecture 35: PHP Increment & Decrement operators - 5:31
Start
Lecture 36: PHP Logical operators - 8:18
Start
Lecture 37: PHP String operators - 3:47
Start
Lecture 38: PHP Array operators - 7:21
Start

Section 5: PHP Conditional Statements

Lecture 39: What is conditional statement in PHP? - 1:08
Start
Lecture 40: PHP if statement - 6:20
Start
Lecture 41: PHP if else statement - 6:02
Preview
Lecture 42: PHP if elseif else statement - 8:20
Start
Lecture 43: PHP switch statement - 10:02
Start

Section 6: PHP Loop Statements

Lecture 44: What is Loop & Types of loop statements in PHP? - 1:25
Start
Lecture 45: PHP while loop statement - 6:20
Start
Lecture 46: PHP do while loop statement - 4:11
Start
Lecture 47: The difference between while and do while statement in PHP - 3:42
Preview
Lecture 48: PHP for loop statement - 5:36
Start
Lecture 49: PHP foreach loop statement - 6:13
Start
Lecture 50: PHP break statement - 6:31
Start
Lecture 51: PHP continue statement - 4:36
Start

Section 7: PHP Arrays

Lecture 52: What is array & types of arrays in PHP? - 1:04
Start
Lecture 53: Indexed Arrays in PHP - 16:48
Start
Lecture 54: Associative Arrays in PHP - 10:29
Start
Lecture 55: Multidimensional arrays in PHP - 7:40
Start
Lecture 56: Useful Array Functions in PHP - 9:46
Preview

Section 8: Functions in PHP

Lecture 57: What are Built-in functions in PHP? How to find and use functions in PHP - 4:14
Start
Lecture 58: String functions in PHP - 10:43
Start
Lecture 59: Math functions in PHP - 5:04
Preview
Lecture 60: Array functions in PHP - 11:17
Start

Section 9: User Defined Functions in PHP

Lecture 61: What are user-defined functions? Why we need user-defined functions? - 3:24
Start
Lecture 62: Define and use your first PHP function - 5:43
Preview
Lecture 63: Define functions with arguments in PHP - 9:08
Start
Lecture 64: Define functions with default arguments in PHP - 12:43
Start
Lecture 65: Define functions that return the value in PHP - 7:45
Start
Lecture 66: What is constant & variable scope in PHP? - 7:11
Start

Section 10: PHP Superglobals or Global variables

Lecture 67: What are Superglobals or Global variables in PHP? - 1:00
Start
Lecture 68: PHP $GLOBALS global variable - 6:43
Start
Lecture 69: PHP $_SERVER global variable - 3:33
Start
Lecture 70: PHP $_ENV global variable - 4:48
Start
Lecture 71: PHP $_GET, $_POST, $_FILES, $_REQUEST, $_COOKIE & $_SESSION global variables - 12:39
Start

Section 11: PHP Date and Time

Lecture 72: View and set timezone in PHP - 9:19
Start
Lecture 73: Date time formatting in PHP - 4:18
Start
Lecture 74: Some useful date time functions in PHP - 13:48
Start

Section 12: PHP Cookies & Sessions

Lecture 75: The cookies & sessions in PHP - 0:34
Start
Lecture 76: What are cookies & How to create cookies in PHP? - 7:03
Start
Lecture 77: How to read cookies in PHP & Where cookies are stored? - 7:47
Start
Lecture 78: How to update cookies in PHP - 2:57
Start
Lecture 79: How to delete cookies in PHP - 6:45
Start
Lecture 80: What are sessions & How to create sessions or session variables in PHP? - 2:47
Start
Lecture 81: How to read session variables in PHP & Where session variables are stored? - 6:47
Start
Lecture 82: How to update session variables in PHP? - 2:38
Start
Lecture 83: How to delete session variables in PHP? - 3:50
Start
Lecture 84: The difference between cookies and sessions - 9:03
Start

Section 13: Building Web Pages in PHP

Lecture 85: Create web page links and URLs in PHP - 4:43
Start
Lecture 86: Pass variables and values via GET method - 5:20
Start
Lecture 87: The importance of URL encoding in PHP - 6:56
Start
Lecture 88: Retrieve or extract the values via POST method - 5:29
Start
Lecture 89: PHP include & require functions and the difference between include & require - 8:39
Start
Lecture 90: Absolute path vs Relative path in PHP - 12:47
Start
Lecture 91: How to redirect web pages in PHP - 2:40
Preview

Section 14: Build your own contact form from scratch using PHP (Project)

Lecture 92: Design a contact form using Bootstrap - 7:26
Start
Lecture 93: Get & display variable values from contact form - 4:32
Preview
Lecture 94: Validate contact form input values using PHP - 20:48
Start
Lecture 95: Sanitize contact form input values using PHP - 11:02
Start
Lecture 96: How to send emails from Localhost using PHP on Windows Operating System - 8:09
Start
Lecture 97: How to send emails from Localhost using PHP on MAC Operating System - 6:35
Start
Lecture 98: PHP mail function to send emails - 5:12
Start

Section 15: Build file upload system from scratch using PHP (Project)

Lecture 99: Design a file upload form using Bootstrap - 3:13
Start
Lecture 100: Checkout the file upload settings in PHP - 3:08
Start
Lecture 101: Temporary file variables while uploading - 3:21
Start
Lecture 102: PHP file validation before upload - 11:21
Start
Lecture 103: PHP move uploaded file to a specific location - 4:04
Preview

Section 16: Introduction to MySQL database

Lecture 104: Introduction to MySQL - 2:30
Start
Lecture 105: Login to MySQL database server & execute basic SQL statements - 6:36
Start
Lecture 106: Keywords, Identifiers, Constants and Clauses - 2:24
Start
Lecture 107: Data Definition Language (DDL) & Data Manipulation Language (DML) - 1:30
Start
Lecture 108: How to create & use a database in MySQL - 3:27
Start
Lecture 109: How to create a table in MySQL database - 5:58
Preview
Lecture 110: Update an existing table in MySQL - 6:15
Start
Lecture 111: Delete or remove an existing table from MySQL database - 1:58
Start
Lecture 112: Add data rows or records in MySQL table - 6:09
Start
Lecture 113: View or retrieve data rows from MySQL table - 2:39
Start
Lecture 114: Update data rows inside MySQL table - 3:50
Start
Lecture 115: Delete or remove data rows from MySQL table - 2:35
Start
Lecture 116: Important Data types in MySQL - 1:29
Start
Lecture 117: Important Conditions & Operators in MySQL - 8:19
Start
Lecture 118: Data grouping, sorting & dates in MySQL - 9:29
Start
Lecture 119: Important SQL constraints in MySQL database - 9:13
Start
Lecture 120: Learn how to design a relational database in MySQL - 11:40
Start
Lecture 121: How to backup & restore database in MySQL - 7:59
Start

Section 17: Introduction to phpMyAdmin

Lecture 122: Introduction to phpMyAdmin - 7:04
Start
Lecture 123: Manage databases using phpMyAdmin - 3:10
Start
Lecture 124: Manage database tables using phpMyAdmin - 7:17
Start
Lecture 125: Managing table data rows using phpMyAdmin - 3:38
Preview
Lecture 126: Backup & restore MySQL database using phpMyAdmin - 7:16
Start

Section 18: Interacting with MySQL database using PHP

Lecture 127: How do we interact with database management systems using PHP? - 2:05
Start
Lecture 128: How to connect to MySQL database using PHP? - 5:10
Preview
Lecture 129: How to create a new database & table in MySQL database using PHP? - 9:15
Start
Lecture 130: How to insert, update & delete data rows in MySQL database table using PHP? - 9:01
Start
Lecture 131: How to display data rows from MySQL database table using PHP? - 7:35
Start
Lecture 132: How to close MySQL database connection in PHP? - 3:57
Start

Section 19: Single page user management system (Project)

Lecture 133: Design user management page using Bootstrap - 4:27
Preview
Lecture 134: Connect to database, display records & close connection - 10:25
Start
Lecture 135: Handle two form submission on single page - 20:03
Start
Lecture 136: Get and validate POST variable values - 15:48
Start
Lecture 137: Complete add user functionality - 5:30
Start
Lecture 138: Complete delete user functionality - 6:53
Start

off original price!

The coupon code was not applied because it has already been redeemed or expired. Please click on "My Courses" to see if the course is already on your account.

Get started now!

Paid Course Coupon Discount

or pay in installments:

$200

140 Lectures

15+ Hours of Video

Lifetime Access

24/7 Support

Instructor Rating

Pradnyankur Nikam

Hi, I am Pradnyankur Nikam from Pune, Maharashtra, India. I'm an instructor, freelance web developer, PHP, MySQL & WordPress developer.

After completing my post graduation in 2008, I started developing websites for myself, where I used to sell affiliate games & software. I learned online marketing & SEO (search engine optimization) skills by using which promoted my websites. While marketing my websites, I started working on freelance projects, where I got opportunities to further improve my skills.

During my 10+ years freelancer carrier, I've helped hundreds of clients to build websites, APIs, troubleshoot errors, setup web servers and much more. I've practical experience of working on thousands of projects. And it would be my pleasure to share my experience with you.

Popular Bundles

StackSkills Unlimited
Evan Kimbrell's Business Launching Bundle
Essential JavaScript Coding Bundle
Ultimate Web Developer Bundle
World Travel Hacker Bundle

off original price!

The coupon code was not applied because it has already been redeemed or expired. Please click on "My Courses" to see if the course is already on your account.

Just In

The 2020 Learn to Code Bundle

Hot Bundle

Master Photoshop & The Entire Creative Cloud

Unlimited Learning

Expand Your Mind with StackSkills Unlimited

Course Categories

PHP MySQL Fundamentals from Scratch with Examples & Projects

Learn PHP procedural programming with MySQL database. Design dynamic websites with PHP & MySQL.

What's Inside

Course Curriculum

Get started now!

Paid Course Coupon Discount

Pradnyankur Nikam