douliedai4838 2016-03-18 08:33
浏览 27
已采纳

通过PHP从CSV获取数据

I am having one csv file with three columns and Name , month and expanses. The file name is : name.csv. The file format is like this.

NAME    MONTH   EXPANSES
JHON    JAN     200
GATES   JAN     150
JHON    MAR     150
BILL    APP     100

Whereas I am having one php file: name.php which will fetch the required data from the csv file and the sours code is:

<?php
$x="JHON"; // to be checked in the first column
  $handle = fopen("name.csv","r")or die("file dont exist");
  $output = '';
   while (!feof($handle )){
    $data = fgetcsv($handle,4096,",");
        if(($data[0] ==$x)){
           $output .= sprintf( "Month: %s     Expanses: %d)<br>", 
           $data[1], $data[2]);
        }
    }
echo $output;
fclose($handle);
?>

I want to sort out where the name is “JHON”, with the above code and the result is as following.

Month:  JAN            Expanses:  200 
Month:  MAR           Expanses:  150 
Month:  AUG           Expanses:  250

But what I want is heading like: Expanses of JHON and at bottom, total expenses: amount

MONTH WISE EXPANSES OF JHON 
Month:  JAN            Expanses:  200 
Month:  MAR           Expanses:  150 
Month:  AUG           Expanses:  250

TOTAL EXPANCES:   600

Can anybody help me in correcting the php code please?

  • 写回答

2条回答 默认 最新

  • doushao8399 2016-03-18 08:53
    关注

    Actually you already exctract data from your CSV. As far I understand it you only want to add a header at the top and a sum at the bottom.

    Why not just do something like this?

    <?php
        $x="JHON"; // to be checked in the first column
        $handle = fopen("name.csv","r") or die("file doesn't exist");
        $output = '';
        $total = 0;
    
        while (!feof($handle )){
            $data = fgetcsv($handle, 4096, ",");
            if(($data[0] == $x)){
                $output .= sprintf( "Month: %s     Expenses: %d)<br>", $data[1], $data[2]);
    
                $total += $data[2];
            }
        }
    
        fclose($handle);
    
        echo "MONTHLY EXPENSES OF " . $x . "<br/><br/>";
        echo $output . "<br/><br/>";
        echo "TOTAL EXPENSES:   " . $total;
    ?>
    

    Remark 2: It's "expense", "expance" is not a word

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 arduino控制ps2手柄一直报错
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 求chat4.0解答一道线性规划题,用lingo编程运行,第一问要求写出数学模型和lingo语言编程模型,第二问第三问解答就行,我的ddl要到了谁来求了
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上