You don't need phpmyadmin at all - unless you want a web based database management tool. I prefer to use the standard mysql client program when I can.
Anyway, you need 2 modules: DBI and DBD::mysql. DBI is the standard database engine for perl and DBD::mysql is the mysql driver for DBI. Both are pretty well documented.
If you want to do OO-relational mapping take a look at DBIx::Class - you don't need it, but it sure can make things easier.
| [reply] |
thanx .....,
but this all the tools i need .....
what other resources can i use to undestand it deeply ? ......
and what about using LAMP (xampp tool) from apachefriends.org is that suitable for perl or itis for php only and will it make things easier ? . ...
| [reply] |
XAMPP does provide perl. I know they do, because they say so on their website:
The distribution for Windows 98, NT, 2000 and XP. This version contains: Apache, MySQL, PHP + PEAR, Perl, mod_php, mod_perl, mod_ssl, OpenSSL, phpMyAdmin, Webalizer, Mercury Mail Transport System for Win32 and NetWare Systems v3.32, JpGraph, FileZilla FTP Server, mcrypt, eAccelerator, SQLite, and WEB-DAV + mod_auth_mysql.
Apparently, they also provide add-ons with DBI/dbd::mysql. Or maybe that's included in the base install. Not sure.
If you're on windows, xampp might be a good way of getting precompiled binaries for everything involved. On most unix/linux systems you can usually get all the tools from your system distributer - or at least you should get a decent C compiler so you can compile everything yourself.
| [reply] |
Hi Adam,
Some monks have given you the basic answer to this question already; I can see that you're after more learning resources. Good for you. As a starting point, I'd recommend:
Simon Cozens's article on Perl.com, introducing the way Perl deals with databases
The O'Reilly book 'Programming the Perl DBI'.
You'll find that Perl's DBI module, and the MySQL module that goes with it, DBD::mysql, are all you need to get Perl and MySQL working together - it's not worth looking at things like phpmyadmin or whatever, they're not really relevant.
For more info on installing modules, you need to find out about something called 'cpan' - search the site here, on Google and at http://www.cpan.org/, and you'll find a load of useful info.
HTH!
Best wishes, andye
| [reply] |
Customarily, the first bit of advice might be that you use the Monastery's "Search" (top left) to tap the fonts of wisdom here, but your statement of your experience and the form of your question (which amounts to "please answer with a full tutorial") suggested you might consider
googling for the knowledge you need.
However, if your experise with mySQL is as you state it, you may find some of the fine Database Programming Tutorials where gmax's contributions (especially the The fine art of database programming) may be helpful.
But as for "a simple way to understand" all that you've asked about... well, the advice in the joke about how to get to Carnegie Hall comes to mind: "Practice, practice, practice!"
Phrased another way, when you've read and understood the documents; studied tutorials; read faqs; and practiced enough, all will become simple, but there are few shortcuts to "understand(ing)" that don't follow sequence
| [reply] |
| [reply] |