How to save inputs wihtout html tags in mysql database?

Question

The problem is after inserting into the database, the html tags like p,h2 etc. is there together with the user's input.

I tried the php function mysqli_real_escape_string but it doesn't work. The html tags are still in the db.

<script src="tinymce/tinymce.min.js"></script>
<?php 
include 'connection.php';

if(isset($_POST['submit'])){
    $msg = mysqli_real_escape_string($conn, $_POST['msg']);
$sql = mysqli_query($conn, "INSERT INTO messages(msg) VALUES('$msg')");
}
?>
    <form action="" method="post">
        <textarea name="msg" id="editor">   </textarea>
        <input type="submit" name="submit" value="Submit">
    </form>

    <script>
        tinymce.init({
  selector: 'textarea#editor',
  auto_focus: 'element1',
  width: "200",
  height: "200"
});
</script>

I want is after saving the inputs there is no html tags in the database.

strip_tags() ? ... though, why implement TinyMCE (a WYSIWYG editor) if you don't want HTML in the system (there's nothing inherently wrong with having HTML in the database btw)? You should also look at prepared statements with bound parameters. — CD001
– CD001, Commented Feb 5, 2019 at 14:44
It might be a good addition to keep the breaks str_replace("<br>", "\n", $_POST['msg']) before calling strip_tags() — KHansen
– KHansen, Commented Feb 5, 2019 at 14:48

mighty_dev · Accepted Answer · 2019-02-05 14:44:48Z

2

Use strip_tags() function.

<?php

$msg = strip_tags($msg);

answered Feb 5, 2019 at 14:44

mighty_dev

17.8k3 gold badges24 silver badges39 bronze badges

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

Comments

CoursesWeb · Accepted Answer · 2019-02-05 14:45:20Z

1

If you want to remove the html tags, you can use strip_tags().

$_POST['msg'] = strip_tags($_POST['msg']);

answered Feb 5, 2019 at 14:45

CoursesWeb

4,2573 gold badges24 silver badges27 bronze badges

Collectives™ on Stack Overflow

How to save inputs wihtout html tags in mysql database?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related