August 10th, 1999, 04:58 AM
We are looking at hosting a simple business directory site using MYsql and
PHP. This would be a start to various information related content on a web
site related to India.
The database contains contact information on about 5000 companies. This will increase to abt 100,000 listings in say six months. We maintain the database as foxpro files, which we understand can be uploaded to the mysql database.
The fields of the business database which we want to start immdtly are;
Pin code (ZIP)
Phones (1,2,3)... 3 telephone numbers
Name of contact person
Contact persons designation
Business Categories (1,2,3).... 3 different business categories or headings.
It would be similar to the business search on say http://www.bigyellow.com
or any other yellow pages site
For Ex: Someone may query for businesses selling Zippers ( Business
Categories ) in NewYork (City) with and/or Pin/Zip code ( for a business
How do we get to use PHP to do this. Would you be able to help. Anybody have some simple code for this?
Would someone be able to suggest
some developers who could do this work for us.
August 10th, 1999, 06:03 AM
August 29th, 1999, 04:50 PM
When we do this for out clients we normally get the database to create a delimited file and use a web page to pull the file from the hard drive and update MySQL.
To pull the file we use input type=file within a form and process the file with PHP3 to copy it to the relevant location for incorporation into the Database.
Its a quick system and very easy to use.