PHP MySQL Fundamentals from Scratch with Examples & Projects

Pradnyankur Nikam, Freelancer PHP & WordPress developer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
145 Lessons (14h 53m)
    • 1. Introduction

      0:59
    • 2. Requirements for PHP MySQL Installation

      4:50
    • 3. Download Install WAMP on Windows 10 Operating System

      12:01
    • 4. Download Install MAMP on MAC Operating System

      11:15
    • 5. Download Install LAMP on Linux Operating System

      11:12
    • 6. Your First PHP Program Hello World

      11:29
    • 7. A brief overview of Bitnami WAMP MAMP LAMP stack manager tool

      32:10
    • 8. Download and Install Text Editor for PHP

      4:33
    • 9. Assignment 1 - Question

      1:01
    • 10. Assignment 1 - Solution

      0:46
    • 11. What is PHP

      3:34
    • 12. History of PHP

      2:30
    • 13. Lets understand PHP Syntax

      1:53
    • 14. Understand how PHP codes are executed on a web server

      2:06
    • 15. View & modify PHP configuration setting Display PHP errors and disable cache

      13:26
    • 16. The echo & print functions in PHP

      13:01
    • 17. Embed HTML tags in PHP

      6:22
    • 18. Whitespace in PHP

      4:12
    • 19. Define and use PHP Variables

      8:22
    • 20. Define and use PHP Constants

      6:21
    • 21. Single quotes vs Double quotes

      7:55
    • 22. Are PHP codes case sensitive

      5:45
    • 23. How to add comments in PHP program

      6:21
    • 24. Data types in PHP

      1:24
    • 25. Boolean data type in PHP

      5:06
    • 26. Integer data type in PHP

      5:14
    • 27. Float or Double data type in PHP

      3:55
    • 28. String data type in PHP

      4:11
    • 29. Array data type in PHP

      3:40
    • 30. Object data type in PHP

      4:57
    • 31. Resource data type in PHP

      3:08
    • 32. NULL data type in PHP

      4:49
    • 33. What are operators & types of operators in PHP

      1:30
    • 34. PHP Arithmetic operators

      3:41
    • 35. PHP Assignment operators

      4:50
    • 36. PHP Comparison operators

      9:07
    • 37. Error Control Operators

      3:27
    • 38. PHP Increment & Decrement operators

      5:31
    • 39. PHP Logical operators

      8:18
    • 40. PHP String operators

      3:47
    • 41. PHP Array operators

      7:21
    • 42. What is conditional statement in PHP

      1:08
    • 43. PHP if statement

      6:20
    • 44. PHP if else statement

      6:02
    • 45. PHP if elseif else statement

      8:20
    • 46. PHP switch statement

      10:02
    • 47. What is Loop & Types of loop statements in PHP

      1:25
    • 48. PHP while loop statement

      6:19
    • 49. PHP do while loop statement

      4:10
    • 50. The difference between while and do while statement in PHP

      3:43
    • 51. PHP for loop statement

      5:36
    • 52. PHP foreach loop statement

      6:13
    • 53. PHP break statement

      6:31
    • 54. PHP continue statement

      4:36
    • 55. What is array & types of arrays in PHP

      1:04
    • 56. Indexed Arrays in PHP

      16:48
    • 57. Associative Arrays in PHP

      10:29
    • 58. Multidimensional arrays in PHP

      7:40
    • 59. Useful Array Functions in PHP

      9:47
    • 60. What are Internal or Built in functions in PHP, How to find and use functions in PHP

      4:14
    • 61. String functions in PHP

      10:43
    • 62. Math functions in PHP

      5:04
    • 63. Array functions in PHP

      11:17
    • 64. What are user defined functions, Why we need user defined functions

      3:27
    • 65. Define and use your first PHP function

      5:43
    • 66. Define functions with arguments in PHP

      9:08
    • 67. Define functions with default arguments in PHP

      12:43
    • 68. Define functions that return the value in PHP

      7:45
    • 69. What is constant variable scope in PHP

      7:11
    • 70. What are Superglobals or Global variables in PHP

      1:00
    • 71. PHP GLOBALS global variable

      6:43
    • 72. PHP SERVER global variable

      3:33
    • 73. PHP ENV global variable

      4:48
    • 74. PHP GET, POST, FILES, REQUEST, COOKIE SESSION global variables

      12:39
    • 75. View and set timezone in PHP

      9:19
    • 76. Date time formatting in PHP

      4:18
    • 77. Some useful date time functions in PHP

      13:48
    • 78. The cookies & sessions in PHP

      0:33
    • 79. What are cookies & How to create cookies in PHP

      7:03
    • 80. How to read cookies in PHP & Where cookies are stored

      7:47
    • 81. How to update cookies in PHP

      2:57
    • 82. How to delete cookies in PHP

      6:44
    • 83. What are sessions & How to create sessions or session variables in PHP

      2:47
    • 84. How to read session variables in PHP & Where session variables are stored

      6:47
    • 85. How to update session variables in PHP

      2:38
    • 86. How to delete session variables in PHP

      3:50
    • 87. The difference between cookies and sessions

      9:03
    • 88. Create web page links and URLs in PHP

      4:43
    • 89. Pass variables and values via GET method

      5:20
    • 90. The importance of URL encoding in PHP

      6:56
    • 91. Retrieve or extract the values via POST method

      5:29
    • 92. PHP include & require functions and the difference between include & require

      8:39
    • 93. Absolute path vs Relative path in PHP

      12:47
    • 94. How to redirect web pages in PHP

      2:40
    • 95. Design a contact form using Bootstrap

      7:26
    • 96. Get & display variable values from contact form

      4:32
    • 97. Validate contact form input values using PHP

      20:48
    • 98. Sanitize contact form input values using PHP

      11:02
    • 99. How to send emails from Localhost using PHP on Windows Operating System

      8:09
    • 100. How to send emails from Localhost using PHP on MAC Operating System

      6:35
    • 101. PHP mail function to send emails

      5:12
    • 102. Section 14 Assignment - Question

      1:07
    • 103. Section 14 Assignment - Solution

      7:38
    • 104. Design a file upload form using Bootstrap

      3:12
    • 105. Checkout the file upload settings in PHP

      3:08
    • 106. Temporary file variables while uploading

      3:21
    • 107. PHP file validation before upload

      11:21
    • 108. PHP move uploaded file to a specific location

      4:04
    • 109. Section 15 Assignment - Question

      1:17
    • 110. Section 15 Assignment - Solution

      6:34
    • 111. Introduction to MySQL

      2:31
    • 112. Login to MySQL database server & execute basic SQL statements

      6:36
    • 113. Keywords, Identifiers, Constants and Clauses

      2:24
    • 114. Data Definition Language (DDL) & Data Manipulation Language (DML)

      1:31
    • 115. How to create & use a database in MySQL

      3:27
    • 116. How to create a table in MySQL database

      5:58
    • 117. Update an existing table in MySQL

      6:15
    • 118. Delete or remove an existing table from MySQL database

      1:58
    • 119. Add data rows or records in MySQL table

      6:09
    • 120. View or retrieve data rows from MySQL table

      2:38
    • 121. Update data rows inside MySQL table

      3:50
    • 122. Delete or remove data rows from MySQL table

      2:35
    • 123. Important Data types in MySQL

      1:29
    • 124. Important Conditions & Operators in MySQL

      8:19
    • 125. Data grouping, sorting & dates in MySQL

      9:29
    • 126. Important SQL constraints in MySQL database

      9:12
    • 127. Learn how to design a relational database in MySQL

      11:39
    • 128. How to backup & restore database in MySQL

      7:58
    • 129. Section 16 Assignment Question

      1:43
    • 130. Section 16 Assignment Solution

      11:01
    • 131. Introduction to phpMyAdmin

      7:04
    • 132. Manage databases using phpMyAdmin

      3:09
    • 133. Manage database tables using phpMyAdmin

      7:17
    • 134. Managing table data rows using phpMyAdmin

      3:38
    • 135. Backup & restore MySQL database using phpMyAdmin

      7:15
    • 136. Section 17 Assignment Question

      0:56
    • 137. Section 17 Assignment Solution

      5:09
    • 138. How do we interact with database management systems using PHP

      2:04
    • 139. How to connect to MySQL database using PHP

      5:09
    • 140. How to create a new database & table in MySQL database using PHP

      9:14
    • 141. How to insert update & delete data rows in MySQL database table using PHP

      9:01
    • 142. How to display data rows from MySQL database table using PHP

      7:35
    • 143. How to close MySQL database connection in PHP

      3:57
    • 144. Section 18 Assignment Question

      1:02
    • 145. Section 18 Assignment Solution

      6:05

