require_once 'db.class.php';
$db = new db_class();
// Open up the database connection. You can either setup your database login
// information in the db.class.php file or you can overide the defaults here.
// If you setup the default values, you just have to call $db->connect() without
// any parameters-- which is much easier.
if (!$db->connect('localhost', 'user', 'password', 'database_name', true)) {
$db->print_last_error(false);
}
// Create the table (if it doesn't exist) by executing the external sql
// file with the create table SQL statement.
echo "Executing SQL commands in external file test_data.sql...<br>";
if (!$db->execute_file('test_data.sql')) {
$db->print_last_error(false);
}
$db->print_last_query();
// This I find very handy. You can build an array as you are working through,
// for example, POST variables and validating the data or formatting the data
// etc. By defaul, the class will add slashes (addslashes()) to all string data
// being input using this function. you can override that by doing:
// $db->auto_slashes = false;
// You cannot perform any MySQL functions when using insert_array() as the the
// function will be enclosed in quotes and not executed. If you have some fancy
// MySQL functions you'll want to use the insert_sql() function in which you
// provide all the sql.
// Also, it's worth pointing out that if the table in which data is being inserted
// has an auto_increment value (as this one does), then the function will return
// that value which is generated.
echo "<br>Adding data to the table from an array...<br>";
$data = array('user_name' => 'Micah Carrick', 'email' => '*****@*****.**', 'date_added' => '04/13/2003 4:12 PM', 'age' => 24, 'random_text' => "This ain't no regular text. It's got some \"quotes\" and what not!");
$user_id = $db->insert_array('users', $data);
