phant | the data logging engine behind data.sparkfun.com

You may use

You could convert the array to a json string, convert the special characters in this string, and convert the json string back to an array.

instead of

$db = new PDO("mysql:host=".DBHOST.";port=8889;dbname=".DBNAME, DBUSER, DBPASS); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $db -> exec("set names utf8");

do this 1 line: $db = new PDO("mysql:host=".DBHOST.";port=8889;dbname=".DBNAME.';charset=utf8mb4', DBUSER, DBPASS,array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION)); also note how i changed it from utf8 to utf8mb4.

quote My collation is utf8_general_ci. - best guess, that's your problem right there (along with wrong connection characterset). see, mysql's utf8 is not the real utf8, but a retardedly-named subset, while the real utf8 is named utf8mb4 in MySQL. a subset that probably doesn't support the ╠ character. run utf8mb4 / utf8mb4_unicode_ci all the way through, and you shouldn't get this problem. furthermore, if in the future, you'd like MySQL to throw an error instead of corrupting your data when the data can't be inserted, enable the STRICT_ALL_TABLES sql_mode. (then you would get an exception, instead of mysql storing a corrupted version of your string)

(this is also true for MariaDB, which inherited this brain-damage from the MySQL source code it was forked from)

It looks like your JSON data is an array of objects, so myJson will be an array of dictionaries.

I would try something like this:

Option 1: You need to indicate that you want to modify the global adcOut variable, not just read its value. Modify getAdc() as follows by adding a global adcOut to the function:

Since you're trying to catch the error, you have to pass the error as the first argument in the anonymous function:

Just iterate over the items in each element of the data array (the key, value pairs) and then output them using string formatting.