当前位置: 首页>>代码示例>>PHP>>正文


PHP QueryBuilder::create方法代码示例

本文整理汇总了PHP中QueryBuilder::create方法的典型用法代码示例。如果您正苦于以下问题:PHP QueryBuilder::create方法的具体用法?PHP QueryBuilder::create怎么用?PHP QueryBuilder::create使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在QueryBuilder的用法示例。


在下文中一共展示了QueryBuilder::create方法的5个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: getStartables

 public static function getStartables()
 {
     if (is_null(self::$startables) || !is_array(self::$startables)) {
         self::$startables = array();
         QueryBuilder::create(SQL::getConnection())->withQuery("SELECT id, display_name, folder_name, executable FROM websites")->build()->forEachResult(function ($row) {
             self::$startables[] = new Startables($row['id'], $row['display_name'], $row['folder_name'], $row['executable']);
         });
         if (count(self::$startables) == 0) {
             throw new Exception("lol");
         }
     }
     return self::$startables;
 }
开发者ID:Naniap,项目名称:Updater,代码行数:13,代码来源:Startables.php

示例2: foreach

    if ($webId == "-1") {
        // Update all
        foreach (Website::getAllWebsites() as $site) {
            echoSite($site);
        }
    } else {
        // Update single site
        QueryBuilder::create(SQL::getConnection())->withQuery("SELECT display_name, folder_name FROM websites WHERE id = ?")->withParam($webId, QueryBuilder::PARAM_TYPE_INT)->build()->forEachResult(function ($row) {
            $site = new Website(0, $row['display_name'], $row['folder_name']);
            echoSite($site);
        });
    }
} else {
    function echoStart(Startables $starter)
    {
        echo $starter->getName() . ":\r\n";
        echo $starter->start() . "\r\n";
    }
    $webId = $_GET['start-id'];
    /*if ($webId == "-1") {
    		// Update all
    		foreach (Website::getAllWebsites() as $site) {
    			echoSite($site);
    		}
    	} else {*/
    // Update single site
    QueryBuilder::create(SQL::getConnection())->withQuery("SELECT display_name, folder_name, executable FROM websites WHERE id = ?")->withParam($webId, QueryBuilder::PARAM_TYPE_INT)->build()->forEachResult(function ($row) {
        $starter = new Startables(0, $row['display_name'], $row['folder_name']);
        echoStart($starter);
    });
}
开发者ID:Naniap,项目名称:Updater,代码行数:31,代码来源:ajax.php

示例3: 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;
 }
开发者ID:arunjoseph,项目名称:Logiks-Core,代码行数:42,代码来源:AbstractQueryBuilder.php

示例4: 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;
 }
开发者ID:logiks,项目名称:logiks-core,代码行数:53,代码来源:AbstractQueryBuilder.php

示例5: createQueryBuilder

 /**
  * I mean... It's hard to not understand what this does.
  * @return QueryBuilder
  */
 public static function createQueryBuilder()
 {
     self::getConnection();
     return QueryBuilder::create(self::$connection);
 }
开发者ID:Naniap,项目名称:Updater,代码行数:9,代码来源:SQL.php


注:本文中的QueryBuilder::create方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。