首页 > 代码库 > zencart批量删除无图片产品

zencart批量删除无图片产品

zencart批量删除无图片产品,将以下代码保存为remove_products.php,放到网站根目录运行即可,操作前请先备份数据库。

<?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 "DEL ID $id  Product OK"."<br />\r\n";           }       }       $listing->MoveNext();   }   ?> 

 

zencart批量删除无图片产品