Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 13 of 13
  1. #1
    New Coder
    Join Date
    Feb 2013
    Posts
    20
    Thanks
    2
    Thanked 0 Times in 0 Posts

    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??

    Thanks!

  • #2
    New Coder
    Join Date
    Feb 2013
    Posts
    20
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Anyone have any ideas? I really need to figure out a way to accomplish this!

  • #3
    Senior Coder whizard's Avatar
    Join Date
    Jan 2005
    Location
    Philadelphia, PA, USA
    Posts
    1,662
    Thanks
    14
    Thanked 76 Times in 76 Posts
    So how do you verify that the person submitting the signature is indeed the parent of that child?
    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 :)

    "Also note that it is your responsibility to die() if necessary."

    DON'T USE THE MYSQL_ EXTENSION

  • #4
    New Coder
    Join Date
    Feb 2013
    Posts
    20
    Thanks
    2
    Thanked 0 Times in 0 Posts
    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.

  • #5
    New Coder
    Join Date
    Feb 2013
    Posts
    20
    Thanks
    2
    Thanked 0 Times in 0 Posts
    By the way, just noticed you're from Philly Me too. I'm from Southwest. What part are you from?

  • #6
    Senior Coder whizard's Avatar
    Join Date
    Jan 2005
    Location
    Philadelphia, PA, USA
    Posts
    1,662
    Thanks
    14
    Thanked 76 Times in 76 Posts
    From UD, right outside the city.

    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 :)

    "Also note that it is your responsibility to die() if necessary."

    DON'T USE THE MYSQL_ EXTENSION

  • #7
    New Coder
    Join Date
    Feb 2013
    Posts
    20
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Hi Dan,

    Thanks for the reply!

    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.

  • #8
    Senior Coder whizard's Avatar
    Join Date
    Jan 2005
    Location
    Philadelphia, PA, USA
    Posts
    1,662
    Thanks
    14
    Thanked 76 Times in 76 Posts
    OK well in that case you just need

    kidTable
    -------
    id (PK)
    name
    parentSig
    waived

    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 :)

    "Also note that it is your responsibility to die() if necessary."

    DON'T USE THE MYSQL_ EXTENSION

  • Users who have thanked whizard for this post:

    midnight1932 (07-24-2013)

  • #9
    New Coder
    Join Date
    Feb 2013
    Posts
    20
    Thanks
    2
    Thanked 0 Times in 0 Posts
    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...

  • #10
    Senior Coder whizard's Avatar
    Join Date
    Jan 2005
    Location
    Philadelphia, PA, USA
    Posts
    1,662
    Thanks
    14
    Thanked 76 Times in 76 Posts
    Do you know HTML? Do you have a webserver?
    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 :)

    "Also note that it is your responsibility to die() if necessary."

    DON'T USE THE MYSQL_ EXTENSION

  • #11
    New Coder
    Join Date
    Feb 2013
    Posts
    20
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Very basic....and we just have web hosting

  • #12
    Senior Coder whizard's Avatar
    Join Date
    Jan 2005
    Location
    Philadelphia, PA, USA
    Posts
    1,662
    Thanks
    14
    Thanked 76 Times in 76 Posts
    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 :)

    "Also note that it is your responsibility to die() if necessary."

    DON'T USE THE MYSQL_ EXTENSION

  • #13
    New Coder
    Join Date
    Feb 2013
    Posts
    20
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Okay thanks for the replies/help, and please let me know if you reconsider!


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •