[Resolved] how to set checkbox/select

NoBullMan

Hi,
I am trying to set up some form fields in a PHP file, based on values queried from a database.
If users have already filled out a form and have an ID, they can enter the ID and have the form filled automaticaaly based on results fetched from the DB (using customer id).
I put the <input ...> field, where users enter their id, in one form that submits to itself and the actual form fields (FirstName, LastName,...) in a separate form. There is no problem, I can enter the id and get the results from DB and have the fields filled in. The problem is that I can only fill in the <input type="text" ...> fields and don't know how to get the checkboxes checked or Select boxes show the proper text(option).

// $cid is customer id that user enters, using an input field called cid
$cid = $_POST['cid'];
$query = "SELECT * from Customers WHERE CustomerID=\"$cid\"";
$result = mysql_query($query);
if(mysql_numrows($result)>0)
{
   $result = @mysql_fetch_array($result);
   $FirstName = $result['FirstName'];
   $LastName = $result['LastName'];
  ....
  $select_field = $result['select_name'] // Let's say = text2
  $checked_value = $result['value_based_on_a_checkbox_]  // if == "yes", check the checkbox
}

//Then in form:

<input type="text" name="FirstName" size="30"  value="<?php echo $FirstName
?>" />
...
// I want "text2" to be selected here
<select name="select_name">
  <option>text1
  <option>text2
  <option>text3
 </select>

// if $checked_value is "yes", check this
<input name="FR" type="checkbox">

I really appreciate your help.

TIA.

BooRadLey

Obviously you will need if statements to see which are selected/checked, but those are the attributes needed.

Brad

porco

You would like to repopulate the selects and checkboxes in your form from the database? Want the previously selected options to be shown and checkboxes to have those damn ticks? Check this out....

Ok try this function....

function check($key,$value,$return) {
if ($key == $value)
return $return;
}

Then if you have a checkbox put this.....

echo "<p>State<select class=\"state\" name=\"state\">\n";
echo "<option value=\"Queensland\" ".check("Queensland",$_POST["state"],"selected") ." >Queensland</option>\n";

echo "<option value=\"New South Wales\" ".check("New South Wales",$_POST["state"],"selected"). " >New South Wales</option>\n";

If you want to repopulate selects use this....

echo "<p>State<select class=\"state\" name=\"state\">\n";
echo "<option value=\"Queensland\" ".check("Queensland",$state,"selected") ." >Queensland</option>\n";
echo "<option value=\"New South Wales\" ".check("New South Wales",$state,"selected"). " >New South Wales</option>\n";

I hope this helps, after weeks of hunting out long ways this was given by a guy called Markey Coates at Codewalkers. Cool ay.

Ciao
🆒

NoBullMan

Thanks Porco. Your example used "Select" for both checkbox and select, but I know what you did.

porco

Yeh same thing... Handy piece of code lol.

I must have posted it just as you signed off and went to bed 🆒

ciao

porco