PHP mysql-> prepare（）查询中的IN子句不起作用 - 发布更新

Question

I am having trouble creating prepared statement, it always returns false and i don't understand why. I have looked into other similar questions asked here at stack overflow but they were of little help and I am still stuck with this.

I checked DB connection and its working fine. I also ran the query with TOAD and it's working.

$msqli = new mysqli($dbHost, $dbUser, $dbPass, $dbName, $dbPort);

$prepstmt = $msqli->prepare("select lr.bank_id,lr.bank_name,lr.loan_rate from msdb1.loan_rates lr where lr.bank_id in ? and lr.from_amount = ? and lr.to_amount <= ? and lr.floating = ? and lr.salaried in ? and lr.professional in ? and lr.gender = ?");

The above statement always returns false.

I have already spent good amount of time on it. I am new to PHP programming. Please help me out.

EDIT: I forgot to add other things. In IN clause I am making a list like ('val1','val2').

$prepstmt->bind_param("siissss", $bnkIdFmtList,$frmAmt,$toAmt,$intType,$bind_sal,$bind_pro,$gender);
$prepstmt->execute();
$prepstmt->bind_result($bank_id,$bank_name,$loan_rate);