I want to save a user's email and username when a button is clicked. I assume I have to do this via PHP but I can find the user column at localhost/phpmyadmin. Where is the users' information being stored and which is the MySQL query to achieve that?
You should not use a direct MySQL query to update anything.
The default table where drupal saves user data is
users, there you can find the email and username