MySQL
MySQL: Open-Source Power (By: Mitchell Harper)
MySQL: Open-Source PowerMySQL is the most popular, free, open-source database management system for the Unix/Linux platform. The MySQL database management system contains an enormous amount of functionality and power. In this article, Mitchell will describe some of its most popular features and most powerful functions.MySQL is the most popular, free, open-source database management system for the Unix/Linux platform. The MySQL database management system contains an enormous amount of functionality and power. Using a simple set of commands for inserting, retrieving, ...
A MySQL Driven Chat Script (By: Tim Pabst)
A MySQL Driven Chat ScriptIn this article, Tim will show you how to create a quick-n-easy chat script using PHP and a very simple MySQL database. The script will allow visitors to choose a nickname, enter text to send to the chatting window, and view messages from other people... all in real-time! For a bit of fun, the chat application also has buttons to send several emote-icons including smiling and frowning faces.One of the most popular uses for the Internet ...
Review: NuSphere PHPEd (By: John Ferme)
Review: NuSphere PHPEdI think it's quite amazing how far the PHP and MySQL combination of apps have come in the past 2-3 years. They both started from humble beginnings, yet today they are arguably the most popular scripting and database combination for new programmers to learn. In this article, John takes a look at PHPEd and talks about its interface, installer, and his overall opinion of it as an IDE for developing PHP scripts.I think it's quite amazing how far ...
Creating a Voting Poll With PHP And MySQL Part 1/2 (By: Mitchell Harper)
Creating a Voting Poll With PHP And MySQL Part 1/2Voting polls provide a level of interactivity in a sense that visitors can express their opinions about particular topics and areas of interest, simply by choosing their response to a question and clicking on a vote button. In this series of two articles, Mitchell's going to show us how to create an interactive voting poll system. It will contain an admin page and a page to vote and view results.Besides regular ...
Creating a Voting Poll With PHP And MySQL Part 2/2 (By: Mitchell Harper)
Creating a Voting Poll With PHP And MySQL Part 2/2In the first article of this two part series, Mitchell discussed how to create the database for a voting poll system. He also talked about adding and deleting polls. In this, the second and final article in the series, he will show you how to create a PHP script that will actually allow users to vote, remember which users have voted, and display the results of the most recent poll.In the ...
Introductory Database Theory: Systems And Design (By: Steve Adcock)
Introductory Database Theory: Systems And DesignBefore you can begin to design a database you must understand the underlying concepts and theories of why databases are used and how they are created. In this article, Steve gives us a great explanation of what a database is, the relational database model, metadata and indexes, the database management system and structured query language.Databases are the primary form of storage in both today's online and offline worlds. Databases are used to store millions of ...
Backing Up Your MySQL Databases With MySQLDump (By: Mitchell Harper)
Backing Up Your MySQL Databases With MySQLDumpMySQL includes several ways to backup your important data. In this article Mitchell shows us how to backup our databases using the mysqldump utility that comes with MySQL. He looks at several examples including how to backup your database to a file, another server, and even a compressed gzip file.MySQL is one of the most popular database management systems to use when developing interactive web sites that need to utilize persistent data sources. As ...
Blobbing Data With PHP and MySQL (By: Mitchell Harper)
Blobbing Data With PHP and MySQLIt seems that the latest and greatest use for databases is storing large amounts of binary data, known as BLOB's. These BLOB's can store just about any type of data imaginable, including MS Word documents, GIF/JPEG images, PDF files, MP3's, etc. In this article Mitchell shows us how to create a binary file repository using PHP and MySQL that can store and retrieve several different file types.It seems that the latest and greatest use for ...
Developing A Site Search Engine With PHP And MySQL (By: Mitchell Harper)
Developing A Site Search Engine With PHP And MySQLThe key to developing a successful web site is content. Sure, your site can be packed with 10,000 50-page articles, but what good are these articles if your visitors can't find what they're after? In this article Mitchell shows us how to create a site search engine with PHP and MySQL. He develops the MySQL database and PHP script that will allow us to enter several keywords to search dynamic content.How many ...
An Introduction to PEAR (By: John Ferme)
An Introduction to PEARThere have been several add-ons developed for PHP in the last couple of years, but none have reached the popularity of PEAR. PEAR is a framework and distribution for reusable PHP components. In this article John introduces us to PEAR, and more specifically, its PEAR::DB package, which is a set of classes that allows us to create generic code to talk to a variety of databases with minimal code changes.There are dozens of reasons why programming languages ...
