# 數據庫
- 數據庫操作
```
<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> 支持所有原生
```
```
- 簡介
- 第一章 數據庫
- Mysql/mariadb
- 函數
- 基礎
- 增刪改索引
- 標準查詢
- 高級查詢
- TIDB集群mysql解決方案
- Redis
- 語言基礎
- 5種數據類型
- 其他類型
- Sqlite
- 語言基礎
- 常用查詢
- 第二章 PHP
- 語言基礎
- 第一課 流程控制和運算
- 第二課 數組
- 第三課 日期時間
- 第四課 常用函數
- 第五課 字符串
- 第六課 文件操作
- 第七課 面向對象
- 第八課 正則表達式
- 第九課 圖片處理生成
- 第十課 curl/memche
- 第十一課 mysql和pdo
- 第十三課 cookie和session
- 第十四課 xml操作
- 第十五課 php5.3+新特性
- 第十六課 php7+
- 第十七課 密碼安全
- 廢棄函數
- php命令行
- redis應用
- 算法
- 排序算法
- 基礎算法
- 無限級分類
- 自定義函數Fn
- 查找算法
- 自定義函數數據函數fn
- laravel
- 路由
- 常用語句
- 數據庫
- dingo/api
- Yii2
- 控制器
- 常用類
- 數據庫
- redis
- thinkphp6
- TP6文檔
- TP6插件
- dedecms
- 織夢標簽大全
- 數據庫操作
- 內置函數和定義函數
- 織夢核心改動
- 織夢插件/底層標簽開發
- PHP相關工具
- composer
- php開發環境phpenv
- Phpstorm使用
- windows編譯php擴展
- PHP開源庫
- 開源項目管理禪道
- sns_auth
- php-casbin權限控制
- php-jwt
- 微信SDKeasywechat
- querylist采集庫
- workerman
- Box/Spout處理excel和csv
- dll擴展
- redis/memche/xdebug
- redis
- Lua
- php_xlswriter
- event
- swoole
- 常用代碼庫
- 微擎框架
- 第一課全局變量
- 第二課常用函數
- 第三課自定義微擎獨有函數
- 第四課數據庫操作
- 第五課微信端回復
- 第六課微擎高級操作
- 第八課global函數列表
- mainfest.xml詳解
- js方法
- 人人商城
- 第一課model解讀
- 第二課常用語句解讀
- 第三課常用js解讀
- 第四課附錄常見問題
- 第五課附錄處理報表|支付
- 常用JSON狀態碼
- 第三章 JavaScript
- js基礎
- 瀏覽器對象
- 語言基礎
- html5接口
- ES6新語法
- vue
- 基礎語法
- 京東vueUI組件
- uniapp
- 組件開發規范
- nodejs
- 基礎知識
- 安裝node
- nvm不同版本node切換
- js常用標準庫
- zepto/jquery
- weui
- js圖標庫
- elementUI
- validator表單驗證
- layer彈出層
- requirejs
- wow動畫
- 動畫animate
- swiper4
- 百度編輯器
- flyio/axios/qs
- jquery.form
- bootstrap3
- clipboard復制
- slideout側滑
- imagehover.css圖片懸停動畫
- webpack打包
- Bulma UI框架
- store 客戶端存儲
- lottie動畫創建庫
- sweetalert
- js自定義函數
- 常見JSSDK
- 微信公眾號JSSDK
- 騰訊地圖jssdk
- 微信小程序
- 第四章 編程語言
- markdown語言
- Dart語言
- Dart語言基礎
- Flutter框架
- Lua語言
- 字符串,數組,表
- 自定義方法
- go語言
- 第1.1語言基本語法
- 第1.2流程控制
- 第1.3函數
- 第1.4結構體
- 第1.5接口
- 第1.6包
- go語言框架Gin
- CSS3語言
- CSS與CSS3
- 選擇符
- 屬性
- css3
- loading動畫
- HTML5語言
- less
- sass
- C#
- 基礎知識
- 函數
- 第五章 開發工具
- git
- nginx/apache服務器
- Linux常用操作
- crontab定時任務
- 注冊表與cmd
- 阿里云ECS
- frp穿透和ssl續期
- 寶塔安裝
- 樹莓派
- 瀏覽器模擬
- 火狐/chrome常用插件
- WSL安裝使用
- mac brew和終端命令
- win10相關