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
