Concatenate two php variables in an sql query

Question

So I have an sql query where I would like to query the database using the LIKE operator and the underscore wildcard where the first and last letter of a string are used to construct a pattern. I store the letters of a string in two php variables - $first(representing the first letter) and $last(representing the last letter) and from there they are used in the query. I have tried many different ways to get the query to work and so far I haven't had any success. Could you please look at my code and point out an error and/or suggest a correction. Any help will be appreciated.

$query2 = "SELECT name, description, subcategory, image, price FROM baby_products WHERE name LIKE '".$first."'+'_'+'".$last."'";

If I correctly understand you're missing the CONCAT function in the MySQL Sting functions — fantaghirocco
– fantaghirocco, Commented Jun 5, 2015 at 10:29
Or you can simply write "SELECT name, description, subcategory, image, price FROM baby_products WHERE name LIKE '".$first.'_'.$last."'" — fantaghirocco
– fantaghirocco, Commented Jun 5, 2015 at 10:35
I tried both methods plus Uchicha's method. They all worked. Thank you — user4909046
– user4909046, Commented Jun 5, 2015 at 10:46

Narendrasingh Sisodia · Accepted Answer · 2015-06-05 10:29:09Z

2

Try it out as

$query2 = "SELECT name, description, subcategory, image, price FROM 
baby_products WHERE name LIKE '%{$first}%' OR '%{$last}%'";

answered Jun 5, 2015 at 10:29

Narendrasingh Sisodia

21.4k6 gold badges51 silver badges54 bronze badges

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

Collectives™ on Stack Overflow

Concatenate two php variables in an sql query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related