The Perl Guestbook script I use prints the form results ($guestbookreal) to an html page (http://example.com/new_listings_publish.html):

For example, here is a typical form result: 
INSERT INTO `mysql_db` (`Title`, `Email`, `City`,
`State`, `Country`, `URL`, `Date`, `Description`,
`rid`, `dt_create`, `publish` ) VALUES ('Test',
'example.com', 'Sebastopol', 'Ca', 'USA ',
' ', 'Friday, February 13, 2004
', 'Test', '', 'NOW()', 0)

[download]
I then post the ads to MySQL by copying and pasting the INSERT INTO statements into "Run SQL query/queries" window on the phpMyAdmin interface provided by my host and hitting "GO."

Though the above method works, I'd like to bypass the copy & paste step if possible. Can somebody please be so kind as tell me how (or if it's even possible) I need to change the following code so that it will write the results directly to MySQL instead??

For example:
$guestbookreal = "/home/flute/example-www/new_listings_publish.html";

# becomes (and I know this isn't legit...):
$guestbookreal = substr(
$sth = $dbh->prepare($guestbookreal) execute);

[download]
# anyhow...something like that perhaps??

Many thanks in advance,

-Bob

Edited by BazB: added code tags

In reply to Modifying Perl script to write to MySQL?? by bobafifi

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.