1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: 91: 92: 93: 94: 95: 96: 97: 98: 99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110:
<?php
/**
*
* AdiPHP : Rapid Development Tools (http://adilab.net)
* Copyright (c) Adrian Zurkiewicz
*
* Licensed under The MIT License
* For full copyright and license information, please see the LICENSE.txt
* Redistributions of files must retain the above copyright notice.
*
* @version 0.1
* @copyright Adrian Zurkiewicz
* @link http://adilab.net
* @license http://www.opensource.org/licenses/mit-license.php MIT License
*/
namespace Adi\QuickPDO;
/**
* Helper for WHERE sql expression
*
* @author adrian
*/
class Where {
/**
*
* @var mixed
*/
private $expression = NULL;
/**
*
* @var array
*/
private $params = NULL;
/**
*
* @param mixed $expression String or associative array
* @param mixed $params Simple value or array of values
*/
function __construct($expression, $params = NULL) {
$this->expression = $expression;
if ($params) {
if (!is_array($params)) {
$params = array($params);
}
$this->params = $params;
}
}
/**
* @param \Adi\QuickPDO\DB $db
*/
private function createSql(DB $db) {
if (is_string($this->expression)) {
$this->sql = $this->expression;
return;
} else if (is_array($this->expression)) {
$sql = array();
foreach ($this->expression as $field => $value) {
$db->getEngine()->escapeElement($field);
$sql[] = "{$field} = ?";
$this->params[] = $value;
}
$this->sql = implode(' AND ', $sql);
return;
}
throw new Exception("'Where' expression cannot be created");
}
/**
* Returns WHERE elements as associative array
*
* @param \Adi\QuickPDO\DB $db
* @return array
*/
public function getWhere(DB $db) {
$this->createSql($db);
return array(
'sql' => $this->sql,
'params' => $this->params,
);
}
}