Where is php applied?

MySQL

Primarily it is applied for creating web applications and websites which deal with client-server model. Use MySQL db with php and you could build a three tire architecture. Couple of big website like Facebook do use php.