help request please

brailleschool

Hey there,

I am new here. Have been searching the net all night for a solution to my problem.

Here goes:
I have a form that is written in php and html that submits information to a mysql database... a register script in fact.

I also have a form in the users account that can edit their information, I have drop down menus in this edit account form. I would like to know how I can get the default setting in the mysql database to be selected within the relevant drop down menu. Then, if the user edits their account with the form, the selected item in the drop down menu changes accordingly (as the mysql table is updated with the new information).

I am totally new to PHP and have no idea what I am doing 🙂

Attached are some files, the edit account form, and the relevant table structure.

If you can assist in any way, it would be highly appreciated.

Thanks in advance for your support 🙂

iamjbrandt

There are ways to do it in PHP, but none of them are very time-friendly, so I recommend JavaScript.

After the page loads you can have:

I've never tested this so I don't know if it will work but it should!

Jared

brailleschool

the values that need to be default are located in the mysql db so i am expecting i would have to do it via mysql/php.

but all of the values for the drop down are in the pull down lists, just need to figure out how to get the file to find out the default value in the mysql db and make it selected in the drop down list.

simply___skewed

Not sure I know exactly what you mean here - but if I understand correctly you simply have to load values related to each specific user once they've logged in and come into this edit account page.

I would run a generic type query at the start of the page -
select * from [table] where username=[$username] (or something like that to get the required info on that user)

Assuming your values for your drop down menus are being populated from the database as well (within a while loop) - it's as simple as a simple condition while your populating your drop down menu.

if "i" is the value being inserted to the drop down menu.

if($i == $row->value)
{
print("<option value=\"$i\" SELECTED>$i</option>")
}
else
{
print("<option value=\"$i\">$i</option>")
}

That should do the trick - or at least get you started.

Cheers

brailleschool

its a little difficult to explain but ill try

1) someone registers and inserts information into the mysql db.

2) the edit account form has drop down menus, would like the value in the mysql db to show as selected default in the drop down menus.

3) if someone updates their information with the edit form, the selected default in the drop down menus change accordingly.

does that explain it a little clearer?

the attached files in my previous post shows how the form accesses the database and also shows the layout of the database table.

simply___skewed

Then my explaination still stands true - are you populating the drop down menus via the mysql database

brailleschool

the population is in the drop down menu already, was trying to get the default selection in that drop down menu for what ever was in the db.

i am not a php wiz, kinda starting out and very new to it.

what do you think would be the easiest way to get this solution completed?

these are the drop down menus (and of course, the ones in the register form are the same, just inserts the selection into the mysql db)

<select name="gender" id="gender">
<option name="male">Male</option>
<option name="female">Female</option>
</select>

and

<select name="iam" id="iam">
<option name="blind">Blind</option>
<option name="impaired">Visually Impaired</option>
<option name="sighted">Sighted</option>
</select>

and

<select name="status" id="status">
<option name="single">Single</option>
<option name="married">Married</option>
<option name="divorced">Divorced</option>
<option name="widow">Widow</option>
<option name="na">No Answer</option>
</select>

last one is

MySQL db is:
CREATE TABLE login (
id int(11) NOT NULL auto_increment,
username varchar(250) NOT NULL default '',
password varchar(250) NOT NULL default '',
email varchar(250) NOT NULL default '',
fname varchar(250) NOT NULL default '',
sname varchar(250) NOT NULL default '',
country text NOT NULL,
city text NOT NULL,
interests text NOT NULL,
age text NOT NULL,
iam text NOT NULL,
gender text NOT NULL,
school text NOT NULL,
status text NOT NULL,
aboutu text NOT NULL,
whyjoin text NOT NULL,
hobbies text NOT NULL,
children text NOT NULL,
memberstatus varchar(8) NOT NULL default 'Member',
userpic varchar(255) NOT NULL default '',
userpicalt varchar(255) NOT NULL default '',
warned varchar(9) NOT NULL default 'No (0/0)',
PRIMARY KEY (id)
) TYPE=MyISAM;

LordShryku

Show us your code. That way we can help with a solution to your specific need...

brailleschool

LordShryku

the code is in the zip file attached to this thread (about three posts north of here) 🙂

LordShryku

I see....
Well, his code should work for you. But since you're codeing your HTML outside of php, something like this...

<td><select name="iam" id="iam">
<option name="blind" 
<? if ($iam == "blind") { echo "selected" } ?>>Blind</option>
<option name="impaired" 
<? if ($iam == "impaired") { echo "selected" } ?>>Visually Impaired</option>
<option name="sighted" 
<? if ($iam == "sighted") { echo "selected" } ?>>Sighted</option></select>

brailleschool

Parse error: parse error, expecting ','' or';'' in /home/paddy/public_html/editaccount.php on line 121

line 121 is
<option name="blind" <? if ($iam == "blind") { echo "selected" } ?>>Blind</option>

changed it to (which cleared the errors)
<option name="blind" <? if ($iam == "blind") { echo "selected"; } ?>>Blind</option>

the source code shows as follows:

<select name="iam" id="iam">
<option name="blind" >Blind</option>
<option name="impaired" >Visually Impaired</option>
<option name="sighted" >Sighted</option>
</select>

as you can see, its not selecting anything 🙁

Then went into the mysql database and found that the form was posting "blind" as "Blind" so I changed the above to:

<option name="blind" <? if ($iam == "Blind") { echo "selected"; } ?>>Blind</option>

and it selected the option. I know the mysql is fussy and it has to be 100%.

THANK YOU SO MUCH! 🙂

LordShryku

Is there actually anything in the database? Looks suspicious that there would be because

<option name="blind" >....
should actually be
<option value="blind" >

So the insert would take the value "blind" and link it to $_POST['iam']. The way you have it shouldn't work....

brailleschool

it does work though. have a name and not calling a value will insert the word "ITEM" in the following, so it seems if you have a value="", it will take the value="" and insert it, if it doesnt have one, it will take the ITEM section instead.