Lecture 118: Data grouping, sorting & dates in MySQL

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

Section 2: Introduction to PHP and Basic Configuration Settings

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

Section 3: PHP Data Types

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

Section 4: PHP Operators

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

Section 5: PHP Conditional Statements

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

Section 6: PHP Loop Statements

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

Section 7: PHP Arrays

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

Section 8: Functions in PHP

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

Section 9: User Defined Functions in PHP

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

Section 10: PHP Superglobals or Global variables

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

Section 11: PHP Date and Time

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

Section 12: PHP Cookies & Sessions

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

Section 13: Building Web Pages in PHP

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

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

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

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

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

Section 16: Introduction to MySQL database

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

Section 17: Introduction to phpMyAdmin

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

Section 18: Interacting with MySQL database using PHP

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

Section 19: Single page user management system (Project)

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

Lecture 118: Data grouping, sorting & dates in MySQL

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock