MySQL-string concatenation with a php variable

Question

I want to combine the variable $name with the "%" so i can search for names that begin the value of $name.

$name = $_POST['name'];
$get_search_results_q= "SELECT * FROM `users`.`info` WHERE `info`.`fullname` ='$name'+'%' ";

kefy · Accepted Answer · 2014-09-01 18:52:10Z

4

This u need

$get_search_results_q= "SELECT * FROM `users`.`info` WHERE `info`.`fullname` LIKE '$name%' ";

answered Sep 1, 2014 at 18:52

kefy

5352 silver badges10 bronze badges

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

4 Comments

Worked as expected!Thanks mate :)

Why it returns nothing when i type something that doesn't exist in DB?

because its only return if found any record that begin as u defined LIKE 'keyword%' for all record begin 'keyword'

No i mean nothing.mysql_query doesn't show anything.It don't return even false...

Ende Neu · Accepted Answer · 2014-09-01 18:53:22Z

2

$get_search_results_q= "SELECT * FROM `users`.`info` WHERE `info`.`fullname` ='$name%' ";

Note that your code is open to SQL injection, you should have a look at prepared statements.

answered Sep 1, 2014 at 18:53

Ende Neu

15.8k5 gold badges61 silver badges72 bronze badges

I know Ende thanks for the reply.At the moment i build the main idea,later i will go to mysqli()