class DbTest
{
public function demo1()
{
//原生查詢的讀操作query()
$sql=“SELECT user_id,name,age,email FROM user WHERE age>:age LIMIT :num”;
$map=array(“age”=>20,‘num’=>3);
a=Db::query(a=Db::query(a=Db::query(sql,map);dump(map);
dump(map);dump(a);
}
public function demo2()
{
//原生查詢的寫操作execute()
$sql=“UPDATE user SET age=:age WHERE user_id=:id”;
$map=array(“age”=>20,‘id’=>3);
a=Db::execute(a=Db::execute(a=Db::execute(sql,map);return′成功更新了′.map);
return '成功更新了'.map);return′成功更新了′.a.‘條數(shù)據(jù)！’;
}
//查詢構(gòu)造器
//table()設(shè)置數(shù)據(jù)表
//field()設(shè)置查詢字段列表
//select()返回滿足條件的多條記錄
//find()返回滿足條件的第一條參數(shù)
public function demo3()
{
res=Db::table(′user′)?>field("userid,name,age")?>find(2);dump(res=Db::table('user')
->field("user_id,name,age")
->find(2);
dump(res=Db::table(′user′)?>field("userid,name,age")?>find(2);dump(res);
}
//where()設(shè)置查詢條件，參數(shù)包括字符串，表達(dá)式，數(shù)組
//fetchsql():true,false
public function demo4()
{
res=Db::table(′user′)?>field("userid,name,age")//?>where(′userid=3′)字符串//?>where(′userid′,′=′,′1′)表達(dá)式//?>where(′age′,′>′,′20′)//?>where(′age′,′between′,[20,30])區(qū)間查詢//?>where([′userid′=>2,′age′=>20])數(shù)組查詢?>where([[′age′,′between′,[20,30]]])//索引數(shù)組查詢?>select();dump(res=Db::table('user')
->field("user_id,name,age")
//->where('user_id=3')字符串
//->where('user_id','=','1')表達(dá)式
//->where('age','>','20')
//->where('age','between',[20,30])區(qū)間查詢
//->where(['user_id'=>2,'age'=>20])數(shù)組查詢
->where([['age','between',[20,30]]])//索引數(shù)組查詢
->select();
dump(res=Db::table(′user′)?>field("userid,name,age")//?>where(′userid=3′)字符串//?>where(′userid′,′=′,′1′)表達(dá)式//?>where(′age′,′>′,′20′)//?>where(′age′,′between′,[20,30])區(qū)間查詢//?>where([′userid′=>2,′age′=>20])數(shù)組查詢?>where([[′age′,′between′,[20,30]]])//索引數(shù)組查詢?>select();dump(res);
}?>
比起以往版本這個(gè)無需設(shè)置路由，數(shù)據(jù)庫也有原生文檔Env可以修改，想要添加新文檔首先在config/app.php里面將應(yīng)用變量指向你的新文檔然后打開瀏覽器輸入：
服務(wù)器名/類名/函數(shù)名/
即可訪問了
更多關(guān)于云服務(wù)器，域名注冊(cè)，虛擬主機(jī)的問題，請(qǐng)?jiān)L問西部數(shù)碼官網(wǎng)：m.ps-sw.cn
