PHP方法字符串拼接转化mysql进行数据查询

绝地灬酷狼 2022-06-13 06:50 34阅读 0赞

定义方法部分：

//定义数组  
    private $_getjoinstr = array();  
      
    /** 
        字段中包含 
    */  
    public function dbinstr($fiekd, $str, $spl1=',', $spl2=',')  
    {  
        return "instr(concat('$spl1', $fiekd, '$spl2'), '".$spl1.$str.$spl2."')>0";  
    }  
      
    //字符串拼接转化mysql方法  
    public function getjoinstr($fids, $us, $lx=0, $slx=0)  
    {  
        $s      = '';  
        //判断是否是数字  
        if(is_numeric($us)){  
            $key= 'a'.$fids.''.$us.'_'.$lx.'';  
            if(isset($this->_getjoinstr[$key]))return $this->_getjoinstr[$key];  
            //admin表中查询id、name、deptid、deptath  
            $us = $this->getone($us,'id,`name`,`deptid`,`deptpath`');  
        }  
        //如果没有数据，返回空  
        if(!$us)return '';  
        //有数据执行查询  
        $uid    = $us['id'];  
        $key    = 'a'.$fids.''.$uid.'_'.$lx.'';  
        if(isset($this->_getjoinstr[$key]))return $this->_getjoinstr[$key];  
        //判断是否为空 为空也执行查询   
        if($slx==0)$tj[]    = "ifnull($fids,'')=''";  
        //判断是否包含 all  
        $tj[]   = $this->dbinstr($fids, 'all');  
        //判断包含的u开头的人员信息  
        $tj[]   = $this->dbinstr($fids, 'u'.$uid);  
        //根据当前用户信息去查询当前用户所在组  
        if($us){  
            $dep = explode(',', $us['deptpath']);  
            foreach($dep as $deps){  
                $_deps  = str_replace(array('[',']'), array('',''), $deps);  
                $tj[]   = $this->dbinstr($fids, 'd'.$_deps);  
            }  
        }  
        //用or链接  
        $s  = join(' or ', $tj);  
        $this->_getjoinstr[$key] = $s;  
        return $s;  
    }

![20170630113948163][]

调用部分：

$uid='1';//当前传入用户的ID  
    $where_userid = m('admin')->getjoinstr('userid', $uid);  
    if($where_userid) $s.= $where_userid;  
    //获取所有的步骤  
    $rows = $this->db->getall("SELECT * FROM [Q]flow_course WHERE " .$s. " ORDER BY sort,id ASC");

![20170630154441628][]

![20170630114101017][]

数据库表中字段存储：

![20170630114243010][]

[20170630113948163]: /images/20220613/db3b0cecc74143dd916d99222daa9122.png
[20170630154441628]: /images/20220613/9dcffaa022434b91ab5eb4e83af9027c.png
[20170630114101017]: /images/20220613/2093b050b05342a8be95284e3278aa54.png
[20170630114243010]: /images/20220613/75d929f1af9e4926829e8b2d24b748ab.png