$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); if (!$user_id) { $db->print_last_error(false); } $db->print_last_query(); $db->dump_query("SELECT * FROM users WHERE user_id={$user_id}"); // This is similar to the above, only it updates the data rather than insert. Also // you'll notice that in the first one we used a string to represent the date // and this time we're using the time function to generate a timestamp. This is // done to illustrate the class' ability to convert the date and time formats // to a MySQL compatible format. I like that alot :) echo "<br>Updating the data in the table by changing the date_added... "; $data = array('date_added' => time()); $rows = $db->update_array('users', $data, "user_id={$user_id}"); if (!$rows) { $db->print_last_error(false);
} } if (!empty($_REQUEST['youtube_url'])) { require_once 'db/db.class.php'; checkForSpam(); // Open the DB connection $db = new db_class(); if (!$db->connect($GLOBALS['db_hostname'], $GLOBALS['db_username'], $GLOBALS['db_password'], $GLOBALS['db_name'], true)) { $db->print_last_error(false); } // Get the user info into the DB $user_data = $stuffer->getUserData(); $sql = "SELECT id from users where username = '******'username']) . "';"; $user_id = $db->select_one($sql); if (!$user_id) { $user_id = $db->insert_array('users', $user_data); } // cram the video into the db $youtube_url = mysql_real_escape_string($_REQUEST['youtube_url']); $create_time = empty($create_time) ? time() : $create_time; $video_data = array('youtube_url' => $youtube_url, 'type' => 'video', 'user_id' => $user_id, 'create_time' => time()); $video_id = $db->insert_array('images', $video_data); if (is_numeric($video_id)) { header('Location: http://www.braincrave.org/?id=' . $video_id . "&success=1"); } else { $stuffer->error("Really? You screwed this up? All you had to do was paste in ONE THING. Maybe you should try again."); } } else { $image_id = $stuffer->stuff(); if ($image_id) { // require the twitter library