本文整理汇总了PHP中QueryBuilder::fromArray方法的典型用法代码示例。如果您正苦于以下问题:PHP QueryBuilder::fromArray方法的具体用法?PHP QueryBuilder::fromArray怎么用?PHP QueryBuilder::fromArray使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类QueryBuilder
的用法示例。
在下文中一共展示了QueryBuilder::fromArray方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: fromArray
public static function fromArray($arr, $dbInstance)
{
if (!is_a($dbInstance, "Database")) {
trigger_logikserror("Database ERROR, DBInstance should be an object of Database");
}
$table = null;
$cols = "";
$where = null;
$groupby = null;
$having = null;
$orderby = null;
$index = 0;
$limit = FALSE;
$table = $arr['table'];
$cols = $arr['cols'];
if (isset($arr['where'])) {
$where = $arr['where'];
}
if (isset($arr['groupby'])) {
$groupby = $arr['groupby'];
}
if (isset($arr['having'])) {
$having = $arr['having'];
}
if (isset($arr['orderby'])) {
$orderby = $arr['orderby'];
}
if (isset($arr['limit'])) {
$limit = $arr['limit'];
}
if (isset($arr['index'])) {
$index = $arr['index'];
}
if (is_array($table)) {
$obj = QueryBuilder::fromArray($table, $dbInstance);
$table = $obj->_SQL();
}
$objx = QueryBuilder::create($dbInstance)->_selectQ($table, $cols, $where);
//$objx->_where($where);
if (isset($arr['join'])) {
foreach ($arr['join'] as $jn) {
$query = $jn['query'];
$condition = $jn['condition'];
$as = $jn['as'];
$type = $jn['type'];
$objx->_join($query, $condition, $as, $type);
}
}
$objx->_groupby($groupby, $having);
$objx->_orderby($orderby);
$objx->_limit($limit, $index);
return $objx;
}
示例2: fromArray
public static function fromArray($arr, $dbInstance)
{
$table = null;
$cols = "";
$where = null;
$groupby = null;
$orderby = null;
$limit = FALSE;
$table = $arr['table'];
$cols = $arr['cols'];
if (isset($arr['where'])) {
$where = $arr['where'];
}
if (isset($arr['groupby'])) {
$groupby = $arr['groupby'];
}
if (isset($arr['orderby'])) {
$orderby = $arr['orderby'];
}
if (isset($arr['limits'])) {
$limit = $arr['limits'];
}
if (is_array($table)) {
$obj = QueryBuilder::fromArray($table, $dbInstance);
$table = $obj->_SQL();
}
$objx = QueryBuilder::create($dbInstance)->_selectQ($table, $cols);
$objx = $objx->_where($where);
if (isset($arr['join'])) {
foreach ($arr['join'] as $jn) {
$query = $jn['query'];
$condition = $jn['condition'];
$as = $jn['as'];
$type = $jn['type'];
$objx = $objx->_join($query, $condition, $as, $type);
}
}
$objx = $objx->_groupby($groupby);
$objx = $objx->_orderby($orderby);
$objx = $objx->_limit($limit);
return $objx;
}