[sarahmx]

how do i properly store my php and html code in mysql ?

ok i have text area and i would paste my php and html code inside the text area and then insert it to table

i use this but the code ($content) is not display correctly when i call it other page

PHP Code:

<textarea rows='6' cols='40' name='content'></textarea> 

PHP Code:

 $content = mysql_real_escape_string(htmlspecialchars($_POST['content'])); 

i have read about eval but did not really understand it


how to use it ?
let say i want to paste this

PHP Code:

<?php echo 'hello world<br>'; ?>

the code is change to

PHP Code:

<?php echo \'hello world<br>\'; ?>

in database

in browser it is display like this

Code:

\'; ?>

p/s :move this topic if this is not suitable here

Thank you in advance

[wirehopper]

Try storing just HTML, no PHP.

In you example above, it would be:

hello world<br>

[sarahmx]

the hello world is just an example

the actual php code i want to paste is different...(a bit long)

[wirehopper]

I don't think storing PHP in the database is a good idea. If you want to extract it from the database, then execute it, you can use the eval function.

What are you trying to do?

[sarahmx]

i don't know if this possible, what i'm trying to do with a help from a friend is a simple SEO content generation script... a page will pull data content from my database

we will input file name, page title, meta keywords/description and content (lot of text and some php coding) in admin side

and then automatically generate a php file based on the data from the database in a choosen web server folder with the $filename * php

i'm stuck with

1. how to add content (html & php) to the database
2. how to generate the file


what is the best way to do this...

any simple use of eval ?

[wirehopper]

Don't put PHP in the database. Store keywords in the database, and write them into the HTML when it's delivered.

PHP Code:

<?php

$s='';

echo '<meta name="keywords" content="';

foreach ($keywords as $k => $v)

  $s.=$v.',';

$s=substr($s,0,-1);

echo $s.'" />';

?>

Not tested.

Don't spend too much time on keywords - the search engines rely more heavily on the site content.

[sarahmx]

Thank you wirehopper, got some idea to implement this

for html i use addslashes() to insert, stripslashes() to pull the data from database

for php i will put it in external file and just use include

i've learned a lot today......thanks :-)

[sarahmx]

is it possible i would like if i click submit/save the form a file is generated/created automatically in server based on a template define and named with the name that i input for filename....

[wirehopper]

Are you building a CMS? If so - you might want to check some of the existing solutions - The CMS Matrix - cmsmatrix.org - The Content Management Comparison Tool