[Resolved] sql result to html form

philippeguerind

Hi from France,
I have a form with severals rows and cells i.e.
<tr>
<td bgcolor="#FFCC33">N° portable :
</td>
<td><input type="text" name="PORTABLE" size=15><br>
</td>
</tr>

into a html table (not dynamically created). I have a php script into this form which returns a valid SQL request. Is there any way to have the input text fields to be populated such as html code : document.PORTABLE.value = something ? An echo result['portable']; command prints the right value form into the php script.

thanks for your help.
Philippe

😕

majiclab

Bonjour from Canada.

If I understand what you want to do, you want to fill in the number back into the <INPUT> box?

To do this, you will need to use the value="" attribute in the <INPUT> field.

And example being:

<INPUT type="text" name="PORTABLE" size=15 value="12345">

All you would have to do is echo $result[ 'PORTABLE' ] where the 12345 is, and it should what you are wanting!

Hope that helps.

-Percy

philippeguerind

Thank's for your very fast reply. I don't know where to put the piece of code you sent to me.
First I have the php script which establish the connection and gets the SQL result.
Next I have the htlm code with a standard table containing the "input fields". I believe the part of code you sent is to be used with a table created dynamycally into the php code. Is there a way to do so with a "static" HTML table.
Thank's.
Philippe

majiclab

This is what it would look like:

<tr> 
<td bgcolor="#FFCC33">N° portable : 
</td> 
<td><input type="text" name="PORTABLE" size=15 value="<?= $result[ 'portable' ] ?>"><br> 
</td> 
</tr>

That will insert into the input field.

Hope that helps!

-Percy

philippeguerind

It works great !
thanks.