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