Re: [PHP-DB] re:store html codes in text field (mysql)

mrfroasty wrote:
> Sorry if this has been asked before but I cant seem to find anything
> useful via google......
> I have a text fields which stores my textarea input from a user, my
> design is meant to allow user to submit html codes...but mysql seem to
> replace all html tags with something else...
> 
> Example:
> $title="some text";
> $html_code=<h1>heading 1</h1>
> 
> INSERT INTO $db_table VALUES(null,'$title','$html_code')";
> 
> Result in my dB:
> 1]some text
> 2]&lt;h1&gt;heading &lt;h1&gt;
> 
> How can I solve this problem of mysql replacing the html tags.....?This
> is probably something familiar to webdev, but I am kind of a noob in web
> programming...

mysql is 100% not doing it. If you did that manually in mysql, you would 
get the right results.

mysql> create table test (html text);
Query OK, 0 rows affected (0.01 sec)

mysql> insert into test(html) values ('<h1>heading 1</h1>');
Query OK, 1 row affected (0.00 sec)

mysql> select * from test;
+--------------------+
| html               |
+--------------------+
| <h1>heading 1</h1> |
+--------------------+
1 row in set (0.00 sec)

You have a htmlspecialchars or htmlentities call between $html_code 
being set and where you're doing the insert.

> N:B
> The only way I can think of is replacing them after pulling them out of
> the dB, but I am not sure if this is the way to go...

See http://au.php.net/manual/en/function.html-entity-decode.php

-- 
Postgresql & php tutorials
http://www.designmagick.com/