PHP MySQL Online Video Course and Tutorials

Want to initiate in PHP and MySQL programming language but don't have time to read a book? You can learn with the help of the online video tutorials posted here.

If the player don't start to play the tutorial from first attempt, try again.

PHP 5.3 and MySQL Advanced web programming

In the first lessons of this video course, you will learn how to get and use the free XAMPP aplication and Eclipse editor. Then, you'll lern the basics of the PHP language: syntax, operators, variables, loops, functions, arrays, etc., and advanced things: object orientation, MySQL databases, XML parsing, web services, security, how to read and write cookies and session variables, and much more.
The tutorials also include important new features of PHP 5.3, such as namespaces, lambdas, and late static binding.
- So, this video course can be useful for beginners or eaven for more advanced PHP-MySQL programmers.

1. Instalattion

  1. Installing XAMPP (7:28)
  2. Installing Eclipse (11:09)
  3. Eclipse Basics I (8:17)
  4. Eclipse Basics II (9:59)

2. PHP Basics

  1. Variables (9:23)
  2. Operators (7:38)
  3. Conditionals (10:06)
  4. Loops (3:50)
  5. Functions (6:36)
  6. Arrays I (8:01)
  7. Arrays II (7:03)
  8. Strings (7:23)
  9. Dates (9:37)
  10. Math (8:28)
  11. Building a Library with External Files (11:14)

3. Object-Oriented Programming

  1. SmartUrl Class: Constructors, Public Methods, Private Variables (3:44)
  2. SmartUrl Class: Adding Parameters (Public Method) (7:31)
  3. SmartUrl Class: Properties (8:48)
  4. SmartUrl Class: Static Methods (11:07)
  5. Inheritance (10:36)
  6. Interfaces (7:43)

4. Regular Expressions

  1. Validating Text (preg_match) (7:06)
  2. Finding All Matching Text (preg_match_all) (3:35)
  3. Splitting Text (preg_split) (2:27)
  4. Replacing Text (preg_replace) (6:47)

5. Forms

  1. Building a Form (8:43)
  2. Building a Form Process Page (13:00)
  3. Validating a Form (15:13)
  4. Building a Complex Form (10:31)
  5. Building a Complete Process Page (20:47)

6. Cookies and Sessions

  1. Setting and Reading Cookies (7:01)
  2. Checking If Client Supports Cookies (3:59)
  3. Saving and Reading Session Variables (8:08)

7. Databases

  1. MySQL - Reading Data (8:04)
  2. MySQL - Writing Data (4:14)
  3. SQLite3 - Reading Data via PDO (7:40)
  4. SQLite3 - Writing Data Using PDO (8:44)
  5. SQLite3 - Protecting SQLite Databases (8:07)

8. XML

  1. Reading XML with SimpleXML (4:35)
  2. Reading XML with XMLReader (9:31)
  3. Reading XML with SAX (18:50)
  4. Reading XML with DOM (7:45)
  5. Writing XML with XMLWriter (6:14)
  6. Appending Elements to XML with DOM (5:15)

9. Web Services

  1. REST: Building a Theme-Oriented Search Machine (12:15)
  2. NuSOAP: Building and Consuming a Web Service (10:19)

10. Security

  1. Protecting Online Files (5:10)
  2. Cross Site Scripting (5:14)
  3. SQL Injection (9:28)

11. Files

  1. Writing to Files (5:32)
  2. Reading from Files (4:08)

12. New Features in PHP 5.2

  1. Input Filtering Basics (5:26)
  2. Input Filtering Advanced I (5:46)
  3. Input Filtering Advanced II (11:43)
  4. Encoding and Decoding JSON Text (2:41)
  5. Create and Unpack ZIP Files (8:08)

13. New Features in PHP 5.3

  1. Namespaces (8:58)
  2. Lambdas and Closures (5:25)
  3. Late Static Binding (2:56)
  4. New Function: array_replace (2:49)
  5. New Function: parse_ini_string (3:52)
  6. New Function: date_add (4:22)
  7. Other New Functions (3:27)