PHP & MySQL

 

PHP is a programming language and MySQL is a database application. Where you find one, normally you find the other. The most common place you will find them both being used is on servers. PHP Hypertext Preprocessor (PHP) is a server side scripting language that is often embedded into HTML (Hypertext Markup Language) to add functionality that HTML alone cannot do. HTML is also a programming language. If you intend to build a custom website on a host server or create a web application for use on your website, you must know how to program and create code in HTML and PHP. Wait, you say, a website can be built using WordPress and Joomla or Drupal and knowing how to write code was not required. In addition, there are all kinds of apps and plug-ins that extends the functionality of and customizes the website even more. That is absolutely true and you do not need to know squat about programming. That is because those programs automatically generate the code for you based on the plain language instructions you give it. Those programs convert your everyday action into HTML extended by PHP script and place on your website the object of your desires. The code is there. You just do not see it or create it.

PHP also allows web developers to create dynamic content that interacts with databases. PHP applications are normally found on Linux servers and in conjunction with MySQL databases. It provides those servers with functionality similar to that provided to the Windows platform by Active Server Pages technology. Yeah, yeah TMI (too much information). It had to be said just to prove to you that the simplicity of using code generating programs does not mean that what is beneath it is either simple or straightforward.

MySQL or "My S-Q-L” is the official acronym, but it is also called "My Sequel" as a colloquialism and is a widely used open source relational database management system (RDBMS). It runs as a server providing multi-user access to a number of databases. SQL actually stands for Structured Query Language. To translate, MySQL is a program that allows you to ask questions of any number of databases that hold information and get an answer.