Installing XAMPP

from: PHP 5.3

About this lesson

This lesson walks you through getting PHP 5.3, Apache 2.2, MySQL 5, and phpMyAdmin installed on your computer using the free XAMPP installation tool.

From: PHP 5.3

Learn the nuts and bolts of advanced web application programming! Join Edward Tanguay as he dives into PHP programming. In his workshop, you will learn that it only takes a few minutes to get an Apache web server, a MySQL database, PHP 5.3, and the Eclipse editor up and running using the free XAMPP installation tool. Edward will then cover the PHP syntax, such as operators, loops and variables, before moving on to make you a PHP expert, tackling object orientation, databases, XML parsing, web services, security and much more. The training also includes important new features of PHP 5.3, such as namespaces, lambdas, and late static binding. Once you complete this video training, you will have the skills you need to build next-generation dynamic websites.

$39.99

8 hrs

Buy now

Similar Courses

The first section of this training deals with using free tools to get a PHP development environment set up on your Windows computer so you can develop and test PHP websites.

Installation
- This lesson walks you through getting PHP 5.3, Apache 2.2, MySQL 5, and phpMyAdmin installed on your computer using the free XAMPP installation tool.
  
  Installing XAMPP
  
  07:28
- In this video, you'll learn how to install Eclipse PDT and create a Hello World PHP program.
  
  Installing Eclipse
  
  11:10
- Here's how to use the most important features of Eclipse for PHP programming, e.g. code assist.
  
  Eclipse Basics I
  
  08:18
- This is the second video on how to use the most important features of Eclipse for PHP programming, e.g. templates.
  
  Eclipse Basics II
  
  09:59
In this section, you will learn the basics of the PHP language itself. If you are new to programming, this section is essential. If you already program in another language and are learning PHP, you will learn new syntax for already familiar commands.

PHP Basics
- This lesson teaches the basics of how to assign and display the various types of variables in PHP, including string, integer, boolean, etc.
  
  Variables
  
  09:24
- This session is about operators, such as ==, !=, ===, !==, <, >, <=, >=, $score++, || (or), && (and).
  
  Operators
  
  07:39
- This video explains conditionals indicated by if, ifelse, switch and the ternary operator as an abbreviated if statement.
  
  Conditionals
  
  10:06
- This lesson explains how to use the foreach, for, and while loops.
  
  Loops
  
  03:50
- This lesson explains how to use functions, parameters, and what global and local scope is.
  
  Functions
  
  06:36
- Learn how to create indexed and associative arrays, count(), and to avoid an important trap along the way.
  
  Arrays I
  
  08:02
- This video shows explode(), implode(), multidimensional arrays representing tables in a database, and how to sort arrays.
  
  Arrays II
  
  07:04
- In this session, you'll learn how to run through the characters of a string as if the string is an array and how to use strtolower(), strtoupper(), time() and substr().
  
  Strings
  
  07:23
- This lesson shows how to display the current date and time in U.S. and German formats, day of week, week number, RFC 282 formatted dates, etc. And there's even more: You'll also learn how to get this information for relative dates (e.g. tomorrow) or specific dates and times.
  
  Dates
  
  09:37
- Lots of math in this section: Watch how to get the minimum, maximum and average from a list of numbers. Also see how to get the remainder of a division, how to round up and down, how to get the absolute value, and how to generate random numbers.
  
  Math
  
  08:29
- This video shows you how to build an easy-to-use library of functions by using require_once and include_once to include functions and classes that you need in every file. It also shows how Eclipse is able to show pop-up information on all methods and classes no matter where they are located.
  
  Building a Library with External Files
  
  11:15
This section introduces you to object-oriented programming by showing you how to build a useful class called SmartUrl, which simplifies the building of URLs with parameters. After you finish this section, you will be able to develop your own classes.

Object-Oriented Programming
- In this video, you'll create a class called SmartUrl that has a constructor. This constructor accepts a value that is saved as an internal variable. Then a public method is called to output the internal variable.
  
  SmartUrl Class: Constructors, Public Methods, Private Variables
  
  03:44
- This follow-up video continues to build the SmartUrl class by enabling the adding of parameters to the URL.
  
  SmartUrl Class: Adding Parameters (Public Method)
  
  07:31
- In this part of the SmartUrl series, you'll add two properties called "File" and "Text" and a public method called "renderLink()".
  
  SmartUrl Class: Properties
  
  08:48
