Solved

PHP Parse CSC

Posted on 2009-04-14
14
362 Views
Last Modified: 2013-12-12
I am trying to upload a .csv file and then parse it out.. I have the file uploading with no problem and can read the file using fgetcsv just fine.. However, I am stuck on how to parse the arrays. I have tried multiple options but I guess just do not understand what I am trying to do.. I have posted some of the array below but I would like to do is get each set of data separated so I can loop through them individually.. any help is greatly appreciated.
Array ( [0] => TELEPHONE_NUMBER [1] => BTN [2] => OCN [3] => DCR [4] => PDCR [5] => COMPLETION_DATE [6] => LN [7] => ORDER_NUMBER [8] => APPLICATION_DATE [9] => PON [10] => CIRCUIT_ID [11] => CLASS_SERVICE ) Array ( [0] => 999-999-9999 [1] => 0 [2] => 1111 [3] => AS [4] => [5] => Apr 9, 2009 [6] => (NON-PUB) SMITH, JOHN [7] => D1DJD7J6 [8] => Apr 6, 2009 [9] => [10] => [11] => 1F1CL ) Array ( [0] => 999-999-9999 [1] => 0 [2] => 1111 [3] => AS [4] => [5] => Apr 9, 2009 [6] => DOE, JOHN [7] => D1FC3291 [8] => Apr 9, 2009 [9] => 2.09E+13 [10] => [11] => 1F3CL ) Array ( [0] => 9999-999-9999 [1] => 0 [2] => 1111 [3] => AS [4] => [5] => Apr 9, 2009 [6] => JONES, JOE [7] => D60W11Y2 [8] => Apr 8, 2009 [9] => 0408JOO [10] => [11] => 1FR )

Open in new window

0
Comment
Question by:vertex_paul
  • 8
  • 6
14 Comments
 
LVL 4

Expert Comment

by:phpmonkey
Comment Utility
If you parse your array like this, you can access your recorords like this:
var_dump($arrData[0]);

for the first record for example.
the first array is numeric so you have to access it like $arrData[0]
the array in it now is associative, so you can use the keys. $arrData[0]['TELEPHONE_NUMBER']
there are a bunch of array functions explained on the php site, take a look at this: http://be.php.net/manual/en/function.array.php
$firstline = true;

$arrData = array();

while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
 

   if($firstline){
 

     $keys = $data;

     $firstline= false;

     continue;
 

  }// end if
 

  $arrData =  array_combine($keys,$data);
 
 

}// end while
 

echo "<pre>";

var_dump($arrData[0]['TELEPHONE_NUMBER']); // string ("999-999-9999")

echo "</pre>";

Open in new window

0
 
LVL 4

Expert Comment

by:phpmonkey
Comment Utility
oops one little error i see...

change
$arrData =  array_combine($keys,$data);

into
$arrData[] =  array_combine($keys,$data);

sorry
0
 
LVL 2

Author Comment

by:vertex_paul
Comment Utility
Thanks for the quick response.. I understand what you are saying.. how now would I look through each array and pull out that ones information and go to the next one?
0
 
LVL 4

Expert Comment

by:phpmonkey
Comment Utility
You can do it with a foreach loop like this.
While foreaching you can offcourse do all kinds of logic with it or echo a table in between.
echo "<pre>";

foreach($arrData as $data){
 

    var_dump($data);
 

}// end foreach

echo "</pre>";

Open in new window

0
 
LVL 2

Author Comment

by:vertex_paul
Comment Utility
ok.. maybe I am not following you as well I as I thought.. below is my code
$file = fopen($target_path,"r");

while(! feof($file))

  {

  //print_r(fgetcsv($file));

  $data [] = fgetcsv($file);

  }

  

$firstline = true;

$arrData = array();

while (($data = fgetcsv($file, 1000, ",")) !== FALSE) {

 

   if($firstline){

 

     $keys = $data;

     $firstline= false;

     continue;

 

  }// end if

 

  $arrData =  array_combine($keys,$data);

  
 

    echo "<pre>";

foreach($arrData as $data1){

 

    var_dump($data1);

 

}// end foreach

echo "</pre>";

 

}// end while

 

 

  

fclose($file);

Open in new window

0
 
LVL 4

Expert Comment

by:phpmonkey
Comment Utility
More info on foreach and looping arrays/data:
http://php.net/foreach
0
 
LVL 4

Expert Comment

by:phpmonkey
Comment Utility
Hehe noooo ;)
put the foreach outside the while.
In the while loop we build up the array, then afterwards you can parse it easely in a foreach.
$file = fopen($target_path,"r");

while(! feof($file))

  {

  //print_r(fgetcsv($file));

  $data = fgetcsv($file);

 

   if($firstline){

 

     $keys = $data;

     $firstline= false;

     continue;

 

  }// end if

 

  $arrData[] =  array_combine($keys,$data);

  

 

}// end while

  

fclose($file);
 
 

echo "<pre>";

foreach($arrData as $data1){

 

    var_dump($data1);

 

}// end foreach

echo "</pre>";

 

}// end while

Open in new window

0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
LVL 4

Expert Comment

by:phpmonkey
Comment Utility
Ignore my last comment, it was some copy paste mess-up from the textbox.
This should be better:
$file = fopen($target_path,"r");

while(! feof($file))

  {

  $data = fgetcsv($file);

 

   if($firstline){

 

     $keys = $data;

     $firstline= false;

     continue;

 

  }// end if

 

  $arrData[] =  array_combine($keys,$data);

  

 

}// end while
 

fclose($file);
 

echo "<pre>";

foreach($arrData as $data1){

 

    var_dump($data1);

 

}// end foreach

echo "</pre>";

Open in new window

0
 
LVL 2

Author Comment

by:vertex_paul
Comment Utility
Error:

Warning: array_combine() expects parameter 1 to be array, null given
0
 
LVL 4

Expert Comment

by:phpmonkey
Comment Utility
put

$firstline = false;

on top of the script.
$firstline = false;

$file = fopen($target_path,"r");

while(! feof($file))

//...

Open in new window

0
 
LVL 4

Accepted Solution

by:
phpmonkey earned 500 total points
Comment Utility
dammid,

$firstline = true;

Sorry, its with beeing fast...
0
 
LVL 2

Author Comment

by:vertex_paul
Comment Utility
Still same error.. pardon my ignorance but if the firstline if is not met then would $keys value not have to be set somewhere?
0
 
LVL 2

Author Comment

by:vertex_paul
Comment Utility
That worked!!! .. Thank you very much.. shouldnt have been that hard but I was stuck
0
 
LVL 2

Author Closing Comment

by:vertex_paul
Comment Utility
That worked!!! .. Thank you very much.. shouldnt have been that hard but I was stuck
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Consider the following scenario: You are working on a website and make something great - something that lets the server work with information submitted by your users. This could be anything, from a simple guestbook to a e-Money solution. But what…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now