Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

PHP Parse CSC

Posted on 2009-04-14
14
Medium Priority
?
374 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
ID: 24139815
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
ID: 24139840
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
ID: 24139876
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 4

Expert Comment

by:phpmonkey
ID: 24139946
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
ID: 24140038
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
ID: 24140040
More info on foreach and looping arrays/data:
http://php.net/foreach
0
 
LVL 4

Expert Comment

by:phpmonkey
ID: 24140066
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
 
LVL 4

Expert Comment

by:phpmonkey
ID: 24140080
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
ID: 24140124
Error:

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

Expert Comment

by:phpmonkey
ID: 24140141
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 2000 total points
ID: 24140146
dammid,

$firstline = true;

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

Author Comment

by:vertex_paul
ID: 24140172
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
ID: 24140213
That worked!!! .. Thank you very much.. shouldnt have been that hard but I was stuck
0
 
LVL 2

Author Closing Comment

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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article discusses how to create an extensible mechanism for linked drop downs.
3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
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…
The viewer will learn how to dynamically set the form action using jQuery.
Suggested Courses

886 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