Re: MySQL Database Manager

What?

#Get the input from the calling html document
#read(STDIN,$buffer,$ENV{'CONTENT_LENGTH'});
#@params = split(/&/,$buffer);
[download]

It does appear you learned that CGI.pm is better, so please remove those offensive comments ;)

Also, since you're bothering to use CGI; instead of:

    print $cgi->header( "text/html" );
    print qq~<HTML>
        <BODY>~;
    if ($header eq "yes"){
        print qq~
        <HTML>
        <HEAD>
        <META HTTP-EQUIV="Content-Type" CONTENT="text/html">
        <TITLE>MySQL Database sorter.</TITLE>
        </HEAD>
        <BODY bgcolor="#FFFFFF">
        <CENTER><H2>MySQL DataBase Sorter</A></H2>
        <br>~;
[download]

use the CGI.pm equivalents to generate your html.

Comment on Re: MySQL Database Manager Select or Download Code

Replies are listed 'Best First'.
Re: Re: MySQL Database Manager by hacker_j99 (Beadle) on Jul 27, 2001 at 21:40 UTC
I was thinking about using a key and token so that the perl script and the HTML is no longer interwoven and dependent... I have the script for that writen but havent combined the two.. # The code included below is used by Campus Crusade for Christ # with permission of Alphalogic Systems, Inc. # No portion of this code made be used or replicated without # permission. # PrintHeader # # Returns the magic line which tells WWW that we're an HTML document + # if a cookie existes, it sets the cookie also sub PrintHeader { print "Content-type: text/html\n"; if ($gCookieValue ne "") { &SetCookies($gCookieName,$gCookieValue); print "\n"; } else { print "\n"; } } # # SendTemplate # # This subroutine is used to display a web page template and then add +information # onto that template. The information comes from the tokens created by + the # perl script. sub SendTemplate { my ($template)=@_; my ($key, $filecontents); open (FILE, "$template"); # opens file containing web page template if (eof(FILE)==1) { # If file doesn't open, provides a basic web page with an error me +ssage. # Then proceeds to post raw data onto the web page. &PrintHeader(); $key = '<!--#title#-->'; print "<HTML><TITLE>$gTokens{$key}</TITLE><HEAD></HEAD><BODY> <H2> +Sorry, There has been an error in calling the Template.</H2>"; print "<P><H2>The information you requested is listed below.</H2>" +; foreach $key (sort keys %gTokens){ print "$key","\t", $gTokens{$key},"<P>\n"; } print "</BODY></HTML>"; return; } # The following commands will dump everything in the web template fi +le into $filecontents undef $/; $filecontents=<FILE>; close FILE; $/ = "\n"; # This loop will search $filecontents and replace any tokens found w +ith the HTML code # that the token is associated with in the hash %gToken hash. foreach $key (sort keys %gTokens){ $filecontents=~s/$key/$gTokens{$key}/g; } &PrintHeader(); print $filecontents; return true; } [download]	[reply] [d/l]

Replies are listed 'Best First'.

Re: Re: MySQL Database Manager
by hacker_j99 (Beadle) on Jul 27, 2001 at 21:40 UTC

# The code included below is used by Campus Crusade for Christ
# with permission of Alphalogic Systems, Inc.
# No portion of this code made be used or replicated without
# permission.

# PrintHeader
#
# Returns the magic line which tells WWW that we're an HTML document  
+ 
# if a cookie existes, it sets the cookie also
sub PrintHeader {
  print "Content-type: text/html\n";
  if ($gCookieValue ne "") {
    &SetCookies($gCookieName,$gCookieValue);
    print "\n";
  }
  else {   
    print "\n";
  }
}
  
#
# SendTemplate
#
# This subroutine is used to display a web page template and then add 
+information
# onto that template. The information comes from the tokens created by
+ the
# perl script.
sub SendTemplate {
  my ($template)=@_;
  my ($key, $filecontents);
  open (FILE, "$template"); # opens file containing web page template
  if (eof(FILE)==1) {
    # If file doesn't open, provides a basic web page with an error me
+ssage.
    # Then proceeds to post raw data onto the web page.
    &PrintHeader();
    $key = '<!--#title#-->';
    print "<HTML><TITLE>$gTokens{$key}</TITLE><HEAD></HEAD><BODY> <H2>
+Sorry, There has been an error in calling the Template.</H2>";
    print "<P><H2>The information you requested is listed below.</H2>"
+;
    foreach $key (sort keys %gTokens){
      print "$key","\t", $gTokens{$key},"<P>\n";
    }
    print "</BODY></HTML>";
    return;
  }
  # The following commands will dump everything in the web template fi
+le into $filecontents
  undef $/;  
  $filecontents=<FILE>;
  close FILE;
  $/ = "\n";
  # This loop will search $filecontents and replace any tokens found w
+ith the HTML code
  # that the token is associated with in the hash %gToken hash.
  foreach $key (sort keys %gTokens){
    $filecontents=~s/$key/$gTokens{$key}/g;
  }
  &PrintHeader();  
  print $filecontents;
  return true;
}
[download]

[reply]
[d/l]