Upload data to mySql database

[chriistoph]

Hello,

is read here:

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…

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

[anon95807532]

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:

Why do I see ?i=1 at the end of a URL

Don’t worry, this is normal! When you visit your website, you might notice ?i=1 added to the end of your URL. Here’s what’s happening and why. What is the ?i=1 suffix? The ?i=1 is a security check that protects your website from bots and malicious traffic. Our system needs to verify you’re using a real web browser before letting you access your site. Why does it appear? When you first visit your website, our security system: Sends a small test to your browser Checks if your browser can store…

Cheers!

[Meishin]

(Nevermind, there’s a difference between remote MySQL and APIs)

[Admin]

@chriistoph

I want to send sensor data with my microcontroller to my created mySql database.

@chriistoph

there is no error message. seems that its connecting but in the my sql database never arrives.

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:

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…

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.

[chriistoph]

Than you very much vor this detailed answer
Will have a look for a home server on my raspberry pi.

Nice regards,
Christoph