4 {{ upvoteCount | shortNum }}
4 {{ upvoteCount | shortNum }}

Need Advice - Creating a Database - I think

by Jeremy James
3 replies
Hey friends,

Got kind of an offline/online business I am about to create with my friends. Basically, we have 50+ offices where the members all change quite a bit, and phone numbers are hard to get ahold of. So, we have come up with a marketing plan to sell a internet and hard copy product that will keep them "in the know" of current contact info (phone, address, email.)

The hard copy will be easy, we'll just find a local printer and get a good rate from him.

However, my question is about the internet copy. Basically, with the exception of a loose association, each office is separate from each other. I want to create a database/website/something where a person can log in and check his office info, but, not another, or, even better, so someone on the "outside" can't just log in and get personal info.

I really don't see the need to develop a separate website/domain name for each office, but, need a way to keep it divided up/secure. Any suggestions?

Thanks.

Jeremy
#advice #creating #database
  • Profile picture of the author Syndicator
    Yep this is pretty basic and actually you could even use a basic Access DB to do this.

    Whilst mySQL is more secure and robust, the server load and traffic would be so low that ACCESS could do it to.

    If you don't have access then just use mySQl as just about every host has this pre-isntalled and good to go.

    Do you have any programming or database experience?

    You may even be able to find something from Wordpress or Joomla that does this already through a module. Joomla Extensions can be found here.

    These can be easily installed on any hosts mysql/php enabled server and then just plug in the modules and use the tools they provide to manage security and data.
    Signature
    How can Inbound Marketing help your company reach it's goals?
    We’ll assess your current marketing and unlock your potential for improvement. Request Assessment
    Digital Hinge Pte Ltd Singapore Digital Agency
    {{ DiscussionBoard.errors[1806468].message }}
  • Profile picture of the author Jeremy James
    Here is the one caveat, and, it may not be an issue at all. I have not worked with SQL or Access. I need to be able to have ads on each side of the page (that's the way we're paying for this, and getting revenue.) After I develop this list, can I upload it so that I can have ads on there?

    Thanks.
    Signature

    Have you ever been a ticked off customer? My reports gets you Satisfaction and Resolution! Click HERE to check it out!

    {{ DiscussionBoard.errors[1806529].message }}
  • Profile picture of the author Jeremy James
    Also, let me ask this question.

    Initially, I am going to have around 55 or so offices for this product. I am assuming, from what I am reading on here, and also talking to others, that I am just going to want one website, and let each individual office have their own "page" that's accessible with a specific user name/password.

    Typically, how much will my hosting/registration/website fees be per year? I don't figure on needing too much space, just enough for business card sized ads, and, also, the individual directories.

    Thanks.
    Signature

    Have you ever been a ticked off customer? My reports gets you Satisfaction and Resolution! Click HERE to check it out!

    {{ DiscussionBoard.errors[1836782].message }}

Trending Topics