An Open source is a program or application that can be used by any user without purchasing any license. They are available at free of cost. Moreover its source code can also be available for the users so they can use or modify it for improvement in that application.
Open Source is a certification mark owned by the Open Source Initiative (OSI). OSI is an organization that promoted open source software. It was founded in 1998 by Bruce Perens and Eric Raymond after Netscape has decided to publish source code for its Netscape communicator software.
Developers can download the source code of open source software and if possible they can add improvement into the software and redistribute it if their distribution terms conform to the OSI's Open Source Definition.
Linux is an example of Open Source Operating System.
Apache, PHP and MySQL also fall into the category of Open Source Application.
PHP (Hypertext Preprocessor)
PHP is a server side scripting language that is used for building dynamic, interactive Web sites.
PHP scripts run on a Web server.
PHP stands for Hypertext Preprocessor.
PHP programs run on a Web server, and serve Web pages to visitors on request.
One of the key features of PHP is that you can embed PHP code within HTML Web pages, making it very easy for you to create dynamic content quickly.
PHP was created by Rasmus Lerdorf in 1994. PHP started out as a set of simple tools coded in the C language to replace the Perl scripts that Rasmus was using on his personal home page. He released PHP to the general public in 1995, and called it PHP version 2.
In 1997 Zeev Suraski and Andi Gutmans along with Rasmus rewrite the PHP and released PHP version 3.0 in June 1998. After the release of PHP version 3.0 PHP becomes so much popular.
The PHP version 4.0 was launched in May 2000. This version includes session handling, output buffering, a richer core language, and support for a wider variety of Web server platforms.
The PHP version 5.0 was released in 2004 with object oriented programming concept such as private and protected class members, final, private, protected, and static methods, abstract classes, interfaces and standardized constructor/destructor syntax.
Apache (Web Server)
Apache is generally recognized as the world's most popular Web server HTTP server. Originally designed for UNIX servers, the Apache Web server has been ported to Windows and other network operating systems (NOS).
The name "Apache" derives from the word "patchy" that the Apache developers used to describe early versions of their software.
The Apache Web server provides a full range of Web server features, including CGI, SSL, and virtual domains. Apache also supports plug-in modules for extensibility. Apache is reliable, free, and relatively easy to configure.
Apache is free software distributed by the Apache Software Foundation. The Apache Software Foundation promotes various free and open source advanced Web technologies.
MySQL is a relational database management system based on SQL (Structured Query Language).
In Relational Database Management System every database consists of one or more tables inside it. Thus you can say that a Database is a collection of one or more then one tables which are related with each other in one or another way.
A table in the Database is used to store records. The records in the table are organized in the form of rows. Each row in the table represents particular record.
A record that is contained in the table is a collection of one or more columns. Each column in the record represents field of specific type in the database table. Each field in the record contains values for the different records.
First released in January, 1998, MySQL is now one component of parent company MySQL AB's product line of database servers and development tools.
MySQL runs on virtually all platforms, including Linux, UNIX, and Windows.
It is fully multi-threaded using kernel threads, and provides application program interfaces (APIs) for many programming languages, including C, C++, Java, Perl, PHP, and Python.
MySQL is used in a wide range of applications, including data warehousing, e-commerce, Web databases, logging applications and distributed applications. It is also increasingly embedded in third-party software and other technologies.