the below code is giving following error: 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 ')' at line 1 at /var/www/cgi-bin/tt.cgi line 35. 

#!/usr/bin/perl
     
    use warnings FATAL => 'all';
    use CGI;
    use CGI::Carp qw(fatalsToBrowser);
    use DBI;
    use DBD::mysql;
     
    my $cgi = CGI->new;
     
    print $cgi->header, $cgi->start_html;
     
    my $title     = $cgi->param('TITLE');
    my $feature  = $cgi->param('FEATURE');
    my $type     = $cgi->param('TYPE');
    my $description  = $cgi->param('DESCRIPTION');
    my $status     = $cgi->param('STATUS');
    my $path  = $cgi->param('PATH');
    my $priority = $cgi->param('priority');





    my $database = "test_case";
    my $host     = "localhost";
    my $user     = "chiragk";
    my $pw       = "";
    my $dsn      = "dbi:mysql:$database:localhost";
    my $dbh      = DBI->connect($dsn, $user, $pw,
                               { RaiseError => 1 })        or die "una
+ble to connect:$DBI::errstr\n";
     
    my $query = "insert into test(title,feature_name,type,description,
+status,test_case_path,priority) values(?,?,?,?,?,?,?,)";
    my $sth   = $dbh->prepare($query); 
    $sth->execute("$title","$feature","$type","$description","$status"
+,"$path","$priority");
    print $cgi->p("[$title],[$feature],[$type],[$description],[$status
+],[$path],[$priority]");    
    print $cgi->end_html;

[download]

In reply to DBD::mysql::st execute failed: You have an error in your SQL syntax; by Anonymous Monk

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.