Easy PHPeasy - PHP & MySQL for code-phobes!
4.7 (23 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,176 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Easy PHPeasy - PHP & MySQL for code-phobes! to your Wishlist.

Add to Wishlist

Easy PHPeasy - PHP & MySQL for code-phobes!

An introduction to the programming world through PHP for complete newbies. Learn the foundation & build your own Blog!
4.7 (23 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,176 students enrolled
Created by Ryan Kennedy
Published 7/2012
Price: $20
30-Day Money-Back Guarantee
  • 5.5 hours on-demand video
  • 3 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • A concrete foundation in the PHP language
  • Basic SQL skills
  • The confidence to extend the language and carry on learning yourself
View Curriculum
  • Some CSS (not essential)
  • Basic HTML is required (forms, lists that type of thing)

This PHP and MySQL Tutorial is aimed at those without any experience of programming and its terminology, I will take you slowly and carefully through the levels of PHP and server side scripting. PHP is extremely popular because of its easy learning curve and ability to adapt dynamically.

Web sites like Facebook are built on PHP and with such a huge community following it; PHP is only getting better and better.

So join me for PHP with MySQL Essential Training today and we can go from zero to hero in no time!

Who is the target audience?
  • Complete Beginners
Students Who Viewed This Course Also Viewed
Curriculum For This Course
37 Lectures
Getting Started
3 Lectures 10:59
Is PHP the language for me? When beginning to learn a language there are a few things you must take into consideration, what you hope to achieve with the language is a key factor, for instance if your main goal is manipulate the webpage or add small dynamic events to the webpage it may be overkill t…
Preview 01:23

An introduction on how to get your local server up and running and a quick talk about editors.

Preview 08:24

 Ok, so now we have our environment set up and we are are all eager to get going, but before we jump right in there we just need to go over a few key parts of the syntax that you will be seeing a lot of from now on. Even though I will try and explain everything in this lecture I will also repeat mys…
Be We Begin - Syntax
Our First Steps
6 Lectures 56:11

An introduction into the basic datatypes before we jump into the nitty gritty. We also take a quick look at variables and how we can assign to and retrieve data from them.

Preview 07:52

A closer look at strings and few functions we can use to manipulate them, although we don't go to deep into the magic of strings we do cover some essentials.

Now you understand strings make sure to check out all the string functions - http://www.w3schools.com/php/php_ref_string.asp

Preview 14:55

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

Datatypes - Arrays

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

Datatypes - Testing & Setting Types

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

Datatypes - Objects

So far we have learnt about lots of different statements, variables and data types. Let's bring them all together now and learn about operators. Operators are symbols we can use to do things like add, divide assign values too and much more.  I have decided to do the following lesson in text format b…
2 Lectures 16:08

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

If, if-else, if-elseif Statements

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

Switch Statements
3 Lectures 23:27

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

While Loops & Do-While Loops

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

For loops

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! 

Foreach Loops
3 Lectures 29:39

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

Functions- Creation

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

Functions - Returning Values & 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.

Date & Time Functions
4 Lectures 53:43

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

Introduction to HTTP

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

The $_GET Superglobal

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

The $_POST Superglobal

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

Uploading files and the $_FILES Superglobal
Tracking Users
2 Lectures 15:56

Working with cookies to recognise individuals on your website!

Cookies & the $_COOKIE Superglobal

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

Sessions & The $_SESSION Superglobal
SQL Basics
7 Lectures 59:21

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

Introduction to MySQL

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

CRUD: Create

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

CRUD: Read

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

CRUD: Update

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

CRUD: Delete

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

Using PHP & MySQL Together - Connection

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

Using PHP & MySQL Together - SELECT
Putting It All Together!
6 Lectures 01:01:39

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 - Database Design

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 - The Admin Page

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 - Creating New Posts

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 - Creating Our Functions

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.

Creating A Blog - Displaying Posts

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

Blog Source Code
4.8 kB
A Sad Goodbye
1 Lecture 13:24

 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

Where To Go From Here
About the Instructor
Ryan Kennedy
4.7 Average rating
23 Reviews
1,176 Students
1 Course
Director of Make It Value CIC

I am 25 from Manchester, UK and I have been working as a web developer for a number of years now, I have a bit of a close bond with php so that is what I specialise in! Although as a web developer by trade I am up to date with everything e.g node.js, python, RoR. I am currently juggling various responsibilities as the director of a CIC (Community Interest Company) helping social enterprises get up to speed with social media and bringing their websites up to standard. Hopefully I have picked up enough knowledge so far to pass on some genuine skill sets for anyone who cares to watch!