<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                ThinkChat2.0新版上線,更智能更精彩,支持會話、畫圖、視頻、閱讀、搜索等,送10W Token,即刻開啟你的AI之旅 廣告
                >[danger] 需 mix-database >= v2.0.2 才可使用。 ## QueryBuilder 查詢生成器,能幫助 PDOConnection 生成 `select` 類型的語句,便于閱讀性與開發效率,能生成大部分常用業務的 SQL。 >[info] insert、batchInsert、update、delete 類型的 SQL 與其他更為復雜的 SQL 依然需使用 PDOConnection 開發。 | 類 | 調用 | | --- | --- | | Mix\Database\QueryBuilder | $db->table('table') | ## 獲取連接 - 同步模式 ``` $db = app()->db; ``` - 協程模式 > 通過連接池組件獲取。 ``` $db = app()->dbPool->getConnection(); $db->release(); // 不手動釋放的連接不會歸還連接池,會在析構時丟棄 ``` ## Result 任何 PDOConnection 連接對象的 table 方法,都可返回一個 QueryBuilder 實例。 ``` // 返回全部 $ret = $db->table('users')->get(); // 返回第一行 $ret = $db->table('users')->first(); ``` ## Select ``` $ret = $db->table('users')->select('name', 'email as user_email')->get(); ``` ## Join 全部關聯方法有: - join - leftJoin - rightJoin - fullJoin ~~~ $ret = $db->table('users') ->join('orders', ['users.id', '=', 'orders.user_id']) ->select('users.*', 'orders.price') ->get(); ~~~ 多個關聯條件: > AND ``` ->join('orders', [['users.id', '=', 'orders.user_id'], ['users.name', '=', 'orders.user_name']]) // JOIN orders ON users.id = orders.user_id AND users.name = orders.user_name ``` > OR ``` ->join('orders', [['users.id', '=', 'orders.user_id'], ['or', ['users.name', '=', 'orders.user_name']]]) // JOIN orders ON users.id = orders.user_id OR users.name = orders.user_name ``` ## Where 只有一個 `where` 方法: ``` // 一緯 $ret = $db->table('users')->where(['id', '=', 1])->get(); ``` ``` // 二維 mix-database >= v2.0.4 $ret = $db->table('users') ->where([['id', '=', 1], ['name', '=', "Xiao Liu"]]) ->get(); ``` 多個關聯條件: > AND ``` $ret = $db->table('users') ->where(['id', '=', 1]) ->where(['name', '=', 'Xiao Liu']) ->get(); ``` > OR ``` $ret = $db->table('users') ->where(['id', '=', 1]) ->where(['or', ['id', '=', 2]]) ->get(); ``` > OR AND ``` $ret = $db->table('users') ->where(['id', '=', 1]) ->where(['or', [['id', '=', 2], ['id', '=', 3]]]) ->get(); // WHERE id = 1 OR (id = 2 AND id = 3) ``` > AND OR ``` $ret = $db->table('users') ->where(['id', '=', 1]) ->where(['and', [['id', '=', 2], ['or', ['id', '=', 3]]]]) ->get(); // WHERE id = 1 AND (id = 2 OR id = 3) ``` ### In / NotIn > IN ``` $ret = $db->table('users') ->where(['id', 'in', [1, 2]]) ->get(); ``` > NOT IN ``` $ret = $db->table('users') ->where(['id', 'not in', [1, 2]]) ->get(); ``` ### Between / NotBetween > BETWEEN ``` // 最新用法 $ret = $db->table('users') ->where(['id', 'between', [5, 10]]) ->get(); // mix-database < v2.0.4 (在v2.1將只支持上面的用法) $ret = $db->table('users') ->where(['id', 'between', 5, 10]) ->get(); ``` > NOT BETWEEN ``` // 最新用法 $ret = $db->table('users') ->where(['id', 'not between', [5, 10]]) ->get(); // mix-database < v2.0.4 (在v2.1將只支持上面的用法) $ret = $db->table('users') ->where(['id', 'not between', 5, 10]) ->get(); ``` ### Null / NotNull > IS NULL ~~~ $ret = $db->table('users') ->where(['id', 'is null']) ->get(); ~~~ > IS NOT NULL ~~~ $ret = $db->table('users') ->where(['id', 'is not null']) ->get(); ~~~ ## Order, Group, Limit, Offset ### orderBy 單個: ~~~ $ret = $db->table('users') ->orderBy('id', 'desc') ->get(); ~~~ 多個: ~~~ $ret = $db->table('users') ->orderBy('id', 'desc') ->orderBy('email', 'asc') ->get(); ~~~ ### groupBy / having 單個: ~~~ $ret = $db->table('orders') ->select('user_id', 'count(id) as counts') ->groupBy('user_id') ->having('count(id)', '>=', 1) ->get(); ~~~ 多個: ~~~ $ret = $db->table('orders') ->select('user_id', 'price', 'count(id) as counts') ->groupBy('user_id', 'price') ->having('count(id)', '>=', 1) ->get(); ~~~ ### limit / offset ~~~ $ret = $db->table('users') ->offset(10) ->limit(5) ->get(); ~~~
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看