100+ php with mysql interview Questions

PHP with mysql interview Questions with answers-- Asked at different competitive exams

Free Online test your knowledge on php and mysql programming exams. Each questions immediate answer or explanation given below, just click View answer button and also have option of Hide Answer button to hide answer. In this given upto 100+ questions and shows answer or explanation under of each question.
          Here all the questions and answers, most asked in different competitive exams and shows answers accordingly.
php and mysql interview questions with answers
Q31. WHAT ARE THE DIFFERENT TYPES OF ERRORS IN PHP?

Answer: Here are three basic types of runtime errors in PHP:
1. Notices: These are trivial, non-critical errors that PHP encounters while executing a script – for example, accessing a variable that has not yet been defined. By default, such errors are not displayed to the user at all – although you can change this default behavior.
2. Warnings: These are more serious errors – for example, attempting to include() a file which does not exist. By default, these errors are displayed to the user, but they do not result in script termination.
3. Fatal errors: These are critical errors – for example, instantiating an object of a nonexistentclass, or calling a non-existent function. These errors cause the immediate termination of the script, and PHP’s default behavior is to display them to the user when they take place. Internally, these variations are represented by twelve different error types

Q32. How can we submit a form without a submit button?

Answer: If you don’t want to use the Submit button to submit a form, you can use normal hyper links to submit a form. But you need to use some JavaScript code in the URL of the link.
For example:
<a document.myform.submit="" href="”javascript:">Submit Me</a>

Q33. Why doesn’t the following code print the newline properly?
  <?php
$str = ‘Hello, there.\nHow are you?\nThanks for visiting fyicenter’;
print $str; ?>

Answer: Because inside the single quotes the \n character is not interpreted as newline, just as a sequence of two characters – \ and n.

Q34. Would you initialize your strings with single quotes or double quotes?

Answer: Since the data inside the single-quoted string is not parsed for variable substitution, it’s always a better idea speed-wise to initialize a string with single quotes, unless you specifically need variable substitution.

Q35.How can we extract string ‘abc.com ‘ from a string http://info@abc.com using regular expression of php?

Answer: We can use the preg_match() function with “/.*@(.*)$/” as the regular expression pattern.
For example:
preg_match(“/.*@(.*)$/”,”http://info@abc.com”,$data);
echo $data[1];

Q36.What is the difference between the functions unlink and unset?

Answer: unlink() is a function for file system handling. It will simply delete the file in context.
unset() is a function for variable management. It will make a variable undefined.

Q37.How come the code works, but doesn’t for two-dimensional array of mine?

Answer: Any time you have an array with more than one dimension, complex parsing syntax is required. print “Contents: {$arr[1][2]}” would’ve worked.

Q38. How can we register the variables into a session?

Answer: session_register($session_var);
$_SESSION[‘var’] = ‘value’;

Q39. What is the difference between characters \023 and \x23?

Answer: The first one is octal 23, the second is hex 23.

Q40. How many ways we can retrieve the date in result set of mysql using php?

Answer: As individual objects so single record or as a set or arrays.

More pages : Php Interview Questions

0 Comments:

Post a Comment