...
Code Block | ||
---|---|---|
| ||
// Produces SELECT `clients`.* FROM `clients`, `contacts`
$this->Record->select(array("clients.*"))->from("clients")->from("contacts");
// Produces SELECT `clients`.* FROM `clients`, `contacts`
$this->Record->select(array("clients.*"))->from("clients")->join("contacts"); |
Multiple conditions
Code Block | ||
---|---|---|
| ||
// Produces SELECT `clients`.* FROM `clients` LEFT JOIN `contacts` ON `contacts`.`user_id`=`clients`.`user_id` AND `contacts`.`id`!='0' $this->Record->select(array("clients.*"))->from("clients")->on("contacts.id", "!=", 0)->leftJoin("contacts", "contacts.user_id", "=", "clients.user_id", false); // Produces SELECT `clients`.* FROM `clients` LEFT JOIN `contacts` ON `contacts`.`user_id`=`clients`.`user_id` OR `contacts`.`id`!='0' $this->Record->select(array("clients.*"))->from("clients")->orOn("contacts.id", "!=", 0)->leftJoin("contacts", "contacts.user_id", "=", "clients.user_id", false); |
...
Code Block | ||
---|---|---|
| ||
// Executes INSERT INTO `clients` (`user_id`,`id_code`) VALUES ('15','USR15') $this->Record->insert("clients", array('user_id' => 15,'id_code' => "USR15", 'first_name' => "First Name", 'last_name' => "Last Name"), array("user_id","id_code")); |
...
Code Block | ||
---|---|---|
| ||
$sub_query_record = new Record(); $sub_query_record->select(array("clients.id"))->from("clients")->where("clients.id", "=", 12); // Executes INSERT INTO `some_table` (`value`) (SELECT `clients`.`id` FROM `clients` WHERE `clients`.`id`='12') $this->Record->insert("some_table", array('value'=>$sub_query_record)); |
Update
Simple Update
Code Block | |
---|---|
|
Delete
...
| |
// Executes UPDATE `clients` SET `user_id`='15', `id_code`='USR15'
$this->Record->update("clients", array('user_id' => 15, 'id_code' => "USR15"));
// Executes UPDATE `clients` SET `id_code`='USR15' WHERE `user_id`='15'
$this->Record->where("user_id", "=", 15)->update("clients", array("id_code"=>"USR15")); |
Update with Filter
Code Block | ||
---|---|---|
| ||
// Executes UPDATE `clients` SET `user_id`='15', `id_code`='USR15'
$this->Record->update("clients", array('user_id' => 15,'id_code' => "USR15", 'first_name' => "First", 'last_name' => "Last"), array("user_id","id_code")); |
Update with Increment
Code Block | ||
---|---|---|
| ||
// Executes UPDATE `clients` SET `user_id`=user_id+3 WHERE `user_id`='15'
$this->Record->set("user_id","user_id+3", false, false)->where("user_id", "=", 15)->update("clients"); |
Delete
Simple Delete
Code Block | ||
---|---|---|
| ||
// Executes DELETE FROM `clients`
$this->Record->from("clients")->delete(); |
Delete from Tuples
Code Block | ||
---|---|---|
| ||
// Executes DELETE `clients`.*, `contacts`.* FROM `clients` INNER JOIN `contacts` ON `contacts`.`client_id`=`clients`.`id` WHERE `clients`.`id`='15'
$this->Record->from("clients")->innerJoin("contacts", "contacts.client_id", "=", "clients.id")->where("clients.id", "=", 15)->delete(array("clients.*","contacts.*")); |
Table Management
Create
Alter
...