PHP for Beginners

In this video we'll install the XAMPP web server, database server and PHP package on Mac OS X.

In this video we'll install the XAMPP web server, database server and PHP package on Ubuntu Linux.

In this video we'll install the open-source Atom code editor on Microsoft Windows.

In this video we'll install the open-source Atom code editor on Mac OS X.

In this video we'll install the open-source Atom code editor on Ubuntu Linux.

In this video you'll learn what variables are, and how to create them in PHP. We'll also look at how to name variables, including best practices.

In this video you'll learn how to create variables containing different types, starting with strings and numbers, including integers and floating point values.

In this video you'll learn how to create variables containing boolean values (true and false) and the special null value.

In this video you'll learn how to perform operations on variables, such as mathematical operations like add, multiply and so on; and operations on strings like concatenation.

Test your knowledge of basic PHP concepts, and variables and operators.

In this video you'll learn how to assign manual array indexes to array elements, and how to use strings as array indexes to create associative arrays.

In this video you'll learn how to create multidimensional arrays, or arrays of arrays, and also how to access values inside them

In this video you'll learn your first control structure in PHP: the foreach loop, and how to use this to process each individual element of an array when you don't know how many elements are in the array.

In this video you'll learn how to use a foreach loop to access the index of each array element in addition to its value.

Test your knowledge of arrays in PHP.

In this video you'll learn how to run code based on a condition, using an if statement. You'll also learn how to run alternative code by extending the if statement using an else block.

In this video you'll learn how to compare one value to another using the various comparison operators that PHP provides, for example equals, not equal, less than, greater than or equal to and so on.

In this video you'll learn how to execute a block of code multiple times based on a condition, using a while loop control structure.

In this video you'll learn how to execute a block of code a specific number of times using a for loop.

In this video you'll learn how to use an alternative to many elseif statements: the switch statement. You'll learn how it's used to compare a variable or value to many different values and execute code based on that comparison.

Test your knowledge of control structures and comparison operators in PHP.

In this video you'll learn what HTML is, and how it's used to markup text to tell the browser how it's structured. You'll also learn the two types of HTML element, and how to add attributes to an HTML tag.

In this video you'll learn how to structure an HTML document using head and body sections, and how to add the title to the top of the browser window using the title element.

In this video you'll learn how to structure the content using header elements and paragraphs.

In this video you'll learn how to emphasise or give text importance using the em and strong elements

In this video you'll learn how to display lists of items in HTML, using ordered lists that have numbers, and unordered lists that have bullet points

In this video you'll learn how to insert images into an HTML document, including best practices for referencing the image

In this video you'll learn how to create a link from one page to another in an HTML document, using the anchor tag.

In this video you'll learn how to divide up your HTML code semantially using semantic sectioning elements like header, nav, main, article, section and so on.

Test your knowledge of the basics of HTML.

In this video you'll learn how to mix PHP and HTML to display dynamic content inside an HTML document. You'll also learn how to use the PHP opening and closing tags inside an HTML document, and the shortcut syntax for echoing out a value.

In this video you'll learn the best way to mix PHP control structures like if, foreach and so on with HTML, using an alternative syntax where necessary.

In this video you'll learn how to make your HTML documents easier to read by using whitespace characters (spaces, tabs, newlines and so on) and comments

A temporary addendum describing a change to the following video.

In this video you'll learn how to make your PHP code more maintainable and portable by using comments and coding standards, such as PSR-2

Test your knowledge of mixing PHP and HTML.

In this video you'll learn how to use the phpMyAdmin tool to connect to the database server and create a new database, ready to store data.

In this video you'll learn how structured data is stored inside a relational database, and you'll use phpMyAdmin to create a new table to store articles. You'll also learn best practices for naming tables inside a database.

In this video you'll learn how to access data in the database using structured query language, or SQL. You'll learn how to use the SELECT statement to select all or some columns, and how to use the WHERE clause to restrict the data returned based on one or more conditions.

In this video you'll learn how to use indexes to make queries faster when selecting data using the SELECT statement in SQL. You'll also learn how to return the results ordered by one or more columns using the ORDER BY clause.

In this video you'll learn how to connect to a database from a PHP script using MySQLi.

In this video you'll learn how to send an SQL query to the database from PHP and how to get the results back to display them.

In this video you'll combine PHP and HTML to retreive some data from the database using PHP, and display it in the browser using HTML to format it.

Test your knowledge of using databases with PHP.

In this video you'll learn how to add another page, this time to select and display one record from the database instead of several. You'll learn how to display a message if the record isn't found in the database.

In this video you'll learn how to pass data to a script in the URL using the query string, and how to access it in PHP using the $_GET superglobal.

In this video you'll learn how to extract repeated code out into a separate file, and how to include that file in another script. You'll also learn the difference between include and require, and include_once and require_once.

In this video you'll learn how to use an .htaccess file to secure access to an included file

Test your knowledge of adding multiple pages to PHP; how to secure them and how to avoid database security issues.

In this video you'll learn how to create a form in HTML so the user can submit data to a PHP script. You'll also learn how to retrieve that data in PHP.

In this video you'll learn what the two different form methods are, GET and POST, how to use them and what they are for.

In this video you'll learn how to create basic input types in a form: text, password, number and so on. You'll also learn what these look like in different browsers, and what happens when a browser doesn't support one of the more recent types introduced in HTML5.

In this video you'll learn how to access the data submitted from the form in PHP. You'll also learn how to submit a form using button elements, and how to name the form controls and access specific inputs in a script on the server.

In this video you'll learn how to create an input control that has multiple lines of text: the textarea element

In this video you'll learn how to use a select element to present a fixed list of options in a form, using option elements inside the select element

In this video you'll learn how to use inputs of type checkbox to present an option that can be toggled on or off. You'll also learn how the values from checkboxes are submitted, and the best way to use multiple checkboxes in a form.

In this video you'll learn how to use radio inputs to present a list of options where only one option can be selected at once, deselecting other options.

In this video you'll learn how to add a text caption to an input that is associated to that input, which is better for accessibility. You'll also learn how to check checkboxes and radio buttons by clicking the text next to that control using label elements.

In this video you'll learn how to make the form easier to use by grouping controls together in fieldsets, and how to use placeholder text to give the user a hint as to what to put inside a control.

In this video you'll learn about common form attributes and how they affect input controls: making them readonly, disabling them, and setting the focus automatically when the form is loaded.

In this video you'll learn how to validate the data in a form before it's submitted using HTML5 form validation attributes. You'll also learn how inputs of different types automatically validate the type of data entered into them depending on the type of the control.

Test your knowledge of HTML forms.