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 attribute can be used to add CSS styles directly in the HTML tag?
type style class
<div style="width: 80%; border: 3px solid #888888;">Content</div>
Which CSS transform method distorts the HTML element in a given angle (including its content)?
translate() scale() skew()
#some_id {
  transform: skew(20deg, 25deg);
  -ms-transform: skew(20deg, 25deg);   /* IE 9 */
  -webkit-transform: skew(20deg, 25deg);   /* Safari and Chrome */
}
Click on the function which converts a Date object to a string.
indexOf() toString() getDate()
var rightnow = new Date();
alert( rightnow.toString() );
Which function applies a callback function to the elements of the given array?
array_merge() array_search() array_map()
$arr = arra("abc", "<p>xyz</p>", "<em>PHP</em>");
// apply the strip_tags() function to delete HTML tags from each array item
$arr = array_map("strip_tags", $arr);
}
PHP MySQL Online Video Course and Tutorials

Last accessed pages

  1. querySelector and querySelectorAll (1320)
  2. Selection Tools (1468)
  3. Register and show online users and visitors (4892)
  4. Area and Perimeter Calculator for 2D shapes (2057)
  5. HTML object and param (4480)

Top accessed pages

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