MariaDB

MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system (RDBMS), intended to remain free and open-source software under the GNU General Public License. Development is led by some of the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle Corporation in 2009.^[1] MariaDB is intended to maintain high compatibility with MySQL, with exact matching to MySQL APIs and commands, allowing it in many cases to function as a drop-in replacement for MySQL - however, new features are diverging.^[2] It includes new storage engines like “Aria”, “ColumnStore”, and “MyRocks”.

Server-Side Scripting

Originally designed to create dynamic web pages, PHP's principal focus is server-side scripting. While running the PHP parser with a web server and web browser, the PHP model can be compared to other server-side scripting languages such as Perl, ASP, JSP, Ruby on Rails, and others which provide dynamic content to the client from a web server (and often, a database as well). The LAMP architecture has become popular across many industries as a way of deploying inexpensive, reliable, scalable, secure web applications. PHP is commonly used as the P in this bundle alongside Linux, Apache and MariaDB. PHP can be used with a large number of relational database management systems, runs on all of the most popular web servers and is available for many different Operating Systems. This flexibility means that PHP has a wide installation base across the Internet. Examples of server-side PHP applications include the original Google, phpBB, WordPress, GetWiki, and many, many others. PHP also provides a command line interface (CLI) for developing shell and desktop applications, daemons, log parsing, or other system administration tasks. It is increasingly used on the command line for tasks that have traditionally been the domain of Perl, Python, awk, or shell scripting.

Syntax

PHP can be used as a filter. The PHP program takes input from a file or stream containing text and special PHP instructions and outputs another stream of data for display. From PHP 4, the PHP parser compiles input to produce bytecode for processing by the Zend Engine, giving improved performance over its interpreter predecessor.

The usual “Hello World” code example for PHP is:

<?php
	echo “Hello, World!”;
?>

The example above is equivalent to the following text (and indeed is converted into this form):


PHP only parses code within its delimiters, and anything outside is sent directly to the output and is not parsed. The primary use of this is to easily allow PHP statements to be embedded within HTML documents, for example:

<?php
	// PHP statements here
?>

<?php
	// PHP statements here
?>

Variables are prefixed with a “$” and a type does not usually need to be specified in advance, although this is changing, as PHP becomes more like a strongly “typed” language. Unlike function and class names, variable names are case sensitive. Both double-quoted and single-quoted strings allow one to embed the variable's value into the string. PHP treats new lines as whitespace, in the manner of a free-form language (except when inside string quotes). Statements are terminated by a semicolon, except in a few special cases. PHP has three types of comment syntax: /* */ which serves well for block comments, and // as well as # which is used for inline comments.

Notes and References

• 2006-09-13, Is PHP The Cure For The 'Broken' Web?, internetnews.com, Kerner, Sean Michael , www.internetnews.com/dev-news/article.php/3631831
• 2006-10-31, Microsoft Opens PHP Door, internetnews.com, Kerner, Sean Michael, www.internetnews.com/dev-news/article.php/3641101
• Jason E. Sweat, Guide to PHP Design Patterns, PHP|architect, 2005, ISBN 0-9735898-2-5
• Ilia Alshanetsky, Guide to PHP Security, PHP|architect, 2005, ISBN 0-9738621-0-6
• Chris Shiflett, Essential PHP Security, O'Reilly Media, 2005, ISBN 0-596-00656-X
• Larry Ullman, PHP and MySQL for Dynamic Web Sites, Peachpit Press, 1st Edition, 2003, ISBN 0-321-18648-6

1. Web, www2.computerworld.com.au/article/457551/dead_database_walking_mysql_creator_why_future_belongs_mariadb/, Dead database walking: MySQL's creator on why the future belongs to MariaDB - MariaDB, open source, mysql, Oracle, Computerworld, 2013-09-11, 3 October 2020, web.archive.org/web/20201003111459/https://www2.computerworld.com.au/article/457551/dead_database_walking_mysql_creator_why_future_belongs_mariadb/, dead.
2. Web, MariaDB versus MySQL - Compatibility, mariadb.com/kb/en/library/mariadb-versus-mysql-compatibility/, live, web.archive.org/web/20200916072600/https://mariadb.com/kb/en/mariadb-vs-mysql-compatibility/, 16 September 2020, 17 September 2014, MariaDB KnowledgeBase.

External Links

• PHP Documentation
• PHP - An active listing of PHP links
• Patterns for PHP - A pattern collection site
• Practical PHP Programming wiki - An online PHP book
• Do You PHP? by Rasmus Lerdorf
• PHP at W3Schools
• Quercus - An open-source Java implementation of PHP in the Resin application server