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>
An introduction on how to get your local server up and running and a quick talk about editors.
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.
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
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 -
PHP Documentation - http://php.net/docs.php
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!