How to store values in JSON using Javascript?

Question

I have multiple customers in DB, each customer is signed in for an event. I have multiple customer signed for the same event. So I would like to output on the screen Event name and then under that all customers signed in for that event. Here is example how my records look like in data base:

Event Name     Customer Name
Test 1          joe, allen
Test 2          tim, johnas 
Test 2          camil, gera
Test 1          john, paskins
Test 3          steve, mcines
Test 3          jym, haskynes
Test 2          kim, george

Here is my query:

SELECT EventName, Customer
From Reservations

So I was wondering if I can use JSON to store results with the same Event name? How I would check if they have same event name and how to store them in different row in JSON that why I can output records with the same name on the screen in separate rows below Event name?

Can you share some of the code you are trying? There are many ways to store this data as JSON. You have to add some code context. — Traveling Tech Guy
– Traveling Tech Guy, Commented Jun 29, 2016 at 20:36
What does "store in json" even mean? You already have data stored in database and can query by event or organize output by event. Question doesn't really make sense — charlietfl
– charlietfl, Commented Jun 29, 2016 at 20:48

Gammeldags · Accepted Answer · 2016-07-04 10:24:29Z

1

JSON is a not assoziative format:

var a = [{"eventName" : "Test 1", "customerName": "joe, allen"},
         {"eventName" : "Test 2", "customerName": "tim, johnas"}]
alert(a[0].eventName);

Is the way to adress the eventName in JSON, so you cannot get the right entries without using a loop that way.

But you could use an object to store your JSON lists before printout:

var b = {"Test 1": [{ "customerName": "joe, allen" },
                    { "customerName": "john, paskins" }],
         "Test 2": [{"customerName": "tim, johnas"}]    
}

alert(b["Test 1"][1].customerName); // will return "john, paskins"

but that way you cannot work with b[0][0] since b[0] would only give a result if there was something like this in the object:

                0:[{customerName: "john, doe"}]

answered Jul 4, 2016 at 10:24

Gammeldags

583 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 11:45:57Z

0

The easiest way to understanding it would be to divide it into 2 different queries.

First: Get a list of eventNames that are Distinct

SELECT DISTINCT eventName From Reservations

That will return results like this:

eventName     
Test 1     
Test 2         
Test 3

Then with those results, you can do another query for each on the results to get the customers attending.

foreach(ROW in RESULTS)
    SELECT customerName FROM Reservations WHERE eventName = ROW

This will give you a list of the customers attending that event.

From there building the JSON is really simple. Here is an example from an answer found on stackoverflow: How can I build a json string in javascript/jquery?

edited May 23, 2017 at 11:45

CommunityBot

11 silver badge

answered Jun 29, 2016 at 20:51

Sari Rahal

1,9653 gold badges34 silver badges55 bronze badges

Collectives™ on Stack Overflow

How to store values in JSON using Javascript?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related