Shanghai Grand PHP engineer Face test
Source: http://www.iteye.com/topic/833480
Yesterday to Shanghai Grand interview, apply for PHP engineer.
10 minutes early to the first floor of the hall, the gate and access to the door has 2 guards, as if a pair of "regular" appearance, giving a very serious feeling.
In the lobby of the luxury visitor reception for a few minutes, a beautiful woman with a visitor card came to take me on the 4 floor, I "handed" to a hung "red rope" eldest brother.
Then enter a small conference room and start "trial":
First of all, simply introduce yourself.
Jiliguala ... Jiliguala ...
After shaking the family property, start the technical question:
1. The meaning of several status codes in the HTTP protocol: 503 500 401 200 301 302 ...
2, Safe_mode Open after the place is limited.
3, familiar with which PHP open-source framework, say your understanding of them respectively.
4, familiar with jquery, talk about its selector implementation principle.
5, what is the weird mode, Standard mode, near the standard mode.
6, around the box model to tell, each browser in the CSS rendering differences.
All of these are basic knowledge.
7, build and optimize the LNMP environment? Talk about how you optimized, for Nginx, PHP, and MySQL respectively.
8, there is a table order (Order_id,user_id,order_amount), write a query statement, take out all the total consumption of more than 100 users of all order number order_id.
9, there is a string format as follows:
(A (B) (C (D) (E)) F)
The parentheses in the string appear in pairs, and write a function to take out the nth (indexed in the order in which the opening parenthesis appear) to the contents of the parentheses.
For example:
function GetContent ($id, $str) {...} $str = ' (A (B) (C (D) (E)) F) '; GetContent (3, $STR);
The results are as (C (D) (E))
I implore you to discuss the best solution of the last 2 questions.
1/F ly365 2011-03-12
18 Questions
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
