PHP Forum

**SpottyDog** · 05-16-2005, 06:56 PM

Hi,

I have made a script to send a message to an sql database and then retrieve it again on my homepage. The trouble i am having is that i am inserting html into the database and when i echo it onto my homepage it echo's out the html instead of using it.

Eg. instead of it saying TEXT HERE
it says <b>TEXT HERE</b>

How do i solve this problem?

Thanks

**Uche** · 05-16-2005, 07:00 PM

paste your code in here with that i can help out..

**SpottyDog** · 01:57 PM

**Uche** · 05-16-2005, 07:22 PM

See if u really wanna retrive a data E.g say i have two forms Username and Age, wen user fill in those info. and i wanna retrieve that, i will rather say
<? echo_$POST["Username"];
echo_$POST["Username"];
?>

Then in that case use this code <?echo "$home1"; ?> text that

**SpottyDog** · 05-16-2005, 07:25 PM

yes but then the posted data wont stay on my home page untill it is updated right?

i want it to come from the database not from POST

**Uche** · 05-16-2005, 07:41 PM

It will wen using a form ok let check your code <?php
$sql = mysql_query("Select home From site"); <------

$sql = mysql_query("SELECT home From site") WHERE blah blah blash = blah blah

**SpottyDog** · 05-16-2005, 07:44 PM

ok i really dont understand at what your getting at here. I am still a noob at this lol. Can you construct the script that i should use to retrieve my data while keeping the formatting.

**leavethisplace** · 05-16-2005, 09:46 PM

ok then dude, i've never really seen this problem before, but i have a feeling it's just the way you're echoing it really.

At the moment you're not telling php to do anything to it, just echoing the data not the information. So let's tell PHP to wake the **** up. Try this:

[/PHP]<?php
echo("$home1");
?> [PHP]

Using those brackets and the quote marks makes all the difference. Also, you should have <?php at the beginning of all PHP encasing!

**SpottyDog** · 05-17-2005, 07:10 AM

no, im affraid this still doesn't work

Im sure somebody must of come accross this problem before?

**leavethisplace** · 05-17-2005, 07:17 AM

oh, have you actually made sure you've output HTML headers?? like <HTML><BODY> etc etc ??

**SpottyDog** · 05-17-2005, 07:23 AM

yes i those tags. The php that is getting the info is above the head and the echo bit is in the body

**SpottyDog** · 01:58 PM

**SpottyDog** · 05-17-2005, 12:37 PM

anyone????

**Uche** · 05-17-2005, 12:49 PM

So tell me now do you wanna retrive your data from your DATABASE.. from all wat u saying here i guess thats wat u wanna do. ??? huh ?

**0beron** · 05-17-2005, 01:00 PM

He said that in his first post I think.

SpottyDog, can you check the HTML source that reaches your browser? I'm guessing that what is actually in your database is along the lines of <b>TEXT HERE</b> .

Somewhere in your script to insert things into the database did you make use of the function htmlspecialchars() ? That will transform < int <, ' into " etc, and is a security thing so that people can't submit eg <SCRIPT> tags into your forms. What it means is that when you echo part of the database, the html entity (that's what < , > are) get's printed instead of interpreted as HTML.

You either need to store things away into your database differently, or map from the entities back to the characters manually. You can do this by writing:

PHP Code:


			


echo html_entity_decode($home1);

**SpottyDog** · 05-17-2005, 01:09 PM

0beron my friend, you are a legend!

It worked. I did see that in the source code when i checked it but wasnt sure how to fix it

Thankyou So Much