update multiple textarea into mysql db in php

Question

I have textarea in the UI which i display text inside it from db and the user edits it and clicks on update button.

while($row=$stmt->fetch(PDO::FETCH_NUM,PDO::FETCH_ORI_NEXT)){

<textarea  id= <?php echo $row5[0]; ?> name='upAncText[]' rows=1 cols=40> <?php echo $row5[1]; ?> </textarea><br/> 

}

Now when i click on update i have to read the id and texarea value inorder to insert into DB. could anyone let me know how to do this in php?

This is the subject of every basic PHP/mySQL tutorial. You might be better of systematically going through one of them, as there are some pitfalls to this (e.g. XSS attacks and SQL injection) — Pekka
– Pekka, Commented Nov 10, 2011 at 0:50

nickb · Accepted Answer · 2011-11-10 00:51:09Z

1

Change your textarea to something like this:

// Are you sure you want $row5 and not $row ?
<textarea name="upAncText[<?= $row5[0]; ?>]"></textarea>

Now, when you grab $_POST['upAncText'], it will be an array with keys that are the textarea ID and values that are the user input.

FYI, <?= ?> is shorthand for <?php echo ?>

answered Nov 10, 2011 at 0:51

nickb

59.7k13 gold badges115 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

update multiple textarea into mysql db in php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related