Query_Builder_Insert class

(extends Query_Builder_Where)

The Query_Builder_Insert class handles all the insert operations for the query building process. It extends the Query_Builder_Where class, so all the methods are inherited.

table($table)

The table method sets/changes the table to insert into.

Static No
Parameters
Param Type Default Description
$table string required the table name
Returns Returns the current instance.
Example 
// prepare an insert statement
$query = DB::insert('users');

// Update the table to insert into
$query->table('admins');

// INSERT INTO `admins` ...

columns(array $columns)

The columns method sets/changes the columns to insert.

Static No
Parameters
Param Type Default Description
$columns array required an array of column names
Returns Returns the current instance.
Example 
// prepare an insert statement
$query = DB::insert('users');

// Set the columns
$query->columns(array(
    'name',
    'surname',
    'email')
);

// INSERT INTO `users` (`name`, `surname`, `email`)

values(array $values)

The values method appends the values to insert.

Static No
Parameters
Param Type Default Description
$values array required list of values
Returns Returns the current instance.
Example 
// prepare an insert statement
$query = DB::insert('users');

// Set the columns
$query->columns(array(
    'name',
    'surname',
    'email',
));

// Set the values

$query->values(array(
    'John',
    'Doe',
    'john@doe.com',
));

// INSERT INTO `users` (`name`, `surname`, `email`) VALUES ("John", "Doe", "john@doe.com")

set(array $pairs)

The set method sets the columns and appends the values to insert.

Static No
Parameters
Param Type Default Description
$pairs array required associative array of columns and values
Returns Returns the current instance.
Example 
// prepare an insert statement
$query = DB::insert('users');

// Set the columns and values
$query->set(array(
    'name' => 'John',
    'surname' => 'Doe',
    'email' => 'john@doe.com',
));

// INSERT INTO `users` (`name`, `surname`, `email`) VALUES ("John", "Doe", "john@doe.com")

compile(\Database_Connection$db)

The limit method returns the insert SQL query as a string.

Static No
Parameters
Param Type Default Description
$db object required A database connection
Returns Returns the SQL query as a string.
Example 
// prepare an insert statement
$query = DB::select('*')->from('users');

// Set the limit and offset
$query->limit(10);
$query->offset(5);

// Get the database connection
$connection = Database_Connection::instance();

// Get the sql query
$sql = $query->compile($connection);

reset()

The reset method resets all values of the current instance.

Static No
Parameters None
Returns Returns the current instance.
Example 
// prepare an insert statement
$query = DB::insert('users');

// Set some values
$query->set(array(
    'name' => 'John',
    'surname' => 'Doe',
));

// Reset it
$query->reset();

// Set the new values
$query->table('admins')->set(array(
    'name' => 'Mark',
    'surname' => 'Handriks'
));

// The SQL query will now be:
// INSERT INTO `admins` (`name`, `surname`) VALUES ("Mark", "Hendriks")