Dynamically Insert and Update Values In a MySQL Database Using OOP - You Wouldn't Have to Update It Had You Gotten It Right the First Time

(Page 7 of 7 )

The blob:


// Include the file that contains 
// the MyDatabase class
require('database.class.php');
 
// If the form was submitted...
if($_POST['id'])
{
 // Instantiate the class
 $SQL = new MyDatabase;
 // Connect to the database
 $SQL->Connect();


 // Update values in my_tbl 
 // where id = $_POST['id']
 if(!$SQL->UpdateDB('my_tbl', 
 $_POST['id'], 'id'))
  die( $SQL->GetError() );


 // Disconnect from the database
 $SQL->Disconnect();
}



Look familiar? It should, unless you accidentally / intentionally skipped a section or two. The only difference now is we are using the UpdateDB method to update our table and now we are passing the id and the name of the id column in the database table.

You Are Much Faster Now, Grasshopper

Now you are able to focus, grasshopper. No more annoying insert and update statements to distract you. This class has become a permanent "must have" in my arsenal of includes. It's like an audio stream from Digitally Imported Radio (www.di.fm) - I never code without it.

So there you have it; my 2 dollars. It is my hope that you will find this class as helpful as I have. Just don't use it in a production environment without adding some more validation and better error reporting and so on. Until next time!

DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

Comments On: Dynamically Insert and Update Values In a MySQL Database Using OOP

>>> Be the FIRST to comment on this article!