Hello everyone, I am working on a university project at the moment where we have an exhibition of an interactive art installation that will be placed in my local city for 3 days. On our website about the art installation we want to implement a counter that simply counts the amounts of interactions …

Just a thought, why not store the number on the Photon and publish and expose as Particle.variable()?

Thanks for your reply. I thought about that but figured that the number would probably be erased in case the Photon turns off or loses connection to the WiFi. Do you think there is a way to keep the number stored even if the Photon turns off or loses connection?

If you use retained variables the data won’t be lost after a reset (and mere cloud loss doesn’t erase any variables). Retained variables are stored in a special RAM area that’ll be held valid as long the device is powered, and to gain independency from the grid power you can add a coin cell to prov…

Thank you, this is a great idea. I just talked to my teachers again and unfortunately I HAVE to use a database in this project… So I still need to do it in the complicated database way

Does firebase database qualify?

I gave it a look and I think it would qualify as a database, yes.

This tutorial should be handy: [image] Google Firebase with webhooks tutorial Tutorials I created a new tutorial for using Google Firebase and webhooks for storing data from Photons, Electrons, etc… There are three examples in the tutorial: Saving data in a table Saving…

Ubidots can also be used to database the data sent out from a Photon or Electron. It’s probably easier to setup than the Firebase solution also. Just another option.

Call a php script that adds the data to the mysql database. If you have a mysql database with phpmyadmin you just create a table with a column autoID and another field (string) for data or whatever. Than call a simple phpscript that inserts some data into the table. Script in php would look somethin…

Need help with storing event variable in a database connected to website

General

kennethlimcp June 20, 2017, 1:01pm 8

This tutorial should be handy:

Topic		Replies	Views
Google Firebase with webhooks tutorial Tutorials	51	29749	September 3, 2019
Put data to my own database Cloud	11	11640	March 22, 2017
How to write in a database with wireless communication and with photon Getting Started	8	4420	February 25, 2016
Storing a Particle variable on the web General	6	2382	January 12, 2017
Help novice with photon Cloud	27	3395	December 18, 2018

Need help with storing event variable in a database connected to website

Related topics