1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

<?php
include_once('./_common.php');

//_pr($_POST);

$sql = "select * from product_s";
$res = mysql_query($sql,$connect_j3);
$cnt=0;
while($info=mysql_fetch_array($res)){
    $v = strpos($info['item_explain'],$old_url);
    $v2 = strpos($info['item_mobile_explain'],$old_url);
    if($v>0 || $v2){ $cnt++; }
    if($mode=='change' && $old_url!='' && $new_url!=''){
        $vv_it_explan = addslashes(str_replace($old_url,$new_url,$info['item_explain']));
        $vv_it_mobile_explan = addslashes(str_replace($old_url,$new_url,$info['item_mobile_explain']));
        //$vv_it_explan = str_replace($info['it_explan'],$old_url,$new_url);
        $sql = "update product_s 
                    set item_explain = '{$vv_it_explan}', item_mobile_explain = '{$vv_it_mobile_explan}' 
                where pcode = '{$info['pcode']}' ";
        mysql_query($sql,$connect_j3);
    }
}

if($mode=='change'){
    $msg = $cnt."개의 상품이 수정 되었습니다.";
} else {
    $msg = $cnt."개의 상품이 해당이 됩니다.";
}

echo "<?xml version='1.0' encoding='utf-8'?><output>";
echo "<member_cnt>".$cnt."</member_cnt>";
echo "<msg>".$msg."</msg>";
echo "<sql>".$sql."</sql>";
echo "</output>";

?>