Zend Framework中的Zend_Db不支持模糊查询?解决思路

WBOY
Release: 2016-06-13 13:52:30
Original
979 people have browsed it

Zend Framework中的Zend_Db不支持模糊查询???
Zend Framework中的Zend_Db是不是不支持like查询...
下面为我的主要代码:

PHP code
<!--

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/

-->class Dtstockgrade extends Zend_Db_Table_Abstract {
    
    protected $_name = 'dtstockgrade';
    protected $_db;
    
    public function init(){
        
        $this->_db=$this->getAdapter();    
    }
        public function getListSize($classid='',$author='',$stockcode='',$title='',$time=''){
        if(strlen($classid)>1){
            $where=" classid='".$classid."'";
        }else{
            $where=" createtime > '".$time."'";
            if(strlen($author)>1){
                $where.=" and author like '%".$author."%' ";
            }
            if(strlen($stockcode)>1){
                $where.=" and stockcode='".$stockcode."' ";
            }
            if(strlen($title)>1){
                $where.=" and title like '%".$title."%' ";
            }
        }
        $sql="select count(*) as total from  dtstockgrade where $where";
        //file_put_contents("d://a.txt",$sql); 
        $sql=$this->_db->quoteInto($sql,'');
        $result=$this->_db->query($sql);
        $result=$result->fetchAll();
        return $result;
    }
}
Copy after login



我用这个代码生成的sql语句在数据库中是对的
可是当我的sql语句中存在like时,就没有得到数据了,可是sql语句在数据库总执行时是有数据的
急急.....
是 不是zend Framework不支持模糊查询还是我的代码写的不对????
那位大侠看哈.....

------解决方案--------------------
恭喜了,jf
------解决方案--------------------
字符集设置的原因。
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template