12 {{ upvoteCount | shortNum }}
12 {{ upvoteCount | shortNum }}

Is it possible to add a database for clients....

by swriviera
10 replies
Hello,

Someone close to me had hired a webmaster to build a site and .... nothing!! He got sc..wed!!

I can set up the basic site with wordpress but what he also wants to have is a (please excuse me if I don't use the correct term) secure database where each client will have access with their unique password to get access to different proprietary/sensitive documents such as contracts, estimates etc. Can this be added to a wordpress-based website? If so - can anyone tell me where I can get the info to do this? If not - can you make suggestions?

I believe that the web-hosting needs to provide SFTP, SSL ..... what else?

Thank you,
Sandra

P.S. I havel posted this same question in the website design area because it overlaps
#add #clients #database
  • Profile picture of the author arunvinud
    No you cant change the database of a wrodpress.Only thing you can do is to custom code the website or use wordpress as the base and custom code the webpage to which the client lands after clicking a link.As far as security is concerned use mobile authentication,image verification,custom encryption.
    Signature
    Technology Web Log
    {{ DiscussionBoard.errors[5604484].message }}
  • Profile picture of the author webpeon
    youre basically asking if you can take a truck designed to carry boxes and boxes of cargo and modifying it to be able to race safely on a race track...

    short answer, probably is possible, but is it really worth the modifications youre going to need to do to make it happen, most likely not.

    .net combined with mssql will get the job done for you easy enough... then no doubt someone will vouch that php combined with mysql will get the job done as well but i cant comment on the php option myself
    Signature
    Web 2 Mobile
    The Future of The Web
    {{ DiscussionBoard.errors[5604581].message }}
  • Profile picture of the author genanovlis
    What you want can be accomplished simply through the use of proper word-press plugin development, creating custom post-types, adding filters to what different users see, etc..
    {{ DiscussionBoard.errors[5609612].message }}
  • Profile picture of the author demoakka
    i think you can not change the database of wp
    {{ DiscussionBoard.errors[5944307].message }}
  • Profile picture of the author phpg
    Perhaps you can achieve this with a wp plugin like this one: WordPress › Role Scoper « WordPress Plugins .
    {{ DiscussionBoard.errors[5944496].message }}
  • Profile picture of the author BlackWar
    Banned
    Its not changeable..
    Ya plugins may help you..
    I'll give you few names of them also, ASAP.
    {{ DiscussionBoard.errors[5947454].message }}
  • Profile picture of the author Earnie Boyd
    What you ask for is known as a CRM. What you have is role based access based on user identification where each user has a unique role for security reasons to access content either at a directory on the server or areas of the database.

    My suggestion is to go to sourceforge.net and search for CRM you'll find many. One of which is CiviCRM Community Site | Open source constituent relationship management for non-profits, NGOs and advocacy organizations. and maybe what you need to help get you started. Another is The Power of Open Source | Open Source Business & Social CRM - SugarCRM but if I remember correctly is Java based.

    Originally Posted by SWBusiness View Post

    Hello,

    Someone close to me had hired a webmaster to build a site and .... nothing!! He got sc..wed!!

    I can set up the basic site with wordpress but what he also wants to have is a (please excuse me if I don't use the correct term) secure database where each client will have access with their unique password to get access to different proprietary/sensitive documents such as contracts, estimates etc. Can this be added to a wordpress-based website? If so - can anyone tell me where I can get the info to do this? If not - can you make suggestions?

    I believe that the web-hosting needs to provide SFTP, SSL ..... what else?

    Thank you,
    Sandra

    P.S. I havel posted this same question in the website design area because it overlaps
    Signature
    Earnie Boyd
    {{ DiscussionBoard.errors[5958303].message }}
    • Profile picture of the author BlueLayerHost
      Originally Posted by arunvinud View Post

      No you cant change the database of a wrodpress.Only thing you can do is to custom code the website or use wordpress as the base and custom code the webpage to which the client lands after clicking a link.As far as security is concerned use mobile authentication,image verification,custom encryption.
      Originally Posted by demoakka View Post

      i think you can not change the database of wp
      Originally Posted by BlackWar View Post

      Its not changeable..
      Ya plugins may help you..
      I'll give you few names of them also, ASAP.
      You all are absolutely wrong. YES, you can utilize the current WP database structure e.g. wp_options as well as extend the database with your own queries, custom plugins and custom post types.

      It sounds like wp wishlist might be a good fit for you as it would allow access on an individual basis to certain restricted areas of a WP install.

      Class Reference/wpdb « WordPress Codex :rolleyes:
      Signature
      BlueLayerHost - Shared + Managed VPS Hosting
      BlueLayerMedia - Web Development
      WPMalware - Resource for WordPress Seurity + Exploits
      {{ DiscussionBoard.errors[5959322].message }}
      • Profile picture of the author PHPSpaZ
        You could also create a new db table among the wp tables via your web host manager and store your user info in that. Put a link on your index page to go to a simple php login page where you can set a session var. After that on the page that this protected data is accessed from you can add in a simple check for that session var and just put the whole page into an if/else clause...
        IF(they logged in){
        display wordpress code that shows the data
        }
        ELSE{
        redirect to failed authentication page
        }

        This may seem a bit difficult but I have had to do it before. If you use the hash encryption method for your data it WILL be secure. Especially when you add SSL to it.

        Hope this helps
        {{ DiscussionBoard.errors[5959832].message }}
    • Profile picture of the author Darknite7
      Originally Posted by Earnie Boyd View Post

      What you ask for is known as a CRM. What you have is role based access based on user identification where each user has a unique role for security reasons to access content either at a directory on the server or areas of the database.

      My suggestion is to go to sourceforge.net and search for CRM you'll find many. One of which is CiviCRM Community Site | Open source constituent relationship management for non-profits, NGOs and advocacy organizations. and maybe what you need to help get you started. Another is The Power of Open Source | Open Source Business & Social CRM - SugarCRM but if I remember correctly is Java based.
      Earnie is 100% this is a CRM,

      you have two options

      * Use of the shelf (+licences)
      * Get a custom one developed (last one I worked on was £40K/year this included maintenance)

      I'm sorry but WP + Plugins will not do the proper job of a CRM
      {{ DiscussionBoard.errors[6064920].message }}

Trending Topics