Re: Re: PHP and Fox Pro (ADODB) question

I'd *mildly* disagree with that suggestion - is this a VFP database or 2.x? Are sub-selects used extensively? Do you need stored procedures? If so, PostgreSQL may be a better choice. If it's 2.x, simple joins, sure, MySQL is fine. Miles Thompson At 12:53 AM 9/6/01 +0800, John Lim wrote:

Best is to port the database to mysql then. Regards, John "Er GalvãO Abbott" <erabbott@DONTSPAMterra.com.br> wrote in message news:3b96531a.411150@news.php.net... Is it possible to do it on Linux servers? On Wed, 5 Sep 2001 23:39:09 +0800, jlim@natsoft.com.my (John Lim) wrote:

Hello, You need to configure an ODBC DSN that accesses the foxpro database.

Assume

the DSN is called foxy. Then download from http://php.weblogs.com/adodb the library. Sample code: include('adodb.inc.php'); include('tohtml.inc.php'); $conn = &ADONewConnection('vfp'); $conn->PConnect('foxy'); $rs = $conn->Execute('select * from table'); rs2html($rs); /* recordset to html table */ John Lim PS: This only works on Windows. "Er GalvãO Abbott" <erabbott@DONTSPAMterra.com.br> wrote in message news:3b9512a5.2381817@news.php.net...

Greetings I'm a newbie but I've been doing very nice thing with PHP. Now a challenge appeared and I'm kinda lost and in need of some help. I have a project that I have to make search and display routines in a Fox Pro database. Everything was wonderful because almost all data I've needed was stored in DBF files and PHP Dbase functions were handling this very well. Now I've found that a piece of data that is extremely important to the application is in a FPT file. I saw a thread here that recommends the use of the ADODB library for PHP that can be found at http://php.weblogs.com/ADODB Well, what I need, hoping that I'm not asking too much is if there is anyone hre that can give me a practical example - maybe a code snip - on how to achieve this. Any help will be gratefully appreciated. Thanks in advance,

-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net