On Thu, Aug 16, 2012 at 2:59 PM, Mike Copeland <[email protected]> wrote:
> My experience with PHP+DBF > files is that PHP will open DBFs, but has absolutely no regard for file > and/or record locking and I've heard rumors of index files getting out > of whack if you use PHP to update DBF files. So, I've never put any code > into use that accessed DBFs from PHP code. Not even just reading a DBF. > Yeah, okay. There are several libraries around for PHP that support 'DBF' access, but understand DBF is even less of a standard that EDI - it is just the three letter suffix used to end the name of an ISAM file produced from xBASE, dBASE, Recital, Excel, askSam and a whole bunch of other incompatible applications. You really want to avoid PHP libraries that claim to read DBF. OTOH, PHP on Apache on Windows does a decent job with ODBC and I've worked on a couple of projects that used that. You MUST run on Windows, since you are using the Microsoft-proprietary VFP drivers (essentially, the VFP runtimes with ODBC APIs) to access the Fox tables. And since MS dumped support for VFP ODBC around version 6, you'll find insufficient support for many of the newer features of VFP. (BTW, in case anyone has their VFP chip on their shoulder, I have to say that the PHP story on Windows isn't much better with other databases, like SQL Server. I have war stories.) -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cacw6n4tzmokrkwhecdxa36o_koc7vsbb3wsk1ad5kzjc+jn...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
