Hi, all i have been at this now for a good few days trying to figure out how to get a variable from my photon to a mysql database i have tried to make it as simple as i can so I can get to grips with it but I keep getting a webhook error. now im not to great with php or the json and i can just about…

I think i have found the problem so i have now declared varibles which hold the db name and other details which are passed to the conn statement it is now inserting data into my database and i am over the moon. however the data entered is 0 and 0 not 200 and 500 but at least it is inserting thanks…

[image] benjiiiiuk: "INSERT INTO photonvalues (value1, value2) VALUES ('$value1', '$value2')"; I'm not a PHP guy but are these grave accents ( ` ) not supposed to be single quotes ( ' ) rather? Also your val1 & val2 are int but in your snprintf() you are treating them as unsigned int, why? I…

@jearle performed something similar in this post, for some ideas on the PHP for mySQL: [image] Pulse counter that writes to MySQL Database Project Share Good Morning, A couple months ago I started trying to make a water meter connect with the cloud using a photon to count…

Thanks! Another suggestion I would have is make sure that your php code is working correctly to post to your database before working about the webhook part. They way it says access denied makes me think it maybe could be a username/password issue with database. You can put the http address of your …

Thank you for your replies. ScruffR i have changed my snprintf() statement to: snprintf(msg, sizeof(msg), "{\"value1\":%d, \"value2\":%d}", val1, val2); im not great at coding and have just started to get back into it, most of the things i try and learn are from what i have read on the particle f…

Cant get photon code,webhook,php to log data to mysql

General

Rftop January 10, 2019, 1:32pm 3

@jearle performed something similar in this post, for some ideas on the PHP for mySQL:

Topic		Replies	Views
Photon to mySQL DB Getting Started	12	8173	January 4, 2018
Help needed with webhook/php inserting data in MySQL table Getting Started	3	5362	August 27, 2015
How to Connect Mysql to particle.io? Getting Started	1	2390	July 30, 2016
HTTPS POST to mySQL on localhost Getting Started	26	11931	April 5, 2020
Add JSON message from web-hook to MySQL Cloud electron	5	1110	February 9, 2019

Cant get photon code,webhook,php to log data to mysql

Related topics