If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Enjoy an ad free experience by logging in. Not a member yet? Register.

Online roster signatures. Database?

I'm not really sure where to post this, so please feel free to move it if it's not in the right place.

We would like to display a team roster on a page, and next to each player's name, have a field where the parent can type their name (as a waiver of sorts) and click a submit button. Clicking the button would then gray that player's name out/make it inaccessible to everyone else. This way, we know which player's parent has acknowledged the waiver. The problem is, the names that have been signed and submitted would have to stay grayed out, even after page refreshes, etc. This leads me to believe that the info would have to be stored in some sort of database. Am I correct? Does anyone know how to accomplish this??

I know that is a concern, but they aren't really too bothered by that. The coach would be the one directing the parents to the link. Basically we just need the name to be inactive in the list once checked and signed. Ideally, we'd like to have access to all the checked/signed submissions, administratively.

Well, as a basic plan you would need a page for them to click on the name. Perhaps instead of a list of all the kids, you give each parent a unique code to enter, which would correspond to their child. When they enter that code, they are taken to a page that shows them the disclaimer and has a text box for them to fill out. When they submit that, you would store the name they typed in the database, tied to the child.

Database setup:

Code:

childTable
----------
id (PK)
uniqueCode (UNIQUE)
name
waived (this would be a flag to set if the parent had submitted the waiver)
parentTable
-----------
id (PK)
name
text (what they enter in the waiver textbox)
childID (the ID from the child table corresponding to their child)

So, page with a textbox for the unique code.
when they submit, page pulls the child data from the child table corresponding to the specific code.

parent sees the info, reads the waiver, types their name, submits

page sends the parent's "signature" to the DB and stores in a new parent row, along with the child's ID.

Additionally you could add another page for the coach to see which kids' waivers had been signed.

Does that make some sense?
Dan

Edit:
I'm no lawyer, but this scheme seems like it would hardly hold up against a lawsuit...how can you prove the parent is the one who typed those words in. You might want to take the IP address of the parent down as well. :\

PHP Tip: If you want to use short tags (<? or <?=$var) then make sure short_open_tag is set to "1". It really helps.

Don't forget to save everyone time and mark your thread as Resolved :)

UD, huh? I know exactly where you are. I lived in Delco for many years.

Yes what you're saying makes a lot of sense, but I think it's actually more involved than what they need. There will be many of these rosters flying around for different tournaments and I think the coaches would just like to send a single link to the parents, have them sign off, and be done with it. We are planning to post the waiver at the top of the page, so each parent can read it when they get to the page. Basically, I'm seeing it like this:

Team Name

Player 1 [checkbox to agree to waiver] (text field for parent's name) SUBMIT
Player 2 [checkbox to agree to waiver] (text field for parent's name) SUBMIT
Player 3 [checkbox to agree to waiver] (text field for parent's name) SUBMIT
Player 4 [checkbox to agree to waiver] (text field for parent's name) SUBMIT
Player 5 [checkbox to agree to waiver] (text field for parent's name) SUBMIT

So if I'm a parent and my child is Player 3, I check the box, type my name, and click the Submit button. Once I click that, my child's name becomes grayed out/inactive. All subsequent visits to the page will show the grayed out names, and the ones that remain active are obviously the ones that still need a parent signature.

When you go to the page, pull all the kids, if(waived) then you gray them out otherwise you set up the checkbox thing. When the submit button is pushed you'll take the data, put it in the table where ID is that child's ID (you'll need a hidden form field holding the kid's ID) and update the waiver flag.

Edit:To see which parents have signed, select * from kids where waived = 1, print them out

PHP Tip: If you want to use short tags (<? or <?=$var) then make sure short_open_tag is set to "1". It really helps.

Don't forget to save everyone time and mark your thread as Resolved :)

Users who have thanked whizard for this post:

Problem is, I'm a COMPLETE rookie and know little about coding. I tried messing with a few plugins to accomplish this, but after reading I thought it was only something that was possible through custom coding. Do you know how to do it? If so, I'd be willing to pay you for your time...

OK man well I don't have time to write it (which I wouldn't charge for anyhow, it is very basic), I'm sorry. Someone here may give you tips, Look up the PHP MySQLI functions for interacting with the database.

PHP Tip: If you want to use short tags (<? or <?=$var) then make sure short_open_tag is set to "1". It really helps.

Don't forget to save everyone time and mark your thread as Resolved :)