Displaying info from a database as a page

  • Resolved stealthpaws

    (@stealthpaws)


    4 years, 7 months ago

    Hi. I’m trying to develop a site, the purpose of which is to allow visitors to search for artists of a specific group. Data will be submitted to me via a form by each artist, and then I can input it I guess. Data includes names, business names, events they participate in, product categories (sub categories & items), state,etc. I’ve actually got the basics of the database in Access, which I’d export to a MySQL on the host server. My question is, I need these categories to be searchable, and to return a list of results (say 5 artists) which they could then click to go to a specific artist’s page and see only THAT artist’s info. Basically a lot like an e-commerce site, but with no commerce. I’m trying to get a “profile” page where a product page would be.

    I’d really appreciate help. I’ve used WP w/WooCommerce in the past, so I have a basic idea of how it works, but can’t find exactly what I need in the forums.
    Thank you!

    • This topic was modified 4 years, 7 months ago by stealthpaws.
    • This topic was modified 4 years, 7 months ago by Jan Dembowski. Reason: Moved to Fixing WordPress, this is not an Developing with WordPress topic

    The page I need help with: [log in to see the link]

Viewing 7 replies - 16 through 22 (of 22 total)

  • No, you can upload to imgur as anonymous.
    No problem, I’m in the middle of mounting a 60 inch tv !! Lol.

    Thread Starter stealthpaws

    (@stealthpaws)

    Hi again! I was going to reply, but figured it would just cause you to be interrupted again. Hope you got it up & running!
    I hope I did this correctly. Here’s the imgur link https://imgur.com/4b97mpG

    The idea is to have an artist, or one of us if need be, fill out the input form (or one like it on-line) to get the information into the database on WordPress. The artist will be on a subscription plan. As long as they renew, their info stays live. Then, a person who wants to shop, but cant remember what the shop name was, or the artist, or whatever can search by any & all of those categories – and then the information is returned with links the artist’s page (generated by the info in the DB) with a link to their shop.
    I just realized I haven’t added a website link yet, but that will be done. Also, hopefully social media pages. Yah. Big project for someone with very little current or recent experience. LOL.

    Thread Starter stealthpaws

    (@stealthpaws)

    PS – there is absolutely nothing being sold ON the site. It’s not an e-commerce site. Just to be clear. I just want artist pages to LOOK like a “product” page like you’d get in Woo, or on my own site.

    I agree you’re taking on a lot.
    What was the reason to start inputting into Access?
    And do you have anything functional yet, or so far you only have the data?

    I would go back to read this :
    https://www.ads-software.com/support/topic/displaying-info-from-a-database-as-a-page/#post-13112432

    Custom post + Advanced Custom Fields.

    It will definitely take some manipulation to migrate your existing data.
    Or, with your custom post type with the fields set up to capture all the data you want, you ask the artist to input their data. Also, if you use the Ultimate Member, then when the artist wants something changed they can simply login to the site and change their profile data. There are a lot of moving parts you need to consider. I would make sure you have strong functional requirements, and then chunk them up into priority. For example, perhaps out of the gate you release the site publicly, but don’t charge the artist right away. Wait until your site gets traction before charging. Things like that. Bc Member management + paying online + roles and permissions + private profiles is a whole project into itself. Focus on one aspect, and get it right. Just my 2 cents.

    Thread Starter stealthpaws

    (@stealthpaws)

    Originally, I wanted to determine what we’d need in terms of information we’d need to gather, how I’d structure it & try to keep it clean & how a form would look. I started 2 weeks before we got the site. I assumed it would be easily transferable. I wrote fields into MySQL years ago (like…18 maybe?) or copied them, I don’t remember… but it wasn’t this complicated a situation. I also seem to recall I did it on my computer & then uploaded it to the hosting site. I’ll read the article. I’ve read so much I’m dreaming about data bases & WordPress. Ugh.

    As far as recreating the info already in? I don’t mind re-tuping it. I just want it structured this way. I don’t want a million random categories/subcategories floating around, or the same Renaissance fair referred to in 5 different ways. In other words I want users’ pages be reasonably constained to the parameters set by the site.
    Tks again!

    Edit:
    Basically? The ONLY reasons the artists might interact with the site is to fill out their form, and set up their pymt plans. Maybe update if they change something. We don’t expect enough people to sign up initially that we couldn’t handle the data entry ourselves if need be. I don’t understand about user profiles…I’ll look tomorrow.

    • This reply was modified 4 years, 7 months ago by stealthpaws.

    > I don’t want a million random categories/subcategories floating around

    Yes.
    You need to control the input.
    Like this :
    https://www.advancedcustomfields.com/resources/select/

    You can also conditionally insert values in one field based on input from other field(s) :
    https://support.advancedcustomfields.com/forums/topic/how-to-auto-populate-a-field-getting-values-from-other-fields/

    Thread Starter stealthpaws

    (@stealthpaws)

    Hi Corrina! I was up until 2 am reading & talking to my partners. I had the right idea, but the wrong approach. I found a directory site plug in that actually works, searches well, & with tweaking, will do nearly exactly what I needed. I set up a sub-directory & data base & used a duplicate plug in to clone the site into the new directory. Working with it there. I really appreciate your kind & patient responses, and all the information. It helped a lot, even if to let me know I was going at it wrong. Enjoy your big TV!

    • This reply was modified 4 years, 7 months ago by stealthpaws.
Viewing 7 replies - 16 through 22 (of 22 total)
  • The topic ‘Displaying info from a database as a page’ is closed to new replies.