# Somewhere in init stage
use DBIx::Handy; # need a better name ...
DBIx::Handy->add_db(dsn  =>  'dbi:mysql:autoreorder',
                    username => 'alex',
                    name => 'oscommerce');

# Then latter
my $DB = DBIx::Handy->get_instance();
my $SQL = "SELECT p.products_id, p.products_image, pd.products_name,
pd.products_description FROM products p INNER JOIN
products_description pd ON p.products_id = pd.products_id
WHERE p.products_id = ?";
    
my $products_data = $DB->execute(sql        => $SQL,
                                 data       => [$form->{id}],
                                 database   => 'oscommerce')->fetchrow_hashref();
    
    
my $template = $self->load_tmpl('Product/details.dwt');
$template->param(%{$products_data});
    
return $template->output(); 

##</code><code>##

my $schools = $DB->execute(sql      =>'SELECT * FROM users ORDER BY username',
                               method   =>'fetchall_aohref');
    
my $t = $self->load_tmpl('Admin/view_admin_users.dwt');
$t->param('schools' => $schools);
    
return $t->output();