
This course includes our updated coding exercises so you can practice your skills as you learn.
See a demo
Before we start learning PHP Development, we must have a local development server on our computer. Here in this lecture, let's talk about the requirements for php and mysql installation.
The full form of WAMP is Windows, Apache, MySQL & PHP. We will learn how to install WAMP using Bitnami stack on Windows 10 operating system.
The abbreviation MAMP stands for MAC, Apache, MySQL & PHP. Let's install MAMP using Bitnami stack on MAC operating system.
LAMP means Linux, Apache, MySQL & PHP. We will install LAMP on Linux Ubuntu operating system.
I know you are excited to write & execute your first php syntax. And now, without further ado, let's write & execute first php code.
Congratulations for installing Bitnami stack successfully on your computer. Before we move ahead, lets take an overview of Bitnami stack on Windows, MAC and Linux operating system.
Not sure, which is free & best text editor for PHP? Let's take a look at free and paid text editors for PHP.
May be you already know what php stands for? or what is php abbreviation. Besides, full form of PHP (Old "Personal Home Page" & new "PHP: Hypertext Preprocessor"), let's understand what is PHP?
Rasmus Lerdorf developed PHP in 1994. Let's Take a brief overview of history of PHP in this lecture.
We already wrote our first php syntax or php code. Let's explore it in more details.
Not sure, how PHP works on a web server? Here is the explanation in this video.
Learn basic PHP configuration by modifying php.ini file.
The echo and print functions in PHP, which are used to output the text.
Is it possible to include HTML tags in PHP? Yes! It it, Let's learn how.
In this video we will learn how whitespace is treated in PHP.
Variables are one of the most important elements in PHP. Let's learn about PHP variables.
The constants are used for storing data or value. Let's practically learn about PHP constants.
Though, we think single quotes and double quotes are similar. There is difference how they work. Understand the difference between single quotes and double quotes in PHP.
Learn if PHP is case-sensitive or case-insensitive.
The main purpose of comment is to read more information about a program. Let's learn how to add comments in PHP.
A data type is the classification of data. Similar to other programming languages, PHP supports different data types. Let's learn about PHP data types.
A PHP Boolean data type can have only either true or false value.
PHP Integer data types are whole numbers or numbers without decimal point.
Float or Double in PHP is the number with decimal point.
A PHP string data type can contain letters, numbers or special characters.
PHP array can store other data types like string, integer float etc. in a single variable.
The PHP object is an instance of a class.
The PHP resource holds a reference to an external resource.
NULL in PHP represents a variable with no value.
An operator is something that takes one or more values (or operands) and yields another value. Let's learn about different PHP operators one by one.
Arithmetic operators in PHP are used to perform arithmetical operations like, addition, subtraction, multiplication, division etc.
The PHP assignment operator is used to assign a value to a variable.
PHP Comparison operators are used to compare the two values.
Errors are the part of PHP development process. We can ignore these errors temporarily using error control operators in PHP.
The increment & decrement operators in PHP increase or decrease the variable value by 1.
Logical operators in PHP are mainly used to combine conditional statements.
In this lecture we will learn about string operators in PHP.
The PHP array operators are used to compare array values.
A conditional statement in PHP is also know as conditional expressions or conditional constructs or conditional processing.
The if statement in PHP evaluates a single condition to either true or false.
If the condition is not true, in such case else statement is executed.
We can evaluate multiple conditions in PHP by using if elseif else statement.
Similar to if elseif else statement we can evaluate multiple conditions using PHP switch statements.
The PHP Loops are used to execute a block of code to a given number of times.
The PHP while statement executes a block of code as long as the given condition is true.
Similar to while statement, the do while statement in PHP executes a block of code as long as the given condition is true.
Let's understand the difference between while and do while in PHP.
A PHP for loop statement is also used to execute the block of codes for the given number of times.
The PHP foreach statement only work on arrays & objects.
We can break the current loop by using PHP break statement.
The PHP continue statement skips the current iteration and starts the loop from the beginning of next iteration.
An array in PHP is one of the data type which can hold multiple values in a single variable.
The indexed arrays are also know as numeric arrays and it stores each element or value with a numeric index.
A PHP associative array stores each element or value with a string index.
The array containing one or more arrays are called multidimensional arrays in PHP.
Let's learn some useful array functions in PHP.
The functions in PHP are pre-built programs which execute the program code and output result with or without accepting parameters.
PHP string functions are mainly used to manipulate string values.
PHP Math functions are used to manipulate integer or float values.
Let's explore different PHP array functions.
Let's learn how we can create our own functions that is user defined functions in PHP.
Create and use your first PHP user defined function.
Understand practically functions with arguments in PHP.
Functions with default arguments in PHP are used to set a default value to be used inside a function.
Get the function output result by using the functions that return the value in PHP.
A variable scope means, which part of PHP program can access or use the given variable. Understand what is the scope of constant & variable in PHP.
There are built-in variables, which are known as PHP Superglobals or PHP Global variables.
The PHP GLOBALS global variables references all variables available in global scope.
PHP SERVER global variable gives an information about the server & execution environment.
We can display more information about our environment variables using PHP ENV global variables.
The GET variable is an associative array of variables passed to the PHP page via the URL parameters. While POST variable is an associative array of variables passed to the PHP page via the HTTP POST method. FILES variable is also, an associative array of items uploaded to the current script via the HTTP POST method. Let's practically learn about these variables.
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.
There are quizzes, do it yourself assignment challenges on each section. This is really important to know how much you understood, and if you are able to use the skill we learned so far.
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.
Lightning fast support to your queries: I personally respond to my students queries (within 1-24hours) via direct messages or on Q&A section of the course. I reply on weekends too. So If you have any question feel free to PM me or ask questions on Q&A section.
Lifetime access to all the content and future updates of this course.
30 days money back guarantee. (I am sure you will never need this)
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.
What students say about this course? Checkout some of my students reviews for this course.
"I believe this is providing a detailed and thorough approach to learning PHP and MySQL. It seems to take a logical "step at a time" learning. echo "Nice job.";" By Brian Mellady
Watch introduction video & checkout "Curriculum" to see list of all sections and topics included in this PHP programming course.