Php wont echo html from database

Question

$stmtcon = $mysqli->prepare("Select content From tblcontent Where contentid =?");
$stmtcon->bind_param('s', $loadcontent);
$stmtcon->execute();
$stmtcon->bind_result($htmlcontent);
$stmtcon->fetch();
$stmtcon->close();

echo $htmlcontent;

The code works perfectly on my computer, but wont echo on the server I use. If i do an isset on the htmlcontent it comes back as true. Every other element on the page loads.

Is there anything in the settings, security wise that could be blocking this echo? the content contains html.

Thanks.

edit - I changed the type of the field to text from longtext, is there any reason why longtext wouldnt work, thanks for replies already ^_^

Make sure it is connecting correctly to the mysql server, and check for mysql errors. — John V.
– John V., Commented May 13, 2012 at 20:47
You could do var_dump($htmlcontent)to see exactly what is in $htmlcontent. — Zombaya
– Zombaya, Commented May 13, 2012 at 20:54
Thanks for the suggestions, the variable htmlcontent was holding nothing, I changed the field type from longtext to text and it works now, so for some reason longtext wont work, It's fixed but does anyone know why longtext wouldnt work? — PaulPaul
– PaulPaul, Commented May 13, 2012 at 21:07
Can it be something related with buffering? Can you put a $stmtcon->store_result() before the bind_result and try? — Ander2
– Ander2, Commented May 13, 2012 at 21:30

Ander2 · Accepted Answer · 2012-05-14 06:29:01Z

1

Can it be something related with buffering? Can you put a $stmtcon->store_result() before the bind_result and try?

answered May 14, 2012 at 6:29

Ander2

5,6682 gold badges25 silver badges45 bronze badges

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

Collectives™ on Stack Overflow

Php wont echo html from database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related