cakephp 中对于数据库的增删查改操作

最新推荐文章于 2020-11-05 08:28:10 发布

凭江仙

最新推荐文章于 2020-11-05 08:28:10 发布

阅读量3.1k

点赞数

分类专栏：网站文章标签： cakephp 数据库增删查改

本文链接：https://blog.csdn.net/gaixm/article/details/50279215

版权

网站专栏收录该内容

7 篇文章 0 订阅

订阅专栏

查找：

$user_id=$this->request->session()->read('User.id');
        $query = $this->Devicesdatas
    		      ->find()
    		      ->where(['user_id' => $user_id]);
        
    	$this->paginate = [
    		      		        'contain' => ['Users','Devices'],
    		      		        'limit' => 10
    		                ];
        $this->set('devicesdatas', $this->paginate($query));
        $this->set('_serialize', ['devicesdatas']);

增加：

$devicesdata = $this->Devicesdatas->newEntity();
        if ($this->request->is('post')) {
            $devicesdata = $this->Devicesdatas->patchEntity($devicesdata, $this->request->data);
            if ($this->Devicesdatas->save($devicesdata)) {
                $this->Flash->success(__('The devicesdata has been saved.'));
                return $this->redirect(['action' => 'index']);
            } else {
                $this->Flash->error(__('The devicesdata could not be saved. Please, try again.'));
            }
        }
        $users = $this->Devicesdatas->Users->find('list', ['limit' => 200]);
        $phones = $this->Devicesdatas->Phones->find('list', ['limit' => 200]);
        $devices = $this->Devicesdatas->Devices->find('list', ['limit' => 200]);
        $this->set(compact('devicesdata', 'users', 'phones', 'devices'));
        $this->set('_serialize', ['devicesdata']);

修改：

$query = $this->Devicesdatas
    			->find()
    			->order(['created' => 'DESC'])
    			->limit(1);
    			//execute query;
    			$results=$query->all();
    			foreach ($results as $result){
    				$result->img_url=$img_url;
    				if($this->Devicesdatas->save($result))
    					echo 'success';
    			}

删除：

public function delete($id = null)
    {
        $this->request->allowMethod(['post', 'delete']);
        $devicesdata = $this->Devicesdatas->get($id);
        if ($this->Devicesdatas->delete($devicesdata)) {
            $this->Flash->success(__('The devicesdata has been deleted.'));
        } else {
            $this->Flash->error(__('The devicesdata could not be deleted. Please, try again.'));
        }
        return $this->redirect(['action' => 'index']);
    }