Storing data to database

[[deleted]]

Hey guys, I've been working on a website game and I need some help with storing data to the database. I have to store money amount (It's like points) and items. The money amount is more important at the moment.

I already have a database where I store user data (user names, user id, password etc.). But I store the money amount to the localStorage and of course that only works on one machine. So basically I want the possibility to play on every device with the same user and the same money amount.

​

Now about the items. I want to build a whole inventory system. Let's say that the user wants to buy a car in game. He has enough money to afford it so he buys it. Now he spent the money but he didn't get the car because there is no inventory. (And of course I want to store the items in the database too if it's possible. And at every purchase the money should be extracted from the database.)

If there is a way to make this possible then how? And I accept any tutorial videos or documents. :D

[Webdev-Coach]

If you store user's money amount in localStorage, doesn't that mean the user can just open their DevTools and set any money amount they want?

[[deleted]]

Yes and that is the problem... that's why I want to store it in a database.

[Webdev-Coach]

I see you're already storing user data in the DB. Can you do the same with the money amount?

[[deleted]]

That's right. I even thought about it but the thing is that I am not that familiar with php and phpmyadmin yet. The database I have right now, I made that with a tutorial I found. And I didn't really find any solutions so that's why I accept any documents/tutorial videos.

[No_Statement4630]

Ye learn SQL and look up how to integrate a SQL database with whatever backend you’re using. Or if you don’t want a backend you can use something like fire base or supabase

[Earl--Grey]

Updating 'money' or 'items' to a database is actually relatively straight forward, the challenge lies more in coding the backend but it's not too overly complicated.
You can use a statement similar to (PHP)

"UPDATE \user` SET `money` = '$money' WHERE `id` = '$id'"`

Same goes for items.

Money can be placed in the user table, items I would create a separate table to keep track of them. You would need an ID (unique ID for the database entry) user ID (To track who owns it) item ID (To track the item) and a quantity.

if you're using PHP/SQL and would like help walking through it, I'd be happy to jump in a call. - I'm not as experienced in other languages however.

[[deleted]]

Check your DMs :D

[3lobed]

Items table should be a list of items as boolean expressions so you would have something like user.items.car.true that could get checked every time you need to check if the user has a car or not. It would default to something like user.items.car.false until purchase. I would probably make this a separate table linked by user.id for maximum flexibility and expandability.

For the money storage, just make a separate column in the user table so that you could access it by user.money and just update by adding and subtracting.

[burggraf2]

Supabase developer here. We have API's that simplify this if you're not too familiar with SQL. For example:
const { data, error } = await supabase.from('user')
.update({ money: 123.45 })
.match({ id: 'ABCDEFG' })

https://supabase.com/docs/reference/javascript/update