DByte\DB::insert PHP Метод

    static function insert($table, array $data)
    {
        $query = "INSERT INTO `{$table}` (`" . implode('`, `', array_keys($data)) . '`) VALUES (' . rtrim(str_repeat('?, ', count($data = array_values($data))), ', ') . ')';
        return DB::$p ? DB::column($query . ' RETURNING `id`', $data) : (DB::query($query, $data) ? static::$c->lastInsertId() : NULL);
    }

 * 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();