wpdb - Read For Learn

Use $wpdb->get_results with filter based on array

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

I can’t write in my DB using $wpdb->insert

I would say the problem is first array. Change it to array( ‘name’ => $_POST[‘name’] ), You can also use wpdb->show_error() or wpdb->print_error() To Samuel Elh: wpdb->insert() can escape value itself

Call to a member function insert()

Unable to pass variable to database

Never mind, I just took a few hours away from the script and then I found the culprit… I did mistype the $proprietate variable when I assigned it to the db field (which is set to not NULL)…

Select Unique Posts for a List of Tags

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

What to do to have access to WordPress functions

never access theme or plugin files directly in their directory, this is a non secure way to develop code which will be blocked on any server with hardened security. If you need to get information from the site you can either add an ajax access, or json end point in your code for that.

+ More