dongtan2017 2018-01-09 16:20
浏览 46
已采纳

从php表单获取.csv格式的数据

I'm using below code to get data from PHP form. Its working fine.

    <?php

$email=$_POST['email'];
$name=$_POST['name'];
$designation=$_POST['designation'];
$company=$_POST['company'];
$phone=$_POST['phone'];
$data=$name.",".$email.",".$designation.",".$company.",".$phone;

$file="file.csv";


file_put_contents($file, $data . PHP_EOL, FILE_APPEND);


?>

Whenever any user puts information in the form with separated (.) then name and email come in different cells in .csv file.

below is issue/csv image enter image description here

How it will solved?

Thanks!

</div>
  • 写回答

1条回答 默认 最新

  • duanba4254 2018-01-09 16:33
    关注

    Use PHP's fputcsv. Let it handle the particulars of CSV formatting for you!

    <?php
    
    $email       = $_POST['email'];
    $name        = $_POST['name'];
    $designation = $_POST['designation'];
    $company     = $_POST['company'];
    $phone       = $_POST['phone'];
    
    $data = [
             $name,
             $email,
             $designation,
             $company,
             $phone,
    ];
    
    $file = fopen('file.csv', 'a'); // Append data to end of file.
    
    fputcsv($file, $data);
    

    If you need a delimiter other than the default (,) put that for the third argument. Same for enclosure & escape chars (", \) as 4th and 5th args.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 在获取boss直聘的聊天的时候只能获取到前40条聊天数据
  • ¥20 关于URL获取的参数,无法执行二选一查询
  • ¥15 液位控制,当液位超过高限时常开触点59闭合,直到液位低于低限时,断开
  • ¥15 marlin编译错误,如何解决?
  • ¥15 有偿四位数,节约算法和扫描算法
  • ¥15 VUE项目怎么运行,系统打不开
  • ¥50 pointpillars等目标检测算法怎么融合注意力机制
  • ¥20 Vs code Mac系统 PHP Debug调试环境配置
  • ¥60 大一项目课,微信小程序
  • ¥15 求视频摘要youtube和ovp数据集