5 {{ upvoteCount | shortNum }}
5 {{ upvoteCount | shortNum }}

Best database to use??

by JonathanBoettcher
4 replies
  • WEB DESIGN
    • |
Hi guys,

I've got a client that wants to have a map that is broken into a few different territories. It needs to be integrated with a database, because he's got a certain number of people available for each territory. They'd like to be able to see the number of people available for each part of the map.

Customer will click on the part of the map that is relevant to them, it will tell them how many people are available, then it will bring up a contact form where they will fill out their info.

The form will then be emailed to my client, and the database will include the relevant people available for that territory.

My questions are:
1. Would MySQL/PHP be a good option for this?
2. What is the best way to access and maintain this database? It needs to be user-friendly for the client to maintain. Can they upload a spreadsheet to update the database?
3. How much should be expected for this sort of project and/or are any of you willing to quote on it?

Cheers
Jonathan
#database #mysql
  • Profile picture of the author justthinking
    I think MySQL/PHP is a great option for your database. The easiest way to maintain it is with myphp. It can be learned quickly and painlessly. Your customer doesn't even have to learn MySQL to query his database. Most MySQL databases can even be updated with a csv file. Again, very easy to do.

    EDIT: Johnathan: myphp is just a front end to aid in querying the database.
    {{ DiscussionBoard.errors[549578].message }}
  • Profile picture of the author JonathanBoettcher
    thanks JustThinking - I've not heard of myphp before but it sounds promising.
    Signature

    Discover My Effective Backlinking Strategies...

    {{ DiscussionBoard.errors[549591].message }}
  • Profile picture of the author xga
    MYSQL should able to do the job.

    I don't think MySQL can be updated via spreadsheet. But most spreadsheet application can export the data as CSV text file. And MySQL have command to load data from CSV files.

    phpMyAdmin is a very good tool for maintaining the MySQL database.
    {{ DiscussionBoard.errors[550629].message }}
  • Profile picture of the author mywebwork
    Aloha Jonathan

    MySQL would be well-suited to this application.

    I built a (admittedly silly!) website using an image map that has a lot of similar functionality - it allows users to select their state from a map of the US and find a "Turkey Trot" (an annual Thanksgiving Fun Run) in their area. You can see it in all it's silliness at Turkey Trot Info Find a Turkey Trot .

    The data is out of date at the moment (it still has Thanksgiving 2008 data) but the idea is similar to what you describe - I hold the page data for the Turkey Trot descriptions in a MySQL database and run the whole thing under WordPress. I do the updates myself on a local database that I export to the site, but building a custom front-end to do administration would be pretty simple with a bit of PHP. Importing a spreadsheet would also be pretty easy, I have another online database that I built for a client that they import students using an Excel file. The map itself is just a simple image map.

    If you're interested I'd be happy to discuss this further - please feel free to PM me.

    All the best

    Bill
    {{ DiscussionBoard.errors[550902].message }}

Trending Topics