* CRUD Queries */ // Create a test table DB::query("DROP TABLE IF EXISTS `users`;\nCREATE TABLE `users` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `username` varchar(50) DEFAULT NULL,\n `email` varchar(70) NOT NULL,\n `created` int(10) unsigned DEFAULT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;"); // Insert some users $user = array('username' => 'Mary', 'email' => '*****@*****.**', 'created' => time()); $result = DB::insert('users', $user); 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();