User confirm function

Not for 'how-to' coding questions but PHP theory instead, this forum is here for those of us who wish to learn about design aspects of programming with PHP.

Moderator: General Moderators

Post Reply
jason87
Forum Newbie
Posts: 14
Joined: Sun May 18, 2008 8:58 pm

User confirm function

Post by jason87 »

I want to add a "date confirmation" page to my cms. The idea is that members of a band (the users) can add dates possible for practice. The other members need to confirm these dates. Right now I have created a table with a record for every date and a column for every user where the default value is 0 (for unconfirmed) and this is supposed to change to 1 (for confirmed). I know this is a theory forum, so I'm not asking for code; I just want to know that there is a smarter way to achieve what I want. I have my users logged in via a simple session_name being their first name (only three users).
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: User confirm function

Post by califdon »

So, if I understand it correctly, you want any of the 3 users to be able to input a date, creating a new record in the table, then any of the 3 users can see what dates have been added, and confirm those dates that are acceptable for them? Your approach sounds reasonable to me. I think I might want to have the column for the user who inputs a date be changed to 1, since if he proposes the date, obviously it's okay for him. I can't come up with a better suggestion. The way to display the proposed dates and permit "voting" on them might get a little tricky, but it's all do-able.
jason87
Forum Newbie
Posts: 14
Joined: Sun May 18, 2008 8:58 pm

Re: User confirm function

Post by jason87 »

Hi,
I've moved my post to viewtopic.php?f=1&t=82854 where it will continue. Thank you very much for your reply! I've been suggested to have two tables. One with practice dates and one with confirmations. You can read about it on the other page, where I have also replied.
Post Reply