I’ve been toying with setting up PHP/MySQL sites for some time now. It’s become quite a hobby actually.
PHP is an open-source (meaning it’s authored, developed and tweaked by one person or many and is generally free of charge to use, develop, and tweak) scripting language for the web. (Like HTML as a language, but "tagged" differently.)
MySQL is merely an open-source database that allows scripts to enter, retrieve and modify "tables" of data (text and more) via the web.
The beauty comes in when folks develop entire sites based on PHP and MySQL and release them for (free) download and use. These sites can be categorized by their functions. Here are a few to spur your appetite:
Portal
A portal is generally an all incompassing web application (even "engine") that allows many types of content to be shared on any given space. You might find project management, calendaring, contacts, journals, IM, forums, listservs, intranet and extranet and many other tools that are typically geared toward "enterprise" applications (corporate intranets for example.) Portals are often referred to as Content Management Systems (CMS.)
Forum
A forum is a central message system used for mild corporate and collaborative communication and project management. You are on one right now.
Blog
Or weblog, is an online database-driven journal that typically allows public (or private) linear communication surrounding topical discussions usually authored by one or select few individuals.
e-commerce
E-commerce is also addressed in the open-source community and houses the functionality for online product marketing and sales.
Wiki
A wiki is a simplified content management system allowing single or multiple (collaborative) users to edit the content of a website with little or no knowledge of HTML or other web languages relying on the database to store and retrieve page content. (Enabling database technology is the basis of managing content via a wiki.)
Groupware
A portal designed for collaborative work amongst project members. Essentially, a database-driven project management facility.
_________
Ok. So why the fuss about all this? Well, if you’re clueless at HTML, if you couldn’t care less about trying to engineer graphics that people actually like, or if you simply don’t have enough time in the day to hand code a website and just need to disseminate information as quickly as possible, then a solution using PHP and My SQL might be just for you.