Relational Databases

DMS General
1

I’m not sure where to put this request, so please move the post if needed.

This is a case of: Agree to do something first and figure out the “how” later.

I am building a website for an industrial process company. I am creating a relational database to integrate into a WordPress site. I want the database to provide various outputs to the site based on a number of factors (Product Category, Manufacturer, Application, etc.). I understand the basics, but don’t know how to integrate the database into WordPress.

Of course, I could watch YouTube and spend a lot of time with trial and error experiments, but I would learn it much faster if I could see someone doing it and asking questions here and there.

Thank you in advance.

2 Likes
2

If you’re very, very, very lucky, @denzuko will give you some of his time and guidance.

4 Likes
3

Try the Advanced Custom Fields plugin. It will give you a visual builder for a relational database. An example of the output is here. Another with pins displayed on a Google Map here.

You can also define your own taxonomy in WP and use that. Little harder to use but…

3 Likes
4

I believe there are regularly scheduled office hours on wednesdays for programming assistance? not sure if that is still a thing…

1 Like
5

yes and anyone can pick a time that’s free:

:smiley:

1 Like
6

Not doing the holidays. I’ll be out of town until January starting next week and this week I might be able to pencil something in.

2 Likes
7

I am building a website for an industrial process company. I am creating a relational database to integrate into a WordPress site. I want the database to provide various outputs to the site based on a number of factors (Product Category, Manufacturer, Application, etc.). I understand the basics, but don’t know how to integrate the database into WordPress.

Eekk… Bad idea written all over a that.

Ok; first if anyone is trying to integrate X into Wordpress then one should be thinking about writing a plugin in php or updating the UI templates to talk to a remote rest service.

@KG5BZN Now biggest question; is the database already in production or is this net new greenfields project?

Next biggest question; When do you want to meet up for some professional/experenced guidence?

1 Like
8

I know this is a delayed response, but I went with Woocommerce and just ignored the shopping cart function. Thank you all for providing me with things to consider and the offer of help.

2 Likes
9

eek… at least you found a solution just remember to harden your wordpress since WooCommerce is one known to have XSS exploits See CVE-2019-1010124. I’m sure they have patched it but still wordpress is a known haven for attacks.

Personally if one is just using the BI and CMS/ERB features of woocommerce then I would go with Odoo instead. Not for security per se but because its an out of the box tool that most have to add twelve plugins to wordpress to get towards.

10

Thank you.

1 Like