Display data from sql database to a textbox

Question

I am performing a search of my sql database, and assigning the data from each row to a variable. Ex.

$query = mysql_query("SELECT * FROM  `PropertyInfo` WHERE  `sitestreet` LIKE  '$street'");
// display query results
while($row = mysql_fetch_array($query))
    {
        $sitestreet = $row['sitestreet'];
        $sitestate =$row['sitestate'];                           
    }

Now my question is how do I get that info to display as text in a text box?

Thanks!

note that if your not using left/right wild cards on the like statement like '%$street%' you may as well use where sitestreet = '$street' — Lawrence Cherone
– Lawrence Cherone, Commented May 13, 2011 at 16:00

mellamokb · Accepted Answer · 2011-05-13 15:57:23Z

2

By echoing a textbox with those variables in the value="" attribute

echo "<input type='text' id='sitestreet' value='$sitestreet' />"
echo "<input type='text' id='sitestate' value='$sitestate' />"

answered May 13, 2011 at 15:57

mellamokb

56.8k12 gold badges111 silver badges138 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

eykanal · Accepted Answer · 2011-05-13 15:57:35Z

1

It's as simple as:

<input value='<?php echo $sitestreet; ?>'>

answered May 13, 2011 at 15:57

eykanal

27.2k19 gold badges86 silver badges114 bronze badges

Comments

SIFE · Accepted Answer · 2011-05-13 16:00:59Z

0

You can fetch and assign in some time:

while($row = mysql_fetch_array($query))
    {
      echo "<input type='text' id='sitestreet' value='$row['sitestreet']' /><br />
            <input type='text' id='sitestate' value='$row['sitestate']' />";                      
    }

answered May 13, 2011 at 16:00

SIFE

5,7537 gold badges34 silver badges48 bronze badges

Collectives™ on Stack Overflow

Display data from sql database to a textbox

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related