OpenCart购物车信息解密

Question

I am developing an android app for opencart user. I need cart information decoded and identify product id quantity etc from oc_customer table. I tried this

$sql = "SELECT cart FROM oc_customer WHERE email='an registered user email';";
$result = mysqli_query($con, $sql);
if (mysqli_num_rows($result) == 1) {
    $row = mysqli_fetch_assoc($result);
    var_dump(unserialize(base64_decode($row['cart'])));
}

I am getting this error

unserialize(): Error at offset 0 of 36 bytes

Can anyone give me an clue how can I get this done

Answer 1

(Based on previous questions, I assume you are using OpenCart 3.0.2.0).

To get the customer's cart contents, get the customer's id based on his email from oc_customers table, then look up that customer id in the oc_cart table. (This is how it is done in OpenCart 2.3+; the cart field of the oc_customers table was used in older versions of OpenCart.)