Interview Questions For 2 & 3 Year Experienced PHP developer

PHP Questions

1. What is asort and arsort in PHP?
2. What is ksort and krsort in PHP?
3. What is the difference between array_combine and array_merge?
4. How to upload files in PHP?
5. What array_slice does?
6. What nl2br() does?
7. What is session in PHP and how it is different from $_POST[] ?
8. What are web services and how to create them in PHP?
9. In how many ways we can fetch the data from the database in PHP?
10. How to create the database in MYSQL using PHP?
11. How the $message and $$message differs from each other?
12. How to submit a form without submit button?
13. What is print_r() does in PHP?
14. AJAX calls?
15. How to save 50 form fields at once in the database from the form?(Hint: AJAX Serialization.)
16. What is inheritance and why we required it and how to implement this in PHP?
17. What is overriding and overloading and how overriding is implemented in PHP?
18. Which function is used in PHP to Upload a file

MySql Questions

1. How to fetch 2nd highest salary from the database?
2. How to fetch 3rd highest salary from the database?
3. What are indexes in MYSQL?
4. How to convert rows in columns and columns in rows in mysql?
5. What are joins in SQL?
6. What is self join in SQL?
7. What are the difference between unique key and primary key and why we preferred primary key over unique key?