MySQL

MySQL Tutorial

MySQL tutorial of w3resource is a comprehensive tutorial to learn MySQL. We have hundreds of examples covered, often with PHP code. This helps you to learn how to create PHP-MySQL based web applications. more...

PostgreSQL

PostgreSQL Tutorial

Learn one of the most widely used and advanced open source database system with w3resource. more...

SQL

SQL Tutorial

SQL tutorial of w3resource is a comprehensive tutorial to learn SQL. We have followed SQL:2003 standard of ANSI. There are hundreds of examples given in this tutorial. Output are shown with Oracle 10G. Often outputs are followed by pictorial presentation and explanation for better understanding. more...

PHP : $_SERVER

PHP $_SERVER Variable Tutorial

$_SERVER is an array which holds information of headers, paths, script locations. Web server creates the entries in the array. more...

MySql insert into statement

MySQL INSERT INTO

MySQL INSERT INTO statement is used to insert record(s) or row(s) into a table. The insertion of records or rows in the table can be done in two ways. Insert a single row at a time, and inserting multiple rows at a time.more...

SQL SELF JOIN

SQL SELF JOIN Tutorial

A SELF JOIN is another type of join in sql which is used to join a table to itself, specially when the table has a FOREIGN KEY which references its own PRIMARY KEY. more...

PHP for loop

PHP FOR LOOP Tutorial

The PHP for loop allows the user to put all the loop-related statements (i.e. INITIALIZER; CONDITION; INCREMENTOR or DECREMENTOR) in one place. The structure is similar to C language. more...

SQL JOIN Cheat sheet

SQL JOIN

w3resource.com has a comprehensive SQL Tutorial and we have covered SQL JOIN in great detail. But we felt that creating a cheat sheet on SQL JOIN will be very useful for you. more...

HTML5 based Form validation without JavaScript

HTML% FORM VALIDATION

For client side form validation, using JavaScript is inevitable. But not any more. With HTML5, now you may validate your forms at client side without using any JavaScript. more...

MySql count() function

mysql count

MySQL COUNT() function returns a count of number of non-NULL values of a given expression. If it does not find any matching row, it returns 0. more...