[RESOLVED] adding empty text field

Ali_baba

Hello all,

I am trying to create text fields, and fill them from data (extraced from database).
Here is the code:

$result_ofsp = mysql_query("SELECT parid, AES_DECRYPT(knhk,'encrypt') as knhk,knsn,SSN FROM ofsp_table WHERE SSN = AES_ENCRYPT('$SSN','encrypt') AND parid = '$ID'");?>               

        <?$i=1;
                while ($array_ofsp = mysql_fetch_array($result_ofsp))  {?>
      <tr>
     <td><input  type="text" name="qV_knsn[<?echo $i?>]" id="qV_knsn<?echo $i?>" value="<?echo $array_ofsp['knsn']?>" /></td>
      <td><input type="text" name="qV_knhk[<?echo $i?>]" id="qV_knhk<?echo $i?>" value="<?echo $array_ofsp['knhk']?>" /></td>
      </tr>
      <?   $i++;   }?>

This works ok. However, I would like to use loop like (i=1; i<=5;i++). I know that it will give me empty field, which I would like to display at the end. How can I do so?

Thanks in advance 🙂

nrg_alpha

why not just throw everything into a for loop?

<?php
$result_ofsp = mysql_query("SELECT parid, AES_DECRYPT(knhk,'encrypt') as knhk,knsn,SSN FROM ofsp_table WHERE SSN = AES_ENCRYPT('$SSN','encrypt') AND parid = '$ID'");

$array_ofsp = mysql_fetch_array($result_ofsp);
for($i=0; $i < count($array_ofsp); $i++){
   echo '<tr>';
   echo '<td><input  type="text" name="qV_knsn$i" id="qV_knsn$i" value="$array_ofsp[\'knsn\']" /></td>';
   echo '<td><input  type="text" name="qV_knhk$i" id="qV_knhk$i" value="$array_ofsp[\'knhk\']" /></td>';
   echo '</tr>';
}
?>

Don't know if this is the format you are looking for..(I'm not knowledgable in mySQL yet.. so I don't know if there are any inherent errors in my solution.. rather just focusing on the format of it all in PHP.

Cheers,

NRG

P.S As our forum's own NogDog points out in his blog, it's not good practice to use the syntax <? ... ?>
http://www.charles-reace.com/blog/2008/07/07/beginners-corner-avoid-bad-habits/#more-10

laserlight

nrg_alpha's is not quite correct since instead of iterating over the result set, that solution iterates over the fields of the first row in the result set. Another problem is that an attempt at variable interpolation is used within single quoted strings, so the variables will not be replaced. A possible fix would be:

<?php
$result = mysql_query("SELECT parid, AES_DECRYPT(knhk,'encrypt') as knhk,knsn,SSN FROM ofsp_table WHERE SSN = AES_ENCRYPT('$SSN','encrypt') AND parid = '$ID'");

for ($i = 0; $row = mysql_fetch_assoc($result); ++$i) {
echo '<tr>'
    . '<td><input type="text" name="qV_knsn' . $i . '" id="qV_knsn' . $i
    . '" value="' . $row['knsn'] . '" /></td>'
    . '<td><input type="text" name="qV_knhk' . $i . '" id="qV_knhk' . $i
    . '" value="' . $row['knhk'] . '" /></td>'
    . '</tr>';
}
?>

However, why use the legacy MySQL extension when you can use the PDO extension or the MySQLi extension?

nrg_alpha

I stand corrected. Here I was thinking that since the variable $i was inside double quotes, it would be interpreted correctly. But I see now what you're talking about.

Ali_baba

First of all, I am sorry that I was unable to reply. I was away for job related trip to Prague
Second, I am sorry, once again that I was unable to make myself clear.

I would to see something like this:

$sn=5;

$result_ofsp = mysql_query("SELECT parid, AES_DECRYPT(knhk,'encrypt') as knhk,knsn,SSN FROM ofsp_table WHERE SSN = AES_ENCRYPT('$SSN','encrypt') AND parid = '$ID'");?>               

        <?for ($i=1;$i<=$sn;$i++;) {
                while ($array_ofsp = mysql_fetch_array($result_ofsp))  {?>
      <tr>
     <td><input  type="text" name="qV_knsn[<?echo $i?>]" id="qV_knsn<?echo $i?>" value="<?echo $array_ofsp['knsn']?>" /></td>
      <td><input type="text" name="qV_knhk[<?echo $i?>]" id="qV_knhk<?echo $i?>" value="<?echo $array_ofsp['knhk']?>" /></td>
      </tr>
      <?   $i++;   }}?>

because I would like to have the text fields according to the value of $sn, not how many entries I have in db. So it means that if there are 3 entries in db then I would like to have 5 text fields as per $sn value.

Hope that I explained myself 🙂

Ali_baba

solved