I'm trying to write a small CGI script which will allow a user to add records to a database by filling in an html form. The form is generated dynamically by getting all the columns from the database along with their types and maximum lengths (where appropriate). The input type is then converted into something suitable for hmtl input (since the database has more then one type of field for which the input is best represented as a textfield in the html) and stored in a hash with column names as keys and the input types as values. The form is generated within a table and should call on the hash to get the right type for the query like this:

print start_Tr, start_td;
    print "$req$key: ";
    print end_td, start_td ($query->$input_html{$key}("$key") );
    print end_td, end_Tr;

[download]

I'm aiming for something like:

<tr>
<td>$req$key:</td>
<td>  <input type="$input_html{$key}" name="$key">  </td>
</tr>

[download]

But this gives me a syntax error near "$input_html{". Is this because what I'm trying to do here is not allowed and if so, how can I work around it?

In reply to Using hash values as CGI query types by Nevtlathiel

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.