PHP--TP架構----操作資料庫

標籤：

//操作資料庫

                   //$attr = $m->select(); //查詢所有資料

                   //$attr = $m->select("p001,p002,p003");

                   //$attr = $m->find("p001"); //找特定的資料根據主索引值找

                  

                   //where可以加查詢條件

                   //$attr = $m->where("code=‘p001‘ or sex=true")->select();

                  

                   //table可以切換要操作的表

                   //$attr = $m->table("Nation")->select();

                  

                   //alias可以設定表的別名

                   //$attr = $m->alias("人員")->select();

                  

                   //field可以指定查詢的欄位

                   //$attr = $m->field("code,name")->select();

                  

                   //order可以加排序條件

                   //$attr = $m->order("Nation desc")->select();

                  

                   //group可以分組

                   //$attr = $m->field("Nation")->group("Nation")->select();

                  

                   //having可以加分組後的條件

                   //$attr = $m->field("Nation")->group("Nation")->having("count(*)>5")->select();

                  

                   //join可以串連多個表，在field裡面要給欄位加別名

                   $attr = $m->field("Info.Code as 代號,Info.Name as 姓名,Sex as 性別,Nation.Name as 民族名稱")->join("Nation on Info.Nation = Nation.Code")->select();

                  

                  

                   var_dump($attr);

                  

                  

         }

 

PHP--TP架構----操作資料庫