0

I am doing simple wordpress select query and want to do this with ajax jquery and do not want the page to refresh when I press search button and writing text in search textbox. As soon as I press search button I get zero .. please help in this because if I do it with normal query it gives the results with form submit now it gives zero no matter what I do. Thanks

jQuery(document).ready(function() {      
    jQuery("#Submityourskill").click(function(e){ 
        event.preventDefault();      
        jQuery.post(yes.ajaxurl,{action : 'doit'},
            function( response) {//start of funciton
                // alert(response);
                //jQuery("#searchtextbox").val(response);
                jQuery("#result").append(response);
                jQuery("#textarea").html(response);
                return false;
            } //end of function
        );
    }); // click button function finishing here
}); //end of main loop 

HTML:

<form action="" method="post">
    <div><input maxlength="200" name="secretcode" size="200" type="text" value="" placeholder="Type Here !" />
    <input id="Submityourskill" name="Submit" type="submit" value="Search Record" /></div>
</form>
<div id="result"></div>

PHP:

function doit() {
    if(isset($_POST['secretcode'])!= ''){
        if($_POST['Submit']) {
            $secretcode=$_POST['secretcode'];
            global $wpdb;
            $sql = "SELECT * FROM wp_store_locator WHERE sl_description='$secretcode'";
            $results = $wpdb->get_results($sql) or die(mysql_error());
            foreach( $results as $result ) {
                echo $result->sl_description;
            }
            exit();
        }
    }
}
add_action( 'wp_ajax_nopriv_doit', 'doit');
add_action( 'wp_ajax_doit', 'doit' );

function add_myjavascript(){  
    wp_register_script( 'globals', get_stylesheet_directory_uri() . "/js/ajax-implementationn.js", array( 'jquery' ) ); 
    wp_enqueue_script( 'globals' );
    // use wp_localize_script to pass PHP variables into javascript
    wp_localize_script( 'globals', 'yes', array( 'ajaxurl' => admin_url( 'admin-ajax.php' ) ) );
}  
add_action( 'init', 'add_myjavascript' );

Thanks everybody ...

  • Have you doen some debug on $results? – cybmeta Feb 22 '15 at 11:28
-1

if ajax returns zero, the function bound is not registered properly

have a read: http://arresteddeveloper.net/woocommerce-get-variation-description-variation-select-changes/

this might point you in the right direction

  • Link only answers are not quite recommended. Please keep some explanation. – Nilambar Mar 4 '15 at 3:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.