Shulou(Shulou.com)06/02 Report--

This article mainly introduces what kind of skills PHP programmers should have. It is very detailed and has certain reference value. Friends who are interested must finish reading it.

MySQL capability

The application in development is based on several capabilities:

(1) understand: know how to use PHP to connect to the database; know how to write some simple SQL; to build some simple indexes; know how to use tools to simply operate the database (add, delete and change database table structure data, etc.).

(2) familiar with: know how to design database, build some effective indexes, use explain to analyze SQL performance, stress testing and so on.

(3) familiar with: in-depth understanding of database index, storage engine principle and operating mechanism, can effectively build a high-performance scalable database structure / architecture, effectively optimize the database performance configuration and debug, and analyze the running status of the database.

(4) proficiency: to put it simply, while having all the above capabilities, there are many years of optimization management experience in high-load distributed environment.

According to observation and communication experience, 70% of the PHPer is in the understanding stage, 25% is in the familiar stage, > 4% is very familiar, and the proficient person is basically not PHPer.

The group of ◆ 70% is most likely to ignore MySQL, thinking that MySQL is just a simple storage medium with no sense of optimization, and that adding memory and CPU can solve the problem.

Typical events: the performance of join, order by, group by and other statements is a mess, the database is not designed at all (limited to splitting into a main table, N schedules, etc.), do not understand the type and function of fields, and there is no way to deal with complex queries in large tables.

◆ 20% of this group of people just do not have a thorough understanding of the operating mechanism of MySQL, do not have a clear grasp of the key factors affecting MySQL performance, and are not proficient.

Typical event: familiar with the manual, but do not know the principle of indexing, do not know the effect of binary tree, HASH and other algorithms on the database

◆ 4% of the population is basically qualified for the function of DBA.

OOP capability

(1) understanding: understand the scope, type and meaning of variables, understand the inheritance mechanism, etc., and understand the concepts of reuse and encapsulation.

(2) familiar with: proficient in the application interface, abstract and other technology mixed development program, and understand the meaning, generally studied Java.

(3) familiar with: OOP architecture design experience, familiar with design patterns, UML, familiar with PHP object operation mechanism, content management, etc.

(4) mastery: it should be at the architect level, not limited to PHP.

Often we come across people who claim to be familiar with OOP but can't even explain public, private, protected, and static, who certainly haven't experienced a formal OOP project.

Experience of large website

(1) understand: familiar with caching applications (Memcache, APC, etc.) developed by PHP; contact with LVS and SQUID applications; have certain Session processing solutions; familiar with load balancing; familiar with PHP data connection pool application; understand PHP programming performance optimization.

(2) familiarity: master distributed cache and cache performance optimization, be familiar with storage system, file system, database, and develop extensible platform. Combined with load balancing, it can reasonably arrange traffic, monitor and analyze the performance of PHP.

(3) very familiar with: have the ability of system analyst, has gone beyond the PHPer link

(4) proficient.

DOM development capability

Application ability

These are all the contents of the article "what skills PHP programmers should have". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.