Shanghai Shanda PHP engineer interview question Source: http://www.iteye.com/topic/833480japanese to Shanghai Shengda, should hire a PHP engineer. Come to the lobby on the first floor 10 minutes in advance. There are two guards at the entrance and the access control room. they look like a regular army and give them a very serious feeling. After waiting for a few minutes on the luxury visitor reception desk in the hall, a girl came with a visitor's card and brought me to Shanghai Grand PHP engineer for interview questions.
Source: http://www.iteye.com/topic/833480
I went to Shanghai for a big interview yesterday and applied for a PHP engineer.
Come to the lobby on the first floor 10 minutes in advance. There are two guards at the entrance and the access control room. they look like a regular army and give them a very serious feeling.
After waiting for a few minutes on the reception desk of the luxurious visitor in the hall, a beautiful girl took me to the fourth floor with a visitor's card and handed me over to a big brother with a red rope.
Then go to a small meeting room and start "trial ":
First, let's briefly introduce yourself.
Ji li... Ji li...
After shaking your feet, start the technical problem:
1. meaning of several status codes in HTTP: 503 500 401 200 301 302...
2. Which of the following are restricted after Safe_mode is enabled.
3. familiar with PHP open-source frameworks and their understanding.
4. Are you familiar with jquery? let's talk about its selector implementation principle.
5. what is the weird mode, standard mode, and near Standard mode.
6. let's talk about the differences in CSS rendering in different browsers around the box model.
The above are basic knowledge
7. Have you ever set up and optimized the lnmp environment? Let's talk about how you optimize it, and talk about nginx, php, and mysql respectively.
8. there is a table order (order_id, user_id, order_amount). write a query statement to retrieve all order_id orders of all users whose total consumption exceeds 100.
9. there is a string in the following format:
(A (B) (C (D) (E) F)
The parentheses in the string appear in pairs. write a function to retrieve the content in the brackets in the nth order (indexed in the order in which left parentheses appear.
For example:
function getcontent($id,$str){...}$str = '(A(B)(C(D)(E))F)';getcontent(3,$str);
The result is (C (D) (E ))
I hope you can talk about the best solution to the last two questions.
1 floor ly365
SELECT aa. user_id, aa. order_id, FROM 'order' aa LEFT JOIN
(
Select sum (order_amount) AS order_amount, user_id FROM 'order' group by 'user _ id'
) Tt ON tt. user_id = aa. user_id AND tt. order_amount> 100
