Hi, I was wondering if someone could help me with a database problem I seem to be facing...
I'm currently learning PHP and MySQL, therefore have tasked myself to build a user registration system (login, forgot password (by email verification), logout, register (with email verification), change email, change password, delete account).
I have successfully done this in Xampp and got it talking to the database, sending queries etc... to do the features mentioned above.
My problem started when I tried to deploy the system to Nodehost. I changed the MySQL server connection details (username, host, password, db etc...) to the one on my Nodehost container and it connects successfully without throwing the "couldn't connect" error message (I tried some incorrect details to test this) but the MySQL database doesnt seem to be responding to the PHP queries I throw at it.
The system is live at https://staging1.robertd.uk. I am happy to give my Adminer and FTP login credentials if this is allowed? If not, I attached a snippet of the code I am using (MySQL server connection details are for Xampp in this). Also, if any admins reply, I give you full permission to access my Adminer/FTP if you are happy to help.
Many thanks 🙂