Given the direct access a server you can type SQL commands at a prompt and get the server to do what you want. However, these tutorials are about Web pages.
PHP contains everything you need to send SQL queries (commands) to the server for you. So a Web page can have PHP in it which gets and uses data from the database server.
The rest of this tutorial is about SQL but it is about using PHP to use SQL.