How do I get the results from a MySQL-queery into a form?

[beginann]

Problem: I have a database with members in a society.

I want to search for one person only (from a form) - perhaps to edit his/hers address etc.

Now I want the result to be shown in the form so I can alter the address there and then send it to the database again for updating.

This i have tried:

<?php 
      //Söker funktionär med namn 
      if(isset($sok)){ 
       
         $query = "SELECT * FROM funktionarer WHERE namn LIKE '%$namn%'"; 
         $result = mysql_query($query); 
         if(!$result){ 
               echo "<div class=tabell4><table><tr><td>Funktionären kunde inte hittas. MySQL rapporterar: " . mysql_error() ."</td></tr>"; 
            echo "</table></div>"; 
         } 
         else { 
            $line = mysql_fetch_assoc($result); 
            $s_namn = $line['namn']; 
            $s_adress = $line['adress']; 
            $s_postnr = $line['postnr']; 
            $s_ort = $line['ort']; 
            $s_tel = $line['tel']; 
            $s_email = $line['email']; 
         } 
      } 
      // Stänger anslutningen till vår databas 
        mysql_close($connection); 

?>

 

Form:

<form method="post" action="<?=$PHP_SELF?>"> 
  <table> 
    <tr> 
      <td width="128" class="text_12">Namn</td> 
      <td width="131"><input type="text" name="namn" size="22" value="<?=$s_namn?>" /></td> 
    </tr> 
    <tr> 
      <td class="text_12">Adress</td> 
      <td><input type="text" name="adress" size="22" value="<?=$s_adress?>" /></td> 
    </tr> 
    <tr> 
      <td class="text_12">Postnr</td> 
      <td><input type="text" name="postnr" size="20" value="<?=$s_postnr?>" /></td> 
    </tr> 
    <tr> 
      <td class="text_12">Ort</td> 
      <td><input type="text" name="ort" size="20" value="<?=$s_ort?>" /></td> 
    </tr> 
    <tr> 
      <td class="text_12">Telnr</td> 
      <td><input type="text" name="tel" size="20" value="<?=$s_tel?>" /></td> 
    </tr> 
    <tr> 
      <td class="text_12">E-mail</td> 
      <td><input type="text" name="email" size="20" value="<?=$s_email?>" /></td> 
    </tr> 
    <tr> 
      <td class="text_12"> </td> 
      <td> </td> 
    </tr> 
    <tr> 
      <td class="text_12"><input class="skicka_knapp3" type="submit" name="sok" value="Sök funktionär" /></td> 
      <td> </td> 
    </tr> 
</table> 
</form>

 

Please help!

[wildteen88]

You'll need to add your form where I have highlighted

            $s_email = $line['email'];

 

            ADD YOUR FORM HERE

 

        }

[beginann]

Like this you mean (or did I misunderstand you because it doesn´t work...?)

  <?php       
  
  	//Söker funktionär med namn       
  		if(isset($sok)){                 
  		$query = "SELECT * FROM funktionarer WHERE namn LIKE '%$namn%'";          
  		$result = mysql_query($query);          
  
  	if(!$result){                
  		echo "<div class=tabell4><table><tr><td>Funktionären kunde inte hittas. MySQL rapporterar: " . mysql_error() ."</td></tr>";             
  		echo "</table></div>";          }          
  
  	else {             
  		$line = mysql_fetch_assoc($result);             
  		$s_namn = $line['namn'];             
  		$s_adress = $line['adress'];             
  		$s_postnr = $line['postnr'];             
  		$s_ort = $line['ort'];             
  		$s_tel = $line['tel'];             
  		$s_email = $line['email']; 

	<form method="post" action="<?=$PHP_SELF?>">   
	<table><tr>       
	td width="128" class="text_12">Namn</td><td width="131"><input type="text" name="namn" size="22" value="<?=$s_namn?>" /></td></tr>     
	<tr><td class="text_12">Adress</td><td><input type="text" name="adress" size="22" value="<?=$s_adress?>" /></td></tr>     
	<tr><td class="text_12">Postnr</td><td><input type="text" name="postnr" size="20" value="<?=$s_postnr?>" /></td></tr>     
	<tr><td class="text_12">Ort</td><td><input type="text" name="ort" size="20" value="<?=$s_ort?>" /></td></tr>     
	<tr><td class="text_12">Telnr</td><td><input type="text" name="tel" size="20" value="<?=$s_tel?>" /></td></tr>     
	<tr><td class="text_12">E-mail</td><td><input type="text" name="email" size="20" value="<?=$s_email?>" /></td></tr>
	<tr><td class="text_12"> </td><td> </td></tr>
	<tr><td class="text_12"><input class="skicka_knapp3" type="submit" name="sok" value="Sök funktionär" /></td><td> </td>
	</tr> </table> 		
	</form>         
	}       
}   

   // Stänger anslutningen till vår databas        
    mysql_close($connection);  
?>

[citricsquid]

  <?php       
  
     //Söker funktionär med namn       
        if(isset($sok)){                 
        $query = "SELECT * FROM funktionarer WHERE namn LIKE '%$namn%'";          
        $result = mysql_query($query);          
  
     if(!$result){                
        echo "<div class=tabell4><table><tr><td>Funktionären kunde inte hittas. MySQL rapporterar: " . mysql_error() ."</td></tr>";             
        echo "</table></div>";          }          
  
     else {             
        $line = mysql_fetch_assoc($result);             
        $s_namn = $line['namn'];             
        $s_adress = $line['adress'];             
        $s_postnr = $line['postnr'];             
        $s_ort = $line['ort'];             
        $s_tel = $line['tel'];             
        $s_email = $line['email']; 
      ?>

      <form method="post" action="<?=$PHP_SELF?>">   
      <table><tr>       
      td width="128" class="text_12">Namn</td><td width="131"><input type="text" name="namn" size="22" value="<?=$s_namn?>" /></td></tr>     
      <tr><td class="text_12">Adress</td><td><input type="text" name="adress" size="22" value="<?=$s_adress?>" /></td></tr>     
      <tr><td class="text_12">Postnr</td><td><input type="text" name="postnr" size="20" value="<?=$s_postnr?>" /></td></tr>     
      <tr><td class="text_12">Ort</td><td><input type="text" name="ort" size="20" value="<?=$s_ort?>" /></td></tr>     
      <tr><td class="text_12">Telnr</td><td><input type="text" name="tel" size="20" value="<?=$s_tel?>" /></td></tr>     
      <tr><td class="text_12">E-mail</td><td><input type="text" name="email" size="20" value="<?=$s_email?>" /></td></tr>
      <tr><td class="text_12"> </td><td> </td></tr>
      <tr><td class="text_12"><input class="skicka_knapp3" type="submit" name="sok" value="Sök funktionär" /></td><td> </td>
      </tr> </table>       
      </form>         
     <?php
      }       
   }   
   
   // Stänger anslutningen till vår databas       
    mysql_close($connection); 
   ?>

[gevensen]

i think it would be for example not

 

value="<?=$s_namn?>" 

 

but

 

value="<?php echo $s_namn; ?>" 

[citricsquid]

i think it would be for example not

 

value="<?=$s_namn?>" 

 

but

 

value="<?php echo $s_namn; ?>" 

 

If the server supports it then <?=... is a workable replacement for <?php echo... albeit bad practice.

[beginann]

Now I have tried both examples, but nothing will appear in my form. I will talk to my webhotel and ask if the server support this or if there is a problem there.