html entities

[Acute]

When I insert "<b>dog</b>" into database using php, it inserts empty string.
WHY???

How to fix it?

thnx in advance

[Shanti C]

check this:
http://php.net/manual/en/function.htmlspecialchars.php

[Acute]

ok... actually I knew that it is html entity, but the problem is how to save such converted string in database?

[Acute]

Say user makes new post and the post is "<b>dog</b>", so my script as usual is gonna save it in db, but it saves "".

[Shanti C]

i tried this query , is working for me:

insert into  `test` values('<b>dog</b>');

or else post your query.

[Acute]

when i do it directly with phpMyAdmin or console, the insertion is ok, however when via php it inserts nothing...

[Shanti C]

ya, then please post post your query,
it may be because of quotes in your query.

[Shanti C]

this code works for me:

<?php 
$str='&lt;b&gt;dog&lt;/b&gt;';
$str=htmlentities($str);
echo $q="insert into test values('$str')";
?>

[Acute]

I think I've found the problem but haven't found the solution yet: problem comes from the root - $_POST. If text sent from client is "<b>dog</b>", then $_POST is empty, that's why php was inserting empty string. But if normal text is sent from client everything goes ok...