How to deploy gitlab/vc to a hoster to work on a website?

Question

git

I do not ask for a detailed manual, but an explanation of the main stages.
The situation is this , there is a standard hosting for the site, there is ssh. I want to make a website (php + MySQL) and work with it through the version control system.
How can this be done, what are the options?
I would like to work with deleted files and immediately see the changes on the site itself and be able to roll back to any state.
As I imagine the ideal option (maybe there are better):
I work with files (winSCP) and databases (phpMyAdmin), a window git client (or console) is launched in parallel, which shows what has changed, I make commits, push. Then, in the same program or on the gitlab.mySite.com site itself, I look at commits, branches, etc. in a graphical form, I look at all the edits. If anything, then I roll back the changes to the previous state in the window git client.
How to be with a DB? If everything is clear with files, then with the database it’s not very good, how are changes in the database tracked, although this is a file, but it is available only through phpMyadmin?

Answer 1

use github
in db use migrations to version changes to db structure