Json - Dev Shed

Dev Shed Forums Sponsor:

January 21st, 2013, 10:51 AM

bads

Contributing User

Join Date: Dec 2012

Posts: 33

Time spent in forums: 6 h 22 m 35 sec
Reputation Power: 1

Other - Json

hello! i have a json code here. how do you avoid returning undefined in json? I am using codeigniter.

here is my view.

PHP Code:


		
			
<script>

                                                function changeLoad(o) {

                                                  var op = o.value;

                                                  //var op = $("#category").val(); 

                                                  $.ajax({

                                                    url: "pms/casecat",

                                                    type: "POST",

                                                    async: false,

                                                    

                                                    data: {

                                                        

                                                        keyword: op

                                                    },

                                                    dataType: "json"

                                                  }).done(function(data){

                                                    var caseName = $("#casename")[0];

                                                    alert(data.result);

                                                    for(var i=0; i<data.length; i++){

                                                    var option = document.createElement("option");

                                                    option.setAttribute("value", data.value);

                                                    option.appendChild(document.createTextNode(data.value));

                                                    caseName.appendChild(option);

                                                    }

                                                  });

                                                }

                                            </script>

here is my controller.

PHP Code:


		
			
function casecat(){

            $keyword = $this->input->post('keyword');

            $this->load->model('Case_model');

            $cases = $this->Case_model->get_Case_by_category($keyword);

            echo json_encode($cases);

        }

January 21st, 2013, 11:01 AM

requinix

Still alive

Dev Shed God 16th Plane (12500 - 12999 posts)

Join Date: Mar 2007

Location: Washington, USA

Posts: 12,877

Folding Points: 417516 Folding Title: Super Ultimate Folder - Level 1

Time spent in forums: 5 Months 1 Week 5 Days 7 h 57 m 15 sec
Reputation Power: 8977

Send a message via Google Talk to requinix

What is the value of data?

__________________
Site rules and FAQ | Project Suggestions | mod_rewrite guide | PHP New User Guide and FAQ - PHP Stickies | Regex Resources

January 22nd, 2013, 07:59 AM

bads

Contributing User

Join Date: Dec 2012

Posts: 33

Time spent in forums: 6 h 22 m 35 sec
Reputation Power: 1

thanks again for the reply. when i try to alert(data.value) it pops undefined.

January 22nd, 2013, 12:12 PM

requinix

Still alive

Join Date: Mar 2007

Location: Washington, USA

Posts: 12,877

Time spent in forums: 5 Months 1 Week 5 Days 7 h 57 m 15 sec
Reputation Power: 8977

Not data.value. Just data.

January 22nd, 2013, 08:38 PM

bads

Contributing User

Join Date: Dec 2012

Posts: 33

Time spent in forums: 6 h 22 m 35 sec
Reputation Power: 1

ahm, values are specifically strings. Child Abuse/ Abandonment, Physical Abuse (PA), Sexual Abuse (SA) etc. that should be the ones returned.

January 22nd, 2013, 09:01 PM

requinix

Still alive

Join Date: Mar 2007

Location: Washington, USA

Posts: 12,877

Time spent in forums: 5 Months 1 Week 5 Days 7 h 57 m 15 sec
Reputation Power: 8977

One more time: What is the exact value of data? I don't mean what you expect to see in it, I don't mean the values it should have, I don't mean data.value, I don't mean anything except for the exact contents of the data variable.

You can find out using code like

Code:

alert(data);

Code:

console.log(data);

January 22nd, 2013, 09:14 PM

bads

Contributing User

Join Date: Dec 2012

Posts: 33

Time spent in forums: 6 h 22 m 35 sec
Reputation Power: 1

when I try alert(data) it pops with the content of

<!DOCTYPE HTML>

<html>

<head>

and cant scrool it down. =(

January 22nd, 2013, 10:21 PM

requinix

Still alive

Join Date: Mar 2007

Location: Washington, USA

Posts: 12,877

Time spent in forums: 5 Months 1 Week 5 Days 7 h 57 m 15 sec
Reputation Power: 8977

That doesn't look like JSON data. Guess there's some problem between your Javascript and your PHP that's affecting what gets executed...

January 22nd, 2013, 10:50 PM

bads

Contributing User

Join Date: Dec 2012

Posts: 33

Time spent in forums: 6 h 22 m 35 sec
Reputation Power: 1

using my previous code. I just added

PHP Code:


		
			
<?php echo $base; ?>index.php

in my url in ajax.

now when I alert(data) this returns [{"casename": "Name of cases"}]

but when I alert(data.value) it is undefined.????

#10

January 23rd, 2013, 12:59 AM

requinix

Still alive

Join Date: Mar 2007

Location: Washington, USA

Posts: 12,877

Time spent in forums: 5 Months 1 Week 5 Days 7 h 57 m 15 sec
Reputation Power: 8977

That's right, because data is an array (not an object) containing an object with a .casename (not a .value). That's the next thing to troubleshoot.

#11

January 23rd, 2013, 10:24 AM

bads

Contributing User

Join Date: Dec 2012

Posts: 33

Time spent in forums: 6 h 22 m 35 sec
Reputation Power: 1

I got it! I solved it when I saw something over the internet.

I converted the data being returned in JSON by using

var json = JSON.parse(data);

And also I can now get each column by using json[i].casename!!!

Thank you requinix for helping!! peace! =)

Other - Json

Developer Shed Advertisers and Affiliates