I'm using Prototype.js and would like to convert the contents of an HTML table to JSON. Converting to an array first is fine too. Any thoughts on this? I haven't seen anyone do anything this....
I have a string that is like [{"carePacks": [{"businessCode":"J1PS","description":"HP 1"}],"coveragePeriod":12}, {"carePacks":[{"businessCode":"J1PS", "description":"HP s"}],"coveragePeriod":13}]. How to convert it to a json structure and how to get data from the data structure, like get "HP 1".
I've a function build in PHP that return this JSON: [URL]. In the HTML page where this PHP function is called via jQuery AJAX I have this code: [URL], this populate two select as you notice, something like this: [URL], But I need the same but in this way: [URL] value come from Json array position.
I am writing this code <script type="text/javascript"> $(document).ready(function() { var obj = jQuery.parseJSON('{"a":"sss","b":"sss","question":"whi?"}'); //alert(obj.question); }); </script> How could I know how many objects variable obj has?
Your table-driven application has a MySQL table on the server side and you want a Javascript associative array on the client side to do rapid look-ups.For example: My application uses the value selected from the form’s drop-down menu to choose which other form fields to hide or show. This choice of a 'Long Form' is table-driven from product data in a MySQL table.
Convert the MySQL table to an associative array in JavaScript.I am using the jQuery library to manage the presentation and form validation on the client side and PHP and MySQL on the server side.Since a JavaScript Object is an associative array and the MySQL table is being used as a look-up table (associative array) I use the PHP function json_encode to create a JSON string - JSON is JavaScript Object Notation - on the server which is then evaluated as a JavaScript Object on the client. The two parts (server and client) of the code are listed below.All very straightforward then. So why the blog?This is what I do (here's the PHP code):
As a newcomer to jQuery this is a good opportunity to show my appreciation to John Resig and the people that have contributed to the jQuery library ... not forgetting those who have integrated all the MySQL and JSON stuff into PHP. It's all very neat ... when you get to understand it!You could just eval(data) to turn the JSON string into a JavaScript Object (a.k.a. associative array), but JSON.parse protects your code against evaluating malicious scripts that could be embedded in the JSON string. This function is found in the json2.js downloadable until included in native browser JavaScript engines.The PHP Booleans translate automatically into JavaScript Boolean types.
[Skip this: My application has a MySQL table of product categories that tell me whether I need to present the administrator with a long form or a short form in the HTML. So, as products are added over time, I want to the administrator to choose whether a new product category can take the short form plus some default values or will require the explicit input of all product values in the long form. As the administrator assigns a category to a new product - and changes his mind half a dozen times - I don’t want to keep on going to the server to do the look-up but want to have the table in Javascript to keep the form presentation responsive. Also, the MySQL tables are on a third party’s server remote from the web server.]
I'm trying to assign the values from the JSON data returned when I run this code into an array that's outside the callback function. The data is multidimensional, and I have been able to use this data within the callback function. However I want to use it outside that function. i.e. the jsdata returned in the code below is to be used outside the function
Code: $.getJSON('../fxns/status.php',function(jsdata){ //do some stuff with JSON data or pass to global variable[code]..........
I am doing a password reset form using Jquery and PHP. If I try to submit an email id it should sent and email and report back the response text as success so that the user knows email has been sent. But I am stuck with JSON submit as I have an empty array to decode at the serverside. I am using minified version of json2.js from the official json.org website
Here is the code. Code JavaScript: var formdata = $("#log-box").serializeArray(); formdata = JSON.stringify(formdata); var notifymsg; alert(formdata); $.ajax({ type: "POST", url: "forgot-pass.php", contentType: 'application/json', data: formdata, success: function(responsedata){ var some = responsedata.split("&"); $.each(some, function(index,value){ //alert("index="+index+"value="+value); }); }, error: function(o, s, e){ alert("Form not posted "+e); }}); formdata alerted gives: [{"name":"email","value":"ravi.k@gmail.com"},{"name":"acctype","value":"loginaccount"}]
The values I have in variable "tables".I want to create variable list which takes values from "tables".Than I want to split this, and put each value in to new array: I've started with:
var list = "tables"; var listArray = list.split("|"); for(i=0; i < listArray.length;i++)[code].....
I am fairly new to javascript and I am wondering how I would load a text file that has a JSON formatted array stored in it?I can pass the array directly to the page via php though I want to be able to store the data and save on calls to the database and of course load the data dynamically to the page.
I run an ajax request and return a json array. There is more in the json array than there is fields on the page. I want to cycle through text fields and find their NAME and match that to the json array and fill in the value.The names of the fields and the names in the json array are the same.
Code:
<script type="text/javascript"> function loadIntake(){ var client = <?php echo $id ?>;
In addition to fetching JSON you might want to POST it back to the server, but there is no postJSON method. You cannot use the generic ajax method, either. What is missing is the complement of "eval" to turn a JavaScript object in to JSON. The JSON.stringify function from www.json.org (see json2.js in JavaScript section) does the trick, but it would be nice if jQuery incorporated that out of the box, to save some hunting time.
Using the jquery ajax method to set the "type" to "json" and the "content-type" to "application/json" send and recieve JSON, but you must use JSON.stringify to convert your outgoing object to JSON. P.S.. a lot of forgiving parsers have resulted in a lot of articles on JSON being wrong. would I like to mention that here. Property names are JSON strings. JSON strings have double quotes. Therefore, property names have to be surrounded with double quotes. Single quotes are not JSON strings and not legal (JSON is not JavaScript).
I am trying out $.ajax instead of getJSON for debugging purposes. Because getJSON did not report an error in IE (6,7 or 8) and I am trying to figure out why a jQuery plug-in is not painting my returned images to the screen in IE but is in other browsers. So I tried this. Interestingly enough, it hits the error event in IE but not firefox, safari and the rest and I don't know why (this code works great and renders my data just fine in FireFox and the rest). I know my returned json is valid:
I don't know what else to do to troubleshoot why IE is having so much trouble with the returned JSON or just executing the function(data) using either getJSON OR this. I have set the headers not the cache also in the response. IE refuses to enter my function(data) on the response.
Same result. Firefox and the rest had no issue. IE still exited the $.ajax and my error method kicked in. No rhyme or reason whatsoever and I tried the IE Dev tools... nothing. About the only thing I get is this: Line: 163 Error: System error: -1072896658.Line 163 which is simply the line: function() { alert("An error has occurred. try again."); This has got to be the most f*d up situation I've been in and I need to get this working! I just cannot understand why IE can't parse a getJSON or $.ajax response, that is impossible or else there would be a huge meltdown with jQuery.
I am working on a page where the user will select a location from a dynamically generated dropdown list. I was able to create the php multidimensional array (tested and working) from a MySql database using the users information at login, but I'm having problems converting it to a javascript multidimensional array. I need to be able to access variables that I can pass to a number of text fields within an html form.For instance, if a user belongs to a company with multiple addresses, I need to be able to let them select the address they need to prepopulate specific text fields.