store php and html in mysql

**sarahmx** · 02-22-2010, 11:27 AM

Hi,

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 is not displaying correctly when i call it

PHP Code:


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

PHP Code:


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

let say i want to paste this..

PHP Code:


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

this is just an example..the actual code that i want to paste is a bit long

the code is change to

PHP Code:


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

in database

in browser it is display like this

Code:

\'; ?>

Help !!

Thank you in advance

**sarahmx** · 02-22-2010, 12:34 PM

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 ?

**traq** · 02-22-2010, 03:24 PM

html is easy (just addslashes() to insert, stripslashes() when you pull it out). php is more complicated. There is a function called serialize() that will convert your php into a storable string, then you would unserialize() it when you pull it back out. But it's still just a string; so you'd have to use eval() to parse it as php code (which can be a security risk if you're dealing with user-submitted content in any way).

php code is *much* easier to store in an external file. Take whatever chunk of code you want to store and just put it in a separate file and include() it whenever you need.

As for generating the file, it sounds to me like you're trying to create a php template. For example, your template would look like:
template.php

PHP Code:


<html>
  <head>
    <title><?php echo $title; ?>
  </head>
  <body>
    <h1 id="header">Welcome to my site</h1>
    <div id="welcome"><h2><?php echo $title; ?></h2>
      <?php echo $welcomeArticle; ?>
    </div>
  </body>
</html>

and you would define the content like so:
webpage.php

PHP Code:


<?php
$title = "Page title";
$welcomeArticle = "Hello world, welcome to my website's home page!";
include("/path/to/template.php");
?>

**sarahmx** · 02-22-2010, 04:16 PM

thanks traq, you gave me a clear idea on how to implement this..

**sarahmx** · 02-22-2010, 04:35 PM

As for generating the file, it sounds to me like you're trying to create a php template.

Yes something like that...

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

**traq** · 02-22-2010, 08:44 PM

so...

you want to input title/content/etc. into a form on a webpage
have the script generate a page, based on the template, using your info
?

do you want the page to be saved on the server (so anyone can visit it) or do you just want the page to be generated and served to you (gone after you leave)?

the answer is yes, either way. Saving the file to your server will be more complicated, you'll have to fix write permissions, etc., and I would *definitely* add security measures - otherwise, anyone could write anything they like to your website. Read up on php filesystem functions.

Thread: store php and html in mysql

Thread Tools

Search Thread

store php and html in mysql

The Following User Says Thank You to traq For This Useful Post:

Bookmarks

Bookmarks

Posting Permissions