更新textarea上的mysql表模糊？

Question

i am trying to make a text area update the information in a table in mysql when the user clicks out the text area. can someone guide me in the right direction please. This is what i have so far. im not getting any errors, but when i update it the changes arnt saving.

HTML CODE

    <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post">

<textarea id="title" textarea name="title" rows="10" style="width: 456px; 
    margin-top:3px;
    text-align:left;
    margin-left:-2px;
    height: 120px;
    resize: none; 
    border: hidden;" data-id='$idbio'><?php echo $profile['bio'] ?> </textarea>
</form>

Javascript code

<script type="text/javascript">

$('textarea').on('blur',function () {
    var titleVal = $(this).val(), id = $(this).data('id');        

    $.ajax({
         type: "POST",
         url: "changebio.php",
         data: {title:titleVal , id:id},
         success: function(msg) {
             $('#'+id).html(msg);
         }
   })
});

</script>

changebio.php

 <?php
require_once("session.php"); 
require_once("functions.php");
require('_config/connection.php');
update_profilebio ();
header('Location: http://www.something.com/confirm.php');
?>

function.php

 function update_profilebio() {
            global $connection;
            global $profile_id;
            $query = "UPDATE ptb_profiles
                      SET bio='value'
                        WHERE ptb_profiles.user_id = \"$profile_id\"
                        AND ptb_profiles.user_id = ptb_users.id";
            $update_profilebio_set = mysql_query($query, $connection);
            confirm_query($update_profilebio_set);
            return $update_profilebio_set;

            }

Answer 1

Why are you using "on" method?? You could just do this: "$('textarea').blur(function(){...});", and i don't know what does the "data" method that you used here: "$(this).data('id')", when i want to get a id in my node i just to this: "$(this).attr('id');", and another thing, you get the string from textarea in the first time with the method "val()", and after that, you try to put a string with "html()", there is something wrong with that.