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)

Daily Test with Code Example

HTML
CSS
JavaScript
PHP-MySQL
Which type of <input> creates a date input control, such as a pop-up calendar?
type="text" type="date" type="button"
<input type="date" name="set_date" value="2012-10-15" />
Which CSS property adds shadow effects to the text of an element?
font-style color text-shadow
h2 {
  text-shadow: 2px 3px 3px #a0a1fe;
}
Click on the function that adds new elements to the end of an array.
pop() shift() push()
var pags = ["lessons", "courses"];
pags.push("download", "tutorials");
alert(pags[2]);            // download
Which function sorts an array by key, in ascending order, maintaining key to data correlations?
asort() ksort() sort()
$lang = array(10=>"PHP", 20=>"JavaScript", "site"=>"coursesweb.net");
ksort($lang);
var_export($lang);     // array ("site"=>"coursesweb.net", 10=>"PHP", 20=>"JavaScript")
PHP MySQL Online Video Course and Tutorials

Last accessed pages

  1. Upload Script for Gallery of Images and Audio files (362)
  2. Bubble Tanks 3 (887)
  3. Pencil and Pen Tools (56)
  4. HTML5 Canvas Tutorial (69)
  5. PHP MySQL - using MySQLi (370)

Top accessed pages

  1. PHP-MySQL free course, online tutorials PHP MySQL code (1920)
  2. Courses Web: PHP-MySQL JavaScript Ajax HTML CSS Flash-AS3 (1868)
  3. PHP PDO - exec (INSERT, UPDATE, DELETE) MySQL (1821)
  4. Get Attribute (ID, Class, Name, Title, Src) with jQuery (1558)
  5. PHP Chat Script (1491)