How can you connect html with database (sql)? Do you use php for that, if so, how?

Answer 1

HTML pages are only client pages used to either view or interact with data. If data needs to be dynamic meaning that the data can change e.g (user registration, capture or update of details etc.) you need a database to save all of your changes. To have access to save/update/delete or read from a database you require a server-side which will be developed in something like java, c#, c++, PHP etc. All your application logic should be processed on the server-side of your application and not within you client pages.

Answer 2

yes you need a server-side technology. php would be one of them. you can do this with python, nodejs, etc. you don t connect the html with a db, but rather php. regarding the how, you can/ should use PDO if not an ORM .. like Doctrine.

Answer 3

For that we use MySQL