donglu9445 2014-05-07 16:42
浏览 31
已采纳

PHP fgetcsv仅显示特定列

I'm using the code below (from a previous post) to pull from an csv file but I'd like to just display specific columns. I've already tried to modify using other solutions with no avail. Any help would be much appriciated.

<?php 
function jj_readcsv($filename, $header=false) {
$handle = fopen($filename, "r");
echo '<table width="400" border="1" bordercolor="#666666" cellspacing="0" cellpadding="2">';
//display header row if true
if ($header) {
    $csvcontents = fgetcsv($handle);
    echo '<tr>';
    foreach ($csvcontents as $headercolumn) {
    echo "<th>$headercolumn</th>";
}
echo '</tr>';
}
// displaying contents
while ($csvcontents = fgetcsv($handle)) {
    echo '<tr>';
    foreach ($csvcontents as $column) {
       echo "<td>$column</td>";
    }
    echo '</tr>';
}
echo '</table>';
fclose($handle);
}
?>

HEADER1 | HEADER2 | HEADER3
COLUMN1 | COLUMN2 | COLUMN3
COLUMN1 | COLUMN3 | COLUMN3

Summary: I just want to display 1&2

  • 写回答

1条回答 默认 最新

  • dtef9322 2014-05-07 16:57
    关注

    Assuming you dont want to display the second column, iterate through the numerically indexed array and exclude the ones you want, something like:

      <?php 
      function jj_readcsv($filename, $header=false) {
      $handle = fopen($filename, "r");
      echo '<table width="400" border="1" bordercolor="#666666" cellspacing="0" cellpadding="2">';
      //display header row if true
     if ($header) {
      $csvcontents = fgetcsv($handle);
      echo '<tr>';
      foreach ($csvcontents as $k => $v) {
        if ($k != 1) {
            echo "<th>$vth>";
        }
    }
    echo '</tr>';
    }
    // displaying contents
    while ($csvcontents = fgetcsv($handle)) {
    echo '<tr>';
    foreach ($csvcontents as $k => $v) {
       if ($k != 1) {
            echo "<td>$v</td>";
        }
    }
    echo '</tr>';
    }
    echo '</table>';
    fclose($handle);
    }
    ?>
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 #MATLAB仿真#车辆换道路径规划
  • ¥15 java 操作 elasticsearch 8.1 实现 索引的重建
  • ¥15 数据可视化Python
  • ¥15 要给毕业设计添加扫码登录的功能!!有偿
  • ¥15 kafka 分区副本增加会导致消息丢失或者不可用吗?
  • ¥15 微信公众号自制会员卡没有收款渠道啊
  • ¥100 Jenkins自动化部署—悬赏100元
  • ¥15 关于#python#的问题:求帮写python代码
  • ¥20 MATLAB画图图形出现上下震荡的线条
  • ¥15 关于#windows#的问题:怎么用WIN 11系统的电脑 克隆WIN NT3.51-4.0系统的硬盘