i have some problems to fetch the data from a mysql database generated
with phpmyadmin. i'm a beginner in programming in perl. i'm nit sure
whther i chose a well formed expression to refer to the database. here
is the code:
$dbh =
DBI->connect("DBI:mysql:c\programme\xampp\mysql\data\lexikon;localhost","myusername","mypassword")
or die "Keine Verbindung möglich: " . $DBI::errstr;
$sql = "select * from v";
$dbh->prepare($sql)
or die "prepare nicht möglich: " . $dbh->errstr();
$sth->execute()
or die "execute nicht möglich: " . $sth->errstr();
while (@row = $sth->fetchrow_array) {
print "@row\n";
}
$sth->finish;
$dbh->disconnect;
after having processed this code i exspect the engine to print the
values stored in table "v". this code is part of a cgi-script which
shall be used to a database which contains a thesaurus and to check whether
.
PostgreSQL and Customer Database ... I've been working on both SQL and Perl for a while now, ... get them all onto an SQL database, and be able to keep track of sales, as ... the database available to customers and potential customers, ... (perl.beginners)
Re: How to access MS Access from Perl? ... if you were to later migrate to MS SQL Server or Oracle ... minimize your load on the database server's compiled procedure cache. ... On the other hand, if startup time for your perl script is an issue, and ... slightly preferable to the bulkier DBI + DBD::ODBC. ... (comp.lang.perl)
Re: LAMP - Program Design with Perl ... > information and queries the MySQL database.... > Maybe there are Perl modules to faciliate this kind of task? ... so I think it worthwhile to second Anno's suggestion on this method (eg. ... Aside from the hint about dispatch tables, ... (comp.lang.perl.misc)
Re: Attempted Simultaneous Access causes "Could not lock file" ... storing it in my MSAccess database.... I just wrote another test perl program and pasted in the massive SELECT ... >> I can have multiple perl programs writing to the database, ... > It probably needs exclusive access to the entire Table if it's modifying ... (microsoft.public.access.tablesdbdesign)
Re: Server-side script executed on page load or event, but not SSI ... I'm sorry I used the term 'database'.... I know I can do it simply by linking to the script,... for running a perl script automagically when a page is loaded. ... Are there any other perl alternatives?... (comp.lang.perl.misc)
