Creating saveable & updateable list

[mugwumpr]

Hello,

I'm trying to build a page for a collector's site that allows members to keep track of which items they have and which they need via a checklist, using checkboxes. For clarification, you can see the list Here.

The MySQL tables are InnoDB as follows:

eggs - ID (primary)
members - ID (primary)
collection - ID (primary), egg_ID (foreign), member_ID (foreign)

I have the page set up so each checkbox has a unique name based on the egg primary ID:

echo '<input type="checkbox" name="' . $row['id'] . '">';

This works great.

Each member has a unique ID passed to the page via a cookie from login, and that part's also working great.

The part that has me stumped is how to manage the following:

1) retrieve and display egg-ownership info based on member_ID, and
2) save changed info into the collections table via a form ($_POST, maybe?).

I've got all the bits working, I just don't know how to put them all together.

😕

[scrupul0us]

i already posted options for you in your original thread regarding this, please refer to that for your best options for managing user-based collection tracking

[mugwumpr]

scrupul0us;10916509 wrote:

i already posted options for you in your original thread regarding this, please refer to that for your best options for managing user-based collection tracking

Umm.... There was no "original thread" on this question other than this one. There was one on how to create the structure of the MySQL table that you posted in:

on each user record, create a field called "collected", in that field store an array of the egg_id's the user has collected... if the number isnt in there, then they havent collected it yet and as such the checkboxes for those missing would be empty

if you dont want todo it on the user table you could create a table just for this with two fields... user_id, collected

if you want more data about each egg collected then youll want a seprate table with
collected_id, user_id, egg_id and then fields for any descriptive stuff about each (date collected, etc)... this table will be huge depending on # of eggs and users

but as you can see, this is an entirely different question. The table you refer to is already created and established and doesn't enter into the question here at all other than for informational purposes.

This is how to code the PHP to put info into that table (already developed and noted here), and to pull it out again using a form with checkboxes.

To clarify: original thread = MySQL; this thread = PHP.

:mad:

[mugwumpr]

:xbones: Okay, I've given up on checkboxes. They're just beyond me. I have another idea....

Ideally it would work something like this:

If the egg is not currently owned, it would display a link that, when clicked, would first insert the info into the table, then refresh the page to display the updated status of the egg.

I have the PHP to display everything, and to determine if the egg is owned or not and what to display in each instance (I think.... it seems to work, anyhoot).

I also have the javascript to do a page refresh onClick.

How would I combine the two into a single clickable link?

😕

[mugwumpr]

Now I'm confused. I've got it worked out to generate a button for each egg to update the database, but for some reason it's not reading two of my variables, yet it is reading the third. What on earth am I doing wrong?

if (isset ($_COOKIE['ID'])) {

$uid = escape_data($_COOKIE['ID']);
} else {
echo 'oopsie, no cookie for you!';
exit();
}

$eggp = escape_data($_POST['$ei']);
$memp = escape_data($_POST['$uid']);
$namp = escape_data($_POST['$name']);


// make the query
$query = "SELECT (fd_eggs.ID AND name) FROM fd_eggs
    LEFT JOIN fd_collection 
	ON fd_eggs.ID = fd_collection.egg_ID 
	ORDER BY releasedate DESC, fd_eggs.ID DESC";	
$result = mysql_query($query) or die(mysql_error());

$ei = escape_data($row['egg_ID']);
$name = escape_data($row['name']);	

echo '<table width="90%" border="0" cellspacing="5" cellpadding="0">';

//update the database
$query = "INSERT INTO fd_collection (ID, member_ID, egg_ID, egg_name) VALUES ('NULL', '$memp', '$eggp', '$namp')";	
$bg = '#eeeeee';  //set row background variable
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {

$bg = ($bg=='#eeeeee' ? '#ffffff' : '#eeeeee');  //set background colours to alternate rows	

if ($row['egg_ID'] != 0) {
$eggid = escape_data($row['fd_eggs.ID']);
echo '<tr bgcolor="' . $bg . '"><td align="left"><img src="pics/yes.gif"></td>';
} else {

echo '<tr bgcolor="' . $bg . '"><td align="left"><form action="' . $PHP_SELF . '" method="post">
<input type="hidden" name="member_ID" size="50" maxlength="100" value="' . $uid . '" />
<input type="hidden" name="egg_ID" size="50" maxlength="100" value="' . $ei . '" />
<input type="hidden" name="egg_name" size="50" maxlength="100" value="' .  $name . '" />
<input type="submit" name="submit" value="Have" />
<input type="hidden" name="submitted" value="TRUE" />
</form></td>';
}
echo '<td>';
echo '<img src="../pics/found/egg-found' . $ei . '.png" height="70px" width="50px"></td><td>'. $name . '</td></tr>';

}

echo '</td></tr></table>';

This is the View Source:

<input type="hidden" name="member_ID" size="50" maxlength="100" value="1" />
<input type="hidden" name="egg_ID" size="50" maxlength="100" value="" />
<input type="hidden" name="egg_name" size="50" maxlength="100" value="" />

What have I done wrong? 😕