THINK PHP增删改查数据操作笔记

THINK PHP增删改查

1、增

添加：

 db('address')->insert($data);//address是数据库名 $data是插入数据

//$data可以是 
$data=[
            'address_name' =>$param['address_name'],
            'address_area' =>$param['address_area'],
            'address_admin' =>$param['address_admin'],
            'admin_phone' =>$param['admin_phone']
       ];
// ''单引号里是数据库里对应的字段，>=后是插入数据

2、删

删除：

 $param=input('post.');//获取前端数据
 db('address')->where('address_id',$param['address_id'])->delete();

3、改

更新数据：

 db('addresss')->where('address_id',$param['address_id'])->update($data);
//根据id更新数据库 数据

4、查

模糊查询：

$param=input('post.');//获取前端传输数据
$select=$param['address_name'];//把前端传输数据 赋值给$select
db('address')->where('address_name|address_admin','like',"%{$select}%")->select();
//模糊 查询数据库中的address_name和address_admin字段