Use PHP into JQuery Array

Question

I have used an example table from X-Editable, this uses an array in JQuery to populate a drop down options box. This is great but I want to use the database to feed the array.

This below is the code from the X-Editable demo

var jsStringFromPHP = "<?php echo json_encode($r); ?>";

$.mockjax({
url: 'myphppage.php',
response: function (settings) {
    this.responseText = jsStringFromPHP;
    log(settings, this);
}
});

This is what I've done to get the array from my database

<?php
require 'assets/functions/core/init.php';
$p = db::getInstance()->query('SELECT id as value, name as text FROM information', array());
    $r = $p->results();
    echo json_encode($r);
?>

How can I incorporate the php array into the jquery and replace the static list?

remove the <pre> tag, and use the result of your php output as a json object via ajax. — vaso123
– vaso123, Commented Oct 28, 2014 at 11:22
Thanks but after this.responseText = in the jquery how do I call it? — Jez
– Jez, Commented Oct 28, 2014 at 11:26
you receive your response json in settings argument of your ajax callback. — user2009750
– user2009750, Commented Oct 28, 2014 at 11:29
Sorry don't understand the {settings}, what does that represent, I'm trying to understand how I can call the php code to run within the jqUery — Jez
– Jez, Commented Oct 28, 2014 at 11:59

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

2

Just encode your array to JSON using json_encode & return that in response. Then in success callback of ajax function, use that JSON string.

To know more about how to handle it, read it: Load JSON Data Using jQuery AJAX

Use in this way,

$.mockjax({
    url: "hello.php",
    proxy: 'sample.json',
    responseTime: 0,
    dataType: 'json'
});

$.ajax({
    url: "hello.php",
    dataType: 'json'

}).done(function (json_response) {

    var names = [];
    for (i in json_response.employees) {
        names.push(json_response.employees[i].firstName);
    }
    output = names.join("<br/>");
    $('#output_fake_json').html(output);

    $.mockjaxClear();
});

More details can be found here on plugin page: http://www.vikaskbh.com/jquery-fake-ajax-requests-for-ajax-testing-using-mockjax-plugin/

edited May 23, 2017 at 11:57

CommunityBot

11 silver badge

answered Oct 28, 2014 at 12:04

Apul Gupta

3,0344 gold badges24 silver badges30 bronze badges

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

4 Comments

Jez Over a year ago

Thanks, I've had a look at that and amended my original post, I don't understand where I can call the actual php page from to run the echo of json_encode?

Apul Gupta Over a year ago

code & tutorial added in the last of my answer. This will help you.

Michail Michailidis Over a year ago

@539 You are calling the php with the url in ajax (e.g hello.php)! Do some reading to get the concepts right :)

Jez Over a year ago

Thanks for the help, I had tried the php inside the url first, with it showing errors in the console log and then after much reading changed it to the /groups as that was how the X-Editable site had shown it. After changing it back, some reason it has worked.

Collectives™ on Stack Overflow

Use PHP into JQuery Array

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related