Write "Like" wildcard with ? keyword in Prepare Statement in MySQL, PHP

Asked Jan 06 '17 at 15:16

Active Jan 06 '17 at 15:36

Viewed 45 times

Currently I'm trying to Use Like in MySQL Prepare Statement but the issue is i'm not getting a way to write it in prepare statement. I've googled it but didn't get it write. Here is my code.

 $name = "Siqarah";
 $statement = mysqli_prepare($con, "SELECT Institute_Name FROM institute WHERE Institute_Name LIKE ? " );
 mysqli_stmt_bind_param($statement,"s", $name);

ok I got the answer from this link
Correct way to use LIKE '%{$var}%' with prepared statements? [mysqli]

edited May 23 '17 at 11:53

Community

asked Jan 06 '17 at 15:16

Muhammad Usman Khan

what errors are you getting and did you successfully connect with mysqli_ and did you execute that query along with fetching the results? – Funk Forty Niner Jan 06 '17 at 15:18
Is this similar? http://stackoverflow.com/q/8247970 – Praveen Kumar Purushothaman Jan 06 '17 at 15:18
this also seems to be related to your other question recently http://stackoverflow.com/q/41449169/1415724 – Funk Forty Niner Jan 06 '17 at 15:18
1

this query doesn't work because I want to use Like with ? and than bind the statement but it is not working – Muhammad Usman Khan Jan 06 '17 at 15:19
no it is not @Fred-ii- I want to use Like keyword in my sql prepare statement but I don't get it write – Muhammad Usman Khan Jan 06 '17 at 15:21
@MuhammadUsmanKhan ah, ok. – Funk Forty Niner Jan 06 '17 at 15:22
1

any Suggestions about how to use like keyword? @Fred-ii- – Muhammad Usman Khan Jan 06 '17 at 15:24
@MuhammadUsmanKhan consult the duplicate your question was closed with. – Funk Forty Niner Jan 06 '17 at 15:25

Write "Like" wildcard with ? keyword in Prepare Statement in MySQL, PHP

0 Answers0