How to add MySQL to website and where to put PHP file?

[Admin]

Those are a lot of questions, and many of them are not really suitable for a Q&A style format, and more of an in-depth tutorial or course.

In short, the guides you’ve read online are probably correct. You’ll just need to plug in the connection details (MySQL hostname, username, password, database name) and you can run your queries.

Please do note that our databases can only be accessed from code running on our servers, so you can’t test your PHP code (or Node.js) on your own computer with our database servers.

I think that this article may answer at least some of your questions:

How to connect with MySQL

Both the popular PDO and MySQLi libraries are available on all accounts and PHP versions, which are the libraries all (modern) scripts use to connect to a MySQL database. However, to use a database, you need to configure a few things first. Before you can use a database, you need to create the database first. You can create a database through your control panel in the section called MySQL Databases. Simply enter a desired name in the text box and click Create Database. To use the database with…

Your website files should be uploaded to the htdocs folder of your account. You can upload them with the file manager or with an FTP client of your choice (like FileZilla).