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

定义方法部分：

//定义数组  
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;  
}  

调用部分：

$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"); 

数据库表中字段存储：