SPUG: inserting content into mysql database

[Keith Reed]

Check out dbh->quote()

Keith








"luis medrano" <lmzaldivar at gmail.com> 
Sent by:
spug-list-bounces+keith.reed=philips.com at pm.org
2006-10-03 10:35 AM

To
spug-list at pm.org
cc

Subject
SPUG: inserting content into mysql database
Classification







List,

I running this code feeding a database:
my $sth1=$dbh->prepare("INSERT INTO wp_posts(post_author, post_date, 
post_date_gmt, post_content,post_title, post_status, comment_status, 
ping_status,post_name, post_modified, post_modified_gmt,guid) 
 
VALUES('$post_author','$post_date','$post_date_gmt','@post_content','$post_title','$post_status','$comment_status','$ping_status','$post_name','$post_modified','$post_modified_gmt','$guid')") 
 or die; # "Couldnt prepare statement: " . dbh->errstr; 

        my $rv1 = $sth1->execute();


but my problem is if any of the values of @post_content or $post_title 
contain apostrophe the script show this error not executing of feeding the 
database: 

DBD::mysql::st execute failed: You have an error in your SQL syntax; check 
the manual that corresponds to your MySQL server version for the right 
syntax to use near 
's%20secret%20visits%20to%20heiress/article.do">Goldsmith s secret visits 
to heir ' at line 2 at posting-news.pl

anybody knows how can I fix this without removing the apostrophe?

Thanks,
Luis_____________________________________________________________
Seattle Perl Users Group Mailing List 
     POST TO: spug-list at pm.org
SUBSCRIPTION: http://mail.pm.org/mailman/listinfo/spug-list
    MEETINGS: 3rd Tuesdays
    WEB PAGE: http://seattleperl.org/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.pm.org/pipermail/spug-list/attachments/20061003/ef3123d9/attachment.html