- In the final part of the SmartUrl series, you'll add a static method, which allows you to create a hyperlink with parameters and variable text all in one line.
  
  SmartUrl Class: Static Methods
  
  11:07
- This lesson shows an example of using inheritance, private/protected variables, method overriding, and calling parent methods.
  
  Inheritance
  
  10:36
- This lesson shows an example of creating an interface iFlashcard to allow the classes FAQs and Books to be treated as flashcards.
  
  Interfaces
  
  07:44
The real-world examples in this section show you how to use regular expressions.

Regular Expressions
- This video walks you through building up a regular expression that validates German and Austrian zip codes.
  
  Validating Text (preg_match)
  
  07:06
- This video shows how to use preg_match_all to find all occurrences of a string inside another string.
  
  Finding All Matching Text (preg_match_all)
  
  03:35
- This lesson shows how to use preg_split to get all the words out of a sentence into an array.
  
  Splitting Text (preg_split)
  
  02:28
- In this session, you'll learn how to use preg_replace to make edits, e.g. "Jim Smith" to "Smith, Jim", and how to reformat telephone numbers.
  
  Replacing Text (preg_replace)
  
  06:47
This section is for building an HTML form formatted with CSS and validated with PHP code. When you finish, you will know how to use PHP, HTML and CSS together to make your own interactive web forms to gather and process information.

Forms
- Learn how to build a cross-browser, engaging form with HTML, CSS and PHP.
  
  Building a Form
  
  08:43
- This lesson tells you how to make a page that processes the data on the form and sends the user back to the form where a message is displayed thanking him for entering information.
  
  Building a Form Process Page
  
  13:00
- This video shows you how to validate all of the form elements on the form, e.g. displaying a message under required fields that the user did not fill in.
  
  Validating a Form
  
  15:13
- Here's how to add radio buttons, a multiple dropdown, a classic dropdown, a checkbox and a hidden variable to the form.
  
  Building a Complex Form
  
  10:31
- Watch how to validate the checkbox and maintain state for radio buttons, multiple dropdown, classic dropdown, and checkbox.
  
  Building a Complete Process Page
  
  20:47
You learn how to use cookies and sessions to provide a more personalized experience for the users of your website.

Cookies and Sessions
- Learn how to keep track of how many visits a user has made to a website. Then see the control the user has over cookies using Firefox. They can look at them, deny them, or turn them off completely.
  
  Setting and Reading Cookies
  
  07:01
- This session shows that it takes just a few lines of code to determine whether or not a client accepts cookies. If so, you can offer them a rich experience. If not, you can still offer them a site that works and looks nice.
  
  Checking If Client Supports Cookies
  
  03:59
- This video shows how to set and read sessions with a shopping cart example. When cookies are turned off, you'll see that sessions do not work. Then you see how you can edit the php.ini to enable sessions to work without cookies.
  
  Saving and Reading Session Variables
  
  08:09
This section teaches you the basics of getting your PHP site to read data out of two different kinds of databases: MySQL (the most common database used with PHP) and SQLite (a fast file-based database).

Databases
- This video shows how to create a database table in phpMyAdmin and how to use PHP to display records from that database table on a web page.
  
  MySQL - Reading Data
  
  08:05
- What do you need to know about inserting information into a MySQL database? This video has the answer.
  
  MySQL - Writing Data
  
  04:15
- Watch how to install the Firefox SQLite Manager add-on, create an SQLite database and database table, then use PHP to display the data from that SQLite database on a web page.
  
  SQLite3 - Reading Data via PDO
  
  07:41
- Learn how to use PHP to write to an SQLite database. Also, you'll see that SQLite takes over 60 seconds to add 20000 records while MySQL takes only 4 seconds to add 20000 records. The pros and cons of using SQLite are also covered here.
  
  SQLite3 - Writing Data Using PDO
  
  08:44
- This video shows and discusses three increasingly secure ways to protect your online SQLite databases.
  
  SQLite3 - Protecting SQLite Databases
  
  08:07
In this section, you'll learn the basics of reading and writing data to and from XML files.

XML
- Watch how to create an XML file in Eclipse and how to get the information out of the XML file in just a few lines with SimpleXML, reading both element contents and attribute contents.
  
  Reading XML with SimpleXML
  
  04:35
- This lesson tells you how to use XMLReader to run through the XML file node by node, building an array of information from your XML file and displaying this array at the end.
  
  Reading XML with XMLReader
  
  09:31
- This session shows how to run through an XML file using SAX and get information out of the XML file, saving it in an array.
  
  Reading XML with SAX
  
  18:50
- This video shows how to read information out of an XML file using DOM and identifies a number of issues that may arise and provides solutions.
  
  Reading XML with DOM
  
  07:46
- Here's how to use XMLWriter to create an XML file from scratch.
  
  Writing XML with XMLWriter
  
  06:14
- Learn how to append an element to an existing XML file using DOM.
  
  Appending Elements to XML with DOM
  
  05:15
This section covers REST and Web Services on the Internet.

Web Services
- Watch how to use the Yahoo Search Service to build a custom "topic search engine", e.g. a "Colorado Search Engine", which allows users to type in keywords such as "car" and receive results on "colorado cars".
  
  REST: Building a Theme-Oriented Search Machine
  
  12:15
- See how to download NuSOAP and use it to build and consume a web service.
  
  NuSOAP: Building and Consuming a Web Service
  
  10:19
This section demonstrates the importance of security on websites and how to safeguard against the most common security issues.

Security
- Many websites feature a security hole in that directories can be browsed and files such as .pdf or .xml or .sqlite can be downloaded by anybody. This video shows how you can protect yourself against this by using .htaccess files to prevent directory browsing and determine which files are downloadable and which are not.
  
  Protecting Online Files
  
  05:10
- This lesson includes an example of how a hacker can use an unprotected form to execute script on your web server and presents ways to protect your forms against this kind of attack.
  
  Cross Site Scripting
  
  05:15
- In this session, you'll see how a hacker can type in a series of characters to log into your application without knowing a correct password of any user. Then you'll see how to prevent this.
  
  SQL Injection
  
  09:28
In this section, you learn how to read and write data to files.

Files
- Let this video show you how to use file_put_contents to write to a file, pointing out a number of common errors that will come up and solutions to them. Also learn the old way of writing to a file with fwrite.
  
  Writing to Files
  
  05:32
- This lesson shows how to use the file_get_contents command to output the contents of a file to the browser. It also shows the older way of doing this with fopen and a while loop plus how to use file_get_contents to get text from an external website.
  
  Reading from Files
  
  04:08
This section covers the advanced features added to version 5.2 of PHP.

New Features in PHP 5.2
- The first video of this section shows you the basics of using the new filter_input function in PHP 5.2 by building a form and then validating an entry on the form as an integer between 3 and 10.
  
  Input Filtering Basics
  
  05:26
- Watch how to use the new PHP 5.2 input filters to easily validate an e-mail and a URL, and how to validate a zip code by using a custom regular expression.
  
  Input Filtering Advanced I
  
  05:46
- This video tells you about using the new PHP 5.2 input filters to remove and encode special characters from strings entered on a form, about calling a custom function to validate text, and about how to not only validate POST variables but also GET variables.
  
  Input Filtering Advanced II
  
  11:44
- This session shows how you can encode and decode between arrays and the JSON format with the new PHP 5.2 functions json_encode and json_decode.
  
  Encoding and Decoding JSON Text
  
  02:41
- Learn how to use the new ZipArchive class to build two custom functions called createZipFile and unpackZipFile, which allow you to zip or unzip files in one line.
  
  Create and Unpack ZIP Files
  
  08:08
This section covers advanced features added to version 5.3 of PHP.

New Features in PHP 5.3
- This video explains which problem the PHP 5.3 namespace feature solves and how to implement it.
  
  Namespaces
  
  08:59
- This lesson shows the basics of using lambdas and closures with array_filter.
  
  Lambdas and Closures
  
  05:25
- This lesson shows the problem that late static binding solves and how to use it in PHP 5.3.
  
  Late Static Binding
  
  02:56
- Watch how to use array_replace to overwrite an array with groups of changes.
  
  New Function: array_replace
  
  02:49
- Use parse_ini_file to get settings information from a file. And you can now use parse_ini_string to get settings information from fields in a database. Here's how!
  
  New Function: parse_ini_string
  
  03:53
- This video tells you how to use the new date_add function.
  
  New Function: date_add
  
  04:22
- This lesson shows how to use the new PHP 5.3 functions lcfirst, gethostname and get_called_class.
  
  Other New Functions
  
  03:28