Can you add SQL code to an HTML file? If so, how?

Answer 1

HTML + SQL? That may be a logic error.

What you can do is execute a function with any backend language (Like PHP) which will bring the response for you to treat and transform into HTML response. But all those SELECTs/INSERTs/etc occur on server side. HTML is at client side. The server treats a page and sends via HTTP/S the packet containing HTML for the browser to read. When you need to get data, it sends another packet to server containing the info it needs, the server processes and brings the response in HTML again to client to process... Tried to resume everything

Answer 2

You might use PHP because it works on the server. Not just HMTL.