Hi folks, I'm a bit stumped on this now (its all been a learning experience!)
Running WordPress, using Cloudflare and Nginx to put it online at my domain. And I have MariaDB and Adminer set up for a MariaDB database.
They're all on the same Proxmox server, with WordPress in a turnkey container and Nginx, MariaDB and Adminer in docker containers in a Debian VM.
I have been able to create a data table referencing MariaDB by using the WP Data Access plugin, and it all works fantastically when I open my page locally – but when I open it at the domain, I can see all my formatting changes etc, but the data table is blank i.e. its obviously not pulling the MariaDB data table to the external web.
Any advice what I need to do to get this to work?
Edit to add: If it matters, I also plan to add to this database remotely via Ardiunio LTE, but that was going to be a future project
You need a PHP function that opens a connection to the DB, runs a query, then closes the connection.