What aspects are needed for PHP engineer interview?

What are the aspects required for a php engineer interview?

1. Technical issues

(1) Basic knowledge: such as array operations, variable operations, and string processing. Mainly examine the functions of arrays and strings. There are also the concepts and differences between cookies and sessions.

(2) Object-oriented: Object-oriented thinking and theoretical knowledge, such as inheritance, interfaces, abstract classes, polymorphism, etc. (3) File operation: Two typical problems:

① Traverse the directory: use recursion to traverse the directory, and the extension is infinite level classification

② Read large files: insufficient memory, How to read the file content

(4) Database knowledge:

① Design the database table and write SQL queries as required. Common ones include order tables, product tables; student tables, grade tables, class tables; province and city tables.

②Basic skills in PHP database operation, handwriting PHP database operation code.

③Database performance optimization. These include the use of MySQL and performance optimization. For example, the difference between int(1) and int(10), the selection of storage type; mysql index, combined index and covering index, etc.; understanding of the four isolation levels in MySQL. Typical questions: There are 1 million pieces of data in a table, how to optimize writing ideas or optimize SQL; how to ensure efficiency when inserting 10,000 pieces of data into the database at the same time.

(5)Linux capability. Basic knowledge of Linux and familiarity with commonly used commands. For example, in the nginx access log, find the top ten interface access categories of the day.

(6) Data structure and algorithm capabilities. Basic sorting methods, such as bubble sort, quick sort, binary search sort; or give you a question and handwrite a method to achieve the effect, such as 100 yuan distributed to 10 people, each person must be at least 6 yuan, and at most 12 yuan. All 100 yuan is divided. The most commonly asked questions are tree traversal and sorting.

(7) Server security issues: sql injection, xss attack, etc. How to prevent these problems when programming.

(8) Framework questions: Understand which frameworks, and then ask some basic questions about the frameworks. Understand the MVC idea of ​​commonly used frameworks, and clarify the relationship between model and controller, and the relationship between controller and view based on logic.

Recommended: "PHP Tutorial"

2. Non-technical questions

Interviewer:

1. My own time arrangement outside of work

2. Self-evaluation

3. Planning for future career

Purpose:

1.Observation Do you study in your spare time?

2. Are you certified enough for yourself?

3. Are you a person who can plan?

Common points: What else Do you want to ask me?

The above is the detailed content of What aspects are needed for PHP engineer interview?. For more information, please follow other related articles on the PHP Chinese website!