var_dump($result); $user = array('username' => 'John', 'email' => '*****@*****.**', 'created' => time()); $result = DB::insert('users', $user); var_dump($result); $user = array('username' => 'Bobb', 'email' => '*****@*****.**', 'created' => time()); $result = DB::insert('users', $user); var_dump($result); $user = array('username' => 'Troll', 'email' => '*****@*****.**', 'created' => time()); $result = DB::insert('users', $user); var_dump($result); // Oops! We got Bob's info wrong! Lets fix it! $user = array('username' => 'Bob', 'email' => '*****@*****.**'); $result = DB::update('users', $user, 3); var_dump($result); // Our moderators say that the "Troll" user needs to be deleted! $result = DB::query('DELETE FROM users WHERE username = ?', array('Troll')); var_dump($result); /* * Select Queries */ // Count all the users $result = DB::column('SELECT COUNT(*) FROM `users`'); var_dump('Total users: ' . $result); br(); // Get user number 2 (John) $result = DB::row('SELECT * FROM `users` WHERE id = ?', array(3)); var_dump($result); br(); // Fetch all the users! $result = DB::fetch('SELECT * FROM `users`'); var_dump($result);