CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: Beginner:
Storing HTML in MySQL

 



musclehead
New User

May 8, 2008, 9:04 AM

Post #1 of 2 (158 views)
Storing HTML in MySQL Can't Post

I'm trying to store HTML in a MySQL DB via a Perl script. I'm far more fluent in PHP and I simply use the addslashes() function to "sanitize" the HTML for storage in a field. I can't seem to find an equivalent function in Perl - any ideas for a simple way to clean up the HTML code for storage and then output to a user as an HTML page?

Thanks!


winfinit
User

May 8, 2008, 2:45 PM

Post #2 of 2 (157 views)
Re: [musclehead] Storing HTML in MySQL [In reply to] Can't Post

you dont need to sanitize anything with DBI, DBI does that for you already, here is a quick example:
$mark = $dbh->prepare("update movies set status=? where uniqueid=?");
$mark->execute('D', $id);

so as you see i am just placing a ? inside my query and when i execute it i am defining variables there, by doing so, DBI will autoescape your characters, and insert data into DB.

hope that helps.

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives