How can I keep HTML styling in a php form storing data in MySQL?

Question

so I have a box where a user enters some data "a description" and it stores in MySQL. However, html tags such as <img src="">, <a href="">, etc. do not store there in the 'description' field. How can I allow certain HTML codes to be passed through to MySQL?

This is what the description input box looks like:

<?=form_textarea(
    'description',
    $Channels->description,
    'class="field" style="width:306px; height: 70px; margin-left:5px;"'
)?>

This is where the form gets passed:

$this->form_validation->set_rules(
    'description',
    lang('user_edit_channel_description'),
    'trim|required|strip_tags|xss_clean'
);

And then posted to MySQL here:

$rows['description'] = $this->input->post('description');

possible duplicate of How to use strip_tags with second parameter in CodeIgniter? — mellamokb
– mellamokb, Commented Oct 13, 2011 at 5:10
MayBe that link helps you out. php.net/manual/en/function.strip-tags.php — Mohit Bumb
– Mohit Bumb, Commented Oct 13, 2011 at 5:41

mellamokb · Accepted Answer · 2011-10-13 05:14:52Z

1

You will need to use the form of the strip_tags function with the second parameter, which allows you to specify which HTML tags are allowed. As explained in this post, you need to create a callback function to call because the two-parameter version of strip_tags cannot be directly used in set_rules(.

answered Oct 13, 2011 at 5:14

mellamokb

56.9k12 gold badges111 silver badges138 bronze badges

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

Comments

Edoardo Pirovano · Accepted Answer · 2011-10-13 05:12:33Z

1

You'll want to get rid of strip_tags from the validation rules, since that removes all HTML tags. Or, ever better, call the function separately using a second parameter to define what tags you want to allow.

answered Oct 13, 2011 at 5:12

Edoardo Pirovano

8,3543 gold badges28 silver badges32 bronze badges

Collectives™ on Stack Overflow

How can I keep HTML styling in a php form storing data in MySQL?

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