donglu9445 2012-08-08 21:11
浏览 34
已采纳

如何使用%通配符?

public function searchItem($itemname) //search item based on itemname
{

    $itemname = (string)$itemname; 
    $select = $this->select() 
    ->from(array('item')) 
    ->where('itemname LIKE "%"?"%', $itemname);
    $row = $this->fetchAll($select);
    if (!$row) { //if row can't be found
        throw new Exception("Could not find row $itemname"); //Catch exception where itemid is not found


    }
    return $row->toArray();
}

Any idea on how to use the two '%'? I tried to use combinations of ' and " but it doesnt work, cant figure out what to use. Thanks in advance.

  • 写回答

1条回答 默认 最新

  • duanbi2760 2012-08-08 21:13
    关注

    You can use \% to escape the percent sign.

    Note you can use PHPs mysql_real_escape_string to do this for you.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?