Convert comma separated string into two strings after CSV upload [PHP]

Question

I have a script that uploads a csv and assign values to a string separated by comma

$has_title_row = true;
if( $_POST['upload_file'] == 1 ) {
    if(is_uploaded_file($_FILES['csvfile']['tmp_name'])){
        $filename = basename($_FILES['csvfile']['name']);

        if(substr($filename, -3) == 'csv'){
            $tmpfile = $_FILES['csvfile']['tmp_name'];
            if (($fh = fopen($tmpfile, "r")) !== FALSE) {
                $i = 0;
                while (($items = fgetcsv($fh, 10000, ",")) !== FALSE) {
                    if($has_title_row === true && $i == 0){ // skip the first row if there is a tile row in CSV file
                        $i++;
                        continue;
                    }
                    //$data = print_r($items);
                    $i++;

                        $num = count($items);

                        $row++;
                        $str = '';
                        for ($c=0; $c < $num; $c++) {
                            //echo $items[$c] . ", ";
                            $str .= $items[$c] . ", ";
                        }
                } 
            }
        }
        else{
            die('Invalid file format uploaded. Please upload CSV.');
        }
    }
    else{
        die('Please upload a CSV file.');
    }
}

In the csv that I am uploading, I have 2 columns City and Country

I am also removing the first row with the title. So in the $str I have something like

$str = "Munich, Germany, Berlin, Germany, London, UK, Paris, France, Vienna, Austria, Milano, Italy, Rome, Italy";

The result I am aiming for is

$city = "Munich, Berlin, London, Paris, Vienna, Milano, Rome";
$country = "Germany, Germany, UK, France, Austria, Italy, Italy";

How would I separate the $str into countries and cities, or maybe it should be done in the upload scripts where I am looping trough the results?

Why didn't you save both information in the different objects while retrieving from CSV? instead of appending it into a string. — Gulshan S
– Gulshan S, Commented Oct 24, 2019 at 6:06
I have tried but somehow didn't succeed. Any idea of how to do it? — lStoilov
– lStoilov, Commented Oct 24, 2019 at 6:08
here you can get your answer stackoverflow.com/questions/2805427/… — Gulshan S
– Gulshan S, Commented Oct 24, 2019 at 6:12

LF-DevJourney · Accepted Answer · 2019-10-24 06:20:20Z

1

You can iterate the array, Demo

$str = "Munich, Germany, Berlin, Germany, London, UK, Paris, France, Vienna, Austria, Milano, Italy, Rome, Italy";
$array = explode(",",$str);
foreach($array as $k => $value){
    if($k % 2){
        $country_list[] = $value;
    }else{
        $city_list[] = $value;
    }
}
$city = join(",",$city_list);
$country = join(",",$country_list);

answered Oct 24, 2019 at 6:20

LF-DevJourney

28.6k30 gold badges170 silver badges322 bronze badges

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

Comments

Nigel Ren · Accepted Answer · 2019-10-24 06:27:05Z

1

Rather than process the result of your current code, following the advice in the comment, process the data directly from the CSV file (only the relevant part included)...

if (($fh = fopen($tmpfile, "r")) !== FALSE) {
    // Skip header
    $header = fgetcsv($fh);
    $cities = [];
    $countries = [];
    while (($items = fgetcsv($fh)) !== FALSE) {
        $cities[] = $items[0];
        $countries[] = $items[1];
    }

    print_r(implode(",",$cities));
    print_r(implode(",",$countries));
}

answered Oct 24, 2019 at 6:27

Nigel Ren

57.3k11 gold badges49 silver badges59 bronze badges

Collectives™ on Stack Overflow

Convert comma separated string into two strings after CSV upload [PHP]

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related