Interview summary (php)

Interview summary (php)

#### Interview summary: The blogger (now) is a junior in the next semester. as a senior in the school can have a full nian internship, he started his internship on the recruitment website to give Shanda game (php intern) I posted my resume because Grand game was in Shanghai and I was in Shandong. I wanted to find several more companies and then meet them in Shanghai, but the interviewer was very friendly, later, I asked the following questions: * How long has php been used? 3 nian (as the freshman year of Bo master and slave started to access php, there are already three nian) * php is not suitable for what to do: suitable-(data processing, management system), not suitable for: (interaction with the underlying layer) * php trait features: implementation of multi-inheritance * understanding of MVC * whether an interface (API) has been written what should be paid attention to: NULL value processing, security issues, and unified data format * security considerations: XSS attacks and SQL injection * How to prevent SQL injection: 1, escape 2, use pdo bind for variable binding * what keywords does mysql reuse: distinct * How to optimize the database (index, etc.) * redis Main What to do: handle high concurrency and cache processing * What are the disadvantages of redis: redis is memory-based and needs to be re-read every restart, without a relational database, the interviewer told me that I would have an hr problem. hr told me that the technology was okay. 'HR was kneeling. 'because a senior student was in Baidu, he got Baidu's inner push, baidu has interviewed a total of 'six rounds (two departments) 'and briefly wrote 'continue upgrade'. * self-introduction: xxx * advantages and disadvantages of tp: many class libraries and Chinese manuals, easy to use * How to optimize nginx: Set cache and buffer, and use the proxy * for any project: xxx * interface: it can store public unimplemented methods and const constants * for reflection: at that time, the answer was that it was relatively simple to use serialized data to reflect the two sides (forgot a part) * to give you an object, which can be XXX or XX: at that time, the answer was to use the simple factory model to process the abstract process .... * How to find the odd and even numbers in an array: n % 2 .. simple * for two Ordered linked list sorting: compares three sides * what method can be used to upload files: post and put. at that time, the brain even said (get) * join: connection * also asked a few questions about database computing (I can't remember it) * What is the best course in school: whether the java * java creation object exists in the heap or in the stack .... (Kneeling) it was actually brushed down, but the interviewer helped me put my resume in the resume pool (52 minutes) * self-introduction: xxxx * variable implementation in php: I explained how to convert struct and hash zval * string type to int 1) strong to 2) use intval function * How to convert an Int type to string 1) strong to 2) settype * the difference between memcached and redis: redis has Transaction Processing and different data structures. after redis is restarted, data can exist * find the maximum number of k: But after answering the order, find again, the interviewer was obviously dissatisfied. later, he knew that mysql engine could be used for binary search *: myisam, innodb, memory * myisam and innodb. Differences: myisam search performance is better, table lock, full-text index, innodb supports foreign keys, transactions, and lock rows * nginx epoll and select. The difference is that select is based on round-robin, and epoll is triggered * How to process concurrency first (30 minutes) * Differences between https and http: after ssl encryption, the certificate (I don't know if I haven't done this yet, but what is the difference in actual development) * session cross-origin: at that time, the answer was to store the sessionid in the database. I should not give you the ip address of GB of data to find the most repeated data: at that time, I first split the answer, split the data into several pieces of data and use the topk algorithm to process * How is redis string implemented: Array, and array length variable, remaining array length variable (sds) * find a number in an ordered matrix: at that time, the answer was to perform binary search for all columns in The Matrix * redis data type; list hash set zset * mysql index implementation principle: B + number, hash hr: I asked whether to use the frontend, backend, or client in the future. at that time, I answered the back section, and then he said someone would call you to tell you that the result was successful (no call, then I went to Beijing for a month to interview the first company posted on the recruitment website) * talked about the project * and asked about the differences between the two mysql engines * thinkphp data loading process * What are the request fields and request content in http? Second Company (too) * Self-introduction * talked about the project * and wrote common php functions: * what fields of http such as string processing functions * mysql index implementation principle: B + tree, hash * How to use jq to call ajax: $. ajax () * delete in a specific directory. svn File: 'Find/-name ". svn "| xargs rm-rf '* consistent hash: at that time, the answer was to achieve master-slave data consistency * to give you two 100 GB data for the intersection * to find out how many 0 factorial there are 3 companies (not to go) the interviewer gave me a bad feeling, in those 80 thousand, zb is very easy to ask, but I will not go to the fourth company even if I have passed (unknown) * Two very competent nian men interviewed me for an hour and 30 minutes * mainly asked about the project, with great depth. kao (this word is in harmony with osc) all of the above answers are answered by myself (is the Da'an being harmonious?). Some answers may be incorrect or incomplete, I hope the majority of oscer will help me to see how to better answer