Php is file function

In php is_file() function checks whether file exists or not.File's full path is given as an argument. If file exists, it returns true otherwise false. Example: <php $path="C:\\Documents and Settings\\user1\\My Documents\\My Pictu ...

Read More

Stripslashes php function

In php stripslashes() function removes the backslashes in the data (\' changes into ' and \\ into \ ). See in the example. <?php $str="This is Raj\'s book."; echo stripslashes($str); // This is Raj's book. ?>

Read More

php date time format

Php date() function returns date format by using timestamp. date(format,timestamp); The timestamp argument is optional. If it is not given by default the value of time() is used. Now see the example of date function for getting mysql ...

Read More

Sql Min function

The MIN function is used to get minimum value in column. Syntax is as: SELECT MIN(column_name) FROM table_name As in example we have table employees id first_name last_name ...

Read More

Sql Max function

The MAX function is used to get maximum value of column. Syntax is as: SELECT MAX(column_name) FROM table_name As in example we have table employees id first_name last_name ...

Read More

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