在sql语句中包含变量的正确方法是什么[重复]

Question

This question already has an answer here:

• What is the difference between single-quoted and double-quoted strings in PHP? 10 answers

I want to include a variable in my sql statement but it's not outputting any data. How do I include a variable correctly?

$vStyles = $wpdb->get_results( 'SELECT slug from vf_venuestyles WHERE vid = "$vid"');

</div>

Answer 1

Change the quote marks around: $vStyles = $wpdb->get_results("SELECT slug from vf_venuestyles WHERE vid = '$vid'");

But, unless that function / class already does something magic about that, you should look into using something with proper prepared statements.