how to use variable in SQL query language in WordPress

Question

I have a DB table named 'affiliate_wp_coupons' where has 3 cols and they are;

coupon_id
affiliate_id
coupon_code

I have coupon_code which is coming from a variable, not static. Now I wanted to query the associated affilaite_id value based on the coupon_code.

I am trying this code:

$results = $wpdb->get_results( "SELECT * FROM affiliate_wp_coupons WHERE `coupon_code`= 'BS0PDDTTGU'");

This code returns an Object with the matched col.

In the above code coupon_code value is static, how can I put a variable here?

emptyhua · Accepted Answer · 2021-10-15 02:22:02Z

1

$coupon_code = 'BS0PDDTTGU';
$results = $wpdb->get_results($wpdb->prepare("SELECT * FROM affiliate_wp_coupons WHERE `coupon_code`= %s", $coupon_code));

answered Oct 15, 2021 at 2:22

emptyhua

6,69212 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ted · Accepted Answer · 2021-10-16 08:15:36Z

0

There're multiple ways to concatenate/inserting variable into a string in PHP, ex:

$coupon_code = 'Windy';
$str = "Hello {$coupon_code}!"; // Hello Windy!
$str2 = "Hello $coupon_code!"; // Hello Windy!
$str3 = 'Hello '.$coupon_code.'!'; // Hello Windy!

personally I prefer $str2.

Then in your case you can replace your code something like:

$results = $wpdb->get_results( "SELECT * FROM affiliate_wp_coupons WHERE `coupon_code`= '{$coupon_code}'");

Note: don't forget to define $coupon_code before run query.

PHP reference: https://www.php.net/manual/en/language.operators.string.php
Related discussion: PHP - concatenate or directly insert variables in string

edited Oct 16, 2021 at 8:15

answered Oct 16, 2021 at 8:09

Ted

4,1868 gold badges63 silver badges88 bronze badges

Collectives™ on Stack Overflow

how to use variable in SQL query language in WordPress

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related