CODEWITHSUNDEEP
phpmysqlsqldatabase
Rocksteady
Rocksteady

Reputation: 281

Creating tables on registration in php

The question is not new in any way but it has a small twist to it. My webpage is a membership page where users places bets. My idea is to create a new table for the users(with a naming convention like TABLE userBet+$userid) bets. User login information is already handled, my goal is now to save the bets of the user to a new table. A table which is created when users register. This will hopefully make score counting easier. Am I right or wrong? Could this be done in a better way? (Everything is done in PHP MySQL)

User registers -> Table for bets get created

"CREATE Table $userID ,id_bet, games, result, points"

And then matching this table against the correct result?

So again my questions: Is this a good way to do it? Is creating a table with the userID a smart thing to do?

EDIT

The bets is always 40 matches, which makes the tables Huge with columns and rows. Should I make 40 Tables, one for each games instead? and put all users in there?

Upvotes: 0

Views: 914

Answers (2)

Ivan Yonkov
Ivan Yonkov

Reputation: 7034

Posting as an answer due to author's request : )

Suggested database schema:

table matches:

id |   name   |
---------------
 1 |   A vs B |

table user_bets

id | user_id | match_id | points | result |
-------------------------------------------
 1 |    X    |    1     |    Y   |   Z    |

Where match_id is related on matches.id

user_id = user.id

user_bets is only one table, containing all the info. No need of separate tables, as it was clear from the comments it's considered bad practice to alter the db schema via user input.

Upvotes: 1

deceze
deceze

Reputation: 522372

Am I right or wrong?

You are wrong. Dynamically altering your database schema will only make it harder to work with. There's no advantage you gain from doing so. You can do the same things by storing all bets within the same table, adding a column userid.

Upvotes: 3

Related Questions