Can I take values from an excel sheet as database?

Hello

I would love to create a simple game where there would be 3 boxes for player to select for prize.

Each box has different prize with limited number. I want to link the result with the excel sheet that BoxA got 3 prizes, BoxB got 5, and BoxC got 2.

So when boxA got selected 3 times by different player, next player will only have to select from BoxB and BoxC.

Thanks in advance

I think that you'd need to have something to parse it between xml and an excel spreadsheet format. I know that Construct has an read-only xml plugin found under the Data & storage when inserting a new object, I think if you're really dead set on using an excel spread sheet then that would probably be the best place to start I reckon. And I think (might be mistaken), you should also be able to save to XML format from Excel, not too sure as I don't have excel. But check it out, hope that can help somehow.

Thank you for your reply.

It doesn't matter if it is not an Excel sheet. Maybe a text file that I can read and write so the value of each Box can be updated.

I read through forum and it seems using AJAX object is the way.

I haven't really try on using AJAX object so I will keep on trying.

If there is anybody can guide me, it'll be very much appreciated.

XML files are read only (tutorial).

If you want to write something, you better use 'LocalStorage' (Tutorial).

I'm thinking of implementing the method from the link,

scirra.com/tutorials/346/online-high-score-table-ajax-php-mysql

Then adapt it to my box variables; planning to change the name and score to prizes and their quantity.

Please comment for possibilities..

It's a very good method to use. Even if the tutorial is very well done, maybe you will have some problems implementing it if you don't have any experiences with MySQL & PHP.

I'd take a look at JSON.

You are right! Now that I have a game that will save result to database but it's not overwriting the data so it' hard to pull an accurate data.

So currently I'm looking for help in editing the PHP from the tutorial so it can overwrite data after sending the same name.

Example

Box A = 3 | Box B = 5 | Box C = 8 (data in DB)

Game result sending

then result in database should be: Box A = 2 | Box B =4 | Box C = 7 not Box A = 3 | Box A = 2 | Box B = 5 | Box B = 4 | Box C = 8 | Box C = 7

Almost there