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 is used in <a> tag for the address of the link?
src href rel
<a href="http://coursesweb.net/" title="CoursesWeb.net">CoursesWeb.net</a>
Which CSS property sets the type of the text font?
font-family text-decoration font-size
h2 {
  font-family:"Calibri",sans-serif;
}
What instruction selects all the <div> tags with class="cls"?
querySelector("div.cls") getElementsByTagName("div") querySelectorAll("div.cls")
var elm_list = document.querySelectorAll("div.cls");
var nr_elms = elm_list.length;       // number of selected items
alert(nr_elms);
Indicate the function that can be used to get the sum of values in an array.
array_sum() array_diff() array_shift()
$arr = array(1, 2, 3, 4);
$arr_sum = array_sum($arr);
echo $arr_sum;       // 10
PHP MySQL Online Video Course and Tutorials

Last accessed pages

  1. Multiple Select Dropdown List with AJAX (9847)
  2. jQuery parent, children and nth-child() (6556)
  3. Script Users Register, Login, Online (11047)
  4. Add, Change, and Remove Attributes with jQuery (17708)
  5. Courses Web: PHP-MySQL JavaScript Ajax HTML CSS Flash-AS3 (31642)

Top accessed pages

  1. Courses Web: PHP-MySQL JavaScript Ajax HTML CSS Flash-AS3 (31642)
  2. PHP-MySQL free course, online tutorials PHP MySQL code (25831)
  3. Get Attribute (ID, Class, Name, Title, Src) with jQuery (24780)
  4. Read Excel file data in PHP - PhpExcelReader (23909)
  5. PHP PDO - exec (INSERT, UPDATE, DELETE) MySQL (21591)