Using mysql like clause in php

Question

Mysql query that works fine for me is :

SELECT *
FROM `review_details`
WHERE category = 'italian'
AND review LIKE '%cozy%';

It display results.

SELECT *  FROM `review_details`    WHERE category = 'italian'    AND review LIKE %cozy%';

But when I execute in my php script :

$word = 'cozy';
$select = mysqli($con,"SELECT *  FROM `review_details`    WHERE category = 'italian'    AND review LIKE %.$word.%' ");

Then it does not display any result.

Please see query is correct, when I change the condition it gives result.

Your first two queries are different. Make them both work and you have solution. — Your Common Sense
– Your Common Sense, Commented Apr 25, 2014 at 6:32
You have wrong sql sentence, and also you need to use mysqli_query not mysqli. See my answer — Hüseyin BABAL
– Hüseyin BABAL, Commented Apr 25, 2014 at 6:38

MinhD · Accepted Answer · 2014-04-25 06:36:37Z

3

Change LIKE %.$word.%' into LIKE '%$word%'

edited Apr 25, 2014 at 6:36

answered Apr 25, 2014 at 6:31

MinhD

1,84812 silver badges14 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:20:48Z

0

Rewrite it as..

$select = mysqli_query($con,"SELECT * FROM `review_details` WHERE category = 'italian' AND review LIKE '%$word%' ");

The concatenation is not at all neccessary.

It should be mysqli_query. Pointed out by Husseyin.

edited May 23, 2017 at 12:20

CommunityBot

11 silver badge

answered Apr 25, 2014 at 6:31

Shankar Narayana Damodaran

68.6k43 gold badges102 silver badges129 bronze badges

2 Comments

Your Common Sense Over a year ago

It's not a problem as long as one have an admiring friend who prefers one's answer over all others

Shankar Narayana Damodaran Over a year ago

@YourCommonSense, Admiring friend O.o ?

Hüseyin BABAL · Accepted Answer · 2014-04-25 06:47:50Z

0

Your syntax is wrong, you need to use mysqli_query or $mysqli->query (PDO) , and some quote problem in sql sentence. You can use following;

$word = 'cozy';
$select = mysqli_query($con,"SELECT *  FROM `review_details`    
                WHERE `category` = 'italian'    AND `review` LIKE '%$word%' ");

Or if you are using pdo, you can use;

// $mysqli is the conn object
$word = 'cozy';
$select = $mysqli->query("SELECT *  FROM `review_details`    
                WHERE `category` = 'italian'    AND `review` LIKE '%$word%' ");

edited Apr 25, 2014 at 6:47

answered Apr 25, 2014 at 6:37

Hüseyin BABAL

15.6k5 gold badges53 silver badges74 bronze badges

1 Comment

Hüseyin BABAL Over a year ago

@YourCommonSense The question is very suspicious, sql sentence is wrong also function is wrong. I couldn't understand which library OP using or not. I have stated both of them. Do you think shall I remove PDO section?

Sadikhasan · Accepted Answer · 2014-04-25 06:32:18Z

-1

Try this

$word = 'cozy';
$select = mysqli($con,"SELECT *  FROM `review_details`    
                WHERE `category` = 'italian'    AND `review` LIKE '%$word%' ");

answered Apr 25, 2014 at 6:32

Sadikhasan

18.6k23 gold badges84 silver badges126 bronze badges

Comments

train_fox · Accepted Answer · 2014-04-25 06:48:56Z

-1

Try this:

$word = 'cozy';
$select = mysqli($con,"SELECT *  FROM `review_details`    WHERE category = 'italian'    AND review LIKE '%{$word}%' ");

But i suggest to use mysqli object oriented style instead of procedural style. Then use $con->prepare().

answered Apr 25, 2014 at 6:48

train_fox

1,5371 gold badge12 silver badges32 bronze badges

Collectives™ on Stack Overflow

Using mysql like clause in php

5 Answers 5

Comments

2 Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

2 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related