PHP Database\MySQL Select Examples

Example #1

File: FunctionsTest.php Project: icetomcat/database_adapter

 public function testSelectUserWithPassword()
 {
     $select = new Select(["table" => "users", "where" => ["#login" => "email", "#password" => ["PASSWORD" => "value"]]], ["prefix" => "prfx_"]);
     $this->assertEquals($select->getRawQuery(), "SELECT * FROM `prfx_users` WHERE `login` = `email` AND `password` = PASSWORD(:__p0)");
 }

Example #2

File: SimpleSelectTest.php Project: icetomcat/database_adapter

 public function testSelectConstSumm()
 {
     $select = new Select(["columns" => ["+" => [1, 2, 3]]]);
     $this->assertEquals($select->getRawQuery(), "SELECT (1 + 2 + 3)");
 }