How do you access the database of a website

Answer 1

in general, you don't

you use a web API to communicate with the server which communicates with the database

now please be more specific with your question as it is quite general

Answer 2

If you own the website, then through the use of PHP and SQL to build a private api and database management system
If you don't own the site then through the publishers public APIs should they provide them.