丢个PHP+MySQL的数据读取函数出来因为换JS+Mongo

丢个PHP+MySQL的数据读取函数出来因为换JS+MongoDB，这玩意用不到了，丢出来留个纪念。核心部分主要还是最后那句： em 24 foreach array $b?array intersect $b,array merge USER 'b' ?:array , $u&&$u== USER 'u' ?array 0,1,2,3,4,5,6,7 :array 0 :array 0 , !$u&& USER 'u' ?array diff array intersect $b,array 5,6,7 , USER 'b' ?:array :array as $ a=>$ {foreach $ as $ b {$sql ='SELECT FROM w:'. $v?'v':'' . $u||$ a?'u':'' .' FORCE INDEX '. $u||$ a ?'u ':'' . $v?'v ':'' .'b '. $c?'c ':'d ' .' WHERE '. $u||$ a ?' u ='. $u|| USER 'u' .' AND':'' .' '. $v?' v ='.$v.' AND':'' .' b ='.$ b.' '. $c||$d ?'AND '. $c?' c ':' d ' . $asc?'>':'<' . $w?'':'=' . $c?:$d .' '. $w?'OR '. $c?' c ='.$c:' d ='.$d .' AND w '. $asc?'>':'<' .$w.' ':'' .' ' :'' .' ORDER BY '. $asc? $c?' c ':' d ' .' ASC, ASC': $c?' c ':' d ' .' DESC, DESC' .' LIMIT '.$qty;}} 完整函数： function W LST $a { $ SQL= INIT ; $v= SAFE 'i',$a 'v' ; $u= SAFE 'i',$a 'u' ; if !$v&&!$u {return array ;}; $b= SAFE 'k',$a 'b' ; //前端直接传入EXT后的B（JS计算扩展） $d= SAFE 'i',$a 'd' ; $c= SAFE 'i',$a 'c' ; $w= SAFE 'i',$a 'w' ; $f= SAFE 'f',$a 'f' ; $qty=strtok $f,'.' ; if !$qty {$qty= W QTY;} elseif $qty> W MAX {$qty= W MAX;} $asc=strtok '.' ; $sql=array ; //读取某话题，即便没有权限，也要将用户自己发的内容也读取出来，所以用$u||$ a。 foreach array $b?array intersect $b,array merge USER 'b' ?:array , $u&&$u== USER 'u' ?array 0,1,2,3,4,5,6,7 :array 0 :array 0 , !$u&& USER 'u' ?array diff array intersect $b,array 5,6,7 , USER 'b' ?:array :array as $ a=>$ { foreach $ as $ b {$sql ='SELECT FROM w:'. $v?'v':'' . $u||$ a?'u':'' .' FORCE INDEX '. $u||$ a ?'u ':'' . $v?'v ':'' .'b '. $c?'c ':'d ' .' WHERE '. $u||$ a ?' u ='. $u|| USER 'u' .' AND':'' .' '. $v?' v ='.$v.' AND':'' .' b ='.$ b.' '. $c||$d ?'AND '. $c?' c ':' d ' . $asc?'>':'<' . $w?'':'=' . $c?:$d .' '. $w?'OR '. $c?' c ='.$c:' d ='.$d .' AND w '. $asc?'>':'<' .$w.' ':'' .' ' :'' .' ORDER BY '. $asc? $c?' c ':' d ' .' ASC, ASC': $c?' c ':' d ' .' DESC, DESC' .' LIMIT '.$qty;} }

丢个PHP+MySQL的数据读取函数出来 因为换JS+Mongo - Assbbs

丢个PHP+MySQL的数据读取函数出来因为换JS+Mongo - Assbbs