How the Laravel framework implements CURD operations at the model layer-PHP Tutorial-php.cn

How the Laravel framework implements CURD operations at the model layer

不言

Release： 2023-04-01 06:52:01

Original

1707 people have browsed it

This article mainly introduces the Laravel framework to implement the addition, deletion, modification and query (CURD) operation of the model layer. It analyzes the specific implementation techniques of the Laravel framework model model layer to perform the addition, deletion, modification and query operation of the database in the form of examples. Friends in need can refer to the following

The example of this article describes the Laravel framework's implementation of the add, delete, modify, and query (CURD) operation of the model layer. Share it with everyone for your reference, the details are as follows:

protected $table = &#39;user_city&#39;;
public $timestamps = false;
//添加 返回id
public function cityadd($data)
{
    return $this->insertGetId($data);
}
//单条查找
public function getfind($id)
{
    if($this->where(&#39;id&#39;,$id)->first()){
      return $this->where(&#39;id&#39;,$id)->first()->toArray();
    }else{
      return [];
    }
}
//查询用户有几个uid,返回数量
public function countCity($uid){
    if($this->where(&#39;uid&#39;,$uid)->first()){
      return $this->where(&#39;uid&#39;,$uid)->count();
    }else{
      return [];
    }
}
//查询全部数据
public function getAll()
{
    return $this->get()->toArray();
}
/**
* 修改管理员信息
* @param $id
* @param $data
* @return bool
*/
public function upAdmin($id,$data)
{
    if($this->find($id)){
      return $this->where(&#39;id&#39;,$id)->update($data);
    }else{
      return false;
    }
}
//加条件，时间
//查询用户的认购的城数
public function buy_num($uid){
    $startDate = date(&#39;Y-m-01&#39;, strtotime(date("Y-m-d")));
    $endDate = date(&#39;Y-m-d&#39;, strtotime("$startDate +1 month -1 day"));
    // 将日期转换为Unix时间戳
    $endDate=$endDate." 22:59:59";
    $startDateStr = strtotime($startDate);
    $endtDateStr = strtotime($endDate);
    return $this->where(&#39;uid&#39;,$uid)->where(&#39;buy_type&#39;,1)->whereBetween(&#39;create_time&#39;, array($startDateStr,$endtDateStr))->sum(&#39;buy_num&#39;);
}
/**
* 根据id查找城池信息 只返回某个字段的值
* @param $id
* @return array
*/
public function getCityName($id)
{
    if($this->where(&#39;city_id&#39;,$id)->first()){
      return $this->where(&#39;city_id&#39;,$id)->lists(&#39;city_name&#39;)[0];
    }else{
      return [];
    }
}

Copy after login

The above is the entire content of this article, I hope it will be helpful to everyone’s study , please pay attention to the PHP Chinese website for more related content!

Related recommendations:

Analysis of subviews and form reuse of Laravel5 framework

About Laravel framework database CURD operation and parsing of coherent operations

The above is the detailed content of How the Laravel framework implements CURD operations at the model layer. For more information, please follow other related articles on the PHP Chinese website!