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

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

jacklove

Release： 2023-04-01 18:52:02

Original

3323 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

## Articles you may be interested in:

ThinkPHP framework implements method example of exporting excel data

Native JS implements Ajax method example of interacting with PHP through POST php skills

Laravel integrated Geetest verification code method php example

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