|Contents||Perl Database interaction --DBI Module|
PERL - DBI Module(s)
PERL is capable of running SQL and MySQL queries including: inserts, selects, updates, deletes, etc through a module termed DBI. Often your web host will already have this module as well as DBD::mysql already installed. DBI stands for database interface. Any functions associated with DBI should work with all the available SQL platform including: SQL Server, Oracle, DB2, and MySQL.
Before continuing, be sure the following modules are installed:
Once they are installed, we can build the introduction to our script by telling PERL to use these modules as follows:
#!/usr/bin/perl # PERL MODULES WE WILL BE USING use DBI; use DBD::mysql;
Again, these modules allow for us to call upon functions specific to working with a any database platform including MySQL. These modules must be in "use" to ensure proper functionality of our scripts.
PERL - DBI Config
We will be calling on our database, table, and host machine from time to time. We recommend setting up a some variables for your database and table name, so that you can call upon them as you wish throughout this brief tutorial. You may also set up some variables for your user name and password as we will also be needing to connect to your MySQL web host.
#!/usr/bin/perl # PERL MODULES WE WILL BE USING use DBI; use DBD::mysql; # DBI CONFIG VARIABLES $host = "localhost"; $database = "store"; $tablename = "inventory"; $user = "username"; $pw = "password";
Want Some more information
and Video ???