Test read only
Example #1 Code:
$file = fopen('samplefile.csv', 'r');
print_r(fgetcsv($file));
fclose($file);
Output:
Array
(
[0] => ACCTID
[1] => ACCTDESC
[2] => ACCTFMTTD
)
Example #2 Code:
$file = fopen('export.csv','r');
while(! feof($file))
{
print_r(fgetcsv($file));
}
fclose($file);
Output:
Array
(
[0] => ACCTID
[1] => ACCTDESC
[2] => ACCTFMTTD
)
Array
(
[0] => 1000
[1] => General Bank (Chequing)
[2] => 1000
)
Array
(
[0] => 1010
[1] => General Bank (Savings)
[2] => 1010
)
Array
(
[0] => 3600
[1] => Retained Earnings
[2] => 3600
)
Array
(
[0] => 40001000
[1] => Revenue, General
[2] => 4000-1000
)
Array
(
[0] => 60001000
[1] => Office Hydro, General
[2] => 6000-1000
)
Array
(
[0] => 61001000
[1] => Phone Expense, General
[2] => 6100-1000
)
Array
(
[0] => 62001000
[1] => Internet Expense, General
[2] => 6200-1000
)
Example #3 Code:
$file = fopen('export.csv','r');
$i = 0;
while (($getData = fgetcsv($file, 10000, ",")) !== FALSE)
{
echo "
\n";
echo "\n";
echo $i++;
echo " | \n";
echo "\n";
echo $getData[2];
echo " | \n";
echo "\n";
echo $getData[1];
echo " | \n";
echo "
\n";
}
fclose($file);
Output:
row # |
Column1 |
Column2 |
0 |
ACCTFMTTD |
ACCTDESC |
1 |
1000 |
General Bank (Chequing) |
2 |
1010 |
General Bank (Savings) |
3 |
3600 |
Retained Earnings |
4 |
4000-1000 |
Revenue, General |
5 |
6000-1000 |
Office Hydro, General |
6 |
6100-1000 |
Phone Expense, General |
7 |
6200-1000 |
Internet Expense, General |