Home arrow MySQL arrow Case Study: Handling MySQL Growth With a PHP Class
MYSQL

Case Study: Handling MySQL Growth With a PHP Class


Sick of updating your MySQL database to add new fields half way through a project? In this article Bjorn discusses his PHP class that you can use to make changes to your MySQL database on the fly!

Author Info:
By: Bjorn Roysland
Rating: 4 stars4 stars4 stars4 stars4 stars / 12
November 12, 2002
TABLE OF CONTENTS:
  1. · Case Study: Handling MySQL Growth With a PHP Class
  2. · Generic MySQL Tables
  3. · The Tricky Part
  4. · Formmode
  5. · Conclusion

print this article
SEARCH DEVARTICLES

Case Study: Handling MySQL Growth With a PHP Class
(Page 1 of 5 )

For those of you who are just starting out with PHP and MySQL (as I once was), it's common to just jump right in and start building your MySQL tables with PHPMyAdmin and not make any considerations for future database growth or needs... isn't it? We've all done it, and we all know we shouldn't, but it's quick and easy.

I've been working on a document-publishing engine that can extend a MySQL database in the form of a PHP class. Basically, if you want to add a field to your MySQL database, the PHP class acts as a wrapper to your database and adds the field for you. Sound complex? Well, it isn't, and in this article I will show you the code that I've used to make this class - a kind of case study if you will.

You will need PHP 4.1 and MySQL 3.23 or above. I will assume that you're running a Linux web server, but everything will also work on a Windows 2000 server with Apache/IIS.
blog comments powered by Disqus
MYSQL ARTICLES

- MySQL and BLOBs
- Two Lessons in ASP and MySQL
- Lord Of The Strings Part 2
- Lord Of The Strings Part 1
- Importing Data into MySQL with Navicat
- Building a Sustainable Web Site
- Creating An Online Photo Album with PHP and ...
- Creating An Online Photo Album with PHP and ...
- PhpED 3.2 More Features Than You Can Poke ...
- Creating An Online Photo Album with PHP and ...
- Creating An Online Photo Album with PHP and ...
- Security and Sessions in PHP
- Setup Your Personal Reminder System Using PHP
- Create a IP-Country Database Using PERL and ...
- Developing a Dynamic Document Search in PHP ...

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 
Support 

Developer Shed Affiliates

 




© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials