# 第四課數據庫操作 ### 常用表說明 ``` <pre class="calibre14">``` ims_mc_mapping_fans 粉絲表 ims_mc_members 會員表 ``` ``` ### 數據庫操作函數 ``` <pre class="calibre16">``` 表名 <span class="token1">tablename</span><span class="token2">(</span><span class="token4">'mc_members'</span><span class="token2">)</span> 查詢一條數據 <span class="token1">pdo_get</span><span class="token2">(</span><span class="token4">'yoby_demo'</span><span class="token2">,</span><span class="token2">[</span><span class="token4">'id'</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">pdo_get</span><span class="token2">(</span><span class="token4">'yoby_demo'</span><span class="token2">,</span><span class="token2">[</span><span class="token4">'id'</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="token4">'title'</span><span class="token2">,</span><span class="token4">'num'</span><span class="token2">]</span><span class="token2">)</span><span class="token2">;</span>返回特定字段 <span class="token1">pdo_get</span><span class="token2">(</span><span class="token4">'yoby_demo'</span><span class="token2">,</span><span class="token2">[</span><span class="token2">]</span><span class="token2">,</span><span class="token2">[</span><span class="token4">'count(*) as z'</span><span class="token2">,</span><span class="token4">'title'</span><span class="token2">,</span><span class="token4">'num'</span><span class="token2">,</span><span class="token4">'max(num)'</span><span class="token2">]</span><span class="token2">)</span><span class="token2">;</span> <span class="token1">pdo_fetch</span><span class="token2">(</span><span class="token4">"SELECT username, uid FROM "</span><span class="token2">.</span><span class="token1">tablename</span><span class="token2">(</span><span class="token4">'users'</span><span class="token2">)</span><span class="token2">.</span><span class="token4">" WHERE uid = :uid LIMIT 1"</span><span class="token2">,</span> <span class="token1">array</span><span class="token2">(</span><span class="token4">':uid'</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">pdo_getcolumn</span><span class="token2">(</span><span class="token4">'yoby_demo'</span><span class="token2">,</span><span class="token2">[</span><span class="token4">'id'</span><span class="token">=</span><span class="token">></span><span class="token3">1</span><span class="token2">]</span><span class="token2">,</span><span class="token4">'title'</span><span class="token2">)</span><span class="token2">;</span> <span class="token1">pdo_fetchcolumn</span><span class="token2">(</span><span class="token4">"SELECT COUNT(*) FROM "</span><span class="token2">.</span><span class="token1">tablename</span><span class="token2">(</span><span class="token4">'users'</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>主鍵<span class="token2">,</span>排序<span class="token2">,</span>限制條數 <span class="token1">pdo_getall</span><span class="token2">(</span><span class="token4">'yoby_demo'</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><span class="token2">,</span><span class="token4">''</span><span class="token2">,</span><span class="token4">'id desc'</span><span class="token2">,</span><span class="token4">'.($pindex-1)* $psize.'</span><span class="token2">,</span>'<span class="token2">.</span>$psize<span class="token2">)</span><span class="token2">;</span> <span class="token1">pdo_fetchall</span><span class="token2">(</span><span class="token4">"SELECT username, uid FROM "</span><span class="token2">.</span><span class="token1">tablename</span><span class="token2">(</span><span class="token4">'users'</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> 插入數據<span class="token2">,</span>第二個參數數組 <span class="token1">pdo_insert</span><span class="token2">(</span><span class="token4">'yoby_demo'</span><span class="token2">,</span><span class="token2">[</span><span class="token2">]</span><span class="token2">)</span><span class="token2">;</span> $id <span class="token">=</span> <span class="token1">pdo_insertid</span><span class="token2">(</span><span class="token2">)</span><span class="token2">;</span>插入id 修改 <span class="token1">pdo_update</span><span class="token2">(</span><span class="token4">'yoby_demo'</span><span class="token2">,</span><span class="token2">[</span><span class="token4">'num +='</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="token4">'id'</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">pdo_delete</span><span class="token2">(</span><span class="token4">'yoby_demo'</span><span class="token2">,</span><span class="token2">[</span><span class="token4">'id'</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">pdo_delete</span><span class="token2">(</span>$this<span class="token">-</span><span class="token">></span>table_reply<span class="token2">,</span> <span class="token4">"id IN ('"</span><span class="token2">.</span><span class="token1">implode</span><span class="token2">(</span><span class="token4">"','"</span><span class="token2">,</span> $deleteid<span class="token2">)</span><span class="token2">.</span><span class="token4">"')"</span><span class="token2">)</span><span class="token2">;</span> 執行sql <span class="token1">pdo_query</span><span class="token2">(</span><span class="token4">"DELETE FROM "</span><span class="token2">.</span><span class="token1">tablename</span><span class="token2">(</span><span class="token4">'users'</span><span class="token2">)</span><span class="token2">.</span><span class="token4">" WHERE uid = :uid"</span><span class="token2">,</span> <span class="token1">array</span><span class="token2">(</span><span class="token4">':uid'</span> <span class="token">=</span><span class="token">></span> <span class="token3">2</span><span class="token2">)</span><span class="token2">)</span><span class="token2">;</span> 支持多條sql用分號隔開 <span class="token1">pdo_run</span><span class="token2">(</span>$sql<span class="token2">)</span><span class="token2">;</span> 顯示調試語句 <span class="token1">pdo_debug</span><span class="token2">(</span><span class="token2">)</span><span class="token2">;</span> 檢測某個字段是否存在 <span class="token1">pdo_fieldexists</span><span class="token2">(</span><span class="token4">'shopping_goods'</span><span class="token2">,</span> <span class="token4">'credit'</span><span class="token2">)</span><span class="token2">;</span> 檢測某個表是否存在 <span class="token1">pdo_tableexists</span><span class="token2">(</span>$tablename<span class="token2">)</span> 檢測表是否為空 <span class="token1">pdo_exists</span><span class="token2">(</span>$tb<span class="token2">)</span> 獲取數據條數 <span class="token1">pdo_count</span><span class="token2">(</span>$tb<span class="token2">,</span><span class="token2">[</span><span class="token4">'id'</span><span class="token">=</span><span class="token">></span><span class="token3">1</span><span class="token2">]</span><span class="token2">)</span> ``` ```