ecshop实现将商品批量加入收藏的功能

/* 批量添加收藏商品(ajax) */

elseif ($action == 'collect_all'){

 include_once(ROOT_PATH .'includes/cls_json.php');

 $json = new JSON();

 $result = array('error' => 0, 'message' => '');

 $goods_id = $_GET['id'];

 $goods_id = explode("|",$goods_id);

 $goods_id = array_filter($goods_id); //过滤掉数组中空的值

 if (!isset($_SESSION['user_id']) || $_SESSION['user_id'] == 0){

  $result['error'] = 1;

  $result['message'] = $_LANG['login_please'];

  die($json->encode($result));

 }

 else{

  foreach($goods_id as $goods_id){

   /* 检查是否已经存在于用户的收藏夹 */

   $sql = "SELECT COUNT(*) FROM " .$GLOBALS['ecs']->table('collect_goods') .

     " WHERE user_id='$_SESSION[user_id]' AND goods_id = '$goods_id'";

   if ($GLOBALS['db']->GetOne($sql) > 0){}

   else{

    $time = gmtime();

    $sql = "INSERT INTO " .$GLOBALS['ecs']->table('collect_goods'). " (user_id, goods_id, add_time) " .

      " VALUES ('$_SESSION[user_id]', '$goods_id', '$time')";

    if ($GLOBALS['db']->query($sql) === false){

     $result['error'] = 1;

     $result['message'] = $GLOBALS['db']->errorMsg();

     die($json->encode($result));

    }  

   }

  }

  $result['error'] = 0;

  $result['message'] = $GLOBALS['_LANG']['collect_success'];

  die($json->encode($result));

 }

}