Re: PHP and Fox Pro (ADODB) question
| From: | (Er Galv�o Abbott) | Date: | Wed, 05 Sep 2001 16:30:52 +0000 |
| Subject: | Re: PHP and Fox Pro (ADODB) question | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12176@lists.php.net to get a copy of this message | ||
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,
>
>