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

The html code is:

Paste Your Resume:

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'), };

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

Replies are listed 'Best First'.
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]