CODEWITHSUNDEEP
phphtmlmysql
Darren Griffin
Darren Griffin

Reputation: 41

PHP variable with HTML formatting

Here is my variable that I am actually getting from my MySQL Database:

<h1>This is a H1</h1>
<p>NOT BOLD</p>
<p>&nbsp;</p>
<p><strong>BOLD</strong></p>

I am using TinyMCE to format the code.

Here is how I echo it

<?php 
// WHILE LOOP GETTING $ROW FROM MYSQL
$conContent = $row['content'];

Then, when I go to the page, it displays the output like this... http://i.snag.gy/BbMqx.jpg

I want the variable to make the echo formatted. So like then it will have all the html formatting.

Upvotes: 3

Views: 1593

Answers (2)

Langdi
Langdi

Reputation: 229

Can you check the HTML source of the output? Is the HTML still around? It looks like strip_tags() or HTMLPurifier removes your HTML. Otherwise you would either see the formatting applied or the tags in the output.

If you have HTML code in your database you don't have to do anything with it in PHP, but can directly print it.

Upvotes: 1

Amal Murali
Amal Murali

Reputation: 76666

You can insert your variable inside the <strong> tags using the following method:

<?php     
/* getting row from your table */    
$conContent = $row['content'];    
?>
<strong> <?php echo $conContent; ?> </strong>

Another solution is:

$conContent = $row['content'];
echo "<strong>" . $conContent . "</strong";
//or echo "<strong> $conContent </strong";

If the styles are to be applied to all the rows, then you could use a foreach loop:

foreach($row as $v) {

echo "<strong>$v</strong";

}

Note: This assumes that you've the mysql array result stored in a variable called $row.

It's not just for <strong tags. You can use <h1>, <p>, <div> -- it doesn't matter. PHP will output the variable content in the location you specify.

Hope this helps!

Upvotes: 2

Related Questions