-
- 慕勒1569968 2020-02-29
// model 直接使用
// dump(Name::get(11)->toArray());
// 实例化操作
// $res = new Name;
// dump($res::get(11)->toArray());
// Loader查询
// dump(Loader::model("Name")::get(11)->toArray());
// 助手函数model
// dump(model("Name")::get(11)->toArray());
// ::get(function($query){});
// $res = Name::get(function($query){ //返回一条信息
// $query->where(['money'=>['EGT',5000]]);
// })->toArray();;
// $res = Name::where("id",11)->field("id,name")->find()->toArray();
// $res = Name::all(function($query){ // return $res ;
// $query->where(["money"=>['>=',5000]])->field("name");
// });
// $res = Name::column("name"); //查询单独一列
// 添加数据
// $res = Name::create(["name"=>"小猛","age"=>"22"]); // return $res ;
// $res = Name::create(["name"=>"小贺","age"=>"22","money"=>70000,"else"=>true],true); // return $res ;
//实例化模型添加数据 save 返回影响行数
// $name = new Name;
// $name->name = "小晨";
// $name->age = 78;
// $name->money = 980;
// $res = $name->save();
// saveAll增加数据
// $name = new Name;
// $res = $name->saveAll([
// ["name"=>"小煜","age"=>"88","money"=>800000],
// ["name"=>"小飞","age"=>"68","money"=>300000]
// ]);
// save过滤不存在的字段
// $name = new Name;
// $res = $name->allowField(true)->save(["name"=>"小熙","age"=>"35","money"=>300000,"dieday"=>35]);
// save只添加姓名和年龄字段 //返回影响行数
// $name = new Name;
// $res = $name->allowField(["name","age"])->save(["name"=>"小宋","age"=>"15","money"=>300000,"dieday"=>35]);
- 0赞 · 0采集
-
- 斯巴达汉子 2019-07-01
实例化model 后, 调用继承的底层model 中的方法,实现常规操作
-
截图0赞 · 0采集
-
- 欧文先森 2019-04-28
数据库表的选择：
public function index(){
$db= DB::name('user1');
$res = $db->find(6);
dump($res);
- 0赞 · 0采集
-
- 欧文先森 2019-04-26
使用User::get(function($query)){$query->where()->field()}查询
User::where()->field()->find()查询某一条 返回对象
User::all(function($query){}获取多条记录，使用主键 返回对象
User::where()->field()->limit()->order()->select();多条查询 返回对象
User::where()->value()按字段查询一条 返回的是数组
User::where()->column("email","username")以username为键的数组
$res = User::get(6);
$res = User::where("id",5)
->field("id,username")
->find();
$res= $res->toArray();
$res=User::all(function($query){
$query->where("id","<",6)
->field("id,password");
});
$res = User::where("id","<","6")
->field("id,username")
->limit(5)
->order("id DESC")
->select();
foreach($res as $val){
dump($val->toArray());
}
$res = User::where("id",6)->value('username');
$res = User::column("name","id");
dump($res);
}
}
- 0赞 · 2采集
-
- 慕无忌2480762 2019-04-10
使用User::get(function($query)){$query->where()->field()}查询
User::where()->field()->find()查询某一条 返回对象
User::all(function($query){}获取多条记录，使用主键 返回对象
User::where()->field()->limit()->order()->select();多条查询 返回对象
User::where()->value()按字段查询一条 返回的是数组
User::where()->column("email","username")以username为键的数组
代码：
<?phpnamespaceapp\index\controller;usethink\Controller;useapp\index\controller\User;classindexextendsController{$res= User::get(function($query){$query->where("username","eq","zhangsan")->filed("username,email");});$res= User::where("id",12)->field("id,username")->find();$res= User::all(function($query){$query->where("id","<","15")->select();});$res= User::where('id','>',"15")->field("username,email")->limit(3)->order('id DESC')->select();foreach($resas$val){$res->toArray();dump($val->toArray());}$res= User::value('email');$res= User::where('id','10')->value('email');$res= User::column("email","username");dump($res);}- 0赞 · 0采集
-
- Rody杰 2019-02-25
使用User::get(function($query)){$query->where()->field()}查询
User::where()->field()->find()查询某一条 返回对象
User::all(function($query){}获取多条记录，使用主键 返回对象
User::where()->field()->limit()->order()->select();多条查询 返回对象
User::where()->value()按字段查询一条 返回的是数组
User::where()->column("email","username")以username为键的数组
- 0赞 · 0采集
-
- 慕桂英9369572 2019-01-17
User::column
得到的是一个数组，这里就会显示所有的邮箱
-
截图0赞 · 0采集
-
- 慕桂英9369572 2019-01-17
User->value
-
截图0赞 · 0采集
-
- 慕桂英9369572 2019-01-17
where->select的方法
-
截图0赞 · 0采集
-
- 慕桂英9369572 2019-01-17
all里面也可以放一个闭包函数
-
截图0赞 · 0采集
-
- 慕桂英9369572 2019-01-17
User：：all
然后用遍历
-
截图0赞 · 0采集
-
- 慕桂英9369572 2019-01-17
直接用where->find的链式方法来获取
-
截图0赞 · 0采集
-
- 慕桂英9369572 2019-01-17
User：：get（）这里可以传入一个主键或者一个闭包函数来构造一个where条件
-
截图0赞 · 0采集
-
- 慕桂英9369572 2019-01-17
model下的User.php只定义了Model
-
截图0赞 · 0采集
-
- Atlas_Wu 2018-11-15
每一个模型文件都对应数据库中的一张表
- 0赞 · 0采集
-
- GYNexus 2018-11-05
Model->get 返回对象 用toarray 获取信息
-
截图0赞 · 0采集
-
- GYNexus 2018-11-05
使用模型查询数据；#通过get方式获取数据，括号内可以为主键，也可以为闭包函数
// $res = User::get(function($query){
// $query->where("username","eq","wenco_3")
// ->field("email");
// });
// $res = User::where("id","<=",15)
// ->field("id,username")
// ->limit(19)
// ->order("id" ,"DESC")
// ->select();
- 0赞 · 0采集
-
- technoart 2018-10-29
<?php namespace app\index\controller; use think\Controller; use app\index\controller\User; class index extends Controller{ $res = User::get(function($query){ $query->where("username","eq","zhangsan") ->filed("username,email"); }); $res = User::where("id",12) ->field("id,username") find(); $res = User::all(function($query){ $query->where("id","<","15") ->select(); }); $res = User::where('id','>',"15") ->field("username,email") ->limit(3) ->order('id DESC') ->select(); foreach($res as $val){ $res->toArray(); dump($val->toArray()); } $res = User::value('email'); $res = User::where('id','10')->value('email'); $res = User::column("email","username"); dump($res); }-
截图0赞 · 0采集
-
- 慕仰5501357 2018-08-30
- Model->get 返回对象 用toarray 获取信息
-
截图0赞 · 0采集
-
- qq_光亮_1 2018-06-12
通过value也可以取值
-
截图0赞 · 1采集
-
- qq_光亮_1 2018-06-12
#user::all()
// $res = User::all(function($query){
// $query->where("id","<","5")
// ->field("id","username");
// });
#column()第二个参数为新生成的数组的下标
$res = User::column("email","username");
// foreach($res as $val){
// dump($val->toArray());
// }
//$res = $res->toArray();//将结果转换成数组
dump($res);
-
截图1赞 · 1采集
-
- qq_光亮_1 2018-06-12
使用模型查询数据；#通过get方式获取数据，括号内可以为主键，也可以为闭包函数
// $res = User::get(function($query){
// $query->where("username","eq","wenco_3")
// ->field("email");
// });
// $res = User::where("id","<=",15)
// ->field("id,username")
// ->limit(19)
// ->order("id" ,"DESC")
// ->select();
-
截图0赞 · 2采集
-
- 山水郎2015 2018-05-16
- 使用模型查询
-
截图0赞 · 0采集
-
- 菜鸟Wenco 2018-05-07
模型获取数据库数据：
<?php namespace app\index\controller; use think\controller; use app\index\model\User; class Index { public function index(){ #通过get方式获取数据，括号内可以为主键，也可以为闭包函数 // $res = User::get(function($query){ // $query->where("username","eq","wenco_3") // ->field("email"); // }); // $res = User::where("id","<=",15) // ->field("id,username") // ->limit(19) // ->order("id" ,"DESC") // ->select(); #user::all() // $res = User::all(function($query){ // $query->where("id","<","5") // ->field("id","username"); // }); #column()第二个参数为新生成的数组的下标 $res = User::column("email","username"); // foreach($res as $val){ // dump($val->toArray()); // } //$res = $res->toArray();//将结果转换成数组 dump($res); } }- 0赞 · 0采集
-
- 慕姐6134327 2017-12-19
- // $res = new Admin(); // $res = $res::get(2); // $res = $res->toArray(); // $admin = Loader::model("Admin"); // $res = $admin::get(4); $admin = model("Admin"); $res = $admin::get(7); $res = $res->toArray(); dump($res);
- 0赞 · 0采集
-
- qq_Soulmate_8 2017-11-15
- $res = User::get(function($query){ $query->where("username", "eq","imooc_10") -> field("username, email"); }); // $res = User::where("id", 10) // -> field("id, username") // ->find(); // $res = User::all(function($query){ // $query->where("id", "<", 5) // ->field("id, email"); // }); // $res = User::where("id", ">", "15") // -> field("username, email") // -> limit(3) // -> order("id DESC") // -> select(); // foreach($res as $val) { //$res = $res->toArray(); // dump($val->toArray()); // } // $res = User::where("id", 10)->value('email'); //$res = User::column("email", "username"); dump($res); //dump($res->username); // dump($res);
- 0赞 · 1采集
-
- 慕函数8696247 2017-09-06
- 模型类查询数据的方式跟Db的类似
-
截图0赞 · 0采集
-
- 慕粉1653028732 2017-08-28
- 数据库应用 模型查询2
-
截图0赞 · 1采集
-
- 慕粉1653028732 2017-08-28
- 数据库应用 模型查询1
-
截图0赞 · 1采集
