ecshop删除商品及记录的函数

muban大师

   

/** * 从回收站删除多个商品 * @param mix $goods_id 商品id列表：可以逗号格开，也可以是数组 * @return void */ function delete_goods($goods_id) { if (empty($goods_id)) { return; } /* 取得有效商品id */ $sql = "SELECT DISTINCT goods_id FROM " . $GLOBALS['ecs',->table('goods') . " WHERE goods_id " . db_create_in($goods_id) . " AND is_delete = 1"; $goods_id = $GLOBALS['db',->getCol($sql); if (empty($goods_id)) { return; } /* 删除商品图片和轮播图片文件 */ $sql = "SELECT goods_thumb, goods_img] original_img " . "FROM " . $GLOBALS['ecs',->table('goods') . " WHERE goods_id " . db_create_in($goods_id); $res = $GLOBALS['db',->query($sql); while ($goods = $GLOBALS['db',->fetchRow($res)) { if (!empty($goods['goods_thumb',)) { @unlink('../' . $goods['goods_thumb',); // 节约空间 } if (!empty($goods['goods_img',)) { @unlink('../' . $goods['goods_img',); } if (!empty($goods['original_img',)) { @unlink('../' . $goods['original_img',); } } /* 删除商品 */ $sql = "DELETE FROM " . $GLOBALS['ecs',->table('goods...

   

内容已隐藏,请关注公众号输入验证码查看

               
验证码 

  

本帖支持关注公众号查看

【无套路  无套路  无套路 扫描二维码关注公众号发送【验证码】收到验证码 在上面输入点击提交查看即可显示隐藏内容】