Difference between include and require

require(): It will cause a fatal error and halt the execution of the script if the file not found.
include(): If the file not found a warning will be issued, but execution will continue.

get number of records count in mysql

SELECT COUNT('fieldname') AS numcount FROM tablename;
//Instead of using COUNT(*) it is good i think

AJAX full form

Asynchronous JavaScript and XML

find the current date using MySQL

SELECT now();
or
SELECT CURDATE();
or
SELECT CURRENT_DATE();

submit a form without submit button

document.formname.submit(); //It will work when we are using single form in a page

document.forms['formname'].submit(); //It will work when we are using multiple forms

// above formname is our formname

submit a form using javascript

document.formname.submit(); //It will work when we are using single form in a page

document.forms['formname'].submit(); //It will work when we are using multiple forms

// above formname is our formname

maximum length of a database name, table name, field name in MySQL

Database name: 64 characters
Table name: 64 characters
Column name: 64 characters

PHP Tutorial

Some best links for php that i know

http://www.w3schools.com/php/default.asp
http://www.php.net/manual/en/getting-started.php

file upload in php example

Click the below link to download the code for file uploading

Click Here

php code to create thumbnail

Click the below link to download the code

Click Here