哎,公司里面有个客户的站点还用的oscommece。我又比较倒霉,被安排成了维护这个网站,客户的要求太多了,一下要这样一下要那样。整个系统可以说是修改修改,已经改得看不出是oscommerce了。现在又要来删除它们不同商场同步过来的重复产品。每次这种临时修改的代码都是用完就删,所以跑这里来记下代码,以后再遇到就直接用这段代码了。
<div id="_mcePaste">
<div id="_mcePaste">/*删除指定id的produit*/</div>
<div id="_mcePaste">if(!empty($_GET['del'])){</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>$arr=array(<span style="white-space: pre;"> </span>18497,18898,19175,18849,19282,18870,19295,18933,18983,19025,19133,18886,19315,19031,18994,18580,18768,19195,18771,19207<span style="white-space: pre;"> </span>);</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>if(!empty($arr)){</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>$list<span style="white-space: pre;"> </span>= array();</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>$sql<span style="white-space: pre;"> </span>= "SELECT products_id,winmeuble_reference_client,winmeuble_code_fournisseur,winmeuble_reference_fournisseur FROM products WHERE products_id IN (".implode(',',$arr).")";</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>$res <span style="white-space: pre;"> </span>= tep_db_query($sql);</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>while ($v = tep_db_fetch_array($res)){</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>$winmeuble_reference_client<span style="white-space: pre;"> </span>= addslashes($v['winmeuble_reference_client']);</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>$winmeuble_code_fournisseur<span style="white-space: pre;"> </span>= addslashes($v['winmeuble_code_fournisseur']);</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>$winmeuble_reference_fournisseur<span style="white-space: pre;"> </span>= addslashes($v['winmeuble_reference_fournisseur']);</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>$res1 = tep_db_query("SELECT products_id FROM products WHERE winmeuble_reference_client='".$winmeuble_reference_client."'</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>AND winmeuble_code_fournisseur='".$winmeuble_code_fournisseur."'</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>AND winmeuble_reference_fournisseur='".$winmeuble_reference_fournisseur."'");</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>while ($v1 = tep_db_fetch_array($res1)){</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>$list[]=$v1['products_id'];<span style="white-space: pre;"> </span></div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>}</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>}</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>}</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>if(!empty($list)){</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>$wheresql=" products_id IN (".implode(',',$list).")";</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>tep_db_query("DELETE FROM products WHERE ".$wheresql);</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>tep_db_query("DELETE FROM products_description WHERE ".$wheresql);</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>tep_db_query("DELETE FROM products_to_categories WHERE ".$wheresql);</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>}</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>echo count($list);</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>echo '<br/><pre>';</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>print_r($list);</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>echo '</pre>';</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>die();</div>
<div id="_mcePaste">}/**/</div>
</div>




