[Solved] Which of the following is the correct way to safely prepare a SQL query using $wpdb? — Ans: $wpdb->prepare("SELECT * FROM wp_posts WHERE ID = %d", $id); | Wordpress

Wordpress - WordPress Query and Database

Which of the following is the correct way to safely prepare a SQL query using $wpdb?

A$wpdb->prepare("SELECT * FROM wp_posts WHERE ID = %d", $id);

B$wpdb->query("SELECT * FROM wp_posts WHERE ID = $id");

C$wpdb->get_results("SELECT * FROM wp_posts WHERE ID = $id");

D$wpdb->execute("SELECT * FROM wp_posts WHERE ID = %d", $id);

Step-by-Step Solution

Solution:

Step 1: Identify the safe query method
$wpdb->prepare() safely inserts variables into SQL queries using placeholders like %d.
Step 2: Check each option
$wpdb->prepare("SELECT * FROM wp_posts WHERE ID = %d", $id); uses prepare correctly with %d and variable $id. Others either lack preparation or use wrong methods.
Final Answer:
$wpdb->prepare("SELECT * FROM wp_posts WHERE ID = %d", $id); -> Option A
Quick Check:
Safe query uses prepare with placeholders [OK]

Quick Trick: Use prepare with %d, %s for safe queries [OK]

Common Mistakes:

Master "WordPress Query and Database" in Wordpress

9 interactive learning modes - each teaches the same concept differently

More Wordpress Quizzes

Which of the following is the correct way to safely prepare a SQL query using $wpdb?