You are here

PHP + AJAX + JQUERY

PHP

<?php

        $parse_uri

= explode( 'wp-content', $_SERVER['SCRIPT_FILENAME'] );
        require_once(
$parse_uri[0] . 'wp-load.php' );
       
       
$data = $_POST['dataValue'];
        global
$wpdb;
        global
$current_user;
       
get_currentuserinfo();
       
$id = $current_user->ID;
       
$idlead = $wpdb->get_var ( "SELECT meta_value FROM wp_usermeta WHERE user_id = $id AND meta_key = 'entry_id'");
       
$field_number = "33" + $data; //Signature number
       
$newSignature = $wpdb->get_var ( "SELECT value FROM wp_rg_lead_detail WHERE lead_id = $idlead AND field_number = $field_number");

        echo

json_encode ($newSignature);
?>

AJAX - Jquery

jQuery(document).ready(function($) {
            $('#select-id').on('change',function(){
                $.ajax({
                    url : '/wp-content/themes/fruitful-child/functions/get_signature.php',
                    type : 'POST',
                    data : { dataValue : $('#select-id').val() },
                    dataType : 'json',
                    success : function (data) {
                        var imgdata = data;
                        $('#select-physician .signature').html('<img src="/wp-content/uploads/gravity_forms/signatures/'+imgdata+'">');
                    },
                })
            });
        });

HTML

        <div class="signature">
            <img src="/wp-content/uploads/gravity_forms/signatures/<?php echo $signature?>"> // to add the html
        </div>
code type: