5 Replies Latest reply on Nov 14, 2010 5:19 PM by J_Brooks

    Creating a Web Directory


      Hi there,


      I have been tasked with setting up a brand new directory for my company's website, and am trying to determine the best way to do this, especially since I have not worked with the website until now. Our company is fairly small, and one of our directors created (with the help of a graphics designer) and maintains the site through Dreamweaver, and I am intending to create a searchable directory very similar to this one: http://www.sportmedbc.com/directory.php.


      From what I understand, the best way to do this is probably to purchase a database program like Microsoft Access 2010 or possibly a more sophisticated program like Microsoft SQL Server 2008. I am assuming that most programs like these will be compatible with Dreamweaver, but please correct me if this is wrong. After purchasing the program, I would create the database and link it to the website using a search engine (which I also have no idea how to do, I'm hoping the website manager does, but advice is appreciated in case he does not!).


      As you can probably tell, I am definitely out of my comfort zone here so any advice is much appreciated, even if it's just a link to a site that will help educate me! Thanks in advance!

        • 1. Re: Creating a Web Directory
          Ben M Adobe Community Professional

          What kind of directory are you looking to create?  What will be in it?


          As far as databases go, I would say it would depend on your server.  Your current pages appear to be PHP pages which lead me to believe that you are on a Linux server which means you probably have mySQL databases already available to you depending on your host.  Access and MS SQL would not be able to run on the same server as the Linux website meaning you would need an additional server that the web server would need to connect to with those database types.


          Let's start with a description of what you need and then go with a description of what is available to you.  Then based on your current description I would recommend looking at a pre-built solution (whether open source or commercial options) and then point you in a direction to get you going.

          1 person found this helpful
          • 2. Re: Creating a Web Directory
            John Waller Adobe Community Professional & MVP

            As Snake says, follow some intial logical steps then check for available solutions:


            - start by defining the goal clearly (what kind of directory, how many records  how many total users and concurrent users)

            The more info you can tell us about the directory you have in mind, the better the solutions we can point you to.


            - check what tools are currently available to you.

            The example website for the link you gave is on a PHP-enabled server which often means Linux server and MySql database already available - all very robust tools. What do you have available to you at the moment?

            1 person found this helpful
            • 3. Re: Creating a Web Directory
              J_Brooks Level 1

              Thank you for the quick and helpful reply!


              The directory I am looking to create will encompass certified personal trainers (as well as weight lifting instructors, yoga/pilates instructors, etc.) across the province of BC (and if all goes well, it will be updated later to become a national directory). The idea is to allow visitors to quickly search for trainers in their area, with a quick description of them and contact information readily available.


              We are actually not affiliated with SportMedBC, we are just looking to model our directory after theirs. This is the link to our current website, which uses the .NET platform: http://canadianfitness.net/index.html# although adding the directory is part of a major revamp we are planning (including the introduction of an online store).


              I don't have too much of the server information but I have just requested via email the password for our google analytics account for the website, so hopefully I will have more access to this information shortly. Does the fact that we use the .NET platform mean that Access and MS SQL might be able to run on the same server after all? I certainly wouldn't be opposed to a pre-built solution but wouldn't have much of an idea of where to start and unfortunately price would likely be an object, but if it would be worth it hopefully I would be able to get approval :-)

              • 4. Re: Creating a Web Directory

                Check out this free directory list for some ideas.  Most of the directories there are running a PHP script named php link directory.  It's affordable and gives easy user management.  And the template system can be modified easily with Dreamweaver.

                • 5. Re: Creating a Web Directory
                  J_Brooks Level 1

                  Thank you so much Jamie! After exploring www.phplinkdirectory.com, it looks like a great choice for the directory I will be creating and they even have great support staff to hold my hand throughout the process. Even better, there are much cheaper than the alternatives I was looking at :-)


                  Thanks to SnakEyez02 and John Waller as well for your helpful input!