Thinkphp3.2 增删改查

发布时间：2020-07-24 20:37:05 来源：网络阅读：626 作者：Jinl_bm 栏目：web开发

调用model

D('ModelName')->insert($url, $short, $status, $create_time);

增:

$db = M('Url');

$filed = array(

'url' => $url.$i,

'short' => $short.$i,

'status' => $status,

'create_time' => $create_time

);

$status = $db->add($filed);

查:

$where = "status=%d";

$data = M('Url')->where($where, array(1))->field('id uid, url curl')->select();

这种写法是绑定参数的写法

改:

$where['id'] = array(13,14);

$field['url'] = "http://cribn.org";

$field['short'] = "http://cribn.org";

$status = M('Url')->where($where)->save($field);

Sql:UPDATE `url` SET `url`='http://cribn.org',`short`='http://cribn.org' WHERE ( (`id` = 13) AND (`id` = 14) );

删:

$where['id'] = 74;

$status = M('Url')->where($where)->delete();

M():实例化当前组下边的model

D():如果当前组下不存在model会去其他组里边实例化

find():查询一条记录

select():查询多条记录

where():条件可以是字符串或是数组

field():要查询的字段

Thinkphp3.2开发手册:http://document.thinkphp.cn/manual_3_2.html#delete_data

向AI问一下细节

猜你喜欢