<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>

                企業??AI智能體構建引擎,智能編排和調試,一鍵部署,支持知識庫和私有化部署方案 廣告
                # 數據庫 - 數據庫操作 ``` <pre class="calibre14">``` use Illuminate\Support\Facades\DB<span class="token2">;</span> DB<span class="token2">:</span><span class="token2">:</span><span class="token1">select</span><span class="token2">(</span><span class="token4">"select * from users where name=?"</span><span class="token2">,</span><span class="token2">[</span><span class="token4">'admin'</span><span class="token2">]</span><span class="token2">)</span><span class="token2">;</span> <span class="token6">//也支持name=:name,[':name'=>'admin']綁定,返回obj</span> DB<span class="token2">:</span><span class="token2">:</span><span class="token1">insert</span><span class="token2">(</span><span class="token4">'insert into users (id, name) values (?, ?)'</span><span class="token2">,</span> <span class="token2">[</span><span class="token3">1</span><span class="token2">,</span> <span class="token4">'Dayle'</span><span class="token2">]</span><span class="token2">)</span><span class="token2">;</span> $affected <span class="token">=</span> DB<span class="token2">:</span><span class="token2">:</span><span class="token1">update</span><span class="token2">(</span><span class="token4">'update users set votes = 100 where name = ?'</span><span class="token2">,</span> <span class="token2">[</span><span class="token4">'John'</span><span class="token2">]</span><span class="token2">)</span><span class="token2">;</span> 返回影響行數 $deleted <span class="token">=</span> DB<span class="token2">:</span><span class="token2">:</span><span class="token1">delete</span><span class="token2">(</span><span class="token4">'delete from users'</span><span class="token2">)</span><span class="token2">;</span>返回影響行數 DB<span class="token2">:</span><span class="token2">:</span><span class="token1">statement</span><span class="token2">(</span><span class="token4">'drop table users'</span><span class="token2">)</span><span class="token2">;</span> 其他無返回語句 DB<span class="token2">:</span><span class="token2">:</span><span class="token1">transaction</span><span class="token2">(</span><span class="token5">function</span> <span class="token2">(</span><span class="token2">)</span> <span class="token2">{</span> 事務 DB<span class="token2">:</span><span class="token2">:</span><span class="token1">table</span><span class="token2">(</span><span class="token4">'users'</span><span class="token2">)</span><span class="token">-</span><span class="token">></span><span class="token1">update</span><span class="token2">(</span><span class="token2">[</span><span class="token4">'votes'</span> <span class="token">=</span><span class="token">></span> <span class="token3">1</span><span class="token2">]</span><span class="token2">)</span><span class="token2">;</span> DB<span class="token2">:</span><span class="token2">:</span><span class="token1">table</span><span class="token2">(</span><span class="token4">'posts'</span><span class="token2">)</span><span class="token">-</span><span class="token">></span><span class="token1">delete</span><span class="token2">(</span><span class="token2">)</span><span class="token2">;</span> <span class="token2">}</span><span class="token2">)</span><span class="token2">;</span> $list <span class="token">=</span> DB<span class="token2">:</span><span class="token2">:</span><span class="token1">table</span><span class="token2">(</span><span class="token4">"users"</span><span class="token2">)</span><span class="token">-</span><span class="token">></span><span class="token1">get</span><span class="token2">(</span><span class="token2">)</span><span class="token">-</span><span class="token">></span><span class="token1">toArray</span><span class="token2">(</span><span class="token2">)</span><span class="token2">;</span><span class="token6">//獲取全部轉換成數組</span> DB<span class="token2">:</span><span class="token2">:</span><span class="token1">table</span><span class="token2">(</span><span class="token4">"users"</span><span class="token2">)</span><span class="token">-</span><span class="token">></span><span class="token1">first</span><span class="token2">(</span><span class="token2">)</span> 獲取一行 DB<span class="token2">:</span><span class="token2">:</span><span class="token1">table</span><span class="token2">(</span><span class="token4">"users"</span><span class="token2">)</span><span class="token">-</span><span class="token">></span><span class="token1">value</span><span class="token2">(</span><span class="token4">'email'</span><span class="token2">)</span><span class="token2">;</span> 獲取一個字段 DB<span class="token2">:</span><span class="token2">:</span><span class="token1">table</span><span class="token2">(</span><span class="token4">"users"</span><span class="token2">)</span><span class="token">-</span><span class="token">></span><span class="token1">pluck</span><span class="token2">(</span><span class="token4">'email'</span><span class="token2">)</span><span class="token">-</span><span class="token">></span><span class="token1">toArray</span><span class="token2">(</span><span class="token2">)</span><span class="token2">;</span> 獲取一列<span class="token2">,</span>如果設置兩個<span class="token1">pluck</span><span class="token2">(</span><span class="token4">'name'</span><span class="token2">,</span><span class="token4">'id'</span><span class="token2">)</span> id是鍵name是值的鍵值數組 <span class="token1">count</span><span class="token2">(</span><span class="token2">)</span> 結果集數量 <span class="token1">max</span><span class="token2">(</span><span class="token4">'price'</span><span class="token2">)</span>最大值 <span class="token1">min</span><span class="token2">(</span><span class="token4">'price'</span><span class="token2">)</span>最小值 <span class="token1">avg</span><span class="token2">(</span><span class="token4">'price'</span><span class="token2">)</span>平均數 <span class="token1">sum</span><span class="token2">(</span><span class="token4">'price'</span><span class="token2">)</span>求和 DB<span class="token2">:</span><span class="token2">:</span><span class="token1">table</span><span class="token2">(</span><span class="token4">'users'</span><span class="token2">)</span><span class="token">-</span><span class="token">></span><span class="token1">select</span><span class="token2">(</span><span class="token4">'name'</span><span class="token2">,</span> <span class="token4">'email as user_email'</span><span class="token2">)</span><span class="token">-</span><span class="token">></span><span class="token1">get</span><span class="token2">(</span><span class="token2">)</span><span class="token2">;</span> 返回特定字段 <span class="token1">whereRaw</span><span class="token2">(</span><span class="token4">'price > IF(state = "TX", ?, 100)'</span><span class="token2">,</span> <span class="token2">[</span><span class="token3">200</span><span class="token2">]</span><span class="token2">)</span> 原生where <span class="token1">orderBy</span><span class="token2">(</span><span class="token4">'name'</span><span class="token2">,</span> <span class="token4">'desc'</span><span class="token2">)</span> <span class="token1">inRandomOrder</span><span class="token2">(</span><span class="token2">)</span>隨機排序 <span class="token1">join</span><span class="token2">(</span><span class="token4">'contacts'</span><span class="token2">,</span> <span class="token4">'users.id'</span><span class="token2">,</span> <span class="token4">'='</span><span class="token2">,</span> <span class="token4">'contacts.user_id'</span><span class="token2">)</span> 內連接 <span class="token1">leftJoin</span><span class="token2">(</span><span class="token4">'posts'</span><span class="token2">,</span> <span class="token4">'users.id'</span><span class="token2">,</span> <span class="token4">'='</span><span class="token2">,</span> <span class="token4">'posts.user_id'</span><span class="token2">)</span> 左連接 <span class="token1">groupBy</span><span class="token2">(</span><span class="token4">'account_id'</span><span class="token2">)</span> 分組 <span class="token1">groupBy</span><span class="token2">(</span><span class="token4">'first_name'</span><span class="token2">,</span> <span class="token4">'status'</span><span class="token2">)</span> <span class="token1">having</span><span class="token2">(</span><span class="token4">'account_id'</span><span class="token2">,</span> <span class="token4">'>'</span><span class="token2">,</span> <span class="token3">100</span><span class="token2">)</span> 刷選 <span class="token1">take</span><span class="token2">(</span><span class="token3">5</span><span class="token2">)</span> 返回<span class="token3">5</span>條 <span class="token">-</span><span class="token">></span><span class="token1">offset</span><span class="token2">(</span><span class="token3">10</span><span class="token2">)</span> <span class="token">-</span><span class="token">></span><span class="token1">limit</span><span class="token2">(</span><span class="token3">5</span><span class="token2">)</span> 限制 <span class="token1">insert</span><span class="token2">(</span> <span class="token2">[</span><span class="token4">'email'</span> <span class="token">=</span><span class="token">></span> <span class="token4">'john@example.com'</span><span class="token2">,</span> <span class="token4">'votes'</span> <span class="token">=</span><span class="token">></span> <span class="token3">0</span><span class="token2">]</span><span class="token2">)</span><span class="token2">;</span> 插入 支持多條數據 $id<span class="token">=</span>DB<span class="token2">:</span><span class="token2">:</span><span class="token1">table</span><span class="token2">(</span><span class="token4">"users"</span><span class="token2">)</span><span class="token">-</span><span class="token">></span> <span class="token1">insertGetId</span><span class="token2">(</span> <span class="token2">[</span><span class="token4">'email'</span> <span class="token">=</span><span class="token">></span> <span class="token4">'john@example.com'</span><span class="token2">,</span> <span class="token4">'votes'</span> <span class="token">=</span><span class="token">></span> <span class="token3">0</span><span class="token2">]</span><span class="token2">)</span><span class="token2">;</span> 插入后返回id <span class="token1">update</span><span class="token2">(</span><span class="token2">[</span><span class="token4">'votes'</span> <span class="token">=</span><span class="token">></span> <span class="token3">1</span><span class="token2">]</span><span class="token2">)</span><span class="token2">;</span> 更新 <span class="token1">increment</span><span class="token2">(</span><span class="token4">'votes'</span><span class="token2">,</span> <span class="token3">5</span><span class="token2">)</span><span class="token2">;</span><span class="token1">decrement</span><span class="token2">(</span><span class="token4">'votes'</span><span class="token2">,</span> <span class="token3">5</span><span class="token2">)</span><span class="token2">;</span>自增自減 <span class="token1">increment</span><span class="token2">(</span><span class="token4">'votes'</span><span class="token2">,</span> <span class="token3">1</span><span class="token2">,</span> <span class="token2">[</span><span class="token4">'name'</span> <span class="token">=</span><span class="token">></span> <span class="token4">'John'</span><span class="token2">]</span><span class="token2">)</span><span class="token2">;</span> 支持其他字段更新 DB<span class="token2">:</span><span class="token2">:</span><span class="token1">table</span><span class="token2">(</span><span class="token4">'users'</span><span class="token2">)</span><span class="token">-</span><span class="token">></span><span class="token1">truncate</span><span class="token2">(</span><span class="token2">)</span><span class="token2">;</span> 清空表 DB<span class="token2">:</span><span class="token2">:</span><span class="token1">table</span><span class="token2">(</span><span class="token4">'users'</span><span class="token2">)</span><span class="token">-</span><span class="token">></span><span class="token1">where</span><span class="token2">(</span><span class="token4">'votes'</span><span class="token2">,</span> <span class="token4">'>'</span><span class="token2">,</span> <span class="token3">100</span><span class="token2">)</span><span class="token">-</span><span class="token">></span><span class="token1">delete</span><span class="token2">(</span><span class="token2">)</span><span class="token2">;</span> 刪除 $users <span class="token">=</span> DB<span class="token2">:</span><span class="token2">:</span><span class="token1">table</span><span class="token2">(</span><span class="token4">'users'</span><span class="token2">)</span><span class="token">-</span><span class="token">></span><span class="token1">paginate</span><span class="token2">(</span><span class="token3">15</span><span class="token2">)</span><span class="token2">;</span> 分頁 $users <span class="token">=</span> DB<span class="token2">:</span><span class="token2">:</span><span class="token1">table</span><span class="token2">(</span><span class="token4">'users'</span><span class="token2">)</span><span class="token">-</span><span class="token">></span><span class="token1">simplePaginate</span><span class="token2">(</span><span class="token3">15</span><span class="token2">)</span><span class="token2">;</span> 簡單分頁只有上一頁下一頁 $results<span class="token">-</span><span class="token">></span><span class="token1">total</span><span class="token2">(</span><span class="token2">)</span> 總頁數 <span class="token"><</span>div class<span class="token">=</span><span class="token4">"container"</span><span class="token">></span> @foreach <span class="token2">(</span>$users as $user<span class="token2">)</span> <span class="token2">{</span><span class="token2">{</span> $user<span class="token">-</span><span class="token">></span>name <span class="token2">}</span><span class="token2">}</span> @endforeach <span class="token"><</span><span class="token">/</span>div<span class="token">></span> <span class="token2">{</span><span class="token2">{</span> $users<span class="token">-</span><span class="token">></span><span class="token1">links</span><span class="token2">(</span><span class="token2">)</span> <span class="token2">}</span><span class="token2">}</span> ``` ``` - redis ``` <pre class="calibre16">``` use Illuminate\Support\Facades\Redis<span class="token2">;</span> Redis<span class="token2">:</span><span class="token2">:</span><span class="token1">get</span><span class="token2">(</span><span class="token4">'id'</span><span class="token2">)</span><span class="token2">;</span> Redis<span class="token2">:</span><span class="token2">:</span><span class="token1">set</span><span class="token2">(</span><span class="token4">'name'</span><span class="token2">,</span> <span class="token4">'Taylor'</span><span class="token2">)</span><span class="token2">;</span> Redis<span class="token2">:</span><span class="token2">:</span><span class="token1">command</span><span class="token2">(</span><span class="token4">'set'</span><span class="token2">,</span> <span class="token2">[</span><span class="token4">'name'</span><span class="token2">,</span><span class="token3">34</span><span class="token2">]</span><span class="token2">)</span><span class="token2">;</span> 支持所有原生 ``` ```
                  <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>

                              哎呀哎呀视频在线观看