Installed Embperl wih Apache on my Debian box and would like to play and learn something. After many hours fighting with mySQL setup, Apache setup I am ALMOST THERE ... I have this little test program (which I am appending) taken from the web. When I run it from the command line everything behaves as advertised (appending the output as stdalone.output) but when I run it through my Apache HTTPD the output is a plain/text incomplete page. Here it is pasted from the browser: <html> <head> <title>Embperl Examples - DBI access using Dynamic Tables</title> </head> <h1>Embperl Examples - DBI access using Dynamic Tables</h1> <hr> <table border=1> <tr><th>titolo</th></tr> <tr><td>Syphon Filter</td></tr> <---- PLEASE NOTE ONLY FIRST RECORD PRINTED </table> <p><hr> <small>HTML::Embperl (c) 1997-1998 G.Richter</small> </body> </html> I am also appending my Apache configuration file. Thank you very very much. Bob AlexanderTitle: Embperl Examples - DBI access using Dynamic Tables
Embperl Examples - DBI access using Dynamic Tables
| titolo | codice |
|---|---|
| Syphon Filter | 1 |
| Omega Boost | 2 |
| Tempest X | 3 |
| Croc 2 | 4 |
| Bloody Roar 2 | 5 |
| Resident Evil 2 | 6 |
| Kingsley | 7 |
| Ace Combat 3 | 8 |
HTML::Embperl (c) 1997-1998 G.Richter Title: Embperl Examples - DBI access using Dynamic Tables
Embperl Examples - DBI access using Dynamic Tables
[- $DSN = 'dbi:mysql:psx' ; $table = 'titoli' ; use DBI ; # connect to database $dbh = DBI->connect($DSN) or die "Cannot connect to '$DSN'" ; # prepare the sql select $sth = $dbh -> prepare ("SELECT * from $table") or die "Cannot SELECT from '$table'" ; # excute the query $sth -> execute or die "Cannot execute SELECT from '$table'"; # get the fieldnames for the heading in $head $head = $sth -> {NAME} ; # get the result in $dat $dat = $sth -> fetchall_arrayref ; $rc = $dbh->disconnect; -]
| [+ $head->[$col] +] |
|---|
| [+ $dat -> [$row][$col] +] |
HTML::Embperl (c) 1997-1998 G.Richter
# With this document, you define the name space that users see of your http # server. This file also defines server settings which affect how requests are # serviced, and how results should be formatted. # See the tutorials at http://www.apache.org/ for # more information. # Originally by Rob McCool; Adapted for Apache # DocumentRoot: The directory out of which you will serve your # documents. By default, all requests are taken from this directory, but # symbolic links and aliases may be used to point to other locations. DocumentRoot /var/www # UserDir: The name of the directory which is appended onto a user's home # directory if a ~user request is recieved. UserDir public_html # DirectoryIndex: Name of the file or files to use as a pre-written HTML # directory index. Separate multiple entries with spaces. DirectoryIndex index.html # FancyIndexing is whether you want fancy directory indexing or standard FancyIndexing on # AddIcon tells the server which icon to show for different files or filename # extensions AddIconByEncoding (CMP,/icons/compressed.gif) x-compress x-gzip AddIconByType (TXT,/icons/text.gif) text/* AddIconByType (IMG,/icons/image2.gif) image/* AddIconByType (SND,/icons/sound2.gif) audio/* AddIconByType (VID,/icons/movie.gif) video/* AddIcon /icons/binary.gif .bin .exe AddIcon /icons/binhex.gif .hqx AddIcon /icons/tar.gif .tar AddIcon /icons/world2.gif .wrl .wrl.gz .vrml .vrm .iv AddIcon /icons/compressed.gif .Z .z .tgz .gz .zip AddIcon /icons/a.gif .ps .ai .eps AddIcon /icons/layout.gif .html .shtml .htm .pdf AddIcon /icons/text.gif .txt AddIcon /icons/c.gif .c AddIcon /icons/p.gif .pl .py AddIcon /icons/f.gif .for AddIcon /icons/dvi.gif .dvi AddIcon /icons/uuencoded.gif .uu AddIcon /icons/script.gif .conf .sh .shar .csh .ksh .tcl AddIcon /icons/tex.gif .tex AddIcon /icons/bomb.gif */core AddIcon /icons/deb.gif .deb Debian AddIcon /icons/back.gif .. AddIcon /icons/hand.right.gif README AddIcon /icons/folder.gif ^^DIRECTORY^^ AddIcon /icons/blank.gif ^^BLANKICON^^ # DefaultIcon is which icon to show for files which do not have an icon # explicitly set. DefaultIcon /icons/unknown.gif # AddDescription allows you to place a short description after a file in # server-generated indexes. # Format: AddDescription "description" filename # ReadmeName is the name of the README file the server will look for by # default. Format: ReadmeName name # # The server will first look for name.html, include it if found, and it will # then look for name and include it as plaintext if found. # # HeaderName is the name of a file which should be prepended to # directory indexes. ReadmeName README HeaderName HEADER # IndexIgnore is a set of filenames which directory indexing should ignore # Format: IndexIgnore name1 name2... IndexIgnore .??* *~ *# HEADER HEADER.html README README.html RCS CVS # AccessFileName: The name of the file to look for in each directory # for access control information. AccessFileName .htaccess # DefaultType is the default MIME type for documents which the server # cannot find the type of from filename extensions. DefaultType text/plain # AddEncoding allows you to have certain browsers (Mosaic/X 2.1+) uncompress # information on the fly. Note: Not all browsers support this. AddEncoding x-compress Z AddEncoding x-gzip gz # AddLanguage allows you to specify the language of a document. You can # then use content negotiation to give a browser a file in a language # it can understand. Note that the suffix does not have to be the same # as the language keyword --- those with documents in Polish (whose # net-standard language code is pl) may wish to use "AddLanguage pl .po" # to avoid the ambiguity with the common suffix for perl scripts. AddLanguage en .en AddLanguage fr .fr AddLanguage de .de AddLanguage da .da AddLanguage it .it AddLanguage es .es AddLanguage br .br AddLanguage jp .jp AddLanguage dk .dk AddLanguage pl .pl AddLanguage kr .kr # LanguagePriority allows you to give precedence to some languages # in case of a tie during content negotiation. # Just list the languages in decreasing order of preference. LanguagePriority en fr de # Redirect allows you to tell clients about documents which used to exist in # your server's namespace, but do not anymore. This allows you to tell the # clients where to look for the relocated document. # Format: Redirect fakename url # Aliases: Add here as many aliases as you need (with no limit). The format is # Alias fakename realname # Note that if you include a trailing / on fakename then the server will # require it to be present in the URL. So "/icons" isn't aliased in this # example. Alias /icons/ /usr/share/apache/icons/ # ScriptAlias: This controls which directories contain server scripts. # Format: ScriptAlias fakename realname ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/ # If you want to use server side includes, or CGI outside # ScriptAliased directories, uncomment the following lines. # AddType allows you to tweak mime.types without actually editing it, or to # make certain files to be certain types. # Format: AddType type/subtype ext1 # For example, the PHP3 module (a separate Debian package) # will typically use: #AddType application/x-httpd-php3 .phtml #AddType application/x-httpd-php3-source .phps # AddHandler allows you to map certain file extensions to "handlers", # actions unrelated to filetype. These can be either built into the server # or added with the Action command (see below) # Format: AddHandler action-name ext1 # To use CGI scripts: #AddHandler cgi-script .cgi # To use server-parsed HTML files #AddType text/html .shtml #AddHandler server-parsed .shtml # Uncomment the following line to enable Apache's send-asis HTTP file # feature #AddHandler send-as-is asis # If you wish to use server-parsed imagemap files, use #AddHandler imap-file map # To enable type maps, you might want to use #AddHandler type-map var # Action lets you define media types that will execute a script whenever # a matching file is called. This eliminates the need for repeated URL # pathnames for oft-used CGI file processors. # Format: Action media/type /cgi-script/location # Format: Action handler-name /cgi-script/location # Customizable error response (Apache style) # these come in three flavors # # 1) plain text #ErrorDocument 500 "The server made a boo boo. # n.b. the (") marks it as text, it does not get output # # 2) local redirects #ErrorDocument 404 /missing.html # to redirect to local url /missing.html #ErrorDocument 404 /cgi-bin/missing_handler.pl # n.b. can redirect to a script or a document using server-side-includes. # # 3) external redirects #ErrorDocument 402 http://some.other_server.com/subscription_info.html # # mod_mime_magic allows the server to use various hints from the file itself # to determine its type. #MimeMagicFile conf/magic # The following directives disable keepalives and HTTP header flushes. # The first directive disables it for Netscape 2.x and browsers which # spoof it. There are known problems with these. # The second directive is for Microsoft Internet Explorer 4.0b2 # which has a broken HTTP/1.1 implementation and does not properly # support keepalive when it is used on 301 or 302 (redirect) responses. BrowserMatch "Mozilla/2" nokeepalive BrowserMatch "MSIE 4\.0b2;" nokeepalive downgrade-1.0 force-response-1.0 # The following directive disables HTTP/1.1 responses to browsers which # are in violation of the HTTP/1.0 spec by not being able to grok a # basic 1.1 response. BrowserMatch "RealPlayer 4\.0" force-response-1.0 BrowserMatch "Java/1\.0" force-response-1.0 BrowserMatch "JDK/1\.0" force-response-1.0 Alias /doc/ /usr/doc/ ## The above line is for Debian Policy 3.0.1 (FHS), which specifies that /doc ## is /usr/doc. Some packages may not work otherwise. -- apacheconfig # added to support Netscape roaming rja RoamingAlias /roaming/ /etc/apache/roaming/ #added to support Embeddded Perl (embperl) from mod_perl SetEnv EMBPERL_DEBUG 2285 <FilesMatch ".*\.epl$"> SetHandler perl-script PerlHandler HTML::Embperl Options ExecCGI </FilesMatch> # added to serve Debian mirror Alias /debian /home/ftp/debian
