Of course! I just had to set the $accepted_args parameter of add_filter() to 2. Like so: add_filter(‘posts_join’, ‘my_join’, 10, 2); function my_join($join, &$query) { echo $query->is_main_query() ? ‘y’ : ‘n’; return $join; }
Just use %s for string and %d for digit replacements. Do not forget to use the proper esc_*() functions (use full text search for esc_ in the function reference). global $wpdb; $wpdb->show_errors = true; $wpdb->suppress_errors = false; ! defined( ‘DIEONDBERROR’ ) and define( ‘DIEONDBERROR’, true ); $sql = <<<SQL SELECT ID FROM {$wpdb->posts} WHERE post_type=”attachment” … Read more
You don’t need to use $wpdb->prepare() for ORDER BY clauses. $wpdb->prepare() will always quote your variables. Supposing you receive the ordering in the request, you can prevent SQL injection by not using the user entered value at all: $sql = “SELECT….”; if ( ‘asc’ == $_GET[‘order’] ) { $sql .= ‘ ORDER BY p.post_date ASC’; … Read more
This is something that has thrown me off in the past. You actually see the error that talking about the Privileges, but the actual error is that the database doesn’t exist! You are searching for database name wp_ where there is only bitnami_wordpress. $sql = “SELECT * FROM bitnami_wordpress.wp_comments WHERE comment_ID = $id”;
Are you sure that’s the table name? Usually on install WordPress prompts you to setup a table prefix so the default isn’t wp_. Additionally, you need to call the global $wpdb object so it’s accessible to use: global $wpdb; $user_count = $wpdb->get_var( “SELECT COUNT(*) FROM $wpdb->users” ); echo “<p>User count is {$user_count}</p>”; Finally, to prevent … Read more
$_POST[‘param’] is a string, you can not treat it like an array. That’s why only f characters are inserted. You have two options, prepare data as an array in javascript or parse the string to array on the PHP side. Sample code for 2nd option: $table = $wpdb->prefix.’newsletter’; // ‘firstname=FIRSTNAME&lastname=LASTNAME&email=EMAIL%40DOMAIN.COM&type=TYPE’ $input = explode( ‘&’, $_POST[‘param’] … Read more
Just to add to what MozBoz has already said, you can also set the author from the post / page in WP directly. You can usually do this from the editor itself, but there are a lot of page builders available, so I’d suggest going to WP Admin and to your All Posts, hover over … Read more
Hi @Scott B: Did you remember to include a global $wpdb; in your code, like so? global $wpdb; $excludeImages = array(); $excludeImages = $wpdb->query(“SELECT meta_value FROM $wpdb->postmeta WHERE meta_key = ‘_wp_attached_file'”); array_push($excludeImages);
If I understand correctly- this is an AJAX request, there is no $post var because you haven’t loaded anything from the database in this request. You have to pass both the ID you want to relate it to, and also the ID you want to relate it from, neither exist in the current request.
As you can see in the Codex pages the get_results doesn’t provide the functionality to add a value parameter in the method: $wpdb->get_results(‘query’, output_type); output_type has the following description: One of four pre-defined constants. Defaults to OBJECT. See SELECT a Row and its examples for more information. OBJECT – result will be output as a … Read more