Re: [mdb-dev] mdbtools with php

[Jakob E. <jab...@gm...>]

1) Sorry, don't know anything about this

2) I think mdb-tables has the command line option "-S" to show "system tables" (those whose names start with "MSys")
However, that's not the same as hidden tables in Access. Access also hides some tables that don't start with MSys, but these should always be "visible" in mdb-tables AFAIK.

On 07.04.2011, at 06:31, Dale Scott wrote:

> Thanks Jakob (and everyone else who replied). I’m making progress using the command line utilities from PHP now and so far so good. All should be good as I just need to periodically synchronize a MySQL database with a medium-size Access database - at least nightly but maybe hourly, and possibly user initiated when it’s necessary to pull immediately from Access to MySQL (mentioning this in case someone can say from experience it will be way too slow to be practical).
>  
> And now just another couple questions….
>  
> 1)      At least on my FreeBSD system, the mdbtools-0.5 utilities are dynamically linked while compiling from the github head gives statically linked utilities. Does anyone know if this is unique to FreeSD, or if it’s just a change in the way mdbtools compiles? (and why?)
>  
> 2)      The database I’m reading from has a couple tables “hidden” from Access (or rather, they seem to be “System objects” and have to be specifically unhidden to be visible). Mdb-tables in Mdbtools-0.5 returns all the tables, including the “hidden” ones, but the latest mdb-tables does not return these tables (just all the others). Anyone know why? (I can probably manage without the “hidden” tables, but one of them has username/passwords I was hoping to use to authenticate web users hitting the MySQL database) I can send an example database if anyone wants to take a look.
>  
> Dale
>  
> From: Jakob Egger [mailto:jab...@gm...] 
> Sent: Sunday, March 27, 2011 2:56 AM
> To: Dale Scott
> Subject: Re: [mdb-dev] mdbtools with php
>  
> Hi Dale,
>  
> I found it easiest to simply call the command line tools from php (mdb-tables and mdb-export), and parse the data using the CSV functions in PHP.
>  
> However, it only makes sense if you access data a table at a time. If you only need a few records, this method is probably very slow.
>  
> As an example, here's how I read MDB databases from within php:
>  
> <?php
>  
> $file = "NWind.mdb";
> foreach(tablesInFile($file) as $table) {
>             echo "<h1>".htmlspecialchars($table)."</h1>";
>             echo "<table>";
>             foreach(rowsInTable($file, $table) as $row) {
>                         echo "<tr>";
>                         foreach($row as $columnName=>$columnValue) {
>                                     echo "<td>".htmlspecialchars($columnValue)."</td>";
>                         }
>                         echo "/<tr>";
>             }
>             echo "</table>";
> }
>  
> function tablesInFile($file) {
>             exec("/usr/bin/mdb-tables -1 " . escapeshellarg($file), $tables );
>             return $tables;
> }
>  
> function rowsInTable($file, $table) {
>             $csv = popen("/usr/bin/mdb-export -q \\\" -X \\\\ " . escapeshellarg($file) . " " . escapeshellarg($table), "r");
>             $header = fgetcsv($csv);
>             $rows = array();
>             while($row=fgetcsv($csv)) {
>                         $rows[] = array_combine($header, $row);
>             }
>             return $rows;
> }
>  
> ?>
>  
>  
> Best regards,
> Jakob
>  
>  
> On 26.03.2011, at 21:15, Dale Scott wrote:
> 
> 
> Hi, how is mdbtools being used with php? I first tried pecl-mdbtools. Now I'm trying ODBC (via unixODBC). Are there other and/or better methods?
>  
> Also, I'm having trouble with either unixODBC or mdbtools segfaulting when I try to open a database, so I'm rebuilding everything from scratch on a new install of FreeBSD-7.4-RELEASE with latest ports to make sure I don't have a problem with wrong versions of libraries or something. If anyone has any suggestions, I'm all ears (it will be tomorrow until I can run the tests again).
>  
> Dale
>  
>  
> ------------------------------------------------------------------------------
> Enable your software for Intel(R) Active Management Technology to meet the
> growing manageability and security demands of your customers. Businesses
> are taking advantage of Intel(R) vPro (TM) technology - will your software 
> be a part of the solution? Download the Intel(R) Manageability Checker 
> today! http://p.sf.net/sfu/intel-dev2devmar_______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>