Apply Filters using JSON

101 New Member

[PHP]{"length":50,"accounting":[
{"firstName":"John","lastName":"Doe","age":23},
{"firstName":"Mary","lastName":"Smith","age":32 },
{"firstName":"Sally","lastName":"Green","age":2 3},
{"firstName":"Jim","lastName":"Galley","age":41 }
]}
[/PHP]
I am rendering the above JSON object in a tabel using DOM .

Now i want to add a functionality of Filters means
There is some check box specifying age

if I select 23 age check box it display all the data where age is 23
the table only render those records.

If i unselect the check box it render all the records without filter.

Please help how to do this

Regards,

Nov 6 '07 #1

Subscribe Reply

2985

gits

5,390

Recognized Expert Moderator Expert

hi ...

onclick of your checkbox you should identify its checked-property and call a function that loops through your (json-data) and grabs the appropriate records from it. with that you create new table-row-elements with table-cells and their texts. remove all current table-rows and append the new rows ... you may have a look at the following dom-methods for that issue:

createElement();
removeChild();
appendChild();
createTextNode();

kind regards

Nov 6 '07 #2

buntyindia

101

New Member

hi ...

onclick of your checkbox you should identify its checked-property and call a function that loops through your (json-data) and grabs the appropriate records from it. with that you create new table-row-elements with table-cells and their texts. remove all current table-rows and append the new rows ... you may have a look at the following dom-methods for that issue:

createElement();
removeChild();
appendChild();
createTextNode();

kind regards

Any example is available on the net for this?

Nov 7 '07 #3

gits

5,390

Recognized Expert Moderator Expert

hi ...

ok ... let me give you an example for the dom-handling:

Expand|Select|Wrap|Line Numbers

 <html>

   <script type="text/javascript">

       function handle_rows() {

           var table = document.getElementById('t1');

           var rows  = table.getElementsByTagName('tr');
 
           // remove all rows

           while (rows.length > 0) {

               table.removeChild(table.lastChild);

               rows = table.getElementsByTagName('tr');

           }
 
           // create a new one

           var nr = document.createElement('tr');

           var nc = document.createElement('td');

           var t  = document.createTextNode('new text');
 
           // appending now:

           nc.appendChild(t);

           nr.appendChild(nc);

           table.appendChild(nr);

       }

   </script>

   <body>

        <table id="t1">

            <tr>

                <td>test1</td>

            </tr>

            <tr>

                <td>test2</td>

            </tr>

        </table>

        <input type="button" onclick="handle_rows();" value="handle rows"/>

   </body>

</html>

kind regards

Nov 7 '07 #4

buntyindia

101

New Member

hi ...

ok ... let me give you an example for the dom-handling:

Expand|Select|Wrap|Line Numbers

<html>

   <script type="text/javascript">

       function handle_rows() {

           var table = document.getElementById('t1');

           var rows  = table.getElementsByTagName('tr');

           // remove all rows

           while (rows.length > 0) {

               table.removeChild(table.lastChild);

               rows = table.getElementsByTagName('tr');

           }

           // create a new one

           var nr = document.createElement('tr');

           var nc = document.createElement('td');

           var t  = document.createTextNode('new text');

           // appending now:

           nc.appendChild(t);

           nr.appendChild(nc);

           table.appendChild(nr);

       }

   </script>

   <body>

        <table id="t1">

            <tr>

                <td>test1</td>

            </tr>

            <tr>

                <td>test2</td>

            </tr>

        </table>

        <input type="button" onclick="handle_rows();" value="handle rows"/>

   </body>

</html>

kind regards

Thanks gits for the example :)

but gits how to handle JSON data to get a Filtered Data on clicking of checkBox and to restore the original data after unchecking the check box ?

[PHP] {"length":50,"accounting":[
{"firstName":"John","lastName":"Doe","age":23},
{"firstName":"Mary","lastName":"Smith","age":32 },
{"firstName":"Sally","lastName":"Green","age":2 3},
{"firstName":"Jim","lastName":"Galley","age":41 }
]}[/PHP]

Please provide some help/example on this.... I am very urgent need of this ...

Regards,

Nov 10 '07 #5

buntyindia

101

New Member

I got some idea how to do this filter stuff, will defeneitly share with all once it complete :)

Nov 11 '07 #6

gits

5,390

Recognized Expert Moderator Expert

ok ... i'm looking forward to it :)

Nov 11 '07 #7

Similar topics

2665

proposed new standard: JSON++

by: G Matthew J | last post by:

http://htmatters.net/htm/1/2005/07/evaling-JSON.cfm This is more or less in response to Mr Crockford's admonition a few months ago, "fork if you must". Ironically, although in that usenet post...

Javascript

6808

JSON and the cyclical data structures...

by: Luke Matuszewski | last post by:

Welcome As suggested i looked into JSON project and was amazed but... What about cyclical data structures - anybody was faced it in some project ? Is there any satisactional recomendation... ...

Javascript

10390

JSON.parse

by: Douglas Crockford | last post by:

There is a new version of JSON.parse in JavaScript. It is vastly faster and smaller than the previous version. It uses a single call to eval to do the conversion, guarded by a single regexp test to...

Javascript

3731

JSON modifies Object.prototype?

by: Kevin Newman | last post by:

Hello, I noticed that the JavaScript library for JSON posted on json.org (http://www.json.org/json.js) is modifying Object.prototype (adding a method - toJSONString). I thought this was...

Javascript

3297

Creating instantatable objects using pure JSON?? -- no prototyping!!

by: ChrisO | last post by:

I've been pretty infatuated with JSON for some time now since "discovering" it a while back. (It's been there all along in JavaScript, but it was just never "noticed" or used by most until...

Javascript

5122

AJAX not working when using Session variables.

by: =?Utf-8?B?U2hhd24gU2VzbmE=?= | last post by:

Greetings! I was researching AJAX to provide a solution to displaying status messages while a long process executed. I found several examples online and was able to use their code to get a quick...

ASP.NET

2614

Using hidden fields for single page apps

by: Andrew Burton | last post by:

I'm poking at a small "single page application" (SPA), ala TiddlyWiki, to act as kind of a local, single-user version of Twitter (no real application, except to familiarize myself with JavaScript)....

Javascript

3171

Current JSON Proposal in ES4

by: dhtmlkitchen | last post by:

JSON We all know what it is. In ECMAScript 4, there's a JSON proposal: Object.prototype.toJSONString String.prototype.parseJSON The current proposal, String.prototype.parseJSON, returns...

Javascript

16125

JSON deserialization using DataContractJsonSerializer

by: Andrew | last post by:

Hi, I am using DataContractJsonSerializer to deserialize JSON string in C# objects but I am having a problem. Suppose I have a class: class Item { public ItemId Id { get; set; }

C# / C Sharp

7251

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7367

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7089

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

5673

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

5072

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

4743

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3217

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

790

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

451

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General