thinkPHP的数据添加、修改、删除

数据添加

1、通过关联数组的方法添加

$data = array(
    "goods_name" => "手机",
    "goods_price" => 2121
);
//返回值，如果第一列为自动增长列，则返回编号，不是自动增长，成功了返回1，错误返回0
echo M("goods")->add($data);

2、通过AR(active record)方式来添加

$goods = M("goods");
$goods->goods_name = "电视";
$goods->goods_price = 12312;
//返回值，如果第一列为自动增长列，则返回编号，不是自动增长，成功了返回1，错误返回0
echo $goods->add();

数据修改

1、通过关联数组的方式

$data = array(
    "goods_name" => "手机2222",
    "goods_price" => 123,
    "goods_id" => 139
);
echo M("goods")->save($data);

2、通过AR的方式

$goods = M("goods");
$goods->goods_name = "电视2131231";
$goods->goods_price = 12312;
$goods->goods_id = 140;
echo $goods->save();

数据删除

1、参数为主键

M("goods")->delete(140); 

2、批量删除

M("goods")->delete("138, 139");

3、条件删除

（1）M("goods")->where("goods_name = "手机"")->delete();

（2）$model = M("goods");
$model->goods_name = "手机";
$model->delete();

直接执行sql语句

查询：

$list = M()->query("select * from goods");

增删改：

M()->execute("delete from goods where goods_id = 1");