50 Best PHP MySQL Interview Questions and Answers

List of top 50 most frequently asked php mysql interview questions and answers pdf download free

PHP MySQL Interview Questions and Answers List

  1. How can we submit a form without a submit button?
  2. In how many ways we can retrieve the data in the result set of MySQL using PHP?
  3. What is the difference between mysql_fetch_object and mysql_fetch_array?
  4. What is the difference between $message and $$message?
  5. How can we extract string ‘abc.com ‘ from a string ‘http://info@abc.com’ using regular expression of PHP?
  6. How can we create a database using PHP and MySQL?
  7. What are the differences between require and include, include_once and require_once?
  8. Can we use include (”abc.PHP”) two times in a PHP page “makeit.PHP”?
  9. What are the different tables present in MySQL, which type of table is generated when we are creating a table in the following syntax:
  10. How can we encrypt the username and password using PHP?
  11. What’s PHP ?
  12. What Is a Session?
  13. What is meant by PEAR in php?
  14. How can we know the number of days between two given dates using PHP?
  15. What is the difference between $message and $$message?
  16. What Is a Persistent Cookie?
  17. What does a special set of tags do in PHP?
  18. What are the differences between require and include, include_once?
  19. What is meant by urlencode and urldecode?
  20. How To Get the Uploaded File Information in the Receiving Script?
  21. What is the difference between mysql_fetch_object and mysql_fetch_array?
  22. How can I execute a PHP script using command line?
  23. How To Create a Table?
  24. How can we encrypt the username and password using PHP?
  25. What is the functionality of the function strstr and stristr?
  26. How do I find out the number of parameters passed into function9.?
  27. If the variable $a is equal to 5 and variable $b is equal to character a, what’s the value of $$b?
  28. How To Protect Special Characters in Query String?
  29. Are objects passed by value or by reference?
  30. What are the differences between DROP a table and TRUNCATE a table?
  31. How do you call a constructor for a parent class?
  32. WHAT ARE THE DIFFERENT TYPES OF ERRORS IN PHP?
  33. What’s the special meaning of __sleep and __wakeup?
  34. How can we submit a form without a submit button?
  35. Would you initialize your strings with single quotes or double quotes?
  36. What are the differences between GET and POST methods in form submitting, give the case where we can use GET and we can use POST methods?
  37. What is the difference between the functions unlink and unset?
  38. How come the code works, but doesn’t for two-dimensional array of mine?
  39. What is the difference between characters 23 and \x23?
  40. With a heredoc syntax, do I get variable substitution inside the heredoc contents?
  41. How can we submit form without a submit button?
  42. How can we create a database using PHP and mysql?
  43. How many ways we can retrieve the date in result set of mysql using php?
  44. I am writing an application in PHP that outputs a printable version of driving directions. It contains some long sentences, and I am a neat freak, and would like to make sure that no line exceeds 50 characters. How do I accomplish that with PHP?
  45. What’s the output of the ucwords function in this example?
  46. What’s the difference between htmlentities() and htmlspecialchars()?
  47. How can we extract string “abc.com” from a string “mailto:info@abc.com?
  48. What are the different functions in sorting an array?
  49. How can we know the count/number of elements of an array?
  50. How many ways we can pass the variable through the navigation between the pages?

This entry was posted in Interview Questions. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *