1. Manage and add new users to the system, and later add cards they have earned
2. Allows a way to display the users and which cards they have collected and which ones they haven't.
Here's the idea;
I'm a visitor and I want to view which cards "Susie" has collected. So I click her name in the userlist and up pops a window that has highlighted which cards they have collected out of the total number of cards. Clicking the name of the card or rolling over it shows the picture of the card.
Right now I'm in the phase of the project where I am developing the admin panel that will let me add and edit the users/cards. I have completed the part that adds users and their respective cards to the database, but now I'm on the editing part.
I've figured out a primitive update script that will work for me: here's what I have;
<? include("dbinfo.inc.php"); mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); ?> <form action="updated.php" method="post"> Username: <input type="text" name="ud_usernamec"><br> Air: <input type="checkbox" name="ud_air"><br> Dark: <input type="checkbox" name="ud_dark"><br> <input type="Submit" value="Update"> </form>
<? include("dbinfo.inc.php"); mysql_connect(localhost,$username,$password); $query="UPDATE cardbase SET air='$ud_air', dark='$ud_dark' WHERE usernamec='$ud_usernamec'"; @mysql_select_db($database) or die( "Unable to select database"); mysql_query($query); echo "Record Updated"; mysql_close(); ?>My problem is that for example, if a user already has a card, I have to click the checkbox for that card anyways, or it will get submitted and turn the value for that row on that user to off. Does that make sense? I know now that it shouldn't be hard since there are only 2 cards, but once I get this going there are like 42 total.
So, you can see me having to click the checkboxes over and over could get old. Is there anyways I can modify the update.php script or something else where if the checkbox is submitted without a value that it isn't put in as a 0?