Hello,
is read here:
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…
and its claimed that its not possible to send data from extern to the mysql database?
I want to send sensor data with my microcontroller to my created mySql database.
This is my database:
http://daq-database.free.nf/soilmoisture/php_post_esp_data.php?i=1
My user name
if0_36375521
Error Message
there is no error message. seems that its connecting but in the my sql database never arrives.
Many thanks in advance for any help,
Christoph
Hi Christoph,
If your microcontroller does not run JavaScript to connect first, then it won’t be able to post anything to your application.
Read more about it here:
When you first open your website, you may see the extra characters like ?i=1 at the end of your URL. This article explains more about what causes it, and what you can do about it.
What causes the ?i=1 suffix?
This extra URL parameter is caused by a security system we use to protect your website. This security system ensures that your website can only be accessed through regular web browsers.
What does the ?i=1 suffix do?
The ?i=1 suffix is a counter. When you first load your website, some Ja…
Cheers!
4 Likes
(Nevermind, there’s a difference between remote MySQL and APIs)
1 Like
Admin
April 20, 2024, 10:39am
4
That is by design. Please understand that we provide hosting for websites , i.e. things that produce pages that are viewed in web browsers. To help enforce this, we have this security system:
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…
Our hosting is not intended for IoT data collection services, and you’ll have a very hard time if you try to use our hosting for it.
Personally, I would go with a small, cheap, low power home server, like a Raspberry Pi, to handle the data collection. If only for the privacy benefit of the data not leaving my own network.
5 Likes
Than you very much vor this detailed answer
Will have a look for a home server on my raspberry pi.
Nice regards,
Christoph
system
Closed
April 27, 2024, 11:16am
6
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.