ECSHOP购物车退出不清空

最新推荐文章于 2021-06-20 17:58:55 发布

转载最新推荐文章于 2021-06-20 17:58:55 发布 · 1.9k 阅读

文章标签：

#ecshop

ecshop 专栏收录该内容

30 篇文章

订阅专栏

本文介绍了一种改进的电子商务网站购物车管理和用户信息更新的方法。通过调整PHP代码，实现了仅清除未登录用户的购物车记录，更新已登录用户的访问计数、最后登录时间和IP地址，并确保了用户登录前后购物车内容的一致性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.includes\cls_session.php,将

        if (!empty($GLOBALS['ecs']))
        {
            $this->db->query('DELETE FROM ' . $GLOBALS['ecs']->table('cart') . " WHERE session_id = '$this->session_id'");
        }

改为

		if (!empty($GLOBALS['ecs']))
		{
			$this->db->query('DELETE FROM ' . $GLOBALS['ecs']->table('cart') . " WHERE session_id = '$this->session_id' AND `user_id`=0");
		}

2. includes\lib_main.php中，function update_user_info(){} 在这个函数内最下面加入

    /* 更新登录时间，登录次数及登录ip */
	$sql = "UPDATE " .$GLOBALS['ecs']->table('users'). " SET".
		   " visit_count = visit_count + 1, ".
		   " last_ip = '" .real_ip(). "',".
		   " last_login = '" .gmtime(). "'".
		   " WHERE user_id = '" . $_SESSION['user_id'] . "'";
	$GLOBALS['db']->query($sql);
	$sql = "update ".$GLOBALS['ecs']->table('cart')." set user_id =".$_SESSION['user_id']." where session_id = '".SESS_ID."'";
	$GLOBALS['db'] -> query($sql);
	$sql1 = "update ".$GLOBALS['ecs']->table('cart')." set session_id ='".SESS_ID."' where user_id = '".$_SESSION['user_id']."'";
	$GLOBALS['db'] -> query($sql1);
	$sql2="select distinct(c.goods_id) from".$GLOBALS['ecs']->table('cart')."as c left join".$GLOBALS['ecs']->table('goods')."as g on c.goods_id=g.goods_id where g.is_on_sale =0 AND c.user_id = '".$_SESSION['user_id']."'";
	$data = $GLOBALS['db'] -> getAll($sql2);

	if($data){
		foreach ($data as $k=>$v){
			$sql="delete from".$GLOBALS['ecs']->table('cart')."where goods_id = '".$v['goods_id']."'";
			$GLOBALS['db'] -> query($sql);
		}
	}

3. admin\privilege.php 找到下面代码注释掉

    $sql = "DELETE FROM " . $GLOBALS['ecs']->table('cart') .
            " WHERE session_id NOT " . db_create_in($valid_sess);
    $GLOBALS['db']->query($sql);

完成

转载自：http://www.phptext.net/article_view.php?id=290