public function addUser($conexion, $email, $nombre, $apellido, $edad, $genero, $grado, $password)
{
$roll = 3;
$active = 0;
$query = new Query();
$query->add($this->table, $conexion, $email, $nombre, $apellido, $edad, $genero, $grado, $password, $roll, $active);
}
function add($params)
{
$game = new Game();
foreach ($game as $key => $value) {
if (isset($params[$key])) {
$game->{$key} = $params[$key];
}
}
$game = Query::add($game);
return $game;
}
function add($params)
{
$arena = new Arena();
foreach ($arena as $key => $value) {
if (isset($params[$key])) {
$arena->{$key} = $params[$key];
}
}
$arena = Query::add($arena);
return $arena;
}
function add($params)
{
$user = new User();
foreach ($user as $key => $value) {
if (isset($params[$key])) {
$user->{$key} = $params[$key];
}
}
$user = Query::add($user);
return $user;
}
function testGetTablesClauseMultipleTablesWithJoin()
{
$q = new Query('Article');
$q->join('UserCard', 'Article.CardID = UserCard.CardID AND UserCard.UserID = 2', Query::LEFT_JOIN);
$q->add('UserCard.CardID', null, Query::IS_NULL);
$q->join('CardPicture');
$q->group('Article.CardID');
$q->addOrder('Title', 'DESC');
$this->assertEquals(preg_replace('/\\s/', '', 'SELECT `Article`.*
FROM (`Article`, `CardPicture`)
LEFT JOIN `UserCard` ON (Article.CardID = UserCard.CardID AND UserCard.UserID = 2)
WHERE `UserCard`.`CardID` IS NULL
GROUP BY `Article`.`CardID`
ORDER BY `Title` DESC'), preg_replace('/\\s/', '', $q->getQuery() . ''));
}
<?php
//New query
$q = new Query();
$q->add('Column', 'Value');
//Limit results per page
$limit = 50;
//Specify the current page
$page = 2;
//Create instance of pager, provide the name of the DABL class
$pager = new QueryPager($q, $limit, $page, 'Inspection');
//Retrieve an array of Objects from the DABL class for that page
$inspections = $pager->fetchPage();
/**
* @param string $foreign_table
* @param string $foreign_column
* @param Query $q
* @return Query
*/
protected function getForeignObjectsQuery($foreign_table, $foreign_column, $local_column, Query $q = null)
{
$value = $this->{"get{$local_column}"}();
if (null === $value) {
throw new RuntimeException('NULL cannot be used to match keys.');
}
$column = "{$foreign_table}.{$foreign_column}";
if ($q) {
$q = clone $q;
$alias = $q->getAlias();
if ($alias && $foreign_table == $q->getTable()) {
$column = "{$alias}.{$foreign_column}";
}
} else {
$q = new Query();
}
$q->add($column, $value);
return $q;
}
