Editing html stored in mysql

Question

Im storing some html code in a mysql database . This code is then displayed on the page .

I have setup an editor where a user can edit the code and save it back to the database . This updates the page.

The problem im having is that when its updated , it deletes parts each time.

mysql:

mysqli_query($connection, "UPDATE website_text SET home = '".$_POST['home']."'");

editor:

<textarea class="form-control" name="home" id="home" value="<?php echo $data['home']; ?>" required></textarea>

you need a where clause, otherwise it will update EVERYTHING in your table — Funk Forty Niner
– Funk Forty Niner, Commented May 11, 2015 at 13:01
yh , the type is text . should the Collation be anything specific? — Jess
– Jess, Commented May 11, 2015 at 13:02
the value of a textarea should be between the tags, a textarea doesn't have a value attribute. e.g. <textarea><?php echo $data['home']; ?></textarea> — steven
– steven, Commented May 11, 2015 at 13:02

Blaatpraat · Accepted Answer · 2015-05-11 13:11:13Z

3

A textarea does not have a value property... You need to put the content of it in it:

<textarea class="form-control" name="home" id="home" required><?php echo $data['home']; ?></textarea>

edited May 11, 2015 at 13:11

answered May 11, 2015 at 13:01

Blaatpraat

2,84913 silver badges23 bronze badges

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

7 Comments

Funk Forty Niner Over a year ago

true, but that's only 50% of the issue

Blaatpraat Over a year ago

True that, the other part requires more user input.

Jess Over a year ago

Thanks . Whats the other 50% of the issue?

Funk Forty Niner Over a year ago

@Jess other 50%.... Read up on UPDATE dev.mysql.com/doc/refman/5.0/en/update.html

Blaatpraat Over a year ago

In that case, this is valid (except for the possibility of SQL injection, XSS and such vulnarabilities). I wouldn't recommended working like this (what if you need more pages? A table altering is never recommended!), but your problem is solved... For now.

|

Collectives™ on Stack Overflow

Editing html stored in mysql

1 Answer 1

7 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Linked

Related