getting mysql data into forms

greenber

I want to grab a record from mysql, display it in a form, allowing edits and then do an update. How do I get info from the datafile to an <input> field in HTML?

Thanks!

Ross

LordShryku

1) RTM on how to get info from MySQL
2) echo the result into your input field

<input type="text" name="blah" value="<? echo $result; ?>">

greenber

Worked like a champ! Thanks!

Next Q: if I'm reading data from a file, and I want to display what item was previously selected in an select pull-down, how do I show that "selected" most easily?

Thanks!

Ross

tekky

if ($user_not_reading_online_documentation)
&nbsp&nbsp&nbsp&nbspecho "control structures";
else
&nbsp&nbsp&nbsp&nbspecho "good job! you tried to find it on your own!";

greenber

Sorry, Karl: perhaps I wasn't clear. Given a select structure like:

<select name="optionchoice">
  <option value="A" selected>A</option>
  <option value="B">B</option>
  <option value="C">C</option>
  <option value="D">D</option>
</select>

and a value of "B", how do I automagically show the "B" selection at run time? Without rewriting the above with "selected" for the "B" choice?

I certainly searched on my own for the answer, but no luck.....

Ross

tekky

you question was quite clear, I pointed you to what you needed... an IF statement

echo "<select name='optionchoice'>";
echo "<option value='A' ". (($optionchoice == 'A') ? 'selected' : '') . ">A</option>";
.......
echo '</select>'

note:
([comparison]) ? value : value2

this is just an alternative method to writing an if

basically if ([comaparison true]) ? returnthisvalue : elsereturnthisvalue

greenber

Karl, I see and understand what you're suggesting. I was hoping there was some sort of magic pill to do a "selected" without a rewrite. Oh well.

Thanks!

Ross

tekky

Originally posted by greenber
Karl, I see and understand what you're suggesting. I was hoping there was some sort of magic pill to do a "selected" without a rewrite. Oh well.

Thanks!

Ross

look into using a while() loop, and you can make it only ONE OPTION tag that you have to code to print all of them to the webpage 😉

get a decent attempt at this started an ill help you out with it 😉