Re^3: How to insert the text written in textarea tag in mysql database in perl.

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.

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

Replies are listed 'Best First'.
Re^4: How to insert the text written in textarea tag in mysql database in perl. by Anita (Initiate) on Jun 27, 2012 at 12:19 UTC
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'), };	[reply]
Re^5: How to insert the text written in textarea tag in mysql database in perl. by Anonymous Monk on Jun 27, 2012 at 12:30 UTC
Well, that is never going to work, there are no emailid/contactno..... input elements in your form See Ovid's CGI Course, CGI Programming 101, http://www.w3.org/wiki/HTML/Elements#Forms,	[reply]
Re^5: How to insert the text written in textarea tag in mysql database in perl. by muba (Priest) on Jun 27, 2012 at 13:13 UTC
For readability, you should put code (and preferrably output) inside <code>...</code> tags, or <c>...</c> if you don't like typing so much. `<textarea wrap="physical" id="resume" name="resume"></textarea>` [download] `$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'), };` [download]	[reply] [d/l] [select]