Printing code as text.

billcoker

Hi all,

I am trying to print some code from a mysql db table on the page without it getting parsed.

The code I am using follows:
.....................................
<?php
$string = '

This will be printed on the screen even if
it is code. i.e.

<?php echo "hi all";

$string = '<?php'.$string.'?>';
highlight_string($string);
?>

.................................

The code works perfectly. But what I can't figure out is how to get the row into the code.

<?php'.$string.'?> prints the text. How can I get a table row say "$code" into

$string = '
$code
';

With out it just printing the my echo statement?

I hope this makes sense.

Thanks,

Bill

mad4you

hi!

i'm not really understanding your question (give us another try?), but the following should work:

i suppose you have php-code-snippets stored in your db and would like it to print out to the browser?

let's assume that $dbData contains the php-code you'd like to print, it should work this way:

<?
echo htmlentities($dbData);
?>

any special-characters are being parsed and replaced by their html-entities - '>' gets '>' and so on.

i think this way it's impossible to conflict in any way with the php-interpreter.

gruzz
mario

Anon

on a general note. MOST setups for php come with a special file extention.

.phps or php-source.

it's the same coloring scheme that the articles here use. just put you code in a file "code.phps" and view that to get the code to paste in your website.

it'll be colored and all that jaz. takes all the work out of it.

billcoker

Mario,

That works perfectly! Now I will try to get the color.

Bill.

billcoker

James,

Yes works great. I will just make combination of both to get the results I need.

Thanks. Very helpfull.

Bill.

billcoker

Hi,

Ok. Now that we have that straight I am having trouble with getting the code to display from my query. It keeps telling me no data.

Here is my code i am using:

include ('includes/config.php');
mysql_connect($DBHost,$DBUser,$DBPass) or die ("Problem connecting to DataBase");
$query = "SELECT * FROM codedata where id='6'";

$result = mysql_db_query($DBName, $query);
if ($result) {
while ($r = mysql_fetch_array($result)) {
$desript = $r["desript"];

$desript ='$desript';
echo htmlentities($dbData);

}

} else {
echo "No data.";
}
mysql_free_result($result);

There are 2 records in the $descript. Do I have something backwards here?

Thanks. Bill.

killswytch

Is there an actual item corresponding to the id of 6?