Fill Form Values From Database

thelos999

Is there any way of entering multiple database data into a form's value? I am trying to set it up where it enters text1 and text2, but I am able to label it different.

For example:

$sql = mysql_query("SELECT * FROM articles");
$row = mysql_fetch_array($sql);

<form>
<table>
     <tr>
        <td>Text 1</td>
        <td><input type='text' name='text1' value="<?php echo $row['text']; ?>" /></td>
    </tr>
    <tr>
        <td>Text 2</td>
        <td><input type='text' name='text2' value="<?php echo $row['text']; ?>" /></td>
    </tr>
</table>
</form>

I know that there needs to be a foreach or while loop in there, but then I would not be able to label everything accordingly (Ex. Text1, Text2, etc...). Any suggestions? Thanks in advance.

bradgrafelman

thelos999;10989404 wrote:
I know that there needs to be a foreach or while loop in there, but then I would not be able to label everything accordingly (Ex. Text1, Text2, etc...).

Why wouldn't you? It seems like all you're doing is repeating this:

     <tr>
        <td>Text #</td>
        <td><input type='text' name='text#' value="<?php echo $row['text']; ?>" /></td>
     </tr>

where '#' is an increasing counter. Seems like a while loop is a perfect fit.

thelos999

GENIUS! After I saw your "Text#" and when you said counter, I felt like the biggest idiot... I just put Text $count, and that gave me what I wanted. Thanks...

bradgrafelman

Glad I could help, but note that I was also going to make the same recommendation as what NogDog did (oi, Charles, why'd you hard-delete your post??):

NogDog wrote:
You can use the square bracket notation for the name attribute, and create an enumerated array of $_POST['text'][n] elements:
while($row = mysql_fetch_assoc($sql)) {
  printf(
     "<tr><td><input type='text' name='text[]' value='&#37;s' /></td></tr>\n",
     htmlspecialchars($row['text'])
  );
}
Then in your form-handler, there would be 0-n elements in the $POST['text'] array: $POST['text'][0], $POST['text'][1], etc. (which you could cycle through via a foreach($POST['text'])).

Weedpacket

(Edit: yeah, what they said). Personally, I'd prefer to use a record ID or something like that as the array index so that you know which text field corresponds to which record (in case some are missing, or they get submitted in a different order from how they're listed in the document for some bizarre (and nonstandard) reason).