Record of frequently asked questions in PHP interviews

This article mainly shares with you the records of frequently asked questions in PHP interviews. We first share with you some questions that HR will ask, hoping to help everyone.

1 What is your career plan and what efforts you have made to achieve this goal
2 What are your character strengths and weaknesses
3 What is your role in the team
4 Resignation What is the reason
5 What do you think about overtime
6 Something you have done at work that you think is meaningful
7 In addition to work, what other technologies do you pay attention to
8 You What factors are important when looking for a job (this question is more in-depth. I think the person who asked these questions is either the HR is very responsible and capable, or the company values ​​this position more)
Finally - what do you think? Ask me

Technical aspects
0.1 Solution for large traffic and high concurrency
1 How to sub-database and table mysql
Personally, I think it is currently 3 stars for difficulty. It requires more basic knowledge, and you may not need to use it in actual operations, but you must be able to talk about the theory

2 PHP design pattern – very important – tell me the design patterns, usage scenarios and advantages you know
I think this is a transitional standard between intermediate programs and junior programs, or even between advanced programs and intermediate programs. From a purely programming language perspective, when it comes to design patterns, it should already be somewhat large. project. Of course, you may not notice it at ordinary times, but you are actually using it. But during the interview, if you can't explain it or don't understand it deeply, it will be a negative point for you, and it is a very important point, because you are a programmer after all, not a DBA or operation and maintenance, so you still have the knowledge of the program. Should master more.

3 Tens of millions of database data operations and table design
4 Understanding of indexes
5 Understanding of memcache and the underlying layer - caches like this are almost a must, extensions such as memchache and The difference and practical application scenarios of redis
6 The usage scenarios of redis
7 Understanding of queues and stacks and practical application scenarios
8 PHP multi-process
Regular expression (50% chance of passing the exam, Some interviewers will pay more attention to it because it is the basis, just like operating strings)
What is object-oriented, the chance of passing the exam is 50%. Directly speaking, encapsulation, inheritance, polymorphism and direct elimination
The difference between apache and nginx, and why nginx is now mostly used
mysql optimization method, the question is very general, just test your usual use level and design depth of mysql, you will pass the test The probability is 10000%, it just depends on the depth of the questions
Linux usage, the requirements are not so deep on cache and mysql, but it is also basic at least scheduled tasks, simple shell scripts and basic commands. You must answer
session questions (For example, session sharing, the relationship between session and cookie, etc., this is a must test, almost 100%)
What is the essence of things and application scenarios
9 Operations on strings and arrays, must be tested, no Skip these two questions
The above are general, but they are all required. The following is the written test
10 The difference between int=intval(int) and int=int+0
intval is mandatory Convert the variable to integer type. The operation of + on variables can only be addition operations, so if int is an integer type, it can be operated normally. If it is a non-numeric type, the result is 011arr1= array(1,2,3,4,5);
arr2=array(6,7,8,9,10,11);vardump(arr1+arr2);What is the result of 12arr1 = array(1,2,3,4,5);
foreach (arr1 as &item){echo item;}item = 3;
foreach(arr1asitem){echo $item;}
What will be output these two times

13 PHP operations on large files and Linux operation of large files - the probability of passing the test is very high, especially the former
14 Writing a function that can traverse all files and sub-files in a folder is almost a must-take test
15 Table tab_log structure, id, uid, tm; How to query uid with more than three records in a certain day
select uid, count(*) as num from tab_log group by tm having num > 3
16 error_reporting("E_ALL") What is the difference between ini_set("display_errors", "on")?
The latter has greater authority than the former. If the latter is OFF, the former will be useless even if it is E-ALL.
17 The difference between echo print print_r
The biggest difference between echo and print is that the former is a built-in statement in PHP, has no return value, and cannot be used in expressions such as the ternary operator. The latter is a function, which returns true when printing correctly and false when error occurs. 1?print(1):6; is correct, but using echo is wrong.
——Continuous update
Finally, the ultimate question, talk about your understanding of object-oriented, haha ​​
Generally speaking, the interview is much more important than the written test (provided that the interviewer is not busy, if you ask questions in the written test If you don’t answer well, you may not get an interview opportunity.) As long as you perform well in the interview, everything is not a problem. But, but, but, if you perform well in the interview, can you perform poorly in the interview? Haha, everything has something in common. Many things are complementary to each other

