我如何排序，并从PHP csv文件组织数据 [英] how do I Sort and organize data from csv file in php

问题描述

我有一个csv文件与我的机动车保有量，我想知道如何进行排序我有多久有它的库存。

这是我想什么输出 -

30辆车0-30日龄

25辆31-60日龄

10辆60-90日龄

2车90天以上老人

我有一个变量名为$ numberDays它计算的日子里我有车，给了我一个整数，如30或不管它是什么。

下面是我 -
$ CSV是数组

 的foreach（$ CSV为$车）{//计算库存天
$ todaydate =日期（M / D / Y）;
$ DIS = $车[21]; //日期放养
$ startTimeStamp =的strtotime（$ todaydate）;
$ endTimeStamp =的strtotime（$ DIS）;
$ timeDiff测量= ABS（$ endTimeStamp  -  $ startTimeStamp）;
$ numberDays = $ timeDiff测量/ 86400;
$ numberDays = INTVAL（$ numberDays）;}
 

解决方案

  $ howlong =阵列（0-30days=大于0，31-60days=＆GT; 0 61-90days=大于0，91 +天数= 0）;
的foreach（$ CSV为$车）{
  ...
  $ numberDays = INTVAL（$ numberDays）;在code //最后一行
  如果（$ numberDays＆LT; = 30）$ howlong [0-30days] ++;
  ELSEIF（$ numberDays＆LT; = 60）$ howlong [31-60days] ++;
  ELSEIF（$ numberDays＆LT; = 90）$ howlong [61-90days] ++;
  ELSEIF（$ numberDays大于90）$ howlong [91 +天] ++;
}回声$ howlong [0-30days]汽车0-30天。;
回声$ howlong [31-60days]汽车31-60天。;
//等等
 

I have a csv file with my vehicle inventory, I would like to know how to sort that inventory by how long I have had it.

This is what I would like to output -

30 cars 0-30 days old

25 cars 31-60 days old

10 cars 60-90 days old

2 cars 90+ days old

I have a variable called $numberDays which calculates the days I have had the car and gives me an integer like "30" or whatever it is..

Here is what I have - $csv is the array

foreach($csv as $car){

//Calculate days in stock
$todaydate = date("m/d/Y");
$dis = $car[21]; //date stocked in
$startTimeStamp = strtotime($todaydate);
$endTimeStamp = strtotime($dis);
$timeDiff = abs($endTimeStamp - $startTimeStamp);
$numberDays = $timeDiff/86400; 
$numberDays = intval($numberDays);

}

解决方案

$howlong = array("0-30days"=>0, "31-60days"=>0, "61-90days"=>0, "91+days"=>0);
foreach($csv as $car){
  ...
  $numberDays = intval($numberDays); //last line in your code
  if($numberDays<=30) $howlong["0-30days"]++;
  elseif($numberDays<=60) $howlong["31-60days"]++;
  elseif($numberDays<=90) $howlong["61-90days"]++;
  elseif($numberDays>90) $howlong["91+days"]++;
}

echo $howlong["0-30days"]." cars 0-30 days old";
echo $howlong["31-60days"]." cars 31-60 days old";
//etc

这篇关于我如何排序，并从PHP csv文件组织数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！