ThinkPhp学习_004模型

哆哆Excel

发布于 2022-10-25 14:18:45

1620

发布于 2022-10-25 14:18:45

文章被收录于专栏：哆哆Excel

ThinkPhp学习_004模型

一、建立模型数据库

二、建立模型模板

这个模型方法中可以什么也不写

三.建立模型控制器文件

这个文件中可以写代码对数据库进行操作

【练习代码如下】

<?php
namespaceapp\index\controller;
useapp\index\model\User as UserModel;
classUser
{
//
public function add()
{
         $user = new UserModel;
         $user->name = 'fs哆哆';
         $user->email = 'yg@qq.com';
         $user->birthday =strtotime('1976-3-27');
         if($user->save()){
                 return 'done';
         }else{
                 return 'no';
         }


}
public function addList()
{
         $user = new UserModel();
         $list = [
         ['name'=>'小龙女','email'=>'xlv@qq.com','birthday'=>strtotime('2019-2-1')],
         ['name'=>'黄蓉','email'=>'hr@qq.com','birthday'=>strtotime('2018-2-1')],
         ];
         if($user->saveAll($list)){
                 return '批量插入成功';                 
         }else{
                 return '失败';
         }
}
public function update()
{
         //更新数据方法一
         /*
         $user = UserModel::get(5);
         //dump($user);
         $user->name = '安迪';
         $user->email = 'ad@qq.com';
         if($user->save()){
                 return '更新成功';
         }else{
                 return 'no done';
         }
         */
         //更新方法二
         /*
         $user = new UserModel;
         $user->save( ['name' => '郭靖','email' => 'gj@qq.com'],['id' => 1]);
         */
         //批量更新
         $user = new UserModel;
         $list = [
                 ['id' => 1, 'name' => '令狐冲', 'email' => 'lyc@qq.com'],
                 ['id' => 2, 'name' => '岳不群', 'email' => 'ybq@qq.com'],
                 ['id' => 3, 'name' => '林平之', 'email' => 'lpz@qq.com'],
                 ['id'=> 4, 'name' => '岳灵珊', 'email' =>'yls@qq.com'],
                 ['id' => 5, 'name' => '仪琳', 'email' => 'yls@qq.com'],
                 ['id' => 6, 'name' => '田伯光', 'email' => 'tbg@qq.com'],
                 ['id' => 7, 'name' => '任我行', 'email' => 'rwx@qq.com'],
                 ['id' => 8, 'name' => '向问天', 'email' => 'xwt@qq.com'],
                 ['id' => 9, 'name' => '左冷禅', 'email' => 'zlc@qq.com']
         ];
         foreach($list as $data){
                 $user->data($data,true)->isUpdate(true)->save();
         }
        
}
}