[Mapserver-users] Re: Query data PHP/Mapscript

[woodbri at swoodbridge.com]

In PHP look at the dbase module and in Perl look at the xbase module. 
Both of these will allow you to open and read dbf files.

-Steve W.

On 26 Mar 2003 at 8:36, Jim Burnett wrote:

> I am pretty sure the are NOT dbase files, however mapserver reads them
> just fine when querying the map. What I want to do is query these
> files without displaying a map, but show the results of thedata found.
> Currently I put the data in mysql, but I want to make my application
> 100% mapserver driven. Then I just search on the mysql database  using
> sql. So thats what I want to do with mapserver.
> 
> -Jim
> 
> ----- Original Message -----
> From: "Puneet Kishor" <pkishor at geoanalytics.com>
> To: "'Jim Burnett'" <r000t at adelphia.net>;
> <mapserver-users at lists.gis.umn.edu>
> Sent: Tuesday, March 25, 2003 5:08 PM
> Subject: RE: [Mapserver-users] Re: Query data PHP/Mapscript
> 
> 
> > please reply to the email list... others may have better ideas than
> > me.
> >
> >
> > > -----Original Message-----
> > > From: Jim Burnett [mailto:r000t at adelphia.net]
> > > Sent: Tuesday, March 25, 2003 3:58 PM
> > > To: pkishor_98
> > > Subject: Re: [Mapserver-users] Re: Query data PHP/Mapscript
> > >
> > >
> > > I was hoping to not have to use odbc. Is there anyway to access
> > > the information via mapserver? I could do a query, show the query
> > > on the map and in templates.
> >
> > when you say "I could do a query" do you mean that you are able to
> > do so,
> or
> > you would like to do so?
> >
> > I am not sure of the capabilities of the dbase methods that have
> > been recently built in mapserver, but my sense is that they also
> > access only
> dbf
> > files that are actually dbase compatible. The problem is, dbf files
> created
> > by foxpro are not really true dbf files... they just happen to have
> > the
> .dbf
> > extension. If that is what you have, odbc may be the only way out,
> > unless you can find a foxpro driver for php (I seriously doubt
> > that).
> >
> > So, first determine what exactly these dbf files are. Then use the
> > appropriate way to access them.
> >
> > Hope this helps.
> >
> > Puneet.
> >
> >
> >
> >
> > >
> > > ----- Original Message -----
> > > From: "pkishor_98" <pkishor at geoanalytics.com>
> > > To: <mapserver-users at lists.gis.umn.edu>
> > > Sent: Tuesday, March 25, 2003 4:37 PM
> > > Subject: [Mapserver-users] Re: Query data PHP/Mapscript
> > >
> > >
> > > > --- In mapserver-users at yahoogroups.com, "Jim Burnett"
> > > <r000t at a...> wrote:
> > > > > Yeah I looked in the dbase methods but they dont work
> > > > > with any of the dbf
> > > > > files I have. Actually Excel and Access can even read
> > > > > them.  Any clues?
> > > >
> > > > I am assuming you meant to write "Actually Excel and Access
> > > > _can't_ even read..."
> > > >
> > > >
> > > > Since neither Excel nor Access can read these dbf files, they
> > > > are probably not dbf files created by dbase, or compatible with
> > > the dbase
> > > > format. In all likelihood, these are foxpro files. In which
> > > case, your
> > > > best bet would be to use the foxpro odbc driver, and access
> > > the files
> > > > as odbc datasources.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > >
> > > > >
> > > > > ----- Original Message -----
> > > > > From: "pkishor_98" <pkishor at g...>
> > > > > To: <mapserver-users at l...>
> > > > > Sent: Tuesday, March 25, 2003 3:57 PM
> > > > > Subject: [Mapserver-users] Re: Query data PHP/Mapscript
> > > > >
> > > > >
> > > > > > --- In mapserver-users at yahoogroups.com, "Jim Burnett"
> > > <r000t at a...>
> > > > wrote:
> > > > > > > Hey all, looks like spring is here at last!
> > > > > > >
> > > > > > > Anywho, I want to search a dbf file for some data (
> > > not map ). For
> > > > > > example I have a parcel layer that I want to search on.
> > > I want to get
> > > > > > all the "smiths" or whatever I want to search on. Can
> > > this be done?
> > > > > >
> > > > > >
> > > > > > sure... check out the dbase methods in php. make sure
> > > php is compiled
> > > > > > with dbase.
> > > > > >
> > > > > > since dbf is a crummy format, you will have to loop
> > > through each row,
> > > > > > and within each row, loop through each field, unless
> > > you know which
> > > > > > field you are searching for, until you find what you
> > > are looking for.
> > > > > >
> > > > > > _______________________________________________
> > > > > > Mapserver-users mailing list
> > > > > > Mapserver-users at l...
> > > > > > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> > > > >
> > > > > _______________________________________________
> > > > > Mapserver-users mailing list
> > > > > Mapserver-users at l...
> > > > > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> > > >
> > > > _______________________________________________
> > > > Mapserver-users mailing list
> > > > Mapserver-users at lists.gis.umn.edu
> > > > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> > >
> > _______________________________________________
> > Mapserver-users mailing list
> > Mapserver-users at lists.gis.umn.edu
> > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> >
> 
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>