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
What attribute makes a radio button or checkbox input selected?
checked="checked" selected="selected" disabled="disabled"
<input type="checkbox" name="a_name" value="value" checked="checked" />
What CSS value scales the background image to the largest size contained within the element?
repeat-x contain linear-gradient
#id {
  background:url("path_to_image.png");
  background-size:contain;
  background-repeat:no-repeat;
}
What operator is used to determine the rest of the division of two numbers?
% * /
var rest8_7 = 8 % 7;
alert(rest8_7);
Indicate the PHP function that rounds a number up to the next highest integer.
floor() ceil() abs()
$nr = ceil(3.5);
echo $nr;        // 4
PHP MySQL Online Video Course and Tutorials

Last accessed pages

  1. Get Attribute (ID, Class, Name, Title, Src) with jQuery (1369)
  2. PHP MySQL - WHERE and LIKE (619)
  3. PHP PDO - exec (INSERT, UPDATE, DELETE) MySQL (1603)
  4. Variables and Data Types (149)
  5. Countdown Timer until specified Date-Time (128)

Top accessed pages

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