How to retrieve code from database with php ?

Question

I want to store HTML code in mysql database. If I want to store the following code into database

<html>
<body>
<p> this is a paragraph </p
</body>
</html>

they store as they are. But when I retrieve them and echo with php the tag get vanished. But I want to echo them as they are above. I also want to store and show not only HTML but other code (c,java,php) also. Anyone have any idea?

use htmlentities($whatever)

Mr. Alien
– Mr. Alien

2012-10-06 10:20:35 +00:00
Commented Oct 6, 2012 at 10:20 — Mr. Alien
– Mr. Alien, Commented Oct 6, 2012 at 10:20

StaticVariable · Accepted Answer · 2012-10-06 10:26:34Z

2

you can use htmlentities () php function to echo html codes

    $str = "
<html> 
 <body>
     <p> this is a paragraph </p
 </body>
</html>
";


echo htmlentities($str);

You can also use htmlspecialchars();

edited Oct 6, 2012 at 10:26

answered Oct 6, 2012 at 10:20

StaticVariable

5,2934 gold badges26 silver badges46 bronze badges

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

1 Comment

shanto Over a year ago

This is working. Do I do the same if I want to store other code like c or jave. Is there any problem to store c or java code in database directly? For storing HTML I am using mysql_real_escape_string(). Do I do the same for other code? Or is there any other procedure for storing other code? Thnx in advance.

Rick Kuipers · Accepted Answer · 2012-10-06 10:31:52Z

1

You can use htmlentities($str) for that, another nice thing to use is <pre></pre> Putting those tags around the code will preserve newlines, tabs and spaces. In case you want to showcase it.

answered Oct 6, 2012 at 10:31

Rick Kuipers

6,5972 gold badges19 silver badges37 bronze badges

Collectives™ on Stack Overflow

How to retrieve code from database with php ?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related