[Resolved] save form data

thebighere

Hello,

I have a huge search page with approximately 250 choices (checkboxes, radio buttons, database-derived menus).

My question is, what would be the easiest way to save these choices (save form data) for each user?

I know who is on the page, so I could use that info as well.

BTW, using mysql...

Ideally, the user could name and save more than one search (set of form data).

Maybe I'm dreaming here...any thoughts?

thanks very much

snoopy13

what do you want to save the infromation for? if he goes back and wants to change something? or for longer?

thebighere

i'll have proabbly 5 users that will have their favorite search parameters that they'll want to go back to repeatedly

i'll have to save multiple search choice-sets for each user forever, afaik

snoopy13

what about making two tables, one for the user (unser_ID, name etc.) and the other for search parameters (parameter_ID, item1, item2 etc, and user_ID) so that every user can have one or more choice sets?

and when the user logs in, he automaticly gets his choice sets which he can choose from

thebighere

whoa, i guess i need a little clarification

do you mean i'd have:

checkbox1,checkbox2

but also checkbox1$userid,checkbox2$userid

snoopy13

first you read out all existing data from the user that has logged in (you've stored his user_ID in $id before)

<?php
//read existing data:
$user_SQL=("SELECT * FROM user, parameter WHERE user.user_ID = '$id' AND parameter.user_ID='$id'");
$user_result=mysql_query($user_SQL);
$user=mysql_fetch_array ($user_result);
?>

and then you have your form fields showing the all the items:
eg.

thebighere

Hey,

I just wanted to thank you all for your help.

It's taken me a while to even get a chance to try this, but it works great.

Sometimes a little logic can clear up what can be made into a complicated issue.

thanks again

stolzyboy

mark the thread resolved if it is a resolved issue please

phplearner

Hey Snoopy13:

I want to do something similar, but what do I use when reading from the MySQL table to have the existing selections show as "checked" checkboxes...and all others remain "unchecked"?

Thank very much.

snoopy13

you can do the fallowing:

<? if($checkbox1==1) { $chk="CHECKED"; } else { $chk=""; } ?> <INPUT TYPE="checkbox" NAME="checkbox1" VALUE="1" <? echo $chk?>>

phplearner

Originally posted by snoopy13
hy

you can do the fallowing:

<? if($checkbox1==1) { $chk="CHECKED"; } else { $chk=""; } ?> <INPUT TYPE="checkbox" NAME="checkbox1" VALUE="1" <? echo $chk?>>

Cool. Umh, I forgot to mention these would need to be in some type of "auto-array" I think, because the actual number of options in the table will vary. So, there has to be some way to have checkbox numbers change automatically.

I've been trying a checkbox[] type array thing another person suggested but just have not been able to get it to work.