wpdb

I have include wp-config, should I add global $wpdb also?

If you need a processing endpoint with access to the WordPress API, use the admin_post_ action and eliminate the need to manually include wp-config.php or any other WordPress files. // add for logged-in visitors add_action( ‘admin_post_your_action’, ‘prefix_your_action_function’ ); // for non logged-in visitors add_action( ‘admin_post_nopriv_your_action’, ‘prefix_your_action_function’ ); function prefix_your_action_function() { global $wpdb; // your processing … Read more

Exclude category from DB query

I’m sure there’s a better approach, but this query should do what you want: SELECT DISTINCT meta_value FROM wp_postmeta pm WHERE meta_key = ‘Driver’ AND NOT EXISTS (SELECT * FROM wp_term_relationships tr JOIN wp_term_taxonomy tt ON tt.term_taxonomy_id = tr.term_taxonomy_id JOIN wp_terms t ON t.term_id = tt.term_id WHERE pm.post_id = tr.object_id AND tt.taxonomy = ‘category’ AND … Read more

AJAX call in backend results in empty update_option

I figured it out, when registering with register_setting the second parameter is the name of the settings you will be saving and updating, the parameter is pass in here to whitelist it against being updated outside of the plugin. The AJAX callback is deemed outside of the plugin. My register settings is below and the … Read more

complex query question

It’s pretty easy actually in your single-event.php file within the content loop. add this loop where you want your speakers information to show. $event_title = get_the_title(); // This is the title of the current single event page we are on. $args = array( ‘meta_key’ => ‘event_name’, // the name of your custom field ‘meta_value’ => … Read more

Creating an Angular factory from custom database table

Guess I should have read the error page more carefully, because it contained the answer in plain English. In the factory request is should simply match the request to the response signature (an array in my case), thus becoming: angular.module(“app”).controller(“MainController”, [“$scope”, “commentRepository”, function ($scope, commentRepository) { commentRepository.query(function(data) { $scope.comments = data; }); }]); Instead of … Read more

+ More