Interview Summary (PHP)

# # # Interview Summary Bo Master (now) is the next semester, because the school senior can be full Nian internship, so began the road of internship on the recruitment site to the Grand game (PHP intern) delivered resume, because at that time Shanda games in Shanghai, and I am in Shandong, At that time to find a few companies and then went to Shanghai together, but the interviewer is very friendly, and later added my question to ask the following questions * How long: 3nian (since the blogger freshman started contacting PHP, now has three Nian) * PHP is suitable for doing what is not suitable for doing: fit-(data processing , management system), not suitable for: (interacting with the underlying) * PHP trait Features: Implementing multiple Inheritance * Understanding of MVC * whether to write interfaces (APIs) need to be aware of: null handling, security issues, data format unification * Security aspects need to be aware of: XSS attacks and SQL injection * How to prevent SQL injection: 1, escaping 2, using PDO bind for variable binding * MySQL to use what keyword: distinct* how to optimize the database (index, etc.) * What Redis is primarily used for: handling high concurrency, caching processing * What are the disadvantages of Redis: Redis is based on memory, each restart will need to re-read the data, and is not a relational database after the interviewer told me that there will be HR face, HR told me that the technology is no problem, ' results hr face kneeling ' because of seniors in Baidu, on the acquisition of Baidu inside Push, Baidu altogether interviewed ' wheel (two Departments) ' Briefly write ' Keep kneeling ' side * Self introduction: Xxx* said the advantages and disadvantages of TP: More library, manual Chinese, easy to get started * How to optimize Nginx: Set cache, buffer, use agent * did what project: xxx* Interface Interface: You can store public methods that are not implemented and const constants * How to implement reflection: the answer is to use serialized data for reflection two simple (forget part) * give you an object, this object can do xxx, but also can do xx how to achieve: Then the answer is to use the simple factory model to deal with, A brief description of the abstract process .... * give you an array of how to find the odd number and even numbers: n%2. * To sort two ordered lists: it's a comparison of three sides. * Upload a file can use what method: Post,put, when the brain pumping actually said (get) * Join IS what: Connection * Also asked a few questions about database computing, (can't remember) * in school what lessons the best: java* java to create the object is there heap or exist in the stack .... In fact, it was already brushed down, but the two-face interviewer helped me put my resume in my resume pool (52 minutes) * Self-Introduction: xxxx* PHP variables in the realNow: Say struct and hash zval* how to convert a string type to int 1) strong ext. 2) Use Intval function * How to convert an int type to string 1) strong ext. 2) settype* The difference between memcached and Redis: Redis has transaction processing, data structure is different, after the Redis restart, there can be a maximum number of K to find: But after answering the sorting, the interviewer was obviously dissatisfied, and later knew that he could use the two-point search for the MySQL engine: MyISAM , innodb,memory* MyISAM and InnoDB differences: MyISAM Find better performance, table lock, full-text index, INNODB support foreign key, transaction, lock Line * nginx epoll and select difference: Select is based on polling, Epoll is the trigger of the * hit concurrency first how to deal with two sides (30 minutes) * HTTPS and HTTP difference: After SSL encryption, certificate (did not do this expression do not know, to find out the actual development of what is different) * session Cross-domain: At that time, the answer is to store SessionID in the database, should not give you 500g data IP to find the number of repetitions of the most: at that time, the answer is split first, split the data into several data after the use of the TOPK algorithm processing * Redis string is how to implement: Array, Arrays length variable, array length remaining variable (SDS) * ordered Matrix to find a number: The answer is to the matrix of the column of the two-part search * Redis data type; list hash set zset* MySQL index implementation principle: B + number, Hash hr face: Asked some future to do the front end or back end or client, at that time answer is the latter paragraph, then he said someone will call you to tell you have not had, the result (did not hit, has been kneeling) and then one months went to Beijing interview on the recruitment site delivery of the company's first company (over) * Talk about the project Ask the difference between MySQL two engines * thinkphp load Data Flow * What's in http: Request field, request content Second Company (past) * Introduction * Talk about the project * Write the functions commonly used in PHP: string processing functions such as * HTTP has what fields * MySQL Index implementation principle: B + tree, hash * How to use JQ call Ajax:$.ajax () * Delete the. svn file in a specific directory: ' Find/-name '. SVN ' | Xargs RM-RF ' * Consistent hash: Answers to the master-slave data at that time * give you two 100G data to find the intersection of the 100 factorial how many 0 third company (not to) the interviewer gave me a very bad feeling in that 2580,000, very able to zb ask not difficult but I will not go to the fourth company (unknown) * Two very capable Nian men interviewed me 1个小时30分钟 * mainly around the project to ask, very deep, Kao (the word was the OSC harmony) Consider the very comprehensive above answer is my own answer (DA ' an this two is harmonious), there may be wrong or not comprehensive answer, I hope the vast number of oscer help me see how to better answer

