{"id":219,"date":"2016-04-20T15:25:10","date_gmt":"2016-04-20T07:25:10","guid":{"rendered":"http:\/\/blog.inforere.com\/?p=219"},"modified":"2017-06-29T18:21:19","modified_gmt":"2017-06-29T10:21:19","slug":"%e4%ba%8c%e8%bf%9b%e5%88%b6%e5%ad%97%e8%8a%82%e8%a1%a8%e7%a4%ba%e9%95%bf%e5%ba%a6%e7%9a%84%e8%bd%ac%e6%8d%a2","status":"publish","type":"post","link":"https:\/\/blog.inforere.com\/?p=219","title":{"rendered":"\u4e8c\u8fdb\u5236\u5b57\u8282\u8868\u793a\u957f\u5ea6\u7684\u8f6c\u6362"},"content":{"rendered":"<p>\u5728\u5904\u7406mysql\u534f\u8bae\u65f6\u6216\u4e00\u4e9b\u4e8c\u8fdb\u5236\u6d41(pack\u751f\u6210)\uff0c\u7ecf\u5e38\u7528\u4e001,N\u4e2a\u5b57\u5b57\u6765\u8868\u793a\u957f\u5ea6\uff0c\u9700\u505a\u5982\u4e0b\u8f6c\u5316<\/p>\n<pre class=\"lang:php decode:true\">\/\/ test one\r\n$length = substr($data, 0, 1);\r\n$length = bin2hex($length);\r\n$length = hexdec($length);\r\n\r\n\/\/ test two\r\n$len = 192;\r\n$byte = pack(\"C\", $len);\r\n$len = bin2hex($byte);\r\n$len = hexdec($len);\r\n\r\necho \"length:\" . $len .\"\\n\";<\/pre>\n<p>\u53c2\u8003\uff1ahttp:\/\/blog.csdn.net\/wind520\/article\/details\/43964821<\/p>\n<p>mysql client\u9a8c\u8bc1\u62a5\u6587\u89e3\u6790<\/p>\n<pre class=\"lang:default decode:true \"> \r\n            \/\/ \u5305\u957f\r\n            $length = substr($data, 0, 1);\r\n            $length = bin2hex($length);\r\n            $length = hexdec($length);\r\n            echo $length . \"\\n\";\r\n\r\n            \/\/ \u767b\u5f55\u7528\u6237\u540d\r\n            $body = substr($data, 36);\r\n            $userName = $this-&gt;getChars($body);\r\n            $i = strlen($userName) + 1;\r\n            echo $userName . \"\\n\";\r\n\r\n            \/\/ \u6570\u636e\u5e93\u540d[\u53ef\u9009]\r\n            $lengthByte = substr($body, $i, 1);\r\n            $len = bin2hex($lengthByte);\r\n            $len = hexdec($len);\r\n            echo $len . \"\\n\";\r\n            if($len &lt;= 250){\r\n                $i = $i + $len + 1;\r\n                $dbName = $this-&gt;getChars($body, $i);\r\n                echo $dbName . \"\\n\";\r\n            }\r\n\r\n\r\n    protected function getChars($data, $start = 0){\r\n        $i = $start; $length = strlen($data);\r\n        while($i &lt; $length){\r\n            $char = substr($data, $i, 1);\r\n            if(ord($char) === 0){\r\n                return substr($data, $start, $i - $start);\r\n            }\r\n            $i++;\r\n        }\r\n        return $data;\r\n    }<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728\u5904\u7406mysql\u534f\u8bae\u65f6\u6216\u4e00\u4e9b\u4e8c\u8fdb\u5236\u6d41(pack\u751f\u6210)\uff0c\u7ecf\u5e38\u7528\u4e001,N\u4e2a\u5b57\u5b57\u6765\u8868\u793a\u957f\u5ea6\uff0c\u9700\u505a\u5982\u4e0b\u8f6c\u5316 \/\/ te [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,41],"tags":[30],"_links":{"self":[{"href":"https:\/\/blog.inforere.com\/index.php?rest_route=\/wp\/v2\/posts\/219"}],"collection":[{"href":"https:\/\/blog.inforere.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.inforere.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.inforere.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.inforere.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=219"}],"version-history":[{"count":11,"href":"https:\/\/blog.inforere.com\/index.php?rest_route=\/wp\/v2\/posts\/219\/revisions"}],"predecessor-version":[{"id":232,"href":"https:\/\/blog.inforere.com\/index.php?rest_route=\/wp\/v2\/posts\/219\/revisions\/232"}],"wp:attachment":[{"href":"https:\/\/blog.inforere.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=219"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.inforere.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=219"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.inforere.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}