Returning db query results to the form of origin?

Forum Moderators: coopster

Message Too Old, No Replies

Returning db query results to the form of origin?

can this be done in PHP?

otto_man

9:58 am on Jul 31, 2003 (gmt 0)

I would like to submit a database query from a form and have the data returned to that same form and displayed in the appropriate text fields, select boxes, etc. Is this possible using PHP?

Matt_James

1:22 pm on Jul 31, 2003 (gmt 0)

<input name="text" type="text" value="<? echo$var;?>">
would do text fields

This code would select day 4 in a select field of 1-31 days,
having used getdate()

<?
$aday=4;
$day=1;
while($day <32){
if($aday==$day){ $select=" selected"; }
echo"<OPTION value=\"$day\" ".$select.">".$day."</OPTION>\n";
$day++;
$select="";
}
?>

coopster

3:48 pm on Jul 31, 2003 (gmt 0)

You sure can. It's quite a common practice:


<?php 
if ($_POST['submitbutton']) { 
 your processing statements here; 
} 
#display the form again: 
?> 
<html> 
<head> 
</head> 
<body> 
<form method="post" action="<?php print $_SERVER['PHP_SELF'];?>"> 
<?php 
$rows = mysql_query("SELECT * FROM tablename"); 
while ($row=mysql_fetch_array($rows)) { 
 print "<input type=\"text\" name=\"name\" value=\"$row['value']" /> 
} 
?> 
</body> 
</html>