Save results from pdo query to a javascript variable

Question

I am new to javascript so please be patient with me. I have a function in php which goes like this:

 public function getSubjects() {
            $stmt = $this->_db->prepare('SELECT id, subject from subjects');
            $stmt->execute();                     
            return  $stmt->fetchall();
        }

Then I have a variable subs in javascript which is hardocded like this:

var subs = {"Maths":1,"Geography":2,"Chmesitry":3,"Literature":4};

How do I populate the subs variable with the format above from the getSubjects method?

It depends. Is the javascript being loaded in the page of that PHP code? Or is it ajax? — FirstOne
– FirstOne, Commented Jan 18, 2018 at 17:36
json_encode my friend... jay-son-en-code.... php.net/manual/en/function.json-encode.php — IncredibleHat
– IncredibleHat, Commented Jan 18, 2018 at 17:36

FirstOne · Accepted Answer · 2018-01-18 18:46:11Z

3

I like to use json_encode to convert the array to json so it can be used as an array of objects in JS.

PHP:

public function getSubjects() {
    $stmt = $this->_db->prepare('SELECT id, subject from subjects');
    $stmt->execute();                     
    return json_encode($stmt->fetchall());
}

In javascript:

var subs = <?php echo getSubjects(); ?>;
console.log(subs);

edited Jan 18, 2018 at 18:46

FirstOne

6,2857 gold badges28 silver badges48 bronze badges

answered Jan 18, 2018 at 17:41

Daniel H.

4322 silver badges15 bronze badges

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

8 Comments

iainn Over a year ago

You don't need to run JSON.parse here. In fact it'll cause an error if you do.

Daniel H. Over a year ago

Are you sure? json_encode returns a string and that string needs to be parsed into the subs object as an array...

FirstOne Over a year ago

@DanielH. It's easy to test: run both and check the generated source code / console. (I'm not iainn)

FirstOne Over a year ago

To add to @iainn's comment: it's not a string cause there is no quotes surrounding it. The generated json will be output in raw as javascript source code, which is (roughly) how you define objects in javascript.

Daniel H. Over a year ago

Oh!! damn I am dense.

|

Collectives™ on Stack Overflow

Save results from pdo query to a javascript variable

1 Answer 1

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related