* 單條數據獲取方式 | 傳入參 | 說明 | | --- | --- | | table | [ 必填 ] 表名 | | other | [ 選填 ] 設置數組 | | - field | [ 選填 ] 指定獲取字段名數組,特殊用法加\[\]改成數組<br>如 : [count(*) as total] | | - jointable | [ 選填 ] 兩表左聯接查詢右表名稱，必須與on同時填寫<br>如 user as u（u為user表的別稱） | | - on | [ 選填 ] 兩表左聯接查詢條件，必須與jointable同時填寫<br>如：u.u_id=w.u_id（u和w為兩表的別稱） | | - where | [ 選填 ] 判斷語句數組 | | - order | [ 選填 ] 排序語句 , 如 : "abc desc" | | - limit | [ 選填 ] 顯示區間語句 , 如 : "0,1" | | - double | [ 選填 ] 雙數據模式 (1開啟 0關閉) | | - echo | [ 選填 ] 只輸出語句( 1是 0否 ) | | 回調參 | 說明 | | --- | --- | | succeed | 執行狀態(1成功 0失敗) | | msg | 提示信息 | | [ arr ] | 數據數組鍵名 | | [ sql ] | Sql語句 | * 讀取單條數據 - 格式1 ~~~ $other = []; $other['where'] = ['字段名="'.搜索變量值.'"']; $row = $D_P->row($table,$other); ~~~ * 讀取單條數據 - 格式2 ~~~ $other = []; $other['field'] = ['搜索字段名1','搜索字段名2']; $other['where'] = ['字段名="'.搜索變量值.'"']; $row = $D_P->row($table,$other); ~~~ * 讀取單條數據 - 格式3 ~~~ $other = []; $field = []; $field[] = '搜索字段名1'; $field[] = '搜索字段名2'; $other['field'] = $field; $other['where'] = ['字段名="'.搜索變量值.'"']; $row = $D_P->row($table,$other); ~~~ * 讀取單條數據 - 格式4 ~~~ $other = []; $other['field'] = ['搜索字段名1','搜索字段名2']; $where = []; $where[] = '字段名="'.搜索變量值.'"'; $other['where'] = $where; $row = $D_P->row($table,$other); ~~~ * 讀取單條數據 - 格式5 ~~~ $other = []; $field = []; $field[] = '搜索字段名1'; $field[] = '搜索字段名2'; $other['field'] = $field; $where = []; $where[] = '字段名="'.搜索變量值.'"'; $other['where'] = $where; $row = $D_P->row($table,$other); ~~~ * 讀取單條數據 - 格式6 ~~~ $other = []; $field = []; $field[] = '搜索字段名1'; $field[] = '搜索字段名2'; $other['jointable'] = '表名 as 別稱'; $other['on'] = '兩表聯接查詢條件'; $other['field'] = $field; $where = []; $where[] = '字段名="'.搜索變量值.'"'; $other['where'] = $where; $row = $D_P->row('表名 as 別稱',$other); ~~~