http://www.perlmonks.org?node_id=1223626
nnigam1 has asked for the wisdom of the Perl Monks concerning the following question:

O wise and wonderful Monks, I have an issue on which I seek your wisdom I used to code in perl extensively a few years back. Then my company moved to Oracle forms. But I loved perl and all the things that I could do with it so I am trying to work with perl again. I have created my script from which I can extract data from an Oracle database and create an html file that I can open in the browser. However this is too static. I would like to call this script from a web page to add dynamic capabilities to it. I have read the posts about this saying that I have to install a web server. However, I am pretty sure that I did this before without one. Please let me know that I am wrong or provide assistance in how to do this. This will be for two-three users only, so I would like to avoid having to add another server to the mix. If a web server is necessary, any recommendations for a minimum web server that could do the task with limited resources. I love apache and had used it a lot but that offered a lot more capabilities than I need now. This will be running on a windows 10 laptop with an SSD drive, Oracle 12c, and several development tools on it so I would like to minimize the resource footprint if possible. My previous postings were under nnigam, but I have no longer have that email and have forgotten the password.

Replies are listed 'Best First'.
Re: perl scrpt from html page
by LanX (Archbishop) on Oct 07, 2018 at 00:26 UTC
      Thank you o wise monk. I will follow your suggestion. I may come back with additional questions.
Re: perl scrpt from html page (retrieving password)
by LanX (Archbishop) on Oct 07, 2018 at 11:37 UTC
    > My previous postings were under nnigam, but I have no longer have that email and have forgotten the password.

    Please see Retrieving a forgotten username or password if you have "verifiable proof that you really are the owner of the account in question".

    Cheers Rolf
    (addicted to the Perl Programming Language :)
    Wikisyntax for the Monastery FootballPerl is like chess, only without the dice

Re: perl scrpt from html page
by Anonymous Monk on Oct 07, 2018 at 02:36 UTC
    You could expand the script to scrape the database and make many html pages linked together as a static website but if you need to interact:
    #!/usr/bin/env perl use Mojolicious::Lite; use Data::Dumper; # or DBD::Oracle get '/' => sub { my $c = shift; my $data = Dumper(\%ENV); # or your DB $c->render(text => $data, format => 'txt'); }; app->start;