Autoplay
Autocomplete
Previous Lesson
Complete and Continue
PHP MySQL Fundamentals from Scratch with Examples & Projects
Section 1: PHP MySQL Installation & Run Your First PHP Program
Lecture 1: Requirements for PHP & MySQL Installation
Lecture 2: Download & Install WAMP on Windows 10 Operating System
Lecture 3: Download & Install MAMP on MAC Operating System
Lecture 4: Download & Install LAMP on Linux Operating System
Lecture 5: Your First PHP Program: "Hello World!"
Lecture 6: A brief overview of Bitnami WAMP/MAMP/LAMP stack manager tool
Lecture 7: Download and Install Text Editor for PHP
Assignment 1 Question: Setup a local development server on your computer (Do It Yourself Challenge)
Assignment 1 Solution: Setup a local development server on your computer (Do It Yourself Challenge)
Section 2: Introduction to PHP and Basic Configuration Settings
Lecture 8: What is PHP?
Lecture 9: History of PHP!
Lecture 10: Let's understand PHP Syntax
Lecture 11: Understand how PHP codes are executed on a web server
Lecture 12: View & modify PHP configuration setting, Display PHP errors and disable cache
Lecture 13: The echo & print functions in PHP
Lecture 14: Embed HTML tags in PHP
Lecture 15: Whitespace in PHP
Lecture 16: Define and use PHP Variables
Lecture 17: Define and use PHP Constants
Lecture 18: Single quotes vs Double quotes
Lecture 19: Are PHP codes case sensitive?
Lecture 20: How to add comments in PHP Program?
Section 3: PHP Data Types
Lecture 21: Data types in PHP
Lecture 22: Boolean data type in PHP
Lecture 23: Integer data type in PHP
Lecture 24: Float or Double data type in PHP
Lecture 25: String data type in PHP
Lecture 26: Array data type in PHP
Lecture 27: Object data type in PHP
Lecture 28: Resource data type in PHP
Lecture 29: NULL data type in PHP
Section 4: PHP Operators
Lecture 30: What are operators & types of operators in PHP?
Lecture 31: PHP Arithmetic operators
Lecture 32: PHP Assignment operators
Lecture 33: PHP Comparison operators
Lecture 34: Error Control Operators
Lecture 35: PHP Increment & Decrement operators
Lecture 36: PHP Logical operators
Lecture 37: PHP String operators
Lecture 38: PHP Array operators
Section 5: PHP Conditional Statements
Lecture 39: What is conditional statement in PHP?
Lecture 40: PHP if statement
Lecture 41: PHP if else statement
Lecture 42: PHP if elseif else statement
Lecture 43: PHP switch statement
Section 6: PHP Loop Statements
Lecture 44: What is Loop & Types of loop statements in PHP?
Lecture 45: PHP while loop statement
Lecture 46: PHP do while loop statement
Lecture 47: The difference between while and do while statement in PHP
Lecture 48: PHP for loop statement
Lecture 49: PHP foreach loop statement
Lecture 50: PHP break statement
Lecture 51: PHP continue statement
Section 7: PHP Arrays
Lecture 52: What is array & types of arrays in PHP?
Lecture 53: Indexed Arrays in PHP
Lecture 54: Associative Arrays in PHP
Lecture 55: Multidimensional arrays in PHP
Lecture 56: Useful Array Functions in PHP
Section 8: Functions in PHP
Lecture 57: What are Built-in functions in PHP? How to find and use functions in PHP
Lecture 58: String functions in PHP
Lecture 59: Math functions in PHP
Lecture 60: Array functions in PHP
Section 9: User Defined Functions in PHP
Lecture 61: What are user-defined functions? Why we need user-defined functions?
Lecture 62: Define and use your first PHP function
Lecture 63: Define functions with arguments in PHP
Lecture 64: Define functions with default arguments in PHP
Lecture 65: Define functions that return the value in PHP
Lecture 66: What is constant & variable scope in PHP?
Section 10: PHP Superglobals or Global variables
Lecture 67: What are Superglobals or Global variables in PHP?
Lecture 68: PHP $GLOBALS global variable
Lecture 69: PHP $_SERVER global variable
Lecture 70: PHP $_ENV global variable
Lecture 71: PHP $_GET, $_POST, $_FILES, $_REQUEST, $_COOKIE & $_SESSION global variables
Section 11: PHP Date and Time
Lecture 72: View and set timezone in PHP
Lecture 73: Date time formatting in PHP
Lecture 74: Some useful date time functions in PHP
Section 12: PHP Cookies & Sessions
Lecture 75: The cookies & sessions in PHP
Lecture 76: What are cookies & How to create cookies in PHP?
Lecture 77: How to read cookies in PHP & Where cookies are stored?
Lecture 78: How to update cookies in PHP
Lecture 79: How to delete cookies in PHP
Lecture 80: What are sessions & How to create sessions or session variables in PHP?
Lecture 81: How to read session variables in PHP & Where session variables are stored?
Lecture 82: How to update session variables in PHP?
Lecture 83: How to delete session variables in PHP?
Lecture 84: The difference between cookies and sessions
Section 13: Building Web Pages in PHP
Lecture 85: Create web page links and URLs in PHP
Lecture 86: Pass variables and values via GET method
Lecture 87: The importance of URL encoding in PHP
Lecture 88: Retrieve or extract the values via POST method
Lecture 89: PHP include & require functions and the difference between include & require
Lecture 90: Absolute path vs Relative path in PHP
Lecture 91: How to redirect web pages in PHP
Section 14: Build your own contact form from scratch using PHP (Project)
Lecture 92: Design a contact form using Bootstrap
Lecture 93: Get & display variable values from contact form
Lecture 94: Validate contact form input values using PHP
Lecture 95: Sanitize contact form input values using PHP
Lecture 96: How to send emails from Localhost using PHP on Windows Operating System
Lecture 97: How to send emails from Localhost using PHP on MAC Operating System
Lecture 98: PHP mail function to send emails
Section 15: Build file upload system from scratch using PHP (Project)
Lecture 99: Design a file upload form using Bootstrap
Lecture 100: Checkout the file upload settings in PHP
Lecture 101: Temporary file variables while uploading
Lecture 102: PHP file validation before upload
Lecture 103: PHP move uploaded file to a specific location
Section 16: Introduction to MySQL database
Lecture 104: Introduction to MySQL
Lecture 105: Login to MySQL database server & execute basic SQL statements
Lecture 106: Keywords, Identifiers, Constants and Clauses
Lecture 107: Data Definition Language (DDL) & Data Manipulation Language (DML)
Lecture 108: How to create & use a database in MySQL
Lecture 109: How to create a table in MySQL database
Lecture 110: Update an existing table in MySQL
Lecture 111: Delete or remove an existing table from MySQL database
Lecture 112: Add data rows or records in MySQL table
Lecture 113: View or retrieve data rows from MySQL table
Lecture 114: Update data rows inside MySQL table
Lecture 115: Delete or remove data rows from MySQL table
Lecture 116: Important Data types in MySQL
Lecture 117: Important Conditions & Operators in MySQL
Lecture 118: Data grouping, sorting & dates in MySQL
Lecture 119: Important SQL constraints in MySQL database
Lecture 120: Learn how to design a relational database in MySQL
Lecture 121: How to backup & restore database in MySQL
Section 17: Introduction to phpMyAdmin
Lecture 122: Introduction to phpMyAdmin
Lecture 123: Manage databases using phpMyAdmin
Lecture 124: Manage database tables using phpMyAdmin
Lecture 125: Managing table data rows using phpMyAdmin
Lecture 126: Backup & restore MySQL database using phpMyAdmin
Section 18: Interacting with MySQL database using PHP
Lecture 127: How do we interact with database management systems using PHP?
Lecture 128: How to connect to MySQL database using PHP?
Lecture 129: How to create a new database & table in MySQL database using PHP?
Lecture 130: How to insert, update & delete data rows in MySQL database table using PHP?
Lecture 131: How to display data rows from MySQL database table using PHP?
Lecture 132: How to close MySQL database connection in PHP?
Section 19: Single page user management system (Project)
Lecture 133: Design user management page using Bootstrap
Lecture 134: Connect to database, display records & close connection
Lecture 135: Handle two form submission on single page
Lecture 136: Get and validate POST variable values
Lecture 137: Complete add user functionality
Lecture 138: Complete delete user functionality
Lecture 78: How to update cookies in PHP
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock