Support

Account

Forum Replies Created

  • I have this completely working now…

    When a user is selected, the relevant user meta data is taken out of the database and used to populate 4 other fields.

    Enqueue jquery and localise from functions.php

    function enqueue_scripts_back_end(){
    	wp_enqueue_script( 'ajax-script', get_template_directory_uri() . '/js/my_query.js', array('jquery'));
    	
    	wp_localize_script( 'ajax-script', 'ajax_object',
                array( 'ajax_url' => admin_url( 'admin-ajax.php' )) );
    	
    }
    add_action('admin_enqueue_scripts','enqueue_scripts_back_end');

    seperate jQuery file…

    jQuery(document).ready(function($) {
    	
    	var field = acf.getField('field_5a7dc432d1999');
    	
    	field.on('change', function( e ){
    
        var vally = field.val();
    		
    	var data = {
    		'action': 'my_action',
    		'userno': vally    
    	};
    		
    	$.ajax({
    		url: ajax_object.ajax_url,
    		type : 'post',
    		data: data,
    		dataType: 'json',
    		success: function( data ) {
    		
    			$('#acf-field_5c3daeb8608ae').val(data.heightno);
    			$('#acf-field_5c3daf8f608af').val(data.weightno);
    			$('#acf-field_5c3dafc1608b1').val(data.ageno);
    			$('#acf-field_5c3dafa5608b0').val(data.bodyfatno);
    		}
    	})
    	
    	
    });
    	
    });

    in my functions.php file…

    // Same handler function...
    add_action( 'wp_ajax_my_action', 'my_action' );
    function my_action() {
    	
    
    	global $wpdb;
    	
    	$userno = intval( $_POST['userno'] );
    	
    	$heightno = get_user_meta( $userno, 'user_height', 'true' ); 
    	$weightno = get_user_meta( $userno, 'user_weight', 'true' ); 
    	$bodyfatno = get_user_meta( $userno, 'user_bodyfat', 'true' ); 
    	$dob = get_user_meta( $userno, 'user_dateofbirth', 'true' );	i
    	
    	$dobno = explode( "/", $dob );
    			//get age from date or dob
    		
    			$ageno = ( date( "md", date( "U", mktime( 0, 0, 0, $dobno[ 0 ], $dobno[ 1 ], $dobno[ 2 ] ) ) ) > date( "md" ) ?
    				( ( date( "Y" ) - $dobno[ 2 ] ) - 1 ) :
    				( date( "Y" ) - $dobno[ 2 ] ) );
       
    	
    	echo json_encode(array('heightno' => $heightno,'weightno'=> $weightno, 'ageno'=> $ageno, 'bodyfatno'=> $bodyfatno));
    	
    	wp_die();
    	
    }

    Hope that helps somebody

  • D’oh! I realise now the add_action wasn’t supposed to go in the admin-ajax file.

    I’ve added it to my functions file and I’ve now got the user ID of selected user sending there, where I get the height of that user. I also managed to send that response back to the jquery and into an alert.

    What I need to do now is get another 2 variables in the my_action (easy enough), and update 3 ACF fields (height) (weight) (bodyfat) on the front end.

    Should I
    A) //update height field
    update_field(‘field_5c3daeb8608ae’, $heightno);

    Update that field with PHP in my_action (tried it, it didn’t work. maybe I’m not targeting the field properly).

    or

    B) Send the 3 values back to the jQuery and try and do it that way. So far I’ve only managed to send ‘response’ back, which is a single value. Can I send multiple values?

    Thanks

  • Hi thanks again for this. I just wrote a really long reply but it disappeared. I didn’t have any luck even with the basic example in ‘AJAX in plugins’

    Just to check theres not anything glaringly obviously wrong heres my code…

    In functions.php

    add_action( 'admin_enqueue_scripts', 'my_enqueue' );
    function my_enqueue() {
            
    	wp_enqueue_script( 'ajax-script', get_template_directory_uri() . '/js/my_query.js', array('jquery') );
    
    	// in JavaScript, object properties are accessed as ajax_object.ajax_url, ajax_object.we_value
    	wp_localize_script( 'ajax-script', 'ajax_object',
                array( 'ajax_url' => admin_url( 'admin-ajax.php' ), 'we_value' => 1234 ) );
    }

    In my_query.js

    jQuery(document).ready(function($) {
    	
    	console.log('myquery');
    	
    	var data = {
    		'action': 'my_action',
    		'whatever': ajax_object.we_value      // We pass php values differently!
    	};
    	// We can also pass the url value separately from ajaxurl for front end AJAX implementations
    	jQuery.post(ajax_object.ajax_url, data, function(response) {
    		alert('Got this from the server: ' + response);
    	});
    });

    and at the bottom of admin-ajax.php

    // Same handler function...
    add_action( 'wp_ajax_my_action', 'my_action' );
    function my_action() {
    	global $wpdb;
    	$whatever = intval( $_POST['whatever'] );
    	$whatever += 10;
            echo $whatever;
    	wp_die();
    }	

    I just get a 400 error

    But I think I’m going to give up and pay someone to help me. I guess you probably have better things to do but let me know if not. Its really not working for me

  • Hi thanks again for this. I just wrote a really long reply but it disappeared. I didn’t have any luck even with the basic example in ‘AJAX in plugins’

    Just to check theres not anything glaringly obviously wrong heres my code…

    In functions.php

    add_action( 'admin_enqueue_scripts', 'my_enqueue' );
    function my_enqueue() {
            
    	wp_enqueue_script( 'ajax-script', get_template_directory_uri() . '/js/my_query.js', array('jquery') );
    
    	// in JavaScript, object properties are accessed as ajax_object.ajax_url, ajax_object.we_value
    	wp_localize_script( 'ajax-script', 'ajax_object',
                array( 'ajax_url' => admin_url( 'admin-ajax.php' ), 'we_value' => 1234 ) );
    }

    In my_query.js

    jQuery(document).ready(function($) {
    	
    	console.log('myquery');
    	
    	var data = {
    		'action': 'my_action',
    		'whatever': ajax_object.we_value      // We pass php values differently!
    	};
    	// We can also pass the url value separately from ajaxurl for front end AJAX implementations
    	jQuery.post(ajax_object.ajax_url, data, function(response) {
    		alert('Got this from the server: ' + response);
    	});
    });

    and at the bottom of admin-ajax.php

    // Same handler function...
    add_action( 'wp_ajax_my_action', 'my_action' );
    function my_action() {
    	global $wpdb;
    	$whatever = intval( $_POST['whatever'] );
    	$whatever += 10;
            echo $whatever;
    	wp_die();
    }	

    I just get a 400 error
    https://ibb.co/MMJz8NY

    But I think I’m going to give up and find a proper php coder to help me. Its really not working for me

  • Thanks for all the help, but I think this is a bit beyond me.

    I followed the ‘AJAX in plugins’ documentation, and still got an error even with the most basic example.

    Just in case theres anything glaringly obvious I’ll put the code here, but I think I’m going to try to find someone to pay to do this. I thought it’d be fairly easy but seems to have jumped in difficulty pretty quickly.

    In my functions.php…

    add_action( 'admin_enqueue_scripts', 'my_enqueue' );
    function my_enqueue() {
            
    	wp_enqueue_script( 'ajax-script', get_template_directory_uri() . '/js/my_query.js', array('jquery') );
    
    	// in JavaScript, object properties are accessed as ajax_object.ajax_url, ajax_object.we_value
    	wp_localize_script( 'ajax-script', 'ajax_object',
                array( 'ajax_url' => admin_url( 'admin-ajax.php' ), 'we_value' => 1234 ) );
    }

    In my my_query.js file…

    jQuery(document).ready(function($) {
    	
    	console.log('myquery');
    	
    	var data = {
    		'action': 'my_action',
    		'whatever': ajax_object.we_value      // We pass php values differently!
    	};
    	// We can also pass the url value separately from ajaxurl for front end AJAX implementations
    	jQuery.post(ajax_object.ajax_url, data, function(response) {
    		alert('Got this from the server: ' + response);
    	});
    });	

    And at the bottom of my admin-ajax.php file…

    // Same handler function...
    add_action( 'wp_ajax_my_action', 'my_action' );
    function my_action() {
    	global $wpdb;
    	$whatever = intval( $_POST['whatever'] );
    	$whatever += 10;
            echo $whatever;
    	wp_die();
    }

    I just get this error…
    https://ibb.co/MMJz8NY

    I’m sure you have better things to do but I would be willing to pay for your time to create the code, as I don’t feel like any of this is really going in.

    Thanks

  • Thanks again! I now have a jQuery variable being updated on change of that ACF select field.

    So I now need to send that to my PHP…

    $height = get_user_meta( $userid, 'user_height', 'true' );

    Receive that $height value, and push it to the ACF field.

    Any suggestions of documentation for this, I’m completely new to AJAX

    Thanks!

  • You’re right !

    Thanks for the quick response, and sorry for my ignorance, but I’m still at a loss.

    When I change the selection, it appears to add my new selection as an option, but it doesn’t updated that option to be ‘selected’…it remains over my original choice (pedro) and not the person currently selected (abdullah)

    https://ibb.co/kyP1QWw

    You can see what I mean here

  • Thanks for that. Makes sense, but now I realise I don’t think its possible, as the ACF user select only shows the username on the front end and not the ID, which I think I need to grab the meta data

  • This did solve my initial problem, but how would it work if the inner rows weren’t named sequentially?

    I have four groups in a parent group called carb_cycle_meals, but the inner groups are named ‘zero’, ‘low’, ‘medium’ and ‘high’. I want to perform exactly the same code for each of them.

    Is that possible?

  • Interesting. My labels will always be unique though, so I could switch them over.

    NOPE – Just realised if I do that, the user on the backend is picking from a random list of numbers, it is the complete list though 🙂

    So instead I think the solution is to populate that select box with JUST the label..

    if ( have_rows( 'protein', 2564 ) ) {
            
            // while has rows
            while( have_rows('protein', 2564) ) {
                
                // instantiate row
                the_row();
                
                $type = get_sub_field('class', 2564);
    
                $value = get_sub_field('grams', 2564);
                $label = get_sub_field('food_name', 2564);
    
                // append to choices
                $field['choices'][ $label ] = $label;
                
            }
        }

    (theres definitely a more streamline way of doing that)

    …and then to use that label to find the matching ‘grams’ number back on the options page (ID=2564). The problem is ‘grams’ is not a subfield of the food name, but rather a sibling.

    I’m sure there’s a solution here, just need to give it some thought.

    Thanks for your help, sorry for the rambling 🙂

  • Thanks John,

    Think there were a couple of tiny typos but that works great. And I added my feeds_per_day variable in the for loop to show the right amount of meals. Perfect!

    for ($i=1; $i<$feeds_per_day + 1; $i++) {
    if (have_rows('meal_'.$i)) {
        while (have_rows('meal_'.$i)) {
          the_row();
    		
          // get sub fields and do calulations
          
          ?><tr><td>Meal <?php echo $i; ?></td><td><?php echo more stuff ?></td></tr><?php
        } // end while
      } // end if meal
    } // end for
Viewing 11 posts - 1 through 11 (of 11 total)