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字段