• php读取csv乱码问题解决方法


    <form action="erxian_cy.php" method="post" enctype="multipart/form-data">
          <table class="table_con" style="100%;">
            
            <tbody>
            	<tr >
            	  <td><input type="file" name="file1" id="file1" />
                  <input name="t" type="hidden" value="11"></td>
                </tr>
                <tr>
                  <td colspan="3" align="center" style="text-align:center; padding-bottom:10px;"><input type="submit" value=" 提 交 " class="submit" /></td>
                </tr>
            
          </table>
          </form>
    
    if($_POST){
         $file1 = $_FILES["file1"]; $csv_file = fopen($file1["tmp_name"], 'r'); while(!feof($csv_file))$csv_result[] = fgetcsv_reg($csv_file); print_r($csv_result); foreach($result as $k=>$item){ } } function fgetcsv_reg(&$handle, $length = null, $d = ',', $e = '"') { $d = preg_quote($d); $e = preg_quote($e); $_line = ""; $eof=false; while ($eof != true) { $_line .= (empty ($length) ? fgets($handle) : fgets($handle, $length)); $itemcnt = preg_match_all('/' . $e . '/', $_line, $dummy); if ($itemcnt % 2 == 0) $eof = true; } $_csv_line = preg_replace('/(?: |[ ])?$/', $d, trim($_line)); $_csv_pattern = '/(' . $e . '[^' . $e . ']*(?:' . $e . $e . '[^' . $e . ']*)*' . $e . '|[^' . $d . ']*)' . $d . '/'; preg_match_all($_csv_pattern, $_csv_line, $_csv_matches); $_csv_data = $_csv_matches[1]; for ($_csv_i = 0; $_csv_i < count($_csv_data); $_csv_i++) { $_csv_data[$_csv_i] = preg_replace('/^' . $e . '(.*)' . $e . '$/s', '$1', $_csv_data[$_csv_i]); $_csv_data[$_csv_i] = str_replace($e . $e, $e, $_csv_data[$_csv_i]); } return empty ($_line) ? false : $_csv_data; }

    fgetcsv_reg 替代 fgetcsv 防止php读取csv出现乱码

    只有 type="file" 没有其他任何东西,$_POST为空

  • 相关阅读:
    JS自动化测试 单元测试之Qunit
    mybatis注解开发
    @Valid验证
    httpclient发邮件
    mysql慢查询配置(5.7)
    MySQL5.7.21解压版安装详细教程(转)
    spring注解@Import和@ImportResource
    关于properties文件的读取(Java/spring/springmvc/springboot)
    okclient2详细介绍
    @GetMapping、@PostMapping、@PutMapping、@DeleteMapping、@PatchMapping、@RequestMapping详解
  • 原文地址:https://www.cnblogs.com/microtiger/p/9680602.html
Copyright © 2020-2023  润新知