PHP super series from scratch. Learn with projects

There are variety of editors to choose for web development. We will use Aptana as our main editor. Brackets is also a very impressive editor for quick edits. You can also go for notepad++ for quick edits.

This lecture will help you to install XAMPP on your system. This small server will enable php scripts to get processed. This video will also help you to trouble shoot a few problems that are most common with new users. Get ready with your own localhost.

This lecture is to just make sure that all students have got the text file for this course.

This video will help you to write the very first line of code in PHP. PHP syntax is very simple as compared to other programming languages and this is the reason why most of the programmer likes to learn PHP first and gets into Web development.

PHP is also capable of running system level commands and get the output on the web page. This video is a quick tour for the same. We will get the output of ping command on our page in this video

A variable is a value holder that holds the value for us and can be used latter time and for many times. In this movie we will learn to define variable in PHP. In php variable declaration is easy but there are few rules that we need to watch in this movie

Scope or validity of a variable is vital thing. One needs to understand that variable declared inside a function or working are is not available at all the places. Also there are some global and super global variables that we will learn latter in this couse

Echo is used to print an output of the code on the web page. Print is also used for exactly same work but if the working is same then why we have 2 function with same working. Get the difference between 2 in this video and learn which one is more good to use.

There are a variety of data categorization in computer world. For example alphabets are string type of variable in programming, numbers can be either integer or float types of values.

String is probably the most useful and mostly used data type in web development. When we interact with users using web forms then most of the time it is the string and we can perform variety of operations on strings with the help of in built functions of PHP

There is a feature in your mobile that gives you the ability to define acronym and whenever you type that acronym, mobile automatically write complete phrase. We will same the exact feature in php. this is also known as defining constants

Data needs to go through under a lot of evaluation like addition, subtraction etc. These kinds of operations are known as Arithmetic operations. Also data is assigned to variety of variables to be further evaluated.

When we compare data with other data there are variety of comparision to be done. Also there is an Increment and decrement operation that is very common in looping

A simple flow of code is a thing that never happen in web development. If needs to be placed where we wants to check the condition to be evaluated and only the true result will make the code get executed. If case of false result else part is executed

If and else is a great choice but for the evaluation of certain condition they are not the perfect choice. Therefore, sometime Switch and Case is a must to be implemented. This video will get you with every detail about Switch and case syntax

Loop is a must feature in programming. Writing code again and again is just a waste of time. So in programming we simply, write the code once loop it for repetition evaluation and doing the task if the test is cleared. While loop checks the condition first while do-while checks the condition at the end

For is probably the mostly used loop syntax over the entire internet and php is no exception. The reason is that the for loop is short in syntax and does all the thing in just 2 lines. Also for the array looping, there is a foreach loop which we will study latter in detail

When few lines of code are wrapped into a syntax than that syntax is known as function. Functions may also need arguments if coded that way. Learn how to code a function and more details about it.

Array is a collection of similar type of data. Php allows you to collect similar type of data in one place and use it latter. Some inbuilt function in php like get and post are key value type of array that are pre defined in php and are used very often

Superglobals are super variables that are pre defined and are available everywhere. Even inside the function and without defining it. All the variable are discussed in this movie and with the course you will understand the working and importance latter in this course.

Get and POST can be considered as the heart of entire PHP. Get and post allows you to pass the data from web page to server and to process the data. Get passes the data in clear text form while post passes the data in encryption form.

There are a variety of forms available in HTML but the processing of all types of data can be handled easily in php. In this movie we will pass the data from various web form and then we will print the data with the help of php

PHP can also make sure that some forms are compulsory to be filled on the web page. Although mostly this is done with the help of javascript but it is also recommended to do the same with php also

Although php gives you the ability to check few inputs with inbuilt functions but a lot can be checked with the help of regular expression. One arguments takes the regular expression and other takes the value to be checked

We can include the working of any php file in other php file. This can be done via two methods. One is include and other is require. include just gives a warning when file is not found but require breaks the application and does not process the application further

PHP is really very smart about dates. It can get date and process it with very accuracy. Also you can define your own date and print them in various syntax. Date can be looped and skipped on the basis of days name too.

php is fully capable to handle files and in variety of modes. With php you can create file and read existing file easily. In this video we will learn one of those method that we can use to do so

Although there are various method that can open file and do various operations on file but the most popular and powerful is fopen function and same is discussed in this movie

PHP allows you to open file in various formats or known as options such as append mode or write mode. Append mode allows you to simply add additional data into the file and preserving the previous data while write mode will erase all previous data.

A lot of PHP application allows user to upload various files such as JPEG, PNG, PDF and DOC. While taking file from the user a lot needs to be checked and also there is a problem of where to save that file and retrieve it later. In this movie we will learn about various security checks about the file.

A cookie is often used to identify a user. A cookie is a small file that the server embeds on the user's computer. Each time the same computer requests a page with a browser, it will send the cookie too. With PHP, you can both create and retrieve cookie values.

When you work with an application, you open it, do some changes, and then you close it. This is much like a Session. The computer knows who you are. It knows when you start the application and when you end. But on the internet there is one problem: the web server does not know who you are or what you do, because the HTTP address doesn't maintain state.

Session variables solve this problem by storing user information to be used across multiple pages (e.g. username, favorite color, etc). By default, session variables last until the user closes the browser.

If you want to store some data in database then there are few configuration that need to be checked in php. Also you need to set admin account to make sure that connection is being created properly and our PHP code is able to interact with database.

The very part is to make sure that our code is able to interact with database. Make sure that you have entered correct details like username and password. Once the connection is made properly, only then proceed with further code.

Creating a database is simple in php. All that is working is the simple SQL binded with php functions that are capable enough to create database. You will need special CREATE privileges to create or to delete a MySQL database.

Creating a TABLE is simple in php. All that is working is the simple SQL binded with php functions that are capable enough to create table. A database table has its own unique name and consists of columns and rows.

We have done some manual configuration in the previous videos that will for sure create some password problems in GUI access. In this video we will learn to solve and overcome such problems.

In this movie we will learn to insert some data in the existing tables. Also we will learn some in built functions of PHP that will help us to retrieve ID of recently inserted data. PHP is full of such useful functions and we will advice all to take a look on those functions

The SELECT statement is used to select data from one or more tables. If there are more than zero rows returned, the function fetch_assoc() puts all the results into an associative array that we can loop through. The while() loop loops through the result set and outputs the data from the id, firstname and lastname columns.

Many times a project just comes in to modify. In that case we need to simple create a database with same name and import all the tables of that database in exact same format. This can be done using import feature that takes [dot]sql files.

So, our goal is to create a project and very first part to design a project is to set the database. Database functionality is crucial and you should have answers of all the question about the storage of values and tables required for it.

Next step would be to connect database and for a variety of page we will need those connection. For this we will create a special page that we will include at the top of every page. This page will create connection with the database.

First part of creating such type of application is to make sure that user register at our website. We need to check with database that user is registered once and there is no double account problem. We will also conform email and password from the user twice.

Once the user have successfully registered then user might want to login to your website. So we need to provide a page that can ask for details from the user and then we need to verify that details with database and then user should a different page.

Now, the user is being logged in, he wants to have a profile page where he can upload his/her photograph and every time he/she logs in back that photograph should be served back correctly. So, there should be a match from the database.

One of the most demanded project at sites like Freelancer is to design a 5-10 page website with working contact form. This job can be easily done by you after watching this video. The mail function will use mail server of the server and will directly transfer queries to your mail inbox.

Summary and future updates

In this lecture we will explore about PHP Data Objects and drivers for pdo

In this lecture we will learn about setting up a connection with database using pdo style

In this movie we will learn to create a new database using pdo style

In this movie we will learn to create table in an existing database in pdo style

In this movie we will learn to insert single value using sql query in pdo style

In this movie we will learn to get last insertion ID using pdo

In this movie we will learn to insert multiple values in database using pdo

In this movie we will learn that why object oriented programming is essential to learn