PHP Basic Interview Questions and Answers

1. Asynchronous loop output

Code:

for(var i=1;i<=3;i++){
    setTimeout(function(){
        console.log(i);
    },0);
}

Answer: 4 4 4

2. String split and join

Question: "inhemeter".split('').join(' ') results in?

Answer: i n h e m e t e r (spaces between characters)

3. Accessing GET, POST and uploaded files in PHP

Answer: $_GET , $_POST , $_FILES

4. Incorrect statement about include and require

Options:

A. require generates a warning, include generates a fatal error

B. require is loaded before execution

C. include is loaded at runtime

D. require_once prevents multiple inclusions

Correct answer: A

5. Get the previous day of a given datetime

Question: $time = '2017-05-10 12:34:34'

Answer: date('Y-m-d H:i:s', strtotime('-1 day '.$time)) or date('Y-m-d H:i:s', strtotime("-1 day $time"))

6. Call parent class method load() from a subclass

Answer: parent::load()

7. File to configure maximum upload size in PHP

Answer: php.ini

8. SQL to find the highest score for each team

Answer:

SELECT TEAM, MAX(SCORE) FROM tableA GROUP BY TEAM;

9. SQL to get total score per team with team name from another table

Answer:

SELECT B.NAME, SUM(A.SCORE) FROM tableA A JOIN tableB ON A.TEAM = B.TEAM_ID GROUP BY B.TEAM_ID;

10. Regular expression to match a mobile phone number starting with '1' and 11 digits long

Answer: /1\d{10}/