如何使用textarea更新日期

Question

Need some help here. I am trying to update my date in my database using textarea. At first, I get the date from my database and post it in the textarea. But now I am trying to change the date by editing the date in the text area.

Here is my query.

$sql=mysqli_query($con,"UPDATE tblevent SET title='".$_POST['title']."' , 
eventdate='".$_POST['datee']."' body='".$_POST['body']."' , 
timestart='".$_POST['begtime']."' , timeend='".$_POST['endtime']."' WHERE 
eventid='".$_POST['id']."'" ) or mysqli_error(die($con));

eventdate='".$_POST['datee']."' is always getting an error

"Catchable fatal error: Object of class mysqli could not be converted to string"

here is my textarea

<?php echo "Date: <textarea name='datee' rows=1 cols=25>".$rows['eventdate']."</textarea>"; ?>

Answer 1

You have missed a comma in this line

eventdate='".$_POST['datee']."' body='".$_POST['body']."'

it should be,

eventdate='".$_POST['datee']."', body='".$_POST['body']."'

Furthermore its better to use mysql_escape_string() for each user input to avoid sql injection, rather than directly concatenating POST variables to SQL query string.