PHP DB::queryFullColumns Examples

queryFullColumns() public static method

public static queryFullColumns ( )

Example #1

File: BasicTest.php Project: hllau9/Euro2016

 function test_9_fullcolumns()
 {
     $true = DB::insert('profile', array('id' => 1, 'signature' => 'u_suck'));
     DB::query("UPDATE accounts SET profile_id=1 WHERE id=2");
     $r = DB::queryFullColumns("SELECT accounts.*, profile.*, 1+1 FROM accounts\n      INNER JOIN profile ON accounts.profile_id=profile.id");
     $this->assert($true === true);
     $this->assert(count($r) === 1);
     $this->assert($r[0]['accounts.id'] === '2');
     $this->assert($r[0]['profile.id'] === '1');
     $this->assert($r[0]['profile.signature'] === 'u_suck');
     $this->assert($r[0]['1+1'] === '2');
 }