Skip navigation
Currently Being Moderated

Alphabet sorted cPanel for password protected directory

May 2, 2012 9:21 AM

Tags: #password #alpha #protected #directory #sorted #cpanel

I have a client who wants to put up their trade price list accessed by passwords. It looks simple using the facility within the host's cPanel BUT there could be 2000 names and there is no means within cPanel of alpha sorting them: they are simply added in the order in which they are . . .  added. This will be a real pain in trying to retrieve a particular name. I am using DW CS3. Any ideas greatly appreciated.

 
Replies
  • Currently Being Moderated
    May 2, 2012 9:36 AM   in reply to MissMoppett

    The basic CPanel protection is not what you need.  You need user level access through server-side scripting and databases.  I'd seriously recommend looking into either a CMS (Content Management System) or an extension of their CRM (Customer Relationship Manager).  Not sure if there is anything out there specifically built to your needs, but with that many customers I'm assuming 2 database tables minimum, 1 for the companies and 1 for the pricelists.  This is assuming 1 user per company. 

     

    If you go the CMS route, with that big of a table if you are looking for pre-made solutions Drupal or Joomla may have extensions to fit your needs.

     

    If you are going the CRM route you should be able to pull data from a Salesforce or InfusionSoft and give the end user the pricelist based information from that query without the need of installing/building user access on the website if this is the only use for it.

     
    |
    Mark as:
  • Currently Being Moderated
    May 2, 2012 12:18 PM   in reply to MissMoppett

    Your last post did clarify more but I would still go with my initial statement.  You cannot organize data the way you are looking to with Cpanel alone.  It's not meant to maintain that large of a userbase.  That's what databases are for.

     

    Here's the basics of what CPanel is doing via a GUI: http://httpd.apache.org/docs/2.0/programs/htpasswd.html

     

    It's basically writing to a text file.  It's meant to be good for a handful of users, but not the volume you are describing. 

     

    If it is the same price list for everyone, you can just get away with one database with simply usernames and passwords and if successful redirect them to another page with the PDF.  David wrote a tutorial here:

     

    http://www.adobe.com/devnet/dreamweaver/articles/first_dynamic_site_pt 2.html

     

    That is part 2 of his setting of your first dynamic website tutorial, but that one specifically talks about the login and database table portion. 

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points