how to fetch mysql data using ajax when one input is filled using function.php

Question

mysql table

|order_no |order_name | | -------- |------------| | 43423 | abc | ??????????????????????????

now my question is how do i use ajax to fetch the order name and city when i order number ? any help is appreciated..

I have a code here:

ValidateForm.js

var searchTimeout; //Timer to wait a little before fetching the data
$("#order_numbr").keyup(function() {
    searchKey = this.value;

    clearTimeout(searchTimeout);

    searchTimeout = setTimeout(function() {
        getUsers(searchKey);    
    }, 400); //If the key isn't pressed 400 ms, we fetch the data
});


function getUsers(searchKey) {
    $.ajax({
            type : "POST",
            async: false,
            data : "action=checkOrdrNum",
            url  : ajaxurl,
            dataType:"json",
             success: function(data) {
            if(data.status) {
                $("#ur_name1").val(data.userData.order_name);
            }   
        }
    }"This order number does not exist");         
}




And ofcourse the function.php file:


add_action('wp_ajax_nopriv_checkOrdrNum','checkOrdrNum');
add_action('wp_ajax_checkOrdrNum','checkOrdrNum');
function checkOrdrNum(){
    global $wpdb,$current_user;

     $response = Array();

    $response['status'] = false;

    $query = mysql_query("SELECT `order_name` FROM `art_work_history` WHERE `order_no` LIKE '%".$_POST['value']."%' LIMIT 1"); //Or you can use = instead of LIKE if you need a more strickt search

    if(mysql_num_rows($query)) {
        $userData = mysql_fetch_assoc($query);

        $response['userData'] = $userData;
        $response['status'] = true;            
    }

    echo json_encode($response);
}

Sandeep · Accepted Answer · 2013-02-28 04:35:08Z

0

U need to pass input value to the ajax

I thnk that was the only thing missing

function getUsers(searchKey) {
    $.ajax({
            type : "POST",
            async: false,
            data : "action=checkOrdrNum",
            url  : ajaxurl,
            dataType:"json",
            data: {value: searchKey}, // this is the line missing
             success: function(data) {
                if(data.status) {
                $("#ur_name1").val(data.userData.order_name);
            }   
        }
    });         
}

answered Feb 28, 2013 at 4:35

Sandeep

2,12121 silver badges35 bronze badges

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

9 Comments

Sandeep Over a year ago

what is the output you are getting? whats data in the success function?

user2117832 Over a year ago

I have 2 textbox #order_numbr and #ur_name1. I want to display the value order_name in #ur_name1 once you search correct order_no using #order_numbr.

Sandeep Over a year ago

i understood your requirement. all i need is y it is not working. what is the response you r getting from the server. what does echo json_encode($response); this output?

user2117832 Over a year ago

Im sorry I didnt understand. Ive been do same as [link]stackoverflow.com/questions/12883178/…

Sandeep Over a year ago

hav you jus copy pasted everything from that thread? are you opening and closing the database connections and flusing the output in php? any errors on server side? please check the logs.

|

Collectives™ on Stack Overflow

how to fetch mysql data using ajax when one input is filled using function.php

1 Answer 1

9 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related