Populating Text Field with Data from Mysql Database with PHP

Question

I am trying to populate a text field with data from a MySQL database, but my code seems to not be working.

Any help would be greatly appreciated.

Heres the code:

<?php include ("../config.php");

// Connect to server and select database.
mysql_select_db($db, $con);

// get value of id that sent from address bar
$id = $_GET['ID'];


// Retrieve data from database
$sql="SELECT * FROM members WHERE id='$id'";
$result=mysql_query($sql);

echo '<form name="Edit" method="post" action="update.php">

<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td align="center"><strong>Name:</strong></td>
<td align="center"><strong>Contact:</strong></td>
<td align="center"><strong>Division:</strong></td>
<td align="center"><strong>Rank:</strong></td>
</tr>';
            while ($row = mysql_fetch_assoc($result))
            {
            //we will echo these into the proper fields

        echo '<tr>';
        echo '<td align="center"><input name="Name" type="text" id="Name" value="'; echo $row['Name']; echo '"></td>';
        echo '<td align="center"><input name="Contact" type="text" id="Contact" value="'; echo $row["Contact"]; echo'" size="15"></td>';
        echo'<td>
        <select name="Divison">
        <option value="L4D2">L4D2</option>
        <option value="CSS">CSS</option>
        <option value="GMOD">GMOD</option>
        <option value="TF2">TF2</option>
        </select>
        </td>
        <td>
        <select name="Rank">
        <option value="Division Leader">Division Leader</option>
        <option value="Admin">Administrator</option>
        <option value="Member">Member</option>
        </select>
        </td>
        </tr>';


echo '<tr>';
        echo '<td align="center"><input type="submit" name="Submit" value="Submit"></td>
        </tr>
</table>
</td>
</form>';
}
echo '
</tr>
</table>
</body>
</html>';


// close connection
mysql_close();

?>

Vaibhav Gupta · Accepted Answer · 2011-09-15 19:59:22Z

edited my answer with full fixes:

<?php include ("../config.php");

// Connect to server and select database.
mysql_select_db($db, $con);

// get value of id that sent from address bar
$id = $_GET['ID'];

// Retrieve data from database
$sql="SELECT * FROM members WHERE id='$id'";
$result=mysql_query($sql);

echo '<form name="Edit" method="post" action="update.php">
            <table width="400" border="0" cellspacing="1" cellpadding="0">
                <tr>
                    <td align="center"><strong>Name:</strong></td>
                    <td align="center"><strong>Contact:</strong></td>
                    <td align="center"><strong>Division:</strong></td>
                    <td align="center"><strong>Rank:</strong></td>
                </tr>';
while ($row = mysql_fetch_assoc($result)) {
    //we will echo these into the proper fields

    echo '<tr>
                <td align="center"><input name="Name" type="text" id="Name" value="'.$row['Name'].'"></td>
                <td align="center"><input name="Contact" type="text" id="Contact" value="'.$row["Contact"].'" size="15"></td>
                <td>
                    <select name="Divison">
                        <option value="L4D2">L4D2</option>
                        <option value="CSS">CSS</option>
                        <option value="GMOD">GMOD</option>
                        <option value="TF2">TF2</option>
                    </select>
                </td>
                <td>
                    <select name="Rank">
                        <option value="Division Leader">Division Leader</option>
                        <option value="Admin">Administrator</option>
                        <option value="Member">Member</option>
                    </select>
                </td>
            </tr>';
}
echo     '<tr>
                <td colspan="4" align="center"><input type="submit" name="Submit" value="Submit"></td>
            </tr>
           </table>
        </form>';

// close connection
mysql_close();
?>

now replace whole coding with this one and reply...??

value="'.$row['Name'].'" this does not work for me, i am trying to populate a text field with value in a column of my result, this is what i did <p>First Name: <input type="text" name="fname" value="'.$row['firstname'].'" required /></p>

Bruce · Accepted Answer · 2011-09-15 19:31:55Z

0

Just a guess but I think your column names in the db would be all lower case. But in your php you have $row["Contact"]. I think it should be $row["contact"]

answered Sep 15, 2011 at 19:31

Bruce

1,53813 silver badges17 bronze badges

1 Comment

Puzzledplane Over a year ago

Thanks, but I double checked the cases.

Jay · Accepted Answer · 2011-09-15 19:54:10Z

0

Make sure you use a querystring with a legitimate ID like example.com?ID=1. If you are posting a form and the post method for the form is post, you should use $_POST['ID'] instead of $_GET['ID'].

answered Sep 15, 2011 at 19:54

Jay

11 bronze badge

1 Comment

Puzzledplane Over a year ago

Thanks. Tried changing it to POST and still does not work. Also it is a legitimate ID.

Rahul Kanodia · Accepted Answer · 2011-09-15 20:08:04Z

0

This code:

$sql="SELECT * FROM members WHERE id='$id'";

should be like this

$sql="SELECT * FROM members WHERE id='{$id}'";

Also use

$result=mysql_query($sql) or die(mysql_error());

For debugging purpose.

Remove mysql_close() and it should work

edited Sep 15, 2011 at 20:08

answered Sep 15, 2011 at 19:34

Rahul Kanodia

10512 bronze badges

1 Comment

Puzzledplane Over a year ago

Thanks. Added these for syntax.

thegaffney · Accepted Answer · 2011-09-15 20:20:43Z

0

From previous comments, the id in your url is lower case change $_GET['ID'] to $_GET['id']

Im I allowed to do this? Keeps other people with problem from having to read all the comments

New to this site, thanks!

answered Sep 15, 2011 at 20:20

thegaffney

4403 silver badges10 bronze badges

Collectives™ on Stack Overflow

Populating Text Field with Data from Mysql Database with PHP

5 Answers 5

1 Comment

1 Comment

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

1 Comment

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related