Query DBF records using PHP

From: Date: Thu, 07 Sep 2006 14:45:05 +0000
Subject: Query DBF records using PHP
Groups: php.general 
Request: Send a blank email to php-general+get-241442@lists.php.net to get a copy of this message
Ave, Let¹s say I have a DBF file residing on my somewhere. It has 20 fields, and about 100 records. Is it possible for me to Query that DBF file, so I can search that database for a record and Display the row using PHP? Basically what I want to do is pull out a record from that DBF file that matches the ³Phone Number² entered by the user... And show that record on my PHP page. What I¹m doing is importing all the DBF records in my mySQL database, and then doing the search on that mySQL database and displaying records. I want to eliminate the mySQL database and query the DBF file directly and display records from it. There¹s very little that I find anywhere on the internet pertaining to the dbase functions in php. I¹m easily able to open a DBF file, read all the data and import it into mySQL using some functions I¹ve written. I just don¹t know if I can search the Database or match a record and display it without importing it into mySQL. Any suggestions? Rahul S. Johari Supervisor, Internet & Administration Informed Marketing Services Inc. 500 Federal Street, Suite 201 Troy NY 12180 Tel: (518) 687-6700 x154 Fax: (518) 687-6799 Email: rahul@informed-sources.com http://www.informed-sources.com

« previous php.general (#241442) next »