* 創建視圖 | 傳入參 | 說明 | | --- | --- | | name | [ 必填 ] 視圖名稱 | | arr | [ 必填 ] 對應字段數組 ( 原字段 => 視圖字段 ) | | opt | [ 必填 ] 處理方式 ( 1 union all ) | | other | [ 選填 ] 設置數組 | | - echo | [ 選填 ] 只輸出語句( 1是 0否 ) | | 回調參 | 說明 | | --- | --- | | succeed | 執行狀態(1成功 0失敗) | | msg | 提示信息 | | yuju | 輸出語句 | | [ sql ] | echo啟用時直接輸出語句 | * 合并視圖案例 （ union all ） ~~~ $field = []; $obj = []; $obj['sm_id'] = 'sm_id'; $obj['account'] = 'account'; $field['sbh_manage'] = $obj; $obj = []; $obj['u_id'] = 'u_id'; $obj['account'] = 'account'; $field['user'] = $obj; $back = $D_P->view("view_name",$field,1); $back = $D_P->view("view_name",$field,1,['echo'=>1]); ~~~ * 關聯視圖案例 （ LEFT JOIN ） ~~~ $field = []; $obj = []; $obj['id'] = 'id'; $obj['field1'] = 'field1'; $field['table1'] = [$obj,'id']; $obj = []; $obj['field2'] = 'field2'; $field['upload_program_record'] = [$obj,'id']; $back = $D_P->view("view_name",$field,2); $back = $D_P->view("view_name",$field,2,['echo'=>1]); ~~~ > 注 ：字段名稱不能重復，可用每組1的值定義判斷字段名