douxi3432 2015-06-28 00:28
浏览 62
已采纳

Php,undo mysql_real_escape_string

I really have the reason to reserve this function. I used to saved BINARY content to file, which was run by this function, so the content is something like

WA\0,\0\0\0\0\0\0„Cźw\\\0\0\0\0\0\0\0\0\0\0\0Q\0\0\0

so somehow I must reverse this function. I tried the stripslashes() function, now it looks better:

WA ,      „Cźw\           Q   

still corrupt. I even tried this one:

$search = array( "\0", "
", "", "\\", "\'", "\\", "\Z" );
$replace = array( "\x00", "
", "", "\"", "'", "\", \x1a" );
$a = str_replace($search, $replace, $a);

still no joy. How to restore the original binary data?

  • 写回答

1条回答 默认 最新

  • douwen1549 2015-06-28 01:29
    关注

    The trick is in properly escaping the sequences you want to replace. The following function should work.

    function un_mysql_real_escape_string( $data ) {
        return str_replace(
            array( '\0'  , '
    ', '', '\Z'  , '\"', '\\\'', '\\\\' ),
            array( "\x00", "
    ", "", "\x1a", '"' , '\''  , '\\'   ),
            $data
        );
    }
    

    Unit test for my unescape function.

    $data = '';
    foreach ( range(0, 255) as $dec ) {
        $data .= chr( $dec );
    }
    
    $data_escaped = mysql_real_escape_string( $data );
    var_dump( un_mysql_real_escape_string( $data_escaped ) === $data );
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 python使用pulp线性优化时报错
  • ¥15 开源或低价数据中台哪个最好
  • ¥15 arduino编程出现字符串疑似覆盖现象
  • ¥15 我的b站在没有碰到屏幕的情况下偶尔会自动跳出进度条,就像在屏幕上点了一下一样,但我并没有点。而且视频进度并没有变。这可能是什么原因造成的?
  • ¥30 STK matlab python仿真
  • ¥15 关于IMageEnView 图标定位问题
  • ¥20 求解答(matlab)
  • ¥30 ffmpeg库使用过程中遇到的问题
  • ¥15 pyqt5 中python如何通过Qtwebchannel主动发消息给web前端
  • ¥15 关于HTML中title获取xml内容的问题