Так же хранят в массиве или в бд в которой хранятся все вещи просто указывают user_id у каждой вещи
Чтобы понимать какому юзеру эта вещь принадлежит7
-- на данные пользователя
SELECT * FROM users WHERE id = 1;
-- на книги
SELECT * FROM books WHERE user_id = 1;-- на данные пользователя
SELECT * FROM users WHERE id IN (1, 2, 3 ...);
-- на книги
SELECT * FROM books WHERE user_id IN (1, 2, 3 ...);delimiter |> delimiter |
> CREATE TRIGGER marketing_list_update
AFTER UPDATE
ON cms_offers
FOR EACH ROW
begin
IF NEW.status = 'active' then UPDATE marketing_credits_requests SET sum_a=NEW.ammount, statut=NEW.status WHERE id_req=old.id;
else UPDATE marketing_credits_requests SET statut=NEW.status WHERE id_req=old.id;
END IF;
end; |$sql = "
INSERT INTO users_units
SET
`date`='$date',
`name1`= " . ($array1["name1"] === "" ? "NULL" : "'$array1[name1]'") .
...return response.json()
Uncaught (in promise) SyntaxError: Unexpected token < in JSON at position 550
Promise.then (async)
(anonymous) @ formcheckIn.js:1
Promise.then (async)
then @ VM979 recaptcha__ru.js:202
(anonymous) @ formcheckIn.js:1
setTimeout (async)
(anonymous) @ VM979 recaptcha__ru.js:78
(anonymous) @ VM979 recaptcha__ru.js:131
subTo @ formcheckIn.js:1
console.log(response.text()); - оно не дает дальше считать ответ function itemName(name) { ... }
var items = [
{ name: 'Corrupted Demon Eater', price: '3215.00', inStock: 1 },
...
];
var groups = {}, n;
for (var i = 0; i < items.length; i++) {
n = itemName(items[i].name);
if (n in groups)
groups[n].push(items[i]);
else
groups[n] = [items[i]];
}
var result = [];
for (n in groups) {
groups[n].sort((a, b) => a.price - b.price);
result.push(groups[n][0]);
}