add variable in query

Question

i have this variable here:

$prefix=$wpdb->base_prefix  ;

Which prints

wp_

Now, i do have this query, and i need to insert it something like this:

$path = $wpdb->get_results("SELECT * FROM $prefixbckg
 WHERE id = 1");

My output has to be this:

$path = $wpdb->get_results("SELECT * FROM wp_bckg
 WHERE id = 1");

How can i do this? Because i need to make the prefix to be flexible, so i need to add the prefix before, without pre-defining it. Thanks

$path = $wpdb->get_results("SELECT * FROM {$prefix}bckg WHERE id = 1"); ?.. — Max Yakimets
– Max Yakimets, Commented Dec 27, 2012 at 15:45

Tom van der Woerdt · Accepted Answer · 2012-12-27 15:44:27Z

2

The proper way:

$path = $wpdb->get_results('SELECT * FROM '.$prefix.'bckg WHERE id = 1');

The "I'm new to PHP" way:

$path = $wpdb->get_results("SELECT * FROM {$prefix}bckg WHERE id = 1");

answered Dec 27, 2012 at 15:44

Tom van der Woerdt

30k7 gold badges76 silver badges105 bronze badges

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

5 Comments

Jonah Bishop Over a year ago

Why is option number one more 'proper' than the second?

Alex Over a year ago

You mean... 'The way I like it' and 'The way it should be done' framework.zend.com/manual/1.12/en/…

salih0vicX Over a year ago

@JonahBishop Because it uses single quotation marks so the parser won't waste time in searching for variable inside the statement... Whenever gets to the double quotations the php parser check whole statement for possible variable while with single it doesn't ... It is faster anyway...

Tom van der Woerdt Over a year ago

It's faster, easier to read, editors can help you and it's the way that most languages do it.

Jonah Bishop Over a year ago

While it may technically be faster, I can't believe it matters in 99.9% of cases. Premature optimization is the root of all evil.

Ali · Accepted Answer · 2012-12-27 17:37:42Z

1

Try one of these methods:

$prefix=$wpdb->base_prefix;
$mainPrefix = $prefix . 'bckg';
$path = $wpdb->get_results("SELECT * FROM $mainPrefix WHERE id = 1");

or

$path = $wpdb->get_results("SELECT * FROM {$prefix}bckg WHERE id = 1");

Both results are same:

SELECT * FROM wp_bckg WHERE id = 1

But which one is faster!? I made a simple benchmark program and here is the sequel:

The first method time is: 0.0608940124512

The second method time is: 0.0609350204468

So the first method a bit faster than the second method :-)

Good Luck

edited Dec 27, 2012 at 17:37

answered Dec 27, 2012 at 16:35

Ali

2,0523 gold badges26 silver badges42 bronze badges

Collectives™ on Stack Overflow

add variable in query

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related