in reply to How to insert the text written in textarea tag in mysql database in perl.

Use placeholders, or properly build your SQL insert statement. I recommend placeholders, as documented in DBI.

  • Comment on Re: How to insert the text written in textarea tag in mysql database in perl.

Replies are listed 'Best First'.
Re^2: How to insert the text written in textarea tag in mysql database in perl.
by Anita (Initiate) on Jun 27, 2012 at 12:04 UTC
    I have used place holders.

      As you did not show any relevant code, and also did not explain where your problem is with your existing code, how was I supposed to know?

      Maybe now is a good moment to post the relevant code, the relevant input data and the relevant results you get in the database. Also maybe explain now where the problem is, what you expect and what you get.

        The html code is:
        Paste Your Resume:
        <textarea wrap="physical" id="resume" name="resume"></textarea>
        my perl code regarding the insert query is: my $sql_query = <<'__SQL__'; INSERT INTO posted_resumes (name,email_id,contact_no,comments,date) VALUES (?,?,?,?,CURDATE()) __SQL__ my $bind_params = { 1 => $query->param('name'), 2 => $query->param('emailid'), 3 => $query->param('contactno'), 4 => $query->param('resume'), };