Json encode returning undefined in javascript

Question

I have multidimensional array in PHP which I have converted into json using json encode. Now when I do console.log in javascript it shows undefined.

When I do JSON.parse the error shows

jquery.js:687 Uncaught SyntaxError: Unexpected token u in JSON at position 0
    at JSON.parse (<anonymous>)

This is my json encoded data

"{"select_data":[{"id":10563,"fullname":"Raj Bahadur Thapa","created_by":121,"company_id":68,"company_name":"WhiteHat","selected_at":"2019-10-03 12:14:18","t_count":1,"p_count":3.571428571428571},{"id":10554,"fullname":"Sebastian Antony Sahayan","created_by":121,"company_id":19,"company_name":"Concentrix","selected_at":"2019-10-03 11:22:15","t_count":3,"p_count":10.714285714285714},{"id":10545,"fullname":"Natasha Fernandes","created_by":121,"company_id":21,"company_name":"Firstsource","selected_at":"2019-10-03 10:37:59","t_count":3,"p_count":10.714285714285714},{"id":10537,"fullname":"Farahnaaz Khan","created_by":121,"company_id":90,"company_name":"Hexaware","selected_at":"2019-10-03 10:08:17","t_count":2,"p_count":7.142857142857142},{"id":9788,"fullname":"Saneesh M","created_by":121,"company_id":11,"company_name":"Tele Performance ","selected_at":"2019-10-03 09:58:38","t_count":19,"p_count":67.85714285714286}],"p_count_arr":[3.571428571428571,10.714285714285714,10.714285714285714,7.142857142857142,67.85714285714286]}"

Laravel QUERY

public function company_wise_select()
    {

        $sub_query = DB::table('in_lineups_tracker')
            ->join('in_lineups', 'in_lineups.id', '=', 'in_lineups_tracker.candidate_id')
            ->join('companies', 'companies.id', '=', 'in_lineups.company_id')
            ->join('users', 'users.id', '=', 'in_lineups.created_by')
            ->where([
                ['in_lineups_tracker.status', 19],
                ['in_lineups_tracker.type', 3],
                ['users.id', 405]
            ])
            ->groupBy('in_lineups.id')
            ->select(
                'in_lineups.id',
                'in_lineups.fullname',
                'in_lineups.created_by',
                'companies.id as company_id',
                'companies.name as company_name',
                'in_lineups_tracker.created_at as selected_at'
            );

        $el_query = DB::table(DB::raw("({$sub_query->toSql()}) as table_001"))
            ->mergeBindings($sub_query)
            ->select(
                '*',
                DB::raw('COUNT(*) as t_count')
            )
            ->groupBy('table_001.company_id')
            ->orderBy('table_001.selected_at', 'DESC')
            ->limit(5)
            ->get();


        $totalCount = $el_query->sum('t_count');

        foreach ($el_query as $select)
        {
            $select->p_count = ($select->t_count/$totalCount) * 100;
            $p_count_arr[] = $select->p_count;
        }

        $data['select_data'] = $el_query;
        $data['p_count_arr'] = $p_count_arr;
        return json_encode($data);

    }

How can I json decode it in javascript and utilize the data?

Your JSON is incorrect, Try [JSON VALIDATE](https://jsonlint.com/) — , Oct 16 '19 at 05:47
It's undefined? Error seems to be questioning the validity of JSON instead. — Saharsh, Oct 16 '19 at 05:50
The value you posted as "json encoded data" is neither JSON, nor a JavaScript string. How do you transfer the data from the PHP script to the JavaScript code? Do you use Ajax or the PHP code generates the JavaScript code? — axiac, Oct 16 '19 at 06:14
I have updated the question with PHP code. Why my JSON is not a valid JSON and how can I make it valid? — Fahad Shaikh, Oct 18 '19 at 04:30
Your JSON has an extra set of double quotes surrounding it. It should start / end with `{}` — Matt Clark, Oct 18 '19 at 04:31

score 2 · Answer 1 · edited Oct 16 '19 at 06:21

2

Try this out

<script>
var data= <?= json_encode($array) ?>
console.log(data);
</script>

edited Oct 16 '19 at 06:21

Dino

7,779
12
46
85

answered Oct 16 '19 at 06:00

Shubham Narvekar

77
3

Actually I don't want to go by this method. I am ecoding my data backend side only but javascript is says data is undefined – Fahad Shaikh Oct 18 '19 at 04:32

Manish Gupta · Answer 2 · 2019-10-16T06:20:25.203

-1

You can use JSON.stringify() to acheive this

var JsonObj = <?php echo $json;?>;
var myJsonData = JSON.stringify(JsonObj);

console.log(myJsonData);

edited Oct 16 '19 at 06:20

answered Oct 16 '19 at 05:57

Manish Gupta

95
8

No they can't. See the first sentence of the question which says the raw data is in PHP, not JavaScript. – Quentin Oct 16 '19 at 05:59
You can replace your PHP variable by adding in JsonObj – Manish Gupta Oct 16 '19 at 06:00

Json encode returning undefined in javascript

2 Answers2