johnfork
Forum Replies Created
-
Forum: Fixing WordPress
In reply to: Have I the right structure? Library database website buildThanks a million for your insights bc – I haven’t yet have to delve into WP meta data stuff yet, so that’s my job for the next few days!
keyword/tags have a 1->many relationship…i.e. each url is unique to that word; so that should make things a little more straight forward. So as I visualise a list of URLs as a single array, that will be called upon when a keyword is queried, it makes sense. I just need to figure out how to reference a piece of meta data to a keyword/tag. Sounds like something I should be able to figure out.
Thank you again; – For the benefit of everyone, I’ll get the thread updated on my progress.
Forum: Fixing WordPress
In reply to: Have I the right structure? Library database website buildHi bcworkz,
The issue I’m having with my keywords being tags, is that I have another layer of info sitting under these words. i.e. the ‘tag’ works perfectly to refer upstream to the relevant book it’s attached to – but downstream, it needs to reference another set of parameters, the url links – this is where I’m a bit stuck.
At the moment I have a db table with everything indexed, but I’d like to avoid having to connect to a sql db, and have everything live in the WP ecosystem.
Is it possible to link 2 taxonomies together? Not a parent-child relationship, but more a cousins relation!? In that way I could add a URL link taxonomy and link each URL to its respective keyword – alas I dont think this is possible though, but I could be wrong…
Forum: Fixing WordPress
In reply to: Database Query plugin recommendations?Noted..and I agree with you – sticking php into a style template is not a good idea!
The only reason I am using a page builder, is to easily mock up a draft structure, menus, sub-menus, animations, lightboxes, etc etc. and make a half decent looking site. I already have build the bones of the site outside of elementor, but not being a coder, it’s difficult to design and build a proper site that’s full responsive, with all the bells and whistles of a page builder.
Perhaps the best way forward would be to build without a page builder (just vanilla WordPress, and go from there).
Forum: Fixing WordPress
In reply to: Database Query plugin recommendations?I have taken your advice @catacaustic, and made a custom template for my custom post type, and entered the php into the single_custom.php file. All good!
Now when I try to adapt my current code into the elementor divs, it’s a no-go – although the logic is sound and the code correct, the php returns a blank for all fields.
I’m definitely one step closer to where I want to be, but alas I think I will have to go another route and maybe look for another page builder (that isn’t elementor) to
be able to read my php in the template php file.
Still I find it hard to believe that a page builder within an application that is solely based on php cannot read php code…it doesn’t seem right.Then again, I could be going about this from a completely incorrect approach.
In any case, thanks again for your valuable insight 🙂
Forum: Fixing WordPress
In reply to: Database Query plugin recommendations?Cheers for advice @catacaustic,
Yes I want the search function to be able to be available, and the results displayed – eventually, sorting options, ajax filtering, the works!
So what you’re saying is that I would have to transfer the data in the mysql db into wordpress? Would that not seem like a doubling up of work?
From my work so far, I understand that each page is technically a “post”? That’s the bit I’m having trouble grasping. I did play with trying to input some php into a post’s field, but it just feels weird – like I’m writing a dynamic entry into a table or something.
If I do indeed need to transfer my db data into ‘posts’, then that would mean I techincally would have to import a post for each individual word? I’ve done the calcs, it’d make for potential 986,000 posts..yikes! Just doesn’t make sense to me when I should be able to pull in my results on the fly via direct sql queries, like the flat/non-formatted ex-wordpress php file I coded.
Or maybe I’d be better off sticking to what I have and try to integrate it with the pages that elementor generates…but then I’m thinking it would be a real job to add in filters etc. later on…
#confused