Filter 2 columns at the same time in a table

rlclynn 

https://e.anyoupin.cn/EData/1241.html

//select * from filter_multi_columns;
xli_add_php~～
if(!empty($_POST["tbl"])){
//print_r($_POST);
$tblrowid=implode(',',$_POST["tbl"]);
echo $tblrowid;
$sql=<<<eof
select * from filter_multi_columns where (instr("$tblrowid",f04)>0 and f04 not like "") or (instr("$tblrowid",f05)>0 and f05 not like "");
eof;

//echo($sql);
\multiquery\multiquery_run($sql);

}
?>
<form action="" method=post>
～;
select * from (
select f04,'<input type=checkbox name="tbl[]" value='||f04||'>' options from filter_multi_columns group by f04 union 
select f05,'<input type=checkbox name="tbl[]" value='||f05||'>' 选择 from filter_multi_columns group by f05) where f04 not like '';
;

xli_add_php~～
?>
<button>submit</button>
</form>
～;

rlclynn 

Unpivot both columns.