Escape what the pseudo PHP programmer should do

What is a good PHP programmer to do? What skills should you have to be a PHP programmer? What is your skill level? This article will list some things that you should know as a PHP programmer.

MySQL Ability

The application in development is based on several capabilities:

(1) Understand: Know to use PHP to connect to the database, know how to write some simple SQL, build some simple indexes, know how to use the database with simple tools (add to the table structure data, etc.).

(2) Familiar with: Know how to design the database in the development application, establish some valid indexes, use explain to analyze SQL performance, stress test and so on.

(3) Very familiar: In-depth understanding of database indexing, storage engine principles and operating mechanisms, can effectively build High-performance scalable database structure/architecture, effectively optimize the database performance configuration and debugging, analysis of database operation status.

(4) Proficient: simple to say that with all the above capabilities, there are many years of high load distributed environment optimization management experience.

According to observation and communication experience, 70% of the Phper in the understanding stage, 25% in the familiar stage, >4% very familiar, proficient people are not phper the basic.

70% This group is the most easy to ignore MySQL, that MySQL is just a simple storage medium, no optimization awareness, that add a memory, the CPU can solve the problem.

Typical events: Join, order BY, GROUP by and other statements of the performance of a mess, the database is not designed (only to be broken into a master table, n tables, etc.), do not know the type of field and function, encountered a large table complex query.

20% This group of people is only MySQL operating mechanism understanding is not thorough, to affect the MySQL performance key factors grasp is not clear, unskilled.

Typical events: a familiar manual, but not the principle of indexing, do not know the binary tree, hash and other algorithms for the role of the database

4% groups are already basically competent for DBA functions.

OOP Capabilities

(1) Understand: Understand the scope of variables, types, and their significance, understanding of inheritance mechanisms, and understand the concept of reuse, encapsulation.

(2) familiar with: Skilled application interface, abstraction and other technology mixed development program, and understand the meaning of the general study of Java.

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

(4) Proficient: should be the architect level, not limited to PHP.

Often we will encounter some people claiming to be familiar with OOP but even public, private, protected, static is not clear, is certainly not experienced in the formal OOP project.

experience with large web sites

(1) Understanding: Familiar with PHP development of the cache application (Memcache, APC, etc.), contact with LVS, squid applications, have a certain session processing plan, familiar with load balancing, familiar with PHP data connection pool application, understand PHP programming performance optimization.

(2) familiar with: Master distributed caching and caching performance optimization, familiar with storage system, file system, database, development of scalable platform. The performance of PHP can be monitored and analyzed according to the load balance and reasonable arrangement of flow.

(3) Very familiar: has the system analyst ability, has exceeded the phper link;

(4) Proficient.

DOM Development Capabilities

Application Ability

The above is only a personal humble opinion, only hope to be able to make a comment, I hope Daniel can be supplemented or corrected.