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

[Jim Burnett]

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
>