PHP, SQL – A simple introduction to Databasing

What is PHP?

PHP is a popular scripting language for the web. It is most often used to add different kinds of functionality that HTML can’t really do.

PHP can do math calculations well, Including dates or extra long equations. Right out of the gates PHP can do math using operators and operands. Most math can be done without any extra installation required. PHP core has almost everything necessary.

If you wanted to collect info from visitors like cataloging addresses or allowing participation in a survey then PHP is the way to go.

PHP and MySQL work together very well. When PHP is used with a MySQL database the sky is really the limit. You can place and retrieve information from the database, build a login system, automate things, make a customized photo gallery. You can really do whatever you want using these two tools together.

One example is using cookies to identify users, or store other info. PHP is used to create, delete, or modify cookies.

So what is SQL?

SQL stands for structured Query Language. It is a standardized programming language that we use to manage, store and perform operations with our data. It started in the 1970’s and is used by web developers for scripts and database administrators to run queries or to analyze stored data. It became the standard in the 80’s. With the International Organization for Standardization (also known as ISO) adopting it in 1987.

RDMS

RDMS stands for relational database management systems. Microsoft SQL Server, Oracle Database, IBM DB2, MySQL and others all fall into this category. Software like these examples are meant to help create, update or manage relational databases. These all depend on SQL.

Check out Database Vault at ASPnix for more information on how we can help you backup SQL Server or MySQL databases.