Laravel framework implements an example of adding, deleting, modifying, and checking (CURD) operations in the model layer-PHP Tutorial-php.cn

Laravel framework implements an example of adding, deleting, modifying, and checking (CURD) operations in the model layer

不言

Release： 2023-03-28 20:16:02

Original

1638 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, thank you for reading. Please pay attention to the PHP Chinese website for more information!

Related recommendations:

Laravel framework implements search function code analysis

##Laravel framework implements redis cluster detailed explanation

The above is the detailed content of Laravel framework implements an example of adding, deleting, modifying, and checking (CURD) operations in the model layer. For more information, please follow other related articles on the PHP Chinese website!