Solved

WordPress database versatility

Posted on 2016-07-19
7
68 Views
Last Modified: 2016-07-19
New Webpage designer.  Is Participants Database the best/only db plugin for WordPress?  I'm encountering trouble with such things as varying the width of fields, validating user inputs and displaying all fields on one screen.  I'm used to MS Access versatility.  Am I looking for things that don't exist?
0
Comment
Question by:Member_2_7968517
  • 4
  • 3
7 Comments
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 41719473
Not sure what it is you are looking to do.
0
 

Author Comment

by:Member_2_7968517
ID: 41719494
Need simple answers/recommendations/reasons at this time regarding collecting membership data on a website. Would be nice to evaluate answers on the fly, so answers are valid when completed.
0
 

Author Comment

by:Member_2_7968517
ID: 41719561
Currently my website new membership application input is viewable with "Participants database", but I don't see where I can validate the newly engtered field data such as zip code, for which I need to confirm that it is a valid 5 digit number, and also confirm that it is an existing postal zip code by comparing it to a list of U.S. zip codes.  Can WordPress do this?  Do I need to find a more versatile Website creation tool?
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 70

Accepted Solution

by:
Jason C. Levine earned 500 total points
ID: 41719708
Can WordPress do this?

Yes, but when you use plugins you are (for the most part) limited to the capabilities of the plugin.  You CAN do what you want with plugins but not quite the way you are doing it now.

I'm used to MS Access versatility.

WordPress database design is not quite like MS Access.  For users, there are two tables:  

wp_users = holds username, hashed password, email address, couple of other columns.

wp_usermeta = holds everything else but not as separate columns.  Instead the user_id, the meta name and the meta value are each on a row and each user has tons of rows to correspond with whatever custom data you want for them.  Since these are just text columns in MySQL, they don't have any native validation on them like Access does.  You have to add all validation as client or server side scripting.

 I'm encountering trouble with such things as varying the width of fields, validating user inputs and displaying all fields on one screen.

So this gets a little complicated in WordPress. You can use custom meta fields to store as much data about a user as you like, but the default WordPress user profile screen is not really the best target for a super-complex user profile system.  As you have discovered, when you go into the plugin ecosystem, you will find stuff that gets you part of the way there but not all of the way there.

For your particular needs (especially validation), I would actually not look at profile plugins so much as a couple of the better form builders.  Specifically I'm thinking about Gravity Forms, Formidable Pro, and Ninja Forms.  All three of them can be configured to read and write user meta data into a form with advanced validation capabilities.  Of the three, I would probably look at Formidable Pro first as it is the easiest one to create a form tied to a specific login and allow edits.
0
 

Author Comment

by:Member_2_7968517
ID: 41719763
Thanks very much for that foundation.  No doubt be seeing you again.
0
 

Author Closing Comment

by:Member_2_7968517
ID: 41719765
More related questions to come, undoubtedly.  Thanks again, Jason.
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 41719805
No worries. Ask away
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Did you use a default hosting installation of wordpress with the intention of it being your actual site?  Maybe you’ve installed it as a Blog to your current site and recently converted it to be the main site and do away with the old .htm pages.  An…
Like there are many different versions of Wordpress, there are also a handful of related side projects WordPress users should be familiar with.   All of these projects are open source and GPL licensed, which means there are few restrictions to us…
The purpose of this video is to demonstrate how to insert an Iframe into WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Open Page or Post…
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question