You should use the default way the WP recommend to handle ajax calls. This will save you from lots of pitfalls and bad practices. add_action( ‘wp_ajax_nopriv_****’, ‘your_custom_function’ ); add_action( ‘wp_ajax_****’, ‘your_custom_function’ ); function your_custom_function() { } JS part jQuery.ajax({ type: “post”, dataType: “json”, url: ajax_url,// need the admin_url(‘admin-ajax.php’) data: formData, // your data success: function(msg){ … Read more
Debugging db calls: $wpdb->insert works on test site, not on identical production site
It is a a bit of a stab in the dark, but I’m fairly confident that the problem is your foreach loop. It’s broken (it will not execute anything because only an empty statement (;) is affected, and you will probably want it to have a block that contains the rest of the code. As … Read more
Escaping a WPDB Object in One Shot
In the table, all columns are set with NOT NULL consent. that means they can not be empty at all and considered as required fields. But in the insert query, You are saving only 3 records. $wpdb->insert( $table_name, array( ‘holiday_name’ => $holiday_name, ‘date’ => $date, ‘state’ => $state_form_select, ) ); That’s the issue. Either insert … Read more
You should not use the $errors globally, but use hooks in WordPress development. Since you are new to WP development, I will explain briefly how it works. What you should do instead: make a new hook, or use an existing one which you call at the location you want this error to appear in your … Read more
While your question isn’t entirely clear on the issue you’re having, I’m guessing that it’s the way that you defined the elements of the array you were trying to insert. You had a mix of commas and semicolons separating the elements. I revised your code to correct that – and to aid readability of your … Read more
$wpdb select returns empty array
You won’t be able to do this with meta. All user meta is stored in the meta_value column of wp_usermeta, so if you tried to set a constraint on that column you’d just prevent any other user meta from being set.
Try Applying These Changes Add this conditional before the // first check if data exists with select query: // Do nothing else if the search term is empty. if ( empty( $search_term ) ) { return $where; } Update: You may also want to check if it’s the main query and if not, exit the … Read more