Sql Count function

The COUNT function is used to count number of records in table. Syntax is as: SELECT COUNT(*) FROM table_name As in example we have table employees id first_name last_name ...

Read More

Sql SUM function

The SUM function is used to calculate sum of values of a column. Syntax is as: SELECT SUM(column_name) FROM table_name As in example we have table employees id first_name last_name ...

Read More

Sql AVG function

The AVG function is used to calculate average of values of a column. Syntax is as: SELECT AVG(column_name) FROM table_name As in example we have table employees id first_name last_name ...

Read More

Sql order by

The ORDER BY keyword is used to get data order wise. Data can be arranged in ascending or descending order Syntax is as: SELECT * FROM table_name WHERE [ column_name condition ] ORDER BY column_name [ASC|DESC] ASC is used for ascending order ...

Read More

Sql Like operator

The LIKE operator is used to compare similar values using wildcard operators.Wildcard operators are the percent sign ( % ) and the underscore ( _ ). The percent sign ( % ) represents multiple characters whereas the underscore ( _ ) represents singl ...

Read More

Sql Between operator

The BETWEEN operator is used to select values within range of values in the parenthesis with values separated by AND operator. Syntax is as: SELECT * FROM table_name WHERE column_name BETWEEN 'value1' AND 'value2' As in example we have ...

Read More

Php file handling

Creating file or making file, in php is done with fopen() function. The fopen() function opens file and returns file handle. The function fopen() takes minimum two arguments, first argument is for path of file including file name and second is for m ...

Read More

Implode and explode in php

In php the implode function joins the array elements with desired glue (character); Take an example, we have array of email-ids and we want to join these ids with comma, we shall do like this. <?php $emails=array("abc@gmail.com",&q ...

Read More

Php script for downloading files

As we see on many websites, there are file download links. When we click on the link, browser starts downloading. The question arises that can we do this ? of course, let's learn how to download a file with php. Suppose we have a pdf file which we w ...

Read More

php file upload script | php file upload example

This is php file upload script or php file upload example for uploading file from your computer system to remote server. For uploading file in php,we are going to write simple php file upload script. First of all, we need a html form. So make form as ...

Read More