thinkphp3.2教程-項(xiàng)目部署詳情

@author//應(yīng)用文//PHP die('requirePHP>5.3.0//false緩 設(shè) // ，放到應(yīng) 安全文件的生//define('DIR_SECURE_FILENAME'index.html');//default.htmldefine("DIR_SECURE_CONTENT","http:////引 文/require /命名空namespaceHome\Controller;useThink\Controller;//命名空間是當(dāng)前模塊名\Controlleruse是導(dǎo)入Think\Controller;IndexController//父類Controller名空間在Think,namespaceThink;classIndexControllerextendsController{publicfunction$this->show('<styletype="text/css">*{padding:0;margin:0;}div{padding:4px48px;}body{background:#fff;font-family:"微軟雅黑";color:#333;font-size:24px}h1{font-size:100px;font-weight:normal;margin-bottom:12px;}p{line-height:1.8em;font-size:36px}</style><divstyle="padding:24px48px;"><h1>:)</h1><p>歡迎使用<b> </b>！</p><br/>[您現(xiàn)在訪問(wèn)的是Home模塊的Index控制器 ]</div><scripttype="text/javascript" "charset="UTF-8"></script>','utf-8');}publicfunctiontest(){echo111;}}模塊/控制器/URL模URL模 URL_MODEL置普通模 PATHINFO REWRITE兼容模 Index.phphttpd.conf模mysql =>'mysql',//數(shù)據(jù)庫(kù)類型 =>'localhost',//服務(wù)器主機(jī)地址 =>'hgweibo',//數(shù)據(jù)庫(kù)名 =>'root',//用戶名 '1234' =>3306,//端口'DB_PREFIX'hg_',//PDO的方式來(lái)//PDO =>'pdo', =>'root', =>'1234','DB_PREFIX'=>'hg_', =>'mysql:host=localhost;dbname=hgweibo;charset=UTF-Model()usenamespaceHome\Model;useThink\Model;//classUserModelextends//定義表名,//protected$tablePrefix='top_';protectedpublicfunction}}實(shí)例化模型定義及查詢語(yǔ)DHome中尋找模型，然后在\Common\Model\userModel找publicfunctionechoMCURDD // }publicfunctionecho$user=new}$con=new//between查詢，范圍查詢，notbetween//$be['id']=array("between","1,3表示到//SELECT*FROM`hg_admin`WHERE(='zhuwei')OR(`upwd`='zhuwei'))//SELECT*FROM`hg_admin`WHERE((`id`='1')AND(`uname`='zhuwei'))//1//SELECT*FROM`hg_admin`WHERE((`id`>1)AND(`id`<3))//a //b請(qǐng)求字符串的查詢，類型于url//SELECT*FROM`hg_admin`WHERE((`id`>1)AND(`uname`='zhuwei313'AND`status`='1'))AND(`id`=2)//echo//echo$//echo$user->max("id");////echo$user->min("id");////echo$user->avg("id");//$res=$user->getByUname("zhuwei");////echo//aquery數(shù)//use//或者$r=new//$r=new//$r=new //bexecute用于更新和寫入數(shù)據(jù)的//$r=new uname='zhuwei313123'whereid=2");//echo$flag;//publicfunction//select()中放入條件也可以，不過(guò)這樣寫的方式////'order'=>'id////echo//1where//2order支持多個(gè)條件timedesc,id//3field返回指定字段的數(shù)據(jù)，用逗號(hào)隔開，第二 //4limit//5table//var_dump($user->table("USER")-//SELECT*FROMess,b.user")->table('ADMINASa,USERAS FROMhg_adminASa,hg_userASb//為了盡量避免和mysql的關(guān)鍵字，可以建議//6alias設(shè)置數(shù)據(jù)表的別名,設(shè)置當(dāng)前數(shù)據(jù)表的別名，主要用于其他的表連接使用leftjoin等//var_dump($user->alias("a")->join("INFOASbONa.id=b.uid")->select());//SELECT*FROMhg_adminaINNERJOINhg_infoASbONa.id=b.uid//7group用于結(jié)合合計(jì)函數(shù)，根據(jù)一個(gè)或多個(gè)列對(duì) `hg_admin`GROUPBY//8having配合group選 `hg_admin`GROUPBYidHAVING//9join//join('WORK artist.id WORK.artist_id','RIGHT')-//var_dump($user->alias("a")->join("INFObONa.id=b.uid","RIGHT")->select());//10聯(lián)合查詢 INFO")-//SELECT*FROM`hg_admin`UNIONselect*fromhg_info//11返回不重復(fù)的列distinct//12cache緩存，查詢緩存操作，在緩存期間內(nèi)不}在應(yīng)用開發(fā)過(guò)程中，使用最多的操作還是數(shù)據(jù)查詢操作，憑借的連命名范圍功能的優(yōu)勢(shì)在于可以一次定義多次調(diào)用，并且在項(xiàng)目中也能起到分工CURD理的規(guī)劃命名范圍即可namespaceuseclassUserModelextends//定義表名,protectedpublicfunction}*publicfunctionparent:://echo}protected'order'=>'iddesc',}publicfunction//$user=new實(shí)例化UserModel，然后調(diào)用命名范圍屬性//在定義名范圍屬性上附加條件,增加額外的整iddesc'))->select();}1根據(jù)表單的數(shù)據(jù)，創(chuàng)建數(shù)//var_dump($user-//2以對(duì)象數(shù)組的形式創(chuàng)建數(shù)protected$insertFields="uname";protected當(dāng)創(chuàng)建數(shù)據(jù)時(shí)候就創(chuàng)建模型中指定的字//1根據(jù)表單創(chuàng)建數(shù)////實(shí)例化模//var_dump($user-//2以對(duì)象數(shù)組的形式創(chuàng)建數(shù)//跟新數(shù)//寫入數(shù)//使用自動(dòng)創(chuàng)建來(lái)保存數(shù)//$user->add($user-//echo插入成功//data($where);接收一個(gè)數(shù)組變//修改,刪獲取ID為3的用戶的昵//滿足條件的數(shù)據(jù)表中的該字段的第一行的值可以做多行，每一行字段的值為下標(biāo)的一個(gè)數(shù)//條件中有多個(gè)字段用逗號(hào)隔刪publicfunction//1根據(jù)主鍵來(lái)刪除記$user->delete(2);//刪除主鍵為2的記}詳細(xì)方法看手AR模實(shí)現(xiàn)了A