How to create a JavaScript Object using data in database?

Question

I want to create a JavaScript object as follows.

var codropsEvents = {
    '02-02-2017' : '<span>Some txt from database</span><span>Some txt from database</span>',
    '02-05-2017' : '<span>Some txt from database</span><span>Some txt from database</span>'
};

For that, the js function I developed is as follows.

function setEventsCalendar() {
    var codropsEvents
    try {
        $.ajax({
            type: "POST",
            url: "calendarData.php",
            dataType: "text",
            async: false,
            success: function(msg) {
                codropsEvents = "{" + msg + "}";
                codropsEvents = JSON.parse(codropsEvents);
            }
        });

        return codropsEvents;
    } catch(ex) {
        alert(ex);
    }
}

var codropsEvents = setEventsCalendar();

calendarData.php file generates following as a String (Including all colons, commas, tags etc.)

'02-02-2017' : '<span>Some txt from database</span><span>Some txt from database</span>', '02-08-2017' : '<span>Some txt from database</span><span>Some txt from database</span>'

How can I create the JS object using that String? Or any other proper way to get the expected result.

That's not valid JSON. In JSON, strings are surrounded with double quotes, not single quotes. Why aren't you using json_encode() in the PHP script? — Barmar
– Barmar, Commented Feb 12, 2017 at 6:27
One thing more async: false has been deprecated, please do not use it. — Kumar
– Kumar, Commented Feb 12, 2017 at 6:32
@Barmar I tried 'json_encode()'. But still I couldn't get the expected result. Therefore, could you be more specific so that I can adapt it in my code. — AnushkaM
– AnushkaM, Commented Feb 12, 2017 at 6:57
If PHP returns valid JSON, you don't need to concatenate { and } in the Javascript. — Barmar
– Barmar, Commented Feb 12, 2017 at 6:58

Veshraj Joshi · Accepted Answer · 2017-02-12 07:18:56Z

1

you can make an array like in php-

$dataArray = ['02-02-2017' => '<span>Some txt from database</span><span>Some txt from database</span>',
              '02-05-2017' => '<span>Some txt from database</span><span>Some txt from database</span>'];
// and this array to json string and print it,
 echo json_encode($dataArray,JSON_FORCE_OBJECT);

Now in ajax part you can simply get data in json format by changing dataType to json; msg parameter of success function is javascript object or having code like codropsEvents = JSON.parse(msg); inside success function.

answered Feb 12, 2017 at 7:18

Veshraj Joshi

3,5874 gold badges32 silver badges51 bronze badges

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

Collectives™ on Stack Overflow

How to create a JavaScript Object using data in database?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related