How do you retrieve data stored in the database into the textarea using PHP?

Answer 1

<?php

// Connect to the database

$link = mysql_connect('localhost', 'mysql_user', 'mysql_password') or die('Could not connect: ' . mysql_error());

mysql_select_db('foo', $link) or die('Can\'t use foo : ' . mysql_error());

// Retrieve the content

$sql = "SELECT my_info FROM my_table WHERE id = '42';

$result = mysql_query($sql,$link);

// Now assign a value

$row = mysql_fetch_assoc($result);

// "Wrap" the result in a textarea

echo '<textarea name="bob" rows="10" cols="40">';

echo $row["my_info"];

echo '</textarea>';

?>

... this will work for a single value retrieved from a single row. For a more in depth look at retrieving values from a DB visit:

http://au2.php.net/manual/en/function.mysql-query.php

For a complete textarea reference, visit:

http://www.w3schools.com/tags/tag_textarea.asp

Hope that helps

Answer 2

You can retrieve data from a database and display it in a textarea using PHP by executing a query to fetch the data from the database, then echoing the retrieved data within the value attribute of the textarea element. Make sure to properly sanitize the data to prevent SQL injection or other security vulnerabilities.