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.8 (22 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,171 students enrolled
$20
Take This Course
  • Lectures 37
  • Length 6 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2012 English

Course Description

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!

</p>

What are the requirements?

  • Some CSS (not essential)
  • Basic HTML is required (forms, lists that type of thing)

What am I going to get from this course?

  • A concrete foundation in the PHP language
  • Basic SQL skills
  • The confidence to extend the language and carry on learning yourself

What is the target audience?

  • Complete Beginners

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Started
Article
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…
08:24

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

Article
 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…
Section 2: Our First Steps
07:52

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.

14:55

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

12:44

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

07:39

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

10:24

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

Article
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…
Section 3: Conditionals
07:41

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

08:27

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

Section 4: Loops
08:11

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

10:23

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

04:53

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! 

Section 5: Functions
12:52

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

08:18

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

08:29

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.

Section 6: Forms
04:38

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

09:59

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


20:50

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

18:16

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

Section 7: Tracking Users
08:32

Working with cookies to recognise individuals on your website!

07:24

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

Section 8: SQL Basics
09:36

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

09:47

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

06:24

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

02:21

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

04:01

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

16:30

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

10:42

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

Section 9: Putting It All Together!
03:56

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.

09:28

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!

18:54

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

10:12

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

19:09

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.

4.8 kB

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

Section 10: A Sad Goodbye
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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Ryan Kennedy, 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!

Ready to start learning?
Take This Course