Category: Interview Questions

SELECT  MAX(salary) AS salary   FROM emp WHERE salary < (SELECT MAX(salary) FROM emp);

Basically DELETE TABLE is logged operation and every row deleted is logged. Therefore the process is usually slow. TRUNCATE TABLE also deletes rows in a table but it will not log any of the rows deleted. The process is faster… Read More

Implode(): Using this method we can convert an array into string example  <?php $array = array(‘lastname’, ’email’, ‘phone’); $comma_separated = implode(“,”, $array);echo $comma_separated; // lastname,email,phone ?> explode(): Using this method we can convert a string into array example: <?php // Example 1 $pizza  = “piece1 piece2 piece3 piece4 piece5 piece6″; $pieces = explode(” “, $pizza); echo $pieces[0]; // piece1 echo $pieces[1]; // piece2 ?>

A Query String is a combination of key and values pairs of data, which is always appended in URL followed by ? (Question mark) Each pair separated with & symbol Using Query String we send some data from one location… Read More

include(): Using this method we can include an external file into the current file. If the specified file is not available for inclusion it will give Warning Error require(): Using this method we can include an external file into the… Read More

array_search(): Using this method we can search for an element in an array. If element founds, this method will return the position of the element in_array(): Using this method we can check  for an element in an array. If element… Read More

An array is a collection of values with different data types An array can be created using the array() language construct. It takes any number of comma-separated key => value pairs as arguments. Syntax: array( key => value, key2 =>… Read More

isset(): using this method we can check whether the variable is set with value or              not. If variable is set with value this method returns true. unset(): using this method we can remove the value of a variable