-
Book Overview & Buying
-
Table Of Contents
Mastering phpMyAdmin 2.11 for Effective MySQL Management
Welcome to the evolved Web! In the last few years, the Web has changed dramatically. In its infancy, the Web was a medium used mainly to convey static information ("Look, my home page is on the Web!"). Now, large parts of the Web carry information that is dynamically generated by application programs, on which enterprises and even individuals rely for their intranets and public websites.
Because of the clear benefits of databases (better accessibility and structuring of information), web applications are mostly database driven. The front-end used is the well known (and quickly deployed) web browser, and there is a database system at the back-end. Application programs provide the interface between the browser and the database.
Those who are not operating a database-driven website today are not using the medium to its fullest capability. Also, they could be lagging behind competitors who have made the switch. So it is not a question of whether we should implement a database-driven site, but it is more about when and mostly how to implement it.
Why web applications? They improve user experience and involve them in the process by opening up possibilities such as:
Gathering feedback about the site
Letting users communicate with us and with each other through forums
Ordering goods from our e-commerce site
Enabling easily editable web-based information (content management)
Designing and maintaining databases from the Web
Nowadays, WWW might stand for World-Wide Wave, a big wave that profoundly modifies the way developers think about user interface, data presentation, and most of all, the way data reaches users and comes back to the data center.
This chapter describes the place of phpMyAdmin in the context of PHP/MySQL, explains phpMyAdmin's history, and summarizes its features. Let us look at the solutions currently offered by host providers. The most prevalent is the PHP/MySQL combination.
Well-supported by their respective home sites, http://www.php.net and http://www.mysql.com, this duo has enabled developers to offer a lot of ready-made open-source web applications, and most importantly, enabled in-house developers to quickly put in place solid web solutions.
MySQL, which is mostly compliant with the SQL:2003 standard, is a database system well known for its speed, robustness, and small connection overhead, which is important in a web context where pages must be served as quickly as possible.
PHP, usually installed as a module inside the web server, is a popular scripting language in which applications are written to communicate with MySQL (or other database systems) on the back-end, and browsers on the front-end. Ironically, the acronym's signification has evolved itself along with the Web evolution, from Personal Home Page to Professional Home Page to its current recursive definition: PHP: Hypertext Processor. A reference about the successive name changes can be seen in PHP's source code itself at http://cvs.php.net/viewvc.cgi/php3/CHANGES?r1=1.23&r2=1.24. Available on millions of Web domains, PHP drives its own wave of quickly developed applications.
Change the font size
Change margin width
Change background colour