Is there sample application using mySQL+Perl+CGI+DBI ?

Is there sample application using mySQL+Perl+CGI+DBI ?

am 21.02.2006 18:04:12 von gordon.x.wu

--=_alternative 005DC9328525711C_=
Content-Type: text/plain; charset="us-ascii"

Does anyone know where I can download a sample working mySQL web
application, such as "Address Book", that is using
mySQL in Perl (not PHP), hopefully with CGI.pm and DBI? I'd like to use it
as a test application to prove mySQL and Perl
environment is working and maybe just modify this simple application to do
what I want.

I'm installing the mySQL+Perl+CGI programming environment in Solaris 10
server to develop a web application to replace
the Microsoft Excel spreadsheet, which allows multiple people
access/modify the data at the same time, including import and
export Excel to/from mysql database. (do you know any existing
application like this?)

Any help would be really appreciated and thank you in advanced!

gordon
--=_alternative 005DC9328525711C_=--

Re: Is there sample application using mySQL+Perl+CGI+DBI ?

am 21.02.2006 19:04:54 von MTA-Traffic

an extremely simple example

#!/usr/bin/perl -w
use strict;
use CGI;
use DBI;

my $q = new CGI;
my $pathInfo = $q->path_info;
print $q->header;
if(!$pathInfo) {
print <


Integer Value

Char value



EOT
}
DoSQL() if($pathInfo =~ /do/);
print $q->end_html;

## -----------------------------------------------------

sub DoSQL {
my ( $dbh );
my $i = $q->param('i');
my $c = $q->param('c');
$dbh = DBI->connect( "dbi:mysql:database=test;host=localhost",
'user', 'pass') or die "cant connect";
$dbh->do("insert into testac values($i, '$c')");
$dbh->disconnect or warn "Disconnection failed: $DBI::errstr\n";
}

__END__


On Feb 21, 2006, at 8:04 AM, gordon.x.wu@jpmchase.com wrote:

> Does anyone know where I can download a sample working mySQL web
> application, such as "Address Book", that is using
> mySQL in Perl (not PHP), hopefully with CGI.pm and DBI? I'd like to
> use it
> as a test application to prove mySQL and Perl
> environment is working and maybe just modify this simple
> application to do
> what I want.
>
> I'm installing the mySQL+Perl+CGI programming environment in
> Solaris 10
> server to develop a web application to replace
> the Microsoft Excel spreadsheet, which allows multiple people
> access/modify the data at the same time, including import and
> export Excel to/from mysql database. (do you know any existing
> application like this?)
>
> Any help would be really appreciated and thank you in advanced!
>
> gordon

Rich Allen
A kidney transplant saved my life, plese consider being an organ donor.


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Is there sample application using mySQL+Perl+CGI+DBI ?

am 21.02.2006 19:14:28 von Paul DuBois

At 12:04 -0500 2/21/06, gordon.x.wu@jpmchase.com wrote:
>Does anyone know where I can download a sample working mySQL web
>application, such as "Address Book", that is using
>mySQL in Perl (not PHP), hopefully with CGI.pm and DBI? I'd like to use it
>as a test application to prove mySQL and Perl
>environment is working and maybe just modify this simple application to do
>what I want.
>
>I'm installing the mySQL+Perl+CGI programming environment in Solaris 10
>server to develop a web application to replace
>the Microsoft Excel spreadsheet, which allows multiple people
>access/modify the data at the same time, including import and
>export Excel to/from mysql database. (do you know any existing
>application like this?)
>
>Any help would be really appreciated and thank you in advanced!
>
>gordon


http://www.kitebird.com/mysql-perl/

Check the "downloads" link.

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org