Database & Application Miscellaneous: zip code search

• jdzines / 216 / Thurs, 28 Jan 2010 18:05:00 GMT / Comments (2)
• Hello!
  I have a project where I need to create a dentist search by zip code in our city. The search menu just has all the zip codes and when you select your area, all the dentists that are registered with the site (that are in that zip code) show up. I would like to kill two birds with one stone and have a registration page for new dentists to fill out including their name, address, phone, zip, and type of practice they are in. Have this information go into the database for the search. Is this possible or pretty complex?
  Any input would be appreciated.
  Thanks!
• Keywords:

  zip, code, search, database, application

• http://database.itags.org/database-application/158210/«« Last Thread - Next Thread »»

• 1. Assuming I am right about what your asking, a simple registration form will be very easy to do, especially if you can make the search form work
     
     1. Simply setup a form, and post it to your php script.
     
     2. Get the data ($HTTP_POST_VARS), do any validations on it you need, and use the INSERT command for mySQL (instead of the SELECT command you are using for your search form).
     
     If I have assumed your problem is much simpler than it really is, I apologize, but from what you wrote, this should be a very simple project for you.
     
     -Jared

     jdeschn | Fri, 16 Nov 2007 01:51:00 GMT |

  2. Well, I guess it's kind of silly to pretend like I know what I'm doing with this since I've never worked with php before. My last server only ran asp scripts so it took me a while to figure that out. Can php scripts be added into html pages and run or do the pages all need to be .php pages? I have the site all running except for the database stuff. I just started studying php, but this needs to be done quickly. I could pay someone to walk me through this (I would rather learn than get a free ride). What do you suggest? Your input is greatly appreciated.
     Thanks,
     Dean

     jdzines | Fri, 16 Nov 2007 01:52:00 GMT |