html - Issues with PHP INSERT form -

html - Issues with PHP INSERT form -

so i'm trying php code display textarea , submit button user can submit bio gets inserted db. have few issues code:

for reason, text area filled actual form html instead of blank box, shows as:

class="lang-html prettyprint-override"><form action='page-bio.php' method='post'> <textarea name='author_bio' value=<input type='hidden' name='hidden' value= <input type='submit' name='update' value=update </form>.

i'm using wordpress, php template, wondering if code current user , insert user's bio user's bio field in database? have feeling won't, can't tell because still can't submit button display.

class="lang-php prettyprint-override"><?php $con = mysql_connect("localhost","xxxx","xxxx"); if (!$con){ die("can not connect: " . mysql_error()); } mysql_select_db("i5412",$con); // current user's info $current_user = wp_get_current_user(); if(isset($_post['update'])){ $updatequery = "update wp_usermeta set author_bio='".$_post['author_bio']."'where user_id=$current_user , author_bio='".$_post['hidden']."'"; mysql_query($updatequery, $con); } $sql = "select * wp_usermeta"; $mydata = mysql_query($sql,$con); while($record = mysql_fetch_array($mydata)){ echo "<form action='page-bio.php' method='post'>"; echo "<textarea name='author_bio' cols='10' rows='10' value=" . $record['author_bio']; echo "<input type='hidden' name='hidden' value=" . $record['author_bio']; echo "<input type='submit' name='update' value=update"; echo "</form>"; } mysql_close($con); ?>

you need alter next lines:

echo "<textarea name='author_bio' cols='10' rows='10' value=" . $record['author_bio']; echo "<input type='hidden' name='hidden' value=" . $record['author_bio']; echo "<input type='submit' name='update' value=update";

to

echo "<textarea name='author_bio' cols='10' rows='10'>" . $record['author_bio'] . "</textarea>"; echo "<input type='hidden' name='hidden' value='" . $record['author_bio']. "'>"; echo "<input type='submit' name='update' value='update'>" ;

php html wordpress