Skip to content

Instantly share code, notes, and snippets.

@wpscholar

wpscholar/wpdb-prepare.php

Last active January 15, 2025 21:08
Show Gist options
  • Save wpscholar/5026f5053c898a88c01d to your computer and use it in GitHub Desktop.
Save wpscholar/5026f5053c898a88c01d to your computer and use it in GitHub Desktop.
Download ZIP
$wpdb->prepare() example
Raw
wpdb-prepare.php
<?php
global $wpdb;
$query = $wpdb->prepare(
"SELECT * FROM {$wpdb->posts} WHERE post_type = %s",
$post->post_type
);
$results = $wpdb->get_results( $query );
@lbonomo
Copy link

lbonomo commented Jan 15, 2025

Hi,
Why you don't use ?

$query = $wpdb->prepare( "SELECT * FROM %i WHERE post_type = %s", $wpdb->posts, $post->post_type );

https://developer.wordpress.org/reference/classes/wpdb/prepare/

@wpscholar
Copy link
Author

@lbonomo - I believe my code snippet here predates that feature, but yes, that appears as though it may be the latest best practice.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment