<p><span style="font-size: 14px;">明明txt展示的内容是832219957288977295565,导入到数据库成�8�3�2�2�1�9�9�5�7�2�8�8�9�7�7�2�9�5�5�6�5�,调试打印数字之间有空格</span></p><p><span style="font-size: 14px;">以为通过</span><span style="color: rgb(26, 32, 41); font-family: ui-monospace, SFMono-Regular, "SF Mono", Menlo, Consolas, "Liberation Mono", monospace; white-space: pre; background-color: rgb(246, 247, 249);"> </span><span class="hljs-variable" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: rgb(152, 104, 1); font-family: ui-monospace, SFMono-Regular, "SF Mono", Menlo, Consolas, "Liberation Mono", monospace; white-space: pre; background-color: rgb(246, 247, 249);">$result1</span><span style="color: rgb(26, 32, 41); font-family: ui-monospace, SFMono-Regular, "SF Mono", Menlo, Consolas, "Liberation Mono", monospace; white-space: pre; background-color: rgb(246, 247, 249);"> = </span><span class="hljs-title function_ invoke__" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: rgb(64, 120, 242); font-family: ui-monospace, SFMono-Regular, "SF Mono", Menlo, Consolas, "Liberation Mono", monospace; white-space: pre; background-color: rgb(246, 247, 249);">iconv</span><span style="color: rgb(26, 32, 41); font-family: ui-monospace, SFMono-Regular, "SF Mono", Menlo, Consolas, "Liberation Mono", monospace; white-space: pre; background-color: rgb(246, 247, 249);">(</span><span class="hljs-string" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: rgb(80, 161, 79); font-family: ui-monospace, SFMono-Regular, "SF Mono", Menlo, Consolas, "Liberation Mono", monospace; white-space: pre; background-color: rgb(246, 247, 249);">"gbk"</span><span style="color: rgb(26, 32, 41); font-family: ui-monospace, SFMono-Regular, "SF Mono", Menlo, Consolas, "Liberation Mono", monospace; white-space: pre; background-color: rgb(246, 247, 249);">, </span><span class="hljs-string" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: rgb(80, 161, 79); font-family: ui-monospace, SFMono-Regular, "SF Mono", Menlo, Consolas, "Liberation Mono", monospace; white-space: pre; background-color: rgb(246, 247, 249);">"utf-8//IGNORE"</span><span style="color: rgb(26, 32, 41); font-family: ui-monospace, SFMono-Regular, "SF Mono", Menlo, Consolas, "Liberation Mono", monospace; white-space: pre; background-color: rgb(246, 247, 249);">,</span><span class="hljs-variable" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: rgb(152, 104, 1); font-family: ui-monospace, SFMono-Regular, "SF Mono", Menlo, Consolas, "Liberation Mono", monospace; white-space: pre; background-color: rgb(246, 247, 249);">$result</span><span style="color: rgb(26, 32, 41); font-family: ui-monospace, SFMono-Regular, "SF Mono", Menlo, Consolas, "Liberation Mono", monospace; white-space: pre; background-color: rgb(246, 247, 249);">[</span><span class="hljs-number" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; color: rgb(152, 104, 1); font-family: ui-monospace, SFMono-Regular, "SF Mono", Menlo, Consolas, "Liberation Mono", monospace; white-space: pre; background-color: rgb(246, 247, 249);">1</span><span style="color: rgb(26, 32, 41); font-family: ui-monospace, SFMono-Regular, "SF Mono", Menlo, Consolas, "Liberation Mono", monospace; white-space: pre; background-color: rgb(246, 247, 249);">]);函数就可以解决,经过多次验证终于找到了解决方法</span></p><p><img src="https://www.80zx.com/uploadfile/202507/aaa96ef088e109d.png" title="e4f4ce32-91c0-4ffb-b5fe-c40db4e1396b.png" alt="e4f4ce32-91c0-4ffb-b5fe-c40db4e1396b.png"><span style="color: rgb(26, 32, 41); font-family: ui-monospace, SFMono-Regular, "SF Mono", Menlo, Consolas, "Liberation Mono", monospace; white-space: pre; background-color: rgb(246, 247, 249);"><br></span></p><p>UTF16-LE编码的问题,<font color="#404040" face="quote-cjk-patch, Inter, system-ui, -apple-system, BlinkMacSystemFont, Segoe UI, Roboto, Noto Sans, Ubuntu, Cantarell, Helvetica Neue, Oxygen, Open Sans, sans-serif"><span style="font-size: 16.002px;">具体实现代码参考如下</span></font></p><div style="background-color:#1e1f22;color:#bcbec4"><pre style="font-family:'JetBrains Mono',monospace;font-size:9.8pt;"><span style="color:#cf8e6d;"><?php<br></span><span style="color:#9876aa;">$filepath</span>=<span style="color:#6aab73;">'E:\360Downloads\123.txt'</span>;<br><span style="color:#7a7e85;">//</span><span style="color:#7a7e85;font-family:'宋体',monospace;">必须安装</span><span style="color:#7a7e85;">fileinfo</span><span style="color:#7a7e85;font-family:'宋体',monospace;">组件<br></span><span style="color:#9876aa;">$finfo </span>= <span style="color:#cf8e6d;">new </span>finfo(<span style="color:#9876aa;font-style:italic;">FILEINFO_MIME_ENCODING</span>);<span style="color:#9876aa;">$encoding </span>= <span style="color:#9876aa;">$finfo</span>-><span style="color:#57aaf7;">file</span>(<span style="color:#9876aa;">$filepath</span>);<br><br><span style="color:#cf8e6d;">echo </span><span style="color:#6aab73;">"</span><span style="color:#6aab73;font-family:'宋体',monospace;">文件编码</span><span style="color:#6aab73;">: " </span>. <span style="color:#9876aa;">$encoding</span>;<br><span style="color:#9876aa;">$handle </span>= <span style="color:#57aaf7;">fopen</span>(<span style="color:#9876aa;">$filepath</span>, <span style="color:#6aab73;">"r"</span>);<br><span style="color:#cf8e6d;">if</span>(<span style="color:#9876aa;">$encoding</span>==<span style="color:#6aab73;">"utf-16le"</span>){<br><br> <span style="color:#57aaf7;">stream_filter_append</span>(<span style="color:#9876aa;">$handle</span>, <span style="color:#6aab73;">"convert.iconv.UTF-16LE/UTF-8"</span>, <span style="color:#9876aa;font-style:italic;">STREAM_FILTER_READ</span>);<br>}<br><br><span style="color:#cf8e6d;">while </span>((<span style="color:#9876aa;">$row </span>= <span style="color:#57aaf7;">fgetcsv</span>(<span style="color:#9876aa;">$handle</span>)) !== <span style="color:#cf8e6d;">false</span>) {<br> <span style="color:#cf8e6d;">echo </span><span style="color:#9876aa;">$row</span>[<span style="color:#2aacb8;">0</span>] . <span style="color:#6aab73;">" " </span>. <span style="color:#9876aa;">$row</span>[<span style="color:#2aacb8;">1</span>] . <span style="color:#6aab73;">" " </span>. <span style="color:#9876aa;">$row</span>[<span style="color:#2aacb8;">2</span>] . <span style="color:#6aab73;">" " </span>. <span style="color:#9876aa;">$row</span>[<span style="color:#2aacb8;">3</span>] . <span style="color:#6aab73;">" " </span>. <span style="color:#9876aa;">$row</span>[<span style="color:#2aacb8;">4</span>];<br><br>}</pre></div>
相关文章
