Dynamically Insert and Update Values In a MySQL Database Using OOP - If You POST It, It Will Go
(Page 4 of 7 )
So now all you have to do is name your form fields the same as your database columns and you are (as we say in Kentucky,) "in bidnus." Let's create an example MySQL table:
CREATE TABLE
`my_tbl` (
`id` int(5) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`age` int(3) NOT NULL default '0',
`gender` enum('MALE','FEMALE') NOT NULL default 'MALE',
`phone` varchar(50) NOT NULL default '',
`date_added` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
Now we just create an HTML form using the POST method. We name the fields the same names as the columns in my_tbl.
<form action="<?php echo $_SERVER['PHP_SELF']; ? >" method="post" name="myForm">
<p>Name: <input name="name" type="text"></p>
<p>Age: <input name="age" type="text"></p>
<p>Gender:<br>
<input type="radio" name="gender" value="MALE"> Male<br>
<input type="radio" name="gender" value="FEMALE"> Female</p>
<p>Phone Number: <input name="phone" type="text"></p>
<p><input name="action" type="submit" value="AddToDB"></p>
</form>
The rest is really simple.
// Include the file that contains
// the MyDatabase class
require('database.class.php');
// If the form was submitted...
if($_POST['action'])
{
// Instantiate the class
$SQL = new MyDatabase;
// Connect to the database
$SQL->Connect();
// To get a datetime stamp in the
// date_added column
$_POST['date_added'] = 'DATESTAMP';
// Add values to my_tbl
if(!$SQL->AddToDB('my_tbl'))
die( $SQL->GetError() );
// Disconnect from the database
$SQL->Disconnect();
}
Check to see if the form has been submitted, instantiate the class, connect to the database, execute AddToDB passing the table name to it, and finally disconnecting from the database.
if
(!$SQL->AddToDB('my_tbl'))
die( $SQL->GetError() );
Notice that this will check to see if AddToDB returns false. If it does, it kills the execution of the script and displays the error that can be gotten from the GetError method.
But you didn't think we'd stop there, did you? No, no my blue friend, there is always an update to be done.
Next: Updateagenessly >>
More MySQL Articles
More By Sam 'SammyK' Powers
/ 83 