The first is the HR question
1 What is your career plan and what efforts have you made towards this goal
2 What are your character strengths and weaknesses
3 What is your role in the team
4 What is the reason for leaving your job
5 What do you think about working overtime
6 One thing you have done at work that you feel is more meaningful
7 In addition to work, what other technologies do you pay attention to
8 What factors do you value when looking for a job? (This question is more in-depth. I think the person who asked these questions is either the HR is very responsible and capable, or the company values ​​this position more)
Finally— What do you want to ask me about

Technical aspects
0.1 High traffic and high concurrency solution
1 How to sub-database and table mysql
Personally, I think it is currently difficult to master 3 stars. It requires more basic knowledge, and you may not need to use it in actual operations, but you must be able to talk about the theory

2 PHP design pattern – very important – tell me the design patterns, usage scenarios and advantages you know
I think this is a transition standard between intermediate programs and junior programs, or even between advanced programs and intermediate programs. From a purely programming language perspective, when it comes to design patterns, it should already be somewhat large. project. Of course, you may not notice it at ordinary times, but you are actually using it. But during the interview, if you can't explain it or don't understand it deeply, it will be a negative point for you, and it is a very important point, because you are a programmer after all, not a DBA or operation and maintenance, so you still have the knowledge of the program. Should master more.

3 Tens of millions of database data operations and table design
4 Understanding of indexes
5 Understanding of memcache and the underlying layer - caches like this are almost a must, extensions such as memchache and The difference and practical application scenarios of redis
6 The usage scenarios of redis
7 Understanding of queues and stacks and practical application scenarios
8 PHP multi-process
Regular expression (50% chance of passing the exam, Some interviewers will pay more attention to it because it is the basis, just like operating strings)
What is object-oriented, the chance of passing the exam is 50%. Directly speaking, encapsulation, inheritance, polymorphism and direct elimination
The difference between apache and nginx, and why nginx is now mostly used
mysql optimization method, the question is very general, just test your usual use level and design depth of mysql, you will pass the test The probability is 10000%, it just depends on the depth of the questions
Linux usage, the requirements are not so deep on cache and mysql, but it is also basic at least scheduled tasks, simple shell scripts and basic commands. You must answer
session questions (For example, session sharing, the relationship between session and cookie, etc., this is a must test, almost 100%)
What is the essence of things and application scenarios
9 Operations on strings and arrays, must be tested, no Skip these two questions
The above are general, but they are all required. The following is the written test
10 The difference between int=intval(int) and int=int+0
intval is mandatory Convert the variable to integer type. The operation of + on variables can only be addition operations, so if int is an integer type, it can be operated normally. If it is a non-numeric type, the result is 011arr1= array(1,2,3,4,5);
arr2=array(6,7,8,9,10,11);vardump(arr1+arr2);What is the result of 12arr1 = array(1,2,3,4,5);
foreach (arr1 as &item){echo item;}item = 3;
foreach(arr1asitem){echo $item;}
What will be output these two times

13 PHP operations on large files and Linux operation of large files - the probability of passing the test is very high, especially the former
14 Writing a function that can traverse all files and sub-files in a folder is almost a must-take test
15 Table tab_log structure, id, uid, tm; How to query uid with more than three records in a certain day
select uid, count(*) as num from tab_log group by tm having num > 3
16 error_reporting("E_ALL") What is the difference between ini_set("display_errors", "on")?
The latter has greater authority than the former. If the latter is OFF, the former will be useless even if it is E-ALL.
17 The difference between echo print print_r
The biggest difference between echo and print is that the former is a built-in statement in PHP, has no return value, and cannot be used in expressions such as the ternary operator. The latter is a function, and returns true when printing correctly and false when error occurs. 1?print(1):6; is correct, but using echo is wrong.
——Continuous update
Finally, the ultimate question, talk about your understanding of object-oriented, haha ​​
Generally speaking, the interview is much more important than the written test (provided that the interviewer is not busy, if you ask questions in the written test If you don’t answer well, you may not get an interview opportunity.) As long as you perform well in the interview, everything is not a problem. But, but, but, if you perform well in the interview, can you perform poorly in the interview? Haha, everything has something in common. Many things are complementary to each other.

Related recommendations:

PHP interview summary sharing

Common PHP interview questions and answering skills in 2017

Summary of written test questions in php interview questions

The above is the detailed content of Record of frequently asked questions in PHP interviews. For more information, please follow other related articles on the PHP Chinese website!