PHP and MySQL

What is PHP ?

PHP (recursive acronym for PHP: Hypertext Preprocessor) is a widely-used open source general-purpose scripting language that is especially suited for web development and can be embedded into HTML.”

This one of the definition You can find on the web about what is PHP. This definition is from http://php.net/. So what are the features of PHP then? To understand that I have to outline that PHP is different from static html. This is because HTML run from your computer and PHP doesn’t get executed on your computer, but on the computer you requested the page from. Instead of writing a lot of commands using HTML , PHP allows you to embedded code which does “something”. The PHP code is read from top to bottom until the end of the process. If a user views the page source of a website that contains PHP he only sees the answers that PHP executes. This is enclosed in special start and processing instructions (<?php and ?>) which allows to jump in and out from PHP mode.

PHP Features 

  • Does not execute on your computer
  • It allows to enhance the HTML code
  • PHP is server side scripting
  • Allows you to create website application with registrations, log in pages, content upload ect.
  • PHP is free
  • PHP can be run on any operating system

These are one of the many features of PHP. For our website application we had to use PHP as well as it contains content upload, registration and log in. I will go into more details of PHP used in our website application in another blog post.

What is MySQL

“MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).”

MySQL is the most popular open source database management system. MySQL has been developed, distributed and supported by Oracle Corporation. Is use GNU (General Public Licence) which means that everyone can look at the MySQL script and update it to suit their needs. MySQL database is a rational database. This means that instead of storing a lot of data in one place the date is split in separate tables. in MySQL databases you can set up relationships between different data. The database is able to recognize the relationships so that you don’t have duplicate data, out of date data or missing data. The SQL which stand for Structured Query Language is used to follow the rule between the relationships. Therefore SQL is used to communicate with the database.

MySQL Features: 

  • Open source (general public can edit the script to suit their needs)
  • Free to use
  • Uses rational database management system
  • Allows to set rules and parameters for data
  • Make relationship between different data
  • Information is stored in different tables rather than in once place

References: 

http://www.homeandlearn.co.uk/php/php1p1.html

https://www.siteground.com/tutorials/php-mysql/mysql.htm

https://dev.mysql.com/doc/refman/4.1/en/what-is-mysql.html

http://www.sqlcourse.com/intro.html

http://php.net/manual/en/intro-whatis.php