Output all multidimension array, array data from CSV - PHP

Question

I have a CSV file which the code below uses to put the contents of the CSV into a multidimensional array.

<?php

$val = $_GET['articleid'];
//URL Pass STring

$arrCSV = array();
// Open the CSV
if (($handle = fopen("../articles/artlist.csv", "r")) !==FALSE) {                         
// Set the parent array key to 0
$key = 0;
// While there is data available loop through unlimited times (0) using separator (,)
while (($data = fgetcsv($handle, 0, ",")) !==FALSE) {
   // Count the total keys in each row
   $c = count($data);
   //Populate the array
   for ($x=0;$x<$c;$x++) {
   $arrCSV[$key][$x] = $data[$x];
   }
   $key++;
} // end while
// Close the CSV file
fclose($handle);
} // end if

?>

My first part is to output the entire array.

I think this code below is wrong :(

  <?php       
        for ( $row = 1; $row <$arrCSV; $row++ )
            {
        echo ''.$arrCSV[$row]['6'].'';  
            }
    ?>

Then I would like it ONLY to output one of the columns [*] [6].

I think I should get here fist before I try the rest.

Any guidance would help.

I am trying to learn, so far I have got this far.

Thank you

Ok. I need this part.. <?php print_r($arrCSV); ?>

Arthor
– Arthor

2012-01-25 22:15:12 +00:00
Commented Jan 25, 2012 at 22:15 — Arthor
– Arthor, Commented Jan 25, 2012 at 22:15
Hello, Can anyone help with the code please.

Arthor
– Arthor

2012-01-25 23:21:43 +00:00
Commented Jan 25, 2012 at 23:21 — Arthor
– Arthor, Commented Jan 25, 2012 at 23:21

James · Accepted Answer · 2012-01-25 23:21:08Z

1

Does this not work?:

<?php
$val = $_GET['articleid'];
//URL Pass STring

$arrCSV = array();
// Open the CSV
if (($handle = fopen("../articles/artlist.csv", "r")) !==FALSE) {                         

// While there is data available loop through unlimited times (0) using separator (,)
while (($data = fgetcsv($handle, 0, ",")) !==FALSE) {
   $arrCSV[] = $data;
} // end while
// Close the CSV file
fclose($handle);
} // end if

?>

answered Jan 25, 2012 at 23:21

James

22.4k5 gold badges29 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Arthor Over a year ago

This works.. <?php print_r($arrCSV); ?> How can I only out put ONE of the columns.

Arthor Over a year ago

Ok, this works. I have changed my code above. Now I need to know how to show ONLY the results based on a column content. e.g. show all the rows id column 6 has RED,

Kartik · Accepted Answer · 2012-01-26 01:28:44Z

1

I use this function to convert CSV into an array

function csv2array($string, $separatorChar = ',', $enclosureChar = '"', $newlineChar = "\n") 
{
    $array = array();
    $size = strlen($string);
    $columnIndex = 0;
    $rowIndex = 0;
    $fieldValue = "";
    $isEnclosured = False;

    for($i=0; $i<$size;$i++) 
    {
        $char = $string{$i};
        $addChar = "";

        if($isEnclosured) 
        {
            if($char == $enclosureChar) 
            {
                if($i+1<$size && $string{$i+1} == $enclosureChar)
                {
                    $addChar = $char;
                    $i++; 
                }
                else
                {
                    $isEnclosured = false;
                }
            }
            else 
            {
                $addChar=$char;
            }
        }
        else 
        {
            if($char==$enclosureChar) 
            {
                $isEnclosured = true;
            }
            else 
            {
                if($char==$separatorChar) 
                {
                    $array[$rowIndex][$columnIndex] = $fieldValue;
                    $fieldValue = "";
                    $columnIndex++;
                }
                elseif($char==$newlineChar) 
                {
                    $array[$rowIndex][$columnIndex] = $fieldValue;
                    $fieldValue="";
                    $columnIndex=0;
                    $rowIndex++;
                }
                else 
                {
                    $addChar=$char;
                }
            }
        }

        if($addChar != "")
        {
            $fieldValue.=$addChar;
        }
    }

    if($fieldValue) 
    {
        $array[$rowIndex][$columnIndex] = $fieldValue;
    }

    return $array;
}

You can simply use it like this:

<?php

$handle = fopen("../articles/artlist.csv", "r");
$arr = csv2array($handle);

print_r($arr);

?>

answered Jan 26, 2012 at 1:28

Kartik

9,9319 gold badges50 silver badges52 bronze badges

2 Comments

Arthor Over a year ago

The code I have works, I just need to this part working now. ' $searchchar="cat"; for ( $row = 1; $row <sizeof($arrCSV); $row++ ) { { echo ''.$arrCSV[$row]['6'].''; } } ?>'

Arthor Over a year ago

I can make it show on column, but I only want to show the rows based on another columns vale. e.g. RED. There are 23 RED's contained in on column, this it should who 23 line.

Arthor · Accepted Answer · 2012-01-26 10:38:11Z

This is the solution

To access you CSV:

 <?php

$val = $_GET['articleid'];
//URL Pass STring

$arrCSV = array();
// Open the CSV
if (($handle = fopen("../articles/artlist.csv", "r")) !==FALSE) {                         
// Set the parent array key to 0
$key = 0;
// While there is data available loop through unlimited times (0) using separator (,)
while (($data = fgetcsv($handle, 0, ",")) !==FALSE) {
   // Count the total keys in each row
   $c = count($data);
   //Populate the array
   for ($x=0;$x<$c;$x++) {
   $arrCSV[$key][$x] = $data[$x];
   }
   $key++;
} // end while
// Close the CSV file
fclose($handle);
} // end if

?>

To display on entire column in the CSV:

 <?php       
        for ( $row = 1; $row <$arrCSV; $row++ )
            {
        echo ''.$arrCSV[$row]['6'].'';  
            }
    ?>

Collectives™ on Stack Overflow

Output all multidimension array, array data from CSV - PHP

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related