HTML Logo by World Wide Web Consortium (www.w3.org). Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS, which is now in beta. ocPortal 9 will be superseded by Composr 10.

Head over to compo.sr for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.


Customer Profiles, Extensive.

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#65600 (In Topic #14056)
box
Avatar

Fan in action

Hi,

I'd like to add about two dozen hidden, user-inaccessible fields to each user profile, with the values in these fields to drive some PHP add-ons.

Would it be best to

a) add these fields as additional columns to the existing OCP member table; or,
b) collect all these fields as a single new table, and add that table to the OCP DB; or,
c) break the various fields into neat, normalized, individual tables- one for Products, one for PurchaseDates, etc. ?

In my present, relatively simple membership script, keeping everything lumped together in a single long long long table (and as part of the basic member profile!) makes things easy to update and easy to view…

but what kind of DB design is best for OC Portal?

Thanks!
J
Back to the top
 
Posted
Rating:
#65601
Avatar

It depends how complex the data is I suppose. But have you considered just using CPFs? The Code Book describes how they can be referenced in code.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#65618
box
Avatar

Fan in action

Ah-- thanks. :)
Back to the top
 
There are too many online users to list.
Control functions:

Quick reply   Contract

Your name:
Your message: