Comments (2)
Thanks for the snippet, will keep it around as an example!
from ispindel.
Hi, i have an issue trying to add the RSSI value into the insert into data php file.
Here is my table :
CREATE TABLE `Data` (
`Timestamp` datetime NOT NULL,
`Name` varchar(64) COLLATE ascii_bin NOT NULL,
`ID` INT UNSIGNED NOT NULL,
`Angle` double NOT NULL,
`Temperature` double NOT NULL,
`Battery` double NOT NULL,
`ResetFlag` boolean,
`Gravity` double NOT NULL DEFAULT 0,
`UserToken` varchar(64) COLLATE ascii_bin,
`Interval` int,
`RSSI` int,
PRIMARY KEY (`Timestamp`, `Name`, `ID`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8
COLLATE=utf8_general_ci AUTO_INCREMENT=1 COMMENT='iSpindle Data';
And this is my insert into php code :
$sql = 'INSERT INTO Data (Timestamp, Name, ID, Angle, Temperature, Battery, ResetFlag, Gravity, UserToken, `Interval`, RSSI)
VALUES ("'.$date.'", "'.$data->name.'", "'.$data->id.'", "'. $data->angle .'", "'. $data->temperature .'", "'. $data->battery .'", "'. $data->resetflag .'", "'. $data->gravity .'", "'. $data->usertoken .'", "'. $data->interval .'", "'.$data->rssi.'")';
If you can help me to update this :)
My goal is to be able to record the RSSI wifi data on my database.
FIXED: if someone want to do it too, the issue was a bad naming of some values, here are the good ones :
VALUES ("'.$date.'", "'.$data->name.'", "'.$data->ID.'", "'.$data->angle.'", "'.$data->temperature.'", "'.$data->battery.'", "'.$data->ResetFlag.'", "'.$data->gravity.'", "'.$data->token.'", "'.$data->interval.'", "'.$data->RSSI.'")';
from ispindel.
Related Issues (20)
- iSpindel HOT 2
- Doc link do not exist: https://www.ispindel.de/docs/tools/TestServer/Readme.md HOT 4
- Is it possible to reduce the accuracy of "battery" and keep 2-3 digits after the decimal point? HOT 10
- Wemos V4 HOT 10
- Proposition: Have a project able to route the messages HOT 3
- Discussion: What about using a ispindel github org (e.g.: https://github.com/ispindel, ...) ? HOT 5
- Issue with Ubidots API HOT 3
- Create new release :tada: HOT 3
- Firmware 7.2.0 identifies itself as 7.1.4 HOT 2
- History of tilt entity in HA not shown as line graph HOT 5
- Same issue as Issue #571 - Issue with Ubidots API HOT 2
- HTTP404 when clicking "Delete WiFi configuration and reboot" /r HOT 7
- Wrong tilt value HOT 4
- Holder for the PCB card in the container HOT 15
- Changes in ArduinoJson broke Sender.cpp HOT 1
- MQTT topic to force iSpindel in configuration (AP) mode? HOT 6
- Exception (28) on plain modules HOT 2
- SSL support for MQTT HOT 2
- Biradefteri HOT 1
- If gyro sensor is mounted inverted, the offset calibration does something that makes the unit not read less than 60 degrees when orientated vertically HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from ispindel.