PHP Sirel Table::join Examples

Programming Language: PHP

Namespace/Package Name: Sirel

Class/Type: Table

Method/Function: join

Examples at hotexamples.com: 1

PHP Sirel Table::join - 1 examples found. These are the top rated real world PHP examples of Sirel\Table::join extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

update(2)

delete(2)

getName(1)

insert(1)

join(1)

order(1)

project(1)

where(1)

Example #1

Show file

File: AbstractDbTestCase.php Project: chh/sirel

 function testInnerJoin()
 {
     $users = new Table("users");
     $profiles = new Table("profiles");
     $result = $this->fetchAll($users->join($profiles)->on($users['id']->eq($profiles['user_id'])));
     $this->assertEquals(2, count($result));
     $this->assertEquals(array(1, 2), $this->pluckIds($result));
     $this->assertEquals("John Doe", $result[0]['display_name']);
     $this->assertEquals("1970-01-01 00:00:01", $result[0]['birth_date']);
 }