actionmanwaite

Thanks for your great help, Peter. I now have the hook working. (Proven by the fact that I can get more than a 0 from the test URL above … and also when I do my “if(!is_admin()) {}” test I get the right result!) I guess this means that Snippets isn’t the tool I needed – bit annoyed with the WordPress Support team about that.

Anyway, progress – thank you – but I am not fully functional just yet. I may need more input in the days ahead. Very much appreciating your guidance.

Sorry Peter, I still haven’t managed to pass a variable from JS into the DB. As you can see from the page (URL below) I have a “Test Function” button, and as a “test rig” all I want to do is pass the number “1” into the Database. Sounds easy, but I haven’t cracked it! Thanks for all your help so far.

I’m using the following JS code in an HTML block on the web page (it’s generally functional, as I see “Test button clicked” but there is an error when I run the AJAX call which says “my_ajax_obj is not defined”). And I am running the PHP code (also copied below) using the “Code Snippets” plugin, although I am concerned about whether that code has the necessary admin rights when it runs. (I know that *I* have the admin rights, I’m not sure I have been able to grant them to the code!)
I’m not concerned about security for this site (so have removed all the nonce code) and I want it to be accessible by an anonymous user. I’m also concerned that I haven’t had to use the database number / table … although I’m not even getting to those issues yet!
I’m slightly concerned that I don’t have any wording that says “enqueue” – as that seems to be in many of the examples I have looked at in the documentation – and I’m also guessing that I have failed to “localize” variables (which I guess indicates I have a “training need”?).

Is this a lost hope, or am I getting close?
Thanks
alex

Web page HTML Block

<script>
jQuery(document).ready(function($) {             //wrapper
    $("button").click(function() {               //event triggers on clicking test button
        console.log("Test button clicked");
        var this2 = this;                        //use in callback
        $.post( my_ajax_obj.ajax_url, {          // THIS REFERENCE CAUSING ERROR***
            action: "mygame_update_card",        
            card: 1                              
        }, function(data) {                     //callback function (not needed YET!)
            console.log(data);                  // Will use $(this2)
        });                
    });
});
</script>

<strong>Code Snippet</strong>

<?php
add_action( ‘wp_ajax_nopriv_mygame_update_card’, ‘updateDB’ );  // is_admin() is currently FALSE here, so do I need to change to run in Admin area???

function updateDB() {
	header("Cache-Control: no-store, no-cache, must-revalidate, max-age=0");
	header("Cache-Control: post-check=0, pre-check=0", false);
	header("Pragma: no-cache");
	header('Content-Type: text/plain; charset=utf-8');
	if ( !isset( $_REQUEST['card'] ) ) {
		echo 'ERR-Wrong arguments';
	} ;
	// Get card (add values as needed)
	$card = sanitize_text_field( wp_unslash( $_REQUEST['card'] ) );
// Perform your update here: replace ??? with your values   HAVENT GOT THIS FAR YET
//	global $wpdb;
//	rows_update = $wpdb->update( ??? );
// Return update results
//	echo '' === $wpdb->last_error ? "UPD-{$rows_update}" : 'ERR-' . $wpdb->last_error;
	echo 'well at least im here';
}
?>

/happy-50th-birthday-susan/

Really helpful response Peter. Thank you very much. I ran into issues implementing it and (as someone self employed in Covid) work has taken unpredictable amounts of my time. Can I consult you next week if still struggling with implementation? After that, close as a job “well done”. Thank you for the support!