Easy PHPeasy - PHP & MySQL for code-phobes!

Welcome to the world of Arrays, now we can store more than one item at a time! In this lesson we discuss the different types of arrays and how to set them up.

Here are all the functions you can use to manipulate arrays -  http://www.w3schools.com/php/php_ref_array.asp

We learn how to use the settype() function and type casting and also look at ways to test for certain datatypes.

In this lecture we very quickly look at objects and discover properties and methods

The first of our conditionals the If statement, the If else statement and the if else if statement are all covered in this lesson.

In this lesson we take a look at the switch statement and use it to replace our large clumsy if else statements.

And introduction to our first big loops, the while loop and the do-while loop.

Let's take a look at for loops and how we can use them to walk through items in our arrays.

Our final loop of the this chapter is the foreach loop, here we learn how to use it to iterate through our associative arrays with ease! 

An introduction into the world of functions, a useful tool to help us cut down on repeating our code.

Let's take a look at how we can return values from our functions for further manipulation and discuss the concept of variable scope.

There are a few different ways we can retrieve and  manipulate date and time related data. In this lecture we look at the time() function, the getdate() function and finally the date() function.

A quick introduction to HTTP not really needed for this chapter but why not? 

Our first superglobal array is the $_GET global, used for retrieving items stored in the get array after a form is submitted.

A look at the $_POST superglobal and some more forms!

In this lesson we take a look at uploading files through our forms and proccessing them using the $_FILES superglobal.

Working with cookies to recognise individuals on your website!

Let's learn how to keep track of users and assign them a session id, add products then destroy their id.

An introduction into what mysql is and how we can get it started.

In this lecture we learn how to use INSERT to create rows in our mysql database 

In this lecture we learn how to use the SELECT keyword to find rows in our database

We learn how to use the UPDATE keyword in sql this allows us to update rows that we have inserted into our mysql database.

In this lecture we learn how to use the DELETE keyword to delete certain rows from our mysql database

Now we have a solid understanding of sql let's move back to php and learn how execute sql from php.

Moving on from the last lecture we look at how we can use the fetch() method to select results from our database.

Creating A Blog - this is our first step in creating a real world web application, in this lecture we create a database that we can use with our blog to store our posts.

Creating A Blog - The next step is to get our admin page ready, this is the page we can use to create new posts and get our blog going!

Creating A Blog - In this lecture we look at the process of using our inputted values to create a new record in our database using PDO

Creating A Blog - In this lecture we create our functions.php file that holds all our functions that interact with the database.

Creating A Blog - This is the final lecture of this chapter and our blog has come to an end! In this lecture we look at how we can use the functions we created in the last lecture to display the posts we want.

Download the source code here, most php is commented to help you understand it easily.

 A rant from me about what you could do to take php to it's next level. Do bare in mind that I plan to make more tutorials and extend this tutorial as time goes on, I will update everyone as I add lessons

Links in this lesson -

Codeigniter Framework - http://codeigniter.com/
Laravel Framework - http://laravel.com/
Cakephp Framework - http://cakephp.org/

My Library - http://ryankennedy1991.github.com/toure/

PHP Documentation - http://php.net/docs.php