PHP User Information Form

Scorpion28 · August 1, 2012

I'm using a php form, with all selections for a profile based site, the selections are store in a mysql db. How can I bring the selections back out of the db and show them in a new update profile form for the users profile?

<form>

<label>

<option value="0" selected="selected">Single</option>

<option value="1">Married</option>

<option value="3">Seperated</option>

<option value="2">Divorced</option>

<option value="4">Widowed</option>

<option value="5">Tell You Later</option>

</select>

</label>

</div>

<option value="0">Caucaisan</option>

<option value="1">Black</option>

<option value="2">Hispanic</option>

<option value="3">Asain</option>

<option value="4">Indian</option>

<option value="5">European</option>

<option value="6">Middle Eastern</option>

<option value="7">Mixed Black / White</option>

<option value="8">Native American</option>

<option value="9">Other Ethnicity</option>

</select>

</div>

</select>

</div>

<option value="0">Straight</option>

<option value="1">Bi-Curious</option>

<option value="2">Bi-Sexual</option>

<option value="4">Lesbian</option>

</select>

</div>

<option value="2">Female</option>

</select>

</div>

<option value="1">Athletic</option>

<option value="2">Average</option>

<option value="4">A Few Extra Pounds</option>

<option value="5">Muscular</option>

<option value="6">Curvy</option>

<option value="7">Show You Later</option>

</select>

</div>

</select>

</div>

<option value="0" selected="selected">Black</option>

<option value="1">Brown</option>

<option value="2">Blonde</option>

<option value="6">Mixture of Colors</option>

</select>

</div>

<option value="0">Brown</option>

<option value="2">Green</option>

<option value="3">Light Brown</option>

<option value="4">Hazel</option>

</select>

</div>

</div>

</form>

</div>

jotorres1 · August 1, 2012

Are all these selects done manually or dynamically?

Psycho · August 1, 2012

As jotorres1 was alluding to, you will want to create these select lists dynamically. You should have the values/text for the options stored in a database, array or something similar on the server-side. Then you can create a function/process to create the select lists AND auto-select a value based upon a preset.

Here is an example:

<?php

function createSelectList($options, $selectedValue=false)
{
    $output = '';
    foreach($options as $value => $text)
    {
        $selected = ($value === $selectedValue) ? ' selected="selected"' : '';
        $output .= "<option value=\"{$text}\"{$selected}>{$text}</option>\n"
    }
    return $output;
}

//Create arrays of all select lists/values. This can be retrieved from
//database or with hard-coded arrays. If stored in arrays, put them in
//a separate file and include them when needed
$statuses = array(
    '0' => 'Single',
    '1' => 'Married',
    '2' => 'Seperated',
    '3' => 'Divorced',
    '4' => 'Widowed',
    '5' => 'Tell You Later',
);

//Call function with the list of values to create the options
$statusOptions = createSelectList($statuses, $selectedValueFromDB);

//Then output the options in the HTML
?>
<div id="profile_info">
<form>
      <div id="profile_info_item">
        <label>
          <select name="r_status" id="r_status">
            <?php echo $statusOptions; ?>
            </select>
          </label>
        </div>

Sign In

PHP User Information Form

Recommended Posts

Scorpion28

Link to comment

Share on other sites

jotorres1

Link to comment

Share on other sites

Psycho

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information