Thanks! Another question, what does MySQL-DBI-perl-bin do? Do I need this
package?
Thanks everyone,
Jake
----- Original Message -----
From: "Jonathan Bartlett" <[EMAIL PROTECTED]>
To: "RedHat List" <[EMAIL PROTECTED]>
Cc: "Jack Bowling" <[EMAIL PROTECTED]>
Sent: Sunday, January 13, 2002 12:06 PM
Subject: Re: MySQL
>
> use DBI;
>
> my $dbh = DBI->connect("CONNECTSTRINGGOESHERE", "whateveryourusernameis",
> "whateveryourpasswordis");
>
> my ($x, $y, $z);
>
> my $sth = $dbh->prepare("Select X, Y, Z from whatever where something =
> somethingelse") || die("error preparing statement");
>
> $sth->execute || die("error executing statement");
>
> while(($x, $y, $z) = $sth->fetchrow_array)
> {
>
> }
>
> $dbh->do("insert into whatever (a, b, c) VALUES ('valuea', 'valueb',
> 'valuec');
>
> ################
>
> You can get more info by doing
>
> perldoc DBI
>
> You can find out what your connect string should be by reading MySQL's
> driver docs (perldoc DBD::MySQL maybe, I forget).
>
> Anyway, the preceding code was from my head, and probably has errors.
> Also, you can get DBI errror meessages from the variable $DBI::errstr I
> believe.
>
> Jon
>
> On Sun, 13 Jan 2002, Jake McHenry wrote:
>
> > Ok, I'll look into using my existing scripts, only adding the MySQL to
it.
> > What will I need to change/add in the scripts to access the database?
Will I
> > need to add any other packages? Currently, this is what I have
installed...
> >
> > perl-5.6.0-9
> > groff-perl-1.16-7
> > perl-DBI-1.18-1
> >
> > MySQL-3.23.47-1
> > MySQL-devel-3.23.47-1
> > MySQL-client-3.23.47-1
> > MySQL-shared-3.23.47-1
> >
> >
> > Are there any docs on webpage scripting and MySQL? How do I access the
> > database from the webpage?
> >
> > Thanks again,
> > Jake
> >
> >
> > ----- Original Message -----
> > From: "Jack Bowling" <[EMAIL PROTECTED]>
> > To: "Jake McHenry" <[EMAIL PROTECTED]>
> > Sent: Sunday, January 13, 2002 10:29 AM
> > Subject: Re: MySQL
> >
> >
> > > ** Reply to message from Jake McHenry <[EMAIL PROTECTED]> on
> > Sun, 13 Jan 2002 08:32:43 -0500
> > >
> > > Yes, keep the perl-DBI. It may come in handy. If you are asking which
> > version of PHP to use, get the latest which is 4.0x,
> > >
> > > jb
> > >
> > >
> > > > Should I keep the perl-DBI rpm that I installed for this? Will I
need it
> > for
> > > > anything with PHP? Does anyone recommend any specific version?
> > > >
> > > > Thanks,
> > > > Jake
> > > >
> > > >
> > > > ----- Original Message -----
> > > > From: "Jack Bowling" <[EMAIL PROTECTED]>
> > > > To: "Jake McHenry" <[EMAIL PROTECTED]>
> > > > Sent: Saturday, January 12, 2002 9:43 PM
> > > > Subject: Re: MySQL
> > > >
> > > >
> > > > > ** Reply to message from Jake McHenry
<[EMAIL PROTECTED]> on
> > > > Sat, 12 Jan 2002 20:24:07 -0500
> > > > >
> > > > >
> > > > > > Hello everyone. I am kinda disturbed about what my boss wants me
to
> > do.
> > > > I have spent the past 6 months creating a web-based database all
with
> > perl
> > > > scripts. It works great! But he now want's me to convert it to
MySQL. I
> > have
> > > > MySQL installed, up and running. I can connect to it from the local
> > machine.
> > > > > >
> > > > > > The problem is, what do I do now? I've read articles on using
MySQL
> > and
> > > > PHP together for web access, but I don't have PHP installed. How
else
> > can I
> > > > access the database? Say maybe using perl?
> > > > > >
> > > > > > Also, something else, maybe this is supposed to happen, when I
type
> > in
> > > > the address, then the port for MySQL, it gives me this ..
> > > > > >
> > > > > >
> > > > > > LÿjHost 'winxp.ministang.com' is not allowed to connect to this
> > MySQL
> > > > server
> > > > > >
> > > > > >
> > > > > > Is this supposed to happen? I think it is, because it doesn't
have a
> > web
> > > > server built in, right?
> > > > > >
> > > > > >
> > > > > > Any help would be greatly appreciated.
> > > > > >
> > > > > > Thanks in advance,
> > > > > > Jake
> > > > >
> > > > > Jake - Although not exactly what you wanted, check out Jonathon
> > > > Daugherty's Solomon MySQL Web Interface 2.0.5 at
> > > > >
> > > > > http://www.arches.uga.edu/~cygnusx5
> > > > >
> > > > > It is GPL'ed so you should be able to mix and match if needed. Or
at
> > least
> > > > see how Jon has done things.
> > > > >
> > > > > Jack
> > > > >
> > > > >
> > >
> > >
> >
> >
> >
> >
> > _______________________________________________
> > Redhat-list mailing list
> > [EMAIL PROTECTED]
> > https://listman.redhat.com/mailman/listinfo/redhat-list
> >
>
>
>
> _______________________________________________
> Redhat-list mailing list
> [EMAIL PROTECTED]
> https://listman.redhat.com/mailman/listinfo/redhat-list
>
>
_______________________________________________
Redhat-list mailing list
[EMAIL PROTECTED]
https://listman.redhat.com/mailman/listinfo/redhat-list
