Unable to connect to SQL vi PHP

[orjanjan]

Hi

I want to make a logging database where I use a Arduino board to send data to a PHP script that sends data to my SQL database.

I have made a script on called “post.php”, but i cannot manage to connect to my SQL database.

Current error:
php_network_getaddresses: getaddrinfo failed: Temporary failure in name resolution

PHP file:

$server = "<https://sql200.epizy.com>>";
$username = "<epiz_33199238>";
$password = "<xxxxxxxxxxxxxxx>";
$database = "<epiz_33199238_temp_logging>";
$table = "<temperatur>";

$connection = mysql_connect($server, $username, $password) or die(mysql_error());
mysql_select_db($database) or die(mysql_error());

Have I used the right login names on server, username etc.???

Thank you

[KangJL]

Take note

Connecting to MySQL from an external application

Sometimes, you may want to connect to your MySQL database on your free hosting account using external software, like a desktop database manager (like MySQL Workbench) or an external program you wrote yourself (like an Android or iOS app). You cannot connect to a free hosting MySQL database from outside your hosting account. You can only interact with your free hosting database through PHP scripts uploaded to your free hosting account, or through our phpMyAdmin installation. The ability to con…

[orjanjan]

Hi, thank you for your answer. Mut I have my PHP script on my hosted server. It is created with your online file manager. Location of PHP file is on:
“http://mydatabase.great-site.net/post.php”

I am able to run the file from my web browser. This is tested with having echo “file opened
”;

Do I still need premium account to logon to the SQL from the PHP?

The PHP file recieves data end sends it to SQL.

[wackyblackie]

@orjanjan

$server = “https://sql200.epizy.com>”;

Should be $server = "sql200.epizy.com";
SQL servers generally run on port 3306 not port 443 (HTTPS). And I don’t know if that greater-than symbol was a mis-type or you have that in your code, but it should be gone as well.

[Admin]

@orjanjan

I want to make a logging database where I use a Arduino board to send data to a PHP script that sends data to my SQL database.

I’m sorry, but that’s not allowed on our hosting, and not going to work either because of this security system:

Ensuring only web browsers can access your website

InfinityFree is a website hosting service. That means that the hosting accounts we provided are intended for hosting websites. Websites contain pages that are accessed through web browsers. InfinityFree is not intended to be used for file sharing, API hosting, database hosting or background tasks/tools. To help enforce this, free hosting enforces a security system that makes sure that anyone trying to access your website is using a normal web browser. This is done by checking whether the web br…

Please remember: we provide a website hosting service, not a data collection/analytics platform.

@orjanjan

$server = “https://sql200.epizy.com>”;
$username = “<epiz_33199238>”;
$password = “”;
$database = “<epiz_33199238_temp_logging>”;
$table = “”;

$connection = mysql_connect($server, $username, $password) or die(mysql_error());
mysql_select_db($database) or die(mysql_error());

Have I used the right login names on server, username etc.???

Please enter the details displayed in the client area and control panel. There are never any slashes, brackets or colons in any of the values you need to use.

Also, the mysql_* functions were removed from PHP ~8 years ago. Programming languages evolve over time, so only ever follow recent tutorials, not ones from 10+ years ago. Please use MySQLi or PDO instead.