# Define your your image names, along with
 # any thumbnails they might need, and their max width and heights.

##</code><code>##

 my %Media = {
        img_1 => {
                # scale down the image to this size if needed
                target_geometry => '200x200',
                thumbs => [
                        { name => 'img_1_thumb_1', w => 100, h => 100 },
                        { name => 'img_1_thumb_2', w => 50 , h => 50  }, 
                ],
        },

##</code><code>##

        # A simple syntax if you just want some thumbnails
        img_2 => [
                { name => 'img_2_thumb_1', w => 100, h => 100 },
        ],

        # And a very simple syntax if you want to store the image untouched.
        img_3 => [],
 };

 # Create the accessor. This could be done once in a super class
 # and stored in a param variable.
 
 my $media_srv = CGI::ImageDB->new(
        media_url => '<a href="http://localhost/com/images/media">http://localhost/com/images/media</a>',
        media_dir => '/home/user/www/images/media',
        dbh           => $dbh,  
        media_table => 'media', # defaults to 'media'
        media_def => \%Media,
 );

##</code><code>##

        -- Note the MySQL specific syntax here
        create table media (
                media_id        int AUTO_INCREMENT primary key not null,
                mime_type  character varying(64),
                extension  character varying(8), -- file extension
                width      integer,
                height     integer
        )

##</code><code>##

  img_1_id
  img_1_thumb_1_id

##</code><code>##

 my %Media = {
        img_1 => [
                { name => 'img_1_thumb_1', w => 100, h => 100 },
                { name => 'img_1_thumb_2', w => 50 , h => 50  },
                ],
        img_2 =< [
                { name => 'img_2_thumb_1', w => 100, h => 100 },
        ],
        img_3 => [],
 };

##</code><code>##

 my ($add_to_valid,@rm_from_valid) = $media_srv-&gt;create_install_media($valid);

##</code><code>##

 $valid = { %$valid, %$add_to_valid } if $add_to_valid;
 map { delete $valid->{$_} } @$rm_from_valid;

##</code><code>##

 img_id_1 => 23

##</code><code>##

 img_1_info

##</code><code>##

        my @deleted_field_ids = $img_srv->delete_checked_media;

##</code><code>##

        img_1_id

##</code><code>##

        my $field_id = $img_srv-&gt;delete_media('img_1');

##</code><code>##

  img_1_id

##</code><code>##

        my $tmpl_vars_ref = $media_srv->create_img_tmpl_vars($table,\%where,@prefixes);

##</code><code>##

        my $tmpl_vars_ref = $media_srv->create_img_tmpl_vars('news',{ item_id => 23 },qw/img_1/);

##</code><code>##

        {
                img_1_id     => 523,
                img_1_width  => 100,
                img_1_height => 200,
                img_1_url    => '<a href="http://localhost/images/media/523.jpg">http://localhost/images/media/523.jpg</a>',
        }

##</code><code>##

 SELECT media_id as id,width,height,extension 
        FROM media, $table where (media_id = ${prefix}_id and (%where_clause_expanded here));