About This Class

PHP MySQL Fundamentals from Scratch with Examples & Projects

There are many online php courses with certificate. Some instructors teach fundamentals of PHP with MYSQL for Dynamic Websites, while some explain the concepts practically using php projects. In order to work on live projects, it is necessary to have practical understanding of php and mysql. Since, there are many courses, it is really difficult to guess which is the best php video tutorial for you. In order to clear your confusion, I've created this course for you. The course lectures are organized in such a way that you will learn php from scratch step by step. First we will understand php language fundamentals, then move to MySQL database and then complete a couple of php mysql projects.

Why should you take this PHP MySQL course?

This course contains 15+ hours of video content, 20+ sections, 130+ video tutorials. In short it have almost every important topic you need to learn as a PHP developer.

You will learn PHP fundamentals as well as MySQL database development. Please Note: Every topic is discussed with examples.

We will also design PHP MySQL projects from scratch, relevant to the topics we've learned.

You will learn PHP programming from scratch and effective database designing using MySQL database server for your websites or web applications. Steps involved in the learning process would be,

  • Step 1: You will require local development environment to write and test the examples covered in the course. So, We will start from PHP, MySQL installation and configuration.
  • Step 2: Then You will be introduced to PHP's most important, basic and fundamental topics like, data types, operators, conditional & loop statements, arrays, functions, date & time, cookies & sessions etc. After that, we will explore the skill required to develop web pages.
  • Step 3: When you are confident enough with PHP programming, we will learn database development using MySQL database server. We will understood database development using MySQL command line client tool as well as phpMyAdmin.
  • Step 4: When you have both the tools (PHP & MySQL), we will learn Interacting with MySQL database using PHP programming.
  • Step 5: Throughout your journey, you'll be asked to solve quizzes, complete do it yourself assignment challenges, solve coding exercises.

Do you know the Benefits of learning PHP & MySQL?

Probably, you already know the benefits of PHP & MySQL. That might be the reason you are exploring this course content. If you don't know, here are some of the benefits.

  • If you are a student, you can create academic projects.
  • PHP is simple and easy to understood. It will help you understood programming concepts quickly.
  • It is free & open source. You can design free/paid applications without worrying about license.
  • PHP has a large community of developers. And there are various PHP resources available like, video tutorials, articles/blogs, documentation, FAQ's, discussion boards etc. You can quickly get the help you need.
  • If you are completely new to PHP, I'll recommend you to Google "Benefits of PHP" and checkout the information available online.

Enroll to this course now, and start learning PHP.