zencart 批量删除无图片产品优化网站

LINZHENYU1996

于 2017-09-14 20:26:16 发布

阅读量710

点赞数

分类专栏： php zencart

本文链接：https://blog.csdn.net/LINZHENYU1996/article/details/77984846

版权

php 同时被 2 个专栏收录

7 篇文章 0 订阅

订阅专栏

zencart

2 篇文章 0 订阅

订阅专栏

<?php 
require('includes/application_top.php'); 
$listing_sql = "select * from " .TABLE_PRODUCTS. " "; 
$listing = $db->Execute($listing_sql); 
while (!$listing->EOF)
{ 
if(!file_exists("images/" . $listing->fields['products_image'])) //判断图片是否存在 
{ 
$id= $listing->fields['products_id']; 
if ($id!="") 
{ 
//删除数据库里该产品的数据
$p_sql = "DELETE FROM " .TABLE_PRODUCTS ." WHERE products_id = '".$id."'" ; 
$d_sql = "DELETE FROM " .TABLE_PRODUCTS_DESCRIPTION ." WHERE products_id = '".$id."'" ; 
$c_sql = "DELETE FROM " .TABLE_PRODUCTS_TO_CATEGORIES ." WHERE products_id= '".$id."'" ; 
$a_sql = "DELETE FROM " .TABLE_PRODUCTS_ATTRIBUTES ." WHERE products_id = '".$id."'" ; 
$db->Execute($p_sql); 
$db->Execute($d_sql); 
$db->Execute($c_sql); 
$db->Execute($a_sql); 
echo "DELETE ID $id Product OK"."<br />\r\n"; 
} 
} 
$listing->MoveNext(); 
} 
?>