[iStorePro]

I have csv files but i want to parse and get the data in table or array and use them in others way
Like open links with that data

[Digital]

PHP Code


<?php 
$file = 'sample.csv';
$file_handle = fopen($csvFile, 'r');
    while (!feof($file_handle) ) {
        $line_of_text[] = fgetcsv($file_handle, 1024);
    }
    fclose($file_handle);
    echo json_encode($line_of_text); 


[Onireves]

Learning to use Search Engines bro
https://stackoverflow.com/questions/9139...-using-php

[iStorePro]

PHP Code


<?php 
 $file = 'sample.csv';
$file_handle = fopen($csvFile, 'r');
    while (!feof($file_handle) ) {
        $line_of_text[] = fgetcsv($file_handle, 1024);
    }
    fclose($file_handle);
    echo json_encode($line_of_text); 


Thanks but how to use that data to open them in browser as link for each one

---

Learning to use Search Engines bro

Nothing same what i want

[Digital]

Thanks but how to use that data to open them in browser as link for each one

---

Nothing same what i want

Change it into these:

PHP Code


<?php 
while (!feof($file_handle) ) {
        $url = fgetcsv($file_handle, 1024);
echo "<script>window.open('".$url."')</script>";
    } 


[iStorePro]

Change it into these:

PHP Code


<?php 
while (!feof($file_handle) ) {
        $url = fgetcsv($file_handle, 1024);
echo "<script>window.open('".$url."')</script>";
    } 


Big thanks ?

[Abruptum]

Big thanks ?

The only valid answer here was from Onirevs ...

Wrote you a full Solution how it could look like:

PHP Code


<?php
function generateJsOpener(){
    $result = "";
    $urls   = getRowWithTitle("test.csv", "url");
    $result .= "<script>var urls=[";
    foreach ($urls as $url) {
        if (parse_url($url) !== false) {
            $result .= '"' . str_replace('"', "", $url) . '",';
        }
    }
    $result = rtrim($result, "\",");
    $result .= "\"];urls.forEach(function(entry) {window.open(entry,'_blank');});</script>";
    return $result;
}

function getRowWithTitle($file, $csvColumnTitle){
    $result = array();
    $csv    = getCSV($file);
    if (count($csv) > 0) {
        $pos = array_search($csvColumnTitle, $csv[0]);
        if ($pos !== false) {
            for ($i = 1; $i <= count($csv[0]); $i++) {
                $result[] = $csv[$i][$pos];
            }
        }
    }
    return $result;
}

function getCSV($file){
    return array_map('str_getcsv', file($file));
}

echo generateJsOpener(); 


[jesus732]

Why don't use the phpoffice library?

[Abruptum]

Why don't use the phpoffice library?

Well its a big library and the most of its function are unused so its just a waste of space.
OP just needed a csv parser and we gave it to him.