How to receive data from database via jquery? [wordpress .js]

Question

I am trying to fetch few data from database in my .js file of wordpress theme. I tried with .post() of jquery but nothing is happening.

Please also suggest me any alternate.

code in .js file

jq.post("../abc.php",
        {
        name:"kumar",
        accId:window.accommodationId

        },  function(data,status)
            {
                alert("hello");

             //alert("Data: " + data + "\nStatus: " + status);
            }
        );

code in abc.php file

<?php
global $wpdb;

$max_minAge = $wpdb->get_results( "SELECT price_per_day FROM  wp_byt_accommodation_vacancies where accommodation_id='1741'" );   

echo $max_minAge[0]->price_per_day;
?>

Use wp_ajax hook for all kind of ajax requests in wp codex.wordpress.org/Plugin_API/Action_Reference/… — Shah Rukh
– Shah Rukh, Commented Jan 19, 2015 at 10:28
please make it clear that i have to add any special code in my .php file or what. — ghoomigo akash
– ghoomigo akash, Commented Jan 19, 2015 at 10:30

Shah Rukh · Accepted Answer · 2015-01-19 10:50:11Z

1

you can use wp_ajax hooks like this in your functions.php file

  // script atyle add at frontend
    add_action( 'wp_enqueue_scripts','my_scripts_style');

 function my_scripts_style()
{
    wp_enqueue_script( 'scriptid', PATH_TO . 'script.js', array('jquery') );
    // localize the script
    wp_localize_script( 'scriptid', 'myAjax', array( 'url' =>admin_url( 'admin-ajax.php' ),'nonce' => wp_create_nonce( "ajax_call_nonce" )));
}

Then add the ajax hook

   // action for execute ajax from frontend 
    add_action( 'wp_ajax_nopriv_execute_ajax','execute_ajax');

function execute_ajax() 
{
    $nonce = check_ajax_referer( 'ajax_call_nonce', 'nonce' );
    if($nonce==true)
    {
    // here you will perform all the db communication get data from db and send it to the view area.
    echo 'test this';   
    die();
     }
}

then in your js file which you included via enque_script above. use this

jQuery(function(){
jQuery('.click-onthis').live('click', function(){ // get data by click
    var data = {
                    action: 'execute_ajax',
                    nonce: myAjax.nonce,
                    // anyother code etc
                };

                jQuery.post( myAjax.url, data, function(response) 
                {
                    if(response=='success')
                    {

                    }
                });
        });
    });

jquery click-on-this will work when click on a link you can coomunicate on load or any other event

edited Jan 19, 2015 at 10:50

answered Jan 19, 2015 at 10:45

Shah Rukh

3,1562 gold badges22 silver badges27 bronze badges

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

4 Comments

ghoomigo akash Over a year ago

what if i want it on load, means value should be echoed when this js load.

Shah Rukh Over a year ago

just remove the click function

ghoomigo akash Over a year ago

tough to implement your suggestion, ok lets screen it, Should I add top two section in my .php file, then what to write on PATH_TO, and where to add query.

Shah Rukh Over a year ago

I don't know what the other answers are saying, I just added the the things via Wordpress way. and the php functions and hooks will be added to your functions.php file and the jquery script will be in your script file which you enque in your functions.php the PATH_TO is nothing you just need to add the path of your jquery file, if its in the wordpress theme's js directory then it will be get_bloginfo('template_url').'/js/script.js'

Cas Bloem · Accepted Answer · 2015-01-19 10:40:05Z

0

You can use the jQuery AJAX get shorthand:

$.get( "../abc.php", function( data ) {
  alert( "Data Loaded: " + data );
});

Good to know: Since you're getting data from a file, you should use a GET.

answered Jan 19, 2015 at 10:40

Cas Bloem

5,1102 gold badges26 silver badges23 bronze badges

3 Comments

ghoomigo akash Over a year ago

no alert appeared, how to check if $wpdb is working or not. I have placed this file in root folder of my theme

Cas Bloem Over a year ago

Have you included jQuery before this JS?

ghoomigo akash Over a year ago

ofcourse, but this is wordpress theme I am following.. where I am new

Collectives™ on Stack Overflow

How to receive data from database via jquery? [wordpress .js]

2 Answers 2

4 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related