Re: PHP and Fox Pro (ADODB) question
| From: | John Lim | Date: | Wed, 05 Sep 2001 16:53:51 +0000 |
| Subject: | Re: PHP and Fox Pro (ADODB) question | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12177@lists.php.net to get a copy of this message | ||
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,
> >
> >
>