I have the following mysql tables

Products table
==============
id
name
price
...etc


images table
==============
img_id
prod_id
img_ext

[download]

So when adding products I can add as many images as I want (for now 3 only), but the idea is to leave the number dynamic.

The Problem

The problem is when editing the product I want to be able to replace already uploaded images OR upload some other new images

the idea I had was using the img_id inside the field names like this

<input type="file" name="img[$img_id]">

[download]

So if I have an img with an id I'll update the image record otherwise, it's a new image so I'll insert a new record.

I cannot seem to get CGI module to fetch this html input as key,value pairs.

Any idea or new logic would be appreciated

In reply to fetch html input as hash 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.