Hello Group, I would like to ask you if there is a way I can send data to my own database , or an sql database? Thank you in advance

Server Sent Events, Particle.variable(), HTTP server, TCP/IP, UDP, and probably some others… Take a pick. Enough options to choose from. It just depends on what you’re comfortable with, and what your back-end looks like.

Here is the way I implemented such a solution (your results may vary): I have a core that performs a publish() once every five minutes with a string containing all the data I need. I use a web hook to relay that data to a PHP page on my hosted web server. The PHP script decodes the POST data stri…

I am using an Azure EventHub with an Eventprocessor for something similar. In my case i scan an RFID Card with my photon which triggers an azure event in the cloud via a webhook. Azure than processes my event and “answers” by calling a function on that photon. i only use temporary data and just que…

[image] johnyrobot5: Is it possible to give me any example code? Although theoretically possible, it would be extremely hard in practice. There are simply way too many different options to be able to give you some example code. If you use Particle.variable(), you need to poll with the server…

Another option is to use ThingSpeak (full disclosure, I'm connected to it). There's a library for the Photon/Core in the IDE, and you can set up a free account to store your data. More info and a video in my posting: [image] ThingSpeak Communication Library written by the ThingSpe…

I’ve posted some basic PHP stuff on github that you could pick through. iot.php is a simple FIFO dump into a file formatted for a javascript array. It’s general purpose, but the name field is required for a filename. chart.php loads specific fields for charting, so you could use that for testing …

Hi again, I had success with writing from a mysql , but is it possible also to read from a mysql with the photon? regards johnyrobot5

You can certainly have a PHP script on your website read data from a MySQL database and send it to your Photon using something like Particle.function(). Triggering the script is the real question. My suggestion, untested, would be to use Particle.publish() to trigger a webhook, like you did when you…

Hi Muskie, I’m looking to do the same thing as your solution. My publish function to the Particle cloud is working fine, and the webhook I created in the console seems to publish my data when tested on requestb.in - However, I get no data inserted into mysql DB when the webhook is sent to my host…

Put data to my own database

Cloud

johnyrobot5 September 17, 2015, 9:25am 4

Hello,

Thank you for your help! Is it possible to give me any example code?

Thank you in advance

HTTPS POST to mySQL on localhost

Topic		Replies	Views
Photon to mySQL DB Getting Started	12	8202	January 4, 2018
HTTPS POST to mySQL on localhost Getting Started	26	11995	April 5, 2020
Webhook - Reciving software and store in sql General	8	4669	April 17, 2016
Add JSON message from web-hook to MySQL Cloud electron	5	1117	February 9, 2019
How to write in a database with wireless communication and with photon Getting Started	8	4422	February 25, 2016

Put data to my own database

Related topics