Databases
StackOverflow2013
Postsdbo
POJavascript JSON to PHP Array
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POJavascript JSON to PHP Array
    text
    copied!<p>In my Javascript I am assembling and array like so:</p> <pre><code> cachePHP = "'lat':'" + (Number(upDataItems[2])).toFixed(5)+"'"; cachePHP = cachePHP + ",'lon':'" + (Number(upDataItems[3])).toFixed(5)+"'"; cachePHP = cachePHP + ",'msec':'" + (parseInt(upDataItems[7])-parseInt(tz))+"'"; cachePHP = cachePHP + ",'spd':'" + (Number(upDataItems[0])).toFixed(1)+"'"; cachePHP = cachePHP + ",'hdg':'" + (Number(upDataItems[1])).toFixed(1)+"'"; dataCacheNew.push("{"+cachePHP+"}"); </code></pre> <p>I add a varying amount of data to the array, could be 10 items, could be 100...I then shove this over to a PHP file. The PHP file is called from the Javascript like so:</p> <pre><code>"my.php?che="+JSON.stringify(dataCacheNew); </code></pre> <p>In the PHP, How can I grab the data so I can 'parse' it and post it to my database?</p> <p>UPDATE 03/13: I still can't get this to work. Updated per suggestions below, and still...no workie!</p> <p>My Javascript (jQuery):</p> <pre><code> var jsonData = new Array(); jsonData.push({ lat: Number(56.34).toFixed(2), lon: Number(12.56).toFixed(2), msec: Number(123456799000).toFixed(2), spd: Number(4.2).toFixed(2), hdg: Number(1.4).toFixed(2) }); jsonData.push({ lat: Number(12.34).toFixed(2), lon: Number(34.56).toFixed(2), msec: Number(123456789000).toFixed(2), spd: Number(1.2).toFixed(2), hdg: Number(3.4).toFixed(2) }); $.ajax({ url: 'insertCache.php', type: 'POST', data: "che="+JSON.stringify(jsonData), dataType: 'json', contentType: "application/json", success: function(result) { alert(result); } }); </code></pre> <p>My PHP:</p> <pre><code>$cache = $_POST['che']; writeData($cache,"insertCache.txt"); $cacheDecode = json_decode($cache); writeData($cacheDecode,"insertCacheDecode.txt"); </code></pre> <p>insertCache.txt:</p> <pre><code>[{\"lat\":\"56.34\",\"lon\":\"12.56\",\"msec\":\"123456799000.00\",\"spd\":\"4.20\",\"hdg\":\"1.40\"},{\"lat\":\"12.34\",\"lon\":\"34.56\",\"msec\":\"123456789000.00\",\"spd\":\"1.20\",\"hdg\":\"3.40\"}] </code></pre> <p>insertCacheDecode.txt COMPLETELY BLANK</p> <p>what gives?</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload