How Apache, PHP and MySQL work in tandem?

Before the advent of these three open source giants, developers and users of web technologies had few options to develop a cost effective and dynamic web application. As these three arrived things began to change, though they did not bring a huge revolution at the onset itself. These technologies got further developed, got enriched and matured by the selfless bunch of programmers. These coders believed firmly in open source initiatives and put in their sweat and blood in creating these magical tools. Gradually these tools began to garner a lion’s share in the programming and web technology space. Now let us introduce these three popular technologies one by one, Apache is a web server, PHP is a server side scripting language and MySQL is a relational database management system.

To elaborate it further, Apache is a web server which receives requests from the users for a programming file say in PHP, through one of the various popular browsers. After receiving the user requests, this web server parses the programming file to understand and process its instructions and ultimately send out the output to the web user. PHP, as earlier mentioned, is a server side programming language, popularly also being referred to as a backend language, gives the developers a grammar and syntax to write down their instructions to be executed by the Apache web server. As far as MySQL is concerned, all those familiar with technology terms, can quickly understand that it is a relational database management system. This database system has evolved from a very basic system to the current version, which now handles every type of SQL Query, table joins and sub queries.

Though the above explanation could be easily understood by the geeks and IT professionals. For laymen it is important to explain these utilities in easy to understand language with examples from our day to day life. There is this very famous example of an eatery, which can break the mystery to explain the functionalities of these tools to those who are unfamiliar with programming or technology. What do we do when we go to a restaurant? We call the waiter, who takes our order, takes that order to the kitchen to the chef, and the chef finally produces the dish, by taking ingredients from the store room. So here the waiter is the PHP, which takes all your instructions and carries to the chef, ApacheĀ is the chef, which reads those instructions and prepares the dish to be served to you and MySQL is the store room where all ingredients were kept.

Author: ucavik