Hi all – I’m new to wordpress, but have some old experience of building custom php sites. Hoping someone can point me in the right direction here. I have a WordPress site that has normal pages and posts.
One of the pages has a “listings table” that pulls content from a remote database I host on AWS RDS (I have a bunch of lambda scripts that run and populate the database hourly). For that page, I use WpDataTables and it creates a table from the remote database that can be filtered, etc.
I have a separate MySQL table in my remote database that lists all of the changes to the listings (price changes, status changes, etc etc).
I want to create a new wordpress page that will get passed a querystring parameter (the Listing ID), and show details about that listing, and also do a query of the remote database “changes” table and list out all of the rows. Like a “Listings Detail” type page.
So, my new page might be something like ListingDetails/?ID=<someNumber>
And then on the page I would do two things:
1) query the remote database “Listings” table with the ID from the querystring and present different variables on the page for the different fields
2) query the remote database “Changes” table with the same ID from the querystring and list out all of the results found.
Can someone point me in the right direction of what to research to figure this out?
[ad_2]