Home / Questions / 283664
Accepted
scorpions
Asked: 2020-08-05 03:43:31 +0800 CST 2020-08-05 03:43:31 +0800 CST

Loop through CSV and stick with image URLs

  • 772

I'm trying to loop through a CSV with PHP, I've already done that, but now I need to keep the URLs of the images as they are from a reseller catalog so I can upload them to woocommerce.

The thing is that I can't find the way to find the path of the image inside an array, which I have created to store all the CSV info, I have used some PHP functions but without result. I attach code and image of what I need.

1st CSV image and routes:CSV and .img paths

I have an HTML form that allows me to select the CSV to process it and I'm interested in doing it in a generic way because this script can be used in more situations.

My current php script is like this:

<?php

$fila = 1;
$array = array();
$buscar = 'https://';
$resultadoBusqueda;

if (($gestor = fopen("Productos-Euromoto-20-09-2018.csv", "r")) !== FALSE) {

    while (($datos = fgetcsv($gestor, 1000, ",")) !== FALSE) {
        $numero = count($datos);
        echo "<p> $numero de campos en la línea $fila: <br /></p>\n";
        $fila++;
        for ($i=0; $i < $numero; $i++) {
            //echo $datos[$i] . "<br />\n";
            $array = $datos[$i];
            echo 'contenido array: ' . $array;
            echo "<br>";

            //echo 'foto: ' . strstr($array[$i], 'https://', true);
        }

    }

    $resultadoBusqueda = array_filter($array, function($var) use ($buscar) { return stristr($var, $buscar) } );
        if($resultadoBusqueda){
            echo 'se ha encontrado el termino "' . $buscar .'" en la posicion <br>';
            foreach($resultados as $resultadoBusqueda){
                echo $resultados . "<br>";
            }
        }else{
            echo 'El termino "' . $buscar . '" no se ha encontrado en el array ';
        }

}

But it returns me that an argument is missing. Anyway, I don't know if it will be the best way to do this. What I need is that, within the array, look for the string that begins with "http://" and ends with ".jpg"

I appreciate all help.

All the best

php

2 Answers

  1. When using

    $gestor = fopen("a.csv", "r"))

    and then in each loop:

    fgetcsv($gestor, 1000, ","))

    what you get from the latter is an array where the fields are already separated, you wouldn't need to explode. fgetcsv returns an array itself:

    getcsv — Gets a line from a file pointer and parses it for CSV fields

    Description

    fgetcsv ( 
   resource $handle 
   [, int $length = 0 
     [, string $delimiter = "," 
       [, string $enclosure = '"' 
         [, string $escape = "\"]
       ]
     ]
   ]) : array

    Similar to fgets() except that fgetcsv() parses the line it reads for fields in CSV format, returning an array containing the fields read.

    The bad thing is that in your third parameter you are telling it that your CSV is separated by commas, but as seen in the photo it is separated by semicolons , so you must use semicolons as the third parameter and not commas, as you have in that moment:

    fgetcsv($gestor, 1000, ";"))

    Assuming your CSV had the form:

    "Corona 69 dientes rectos";"https://imagenes.sitio.com/corona.jpg";  "01008105"
"Embrague Reforzado";"https://imagenes.sitio.com/embrague.jpg";"01008115"
"Discos Embrague;"https://imagenes.sitio.com/discos.jpg";"01008121"
"Piñon diente helicoidal";"https://imagenes.sitio.com/helicoidal.jpg";"01008105E"

    Your procedure is equivalent to iterating over an array that looks like:

    $miArray = [
  ["Corona 69 dientes rectos",  "https://imagenes.sitio.com/corona.jpg",  "01008105"],
  ["Embrague Reforzado",  "https://imagenes.sitio.com/embrague.jpg",  "01008115"],
  ["Discos Embrague", "https://imagenes.sitio.com/discos.jpg", "01008121"],
  ["Piñon diente helicoidal",  "https://imagenes.sitio.com/helicoidal.jpg",  "01008105E"]
];

    (Of course, fgetcsv will be removing one row at a time, so as not to store everything in memory)

    For the purposes of the example, your iteration would be like doing:

    foreach( $miArray as $fila => $registro ){
    echo sprintf("La fila %d tiene %d campos %s", $fila, count($registro), PHP_EOL);
}

    (sprintf saves me from interpolating ugly variables)

    To get the images you use a regular expression that says:

    of the following array, give me the elements (indexed by their position) that start with httpsand end with.jpg

    That is:

    foreach( $miArray as $fila => $registro ){

    echo sprintf(PHP_EOL."La fila %d tiene %d campos ".PHP_EOL,$fila,count($registro));

    $campos_con_imagen = preg_grep('/^https:\/\/.*\.jpg$/i', $registro );

    foreach($campos_con_imagen as $key => $value) {

        echo sprintf("Se encontró la imagen '%s' en el campo %d de la fila %d ".PHP_EOL, $value, $key, $fila);

    }

}

    that prints

    La fila 0 tiene 3 campos 
Se encontró la imagen 'https://imagenes.sitio.com/corona.jpg' en el campo 1 de la fila 0 

La fila 1 tiene 3 campos 
Se encontró la imagen 'https://imagenes.sitio.com/embrague.jpg' en el campo 1 de la fila 1 

La fila 2 tiene 3 campos 
Se encontró la imagen 'https://imagenes.sitio.com/discos.jpg' en el campo 1 de la fila 2 

La fila 3 tiene 3 campos 
Se encontró la imagen 'https://imagenes.sitio.com/helicoidal.jpg' en el campo 1 de la fila 3

    In each iteration you can add the images to an array and from this obtain a list of SKU => image tuples:

    <?php
$tuplas = [];

$miArray = [...];

foreach( $miArray as $fila => $registro ){

  $campos_con_imagen = preg_grep('/^https:\/\/.*\.jpg$/i', $registro );

  foreach($campos_con_imagen as $key => $value) {
       $tuplas[$registro[2]] = $value; // $registro[2] es el SKU o código de la pieza
   }

}

echo "Resultado final ".PHP_EOL;
print_r($tuplas);

    And that prints:

    Resultado final 
Array
(
    [01008105] => https://imagenes.sitio.com/corona.jpg
    [01008115] => https://imagenes.sitio.com/embrague.jpg
    [01008121] => https://imagenes.sitio.com/discos.jpg
    [01008105E] => https://imagenes.sitio.com/helicoidal.jpg
)

    COMPLETE EXAMPLE

    • 2
  2. Best Answer

    One way to find the field containing 'https://' is like this:

    • You take the line and convert it into an array with explode.

    • You go through the newly created array and look for the string you are interested in, with a IF.

      $fila = 1;
$array = array();
$buscar = 'https://';
$resultadoBusqueda;

if (($gestor = fopen("a.csv", "r")) !== FALSE) {

    while (($datos = fgetcsv($gestor, 1000, ",")) !== FALSE) {
        $numero = count($datos);
        echo "<p> $numero de campos en la línea $fila: <br /></p>\n";
        $fila++;
        for ($i=0; $i < $numero; $i++) {
            echo $datos[$i] . "<br />\n";
            $array = $datos[$i];
            $campos = explode(';',$array);
            foreach($campos as $campo) {
              echo "<br />".$campo;
              if( strpos($campo, $buscar) !== false){
                echo "<br /> <b>Encontrado : </b>".$campo;
              }
            }
        }

    }

}
?>

    Another way can be...

    Knowing the position of the field that contains the images can also be done like this...

    • You convert the line that is a stringto a arraywith explode.
    • You traverse the array with foreach.
    • You use the conditional IFto filter the position.

    Assuming that the field in position 11 (if it is an array it will be 10)...

    <?php

$fila = 1;
$array = array();
$buscar = 'https://';
$resultadoBusqueda;

if (($gestor = fopen("a.csv", "r")) !== FALSE) {

    while (($datos = fgetcsv($gestor, 1000, ",")) !== FALSE) {
        $numero = count($datos);
        echo "<p> $numero de campos en la línea $fila: <br /></p>\n";
        $fila++;
        for ($i=1; $i < $numero; $i++) {
            echo $datos[$i] . "<br />\n";
            $array = $datos[$i];
            $campos = explode(';',$array);
            foreach($campos as $index=>$campo) {
              echo "<br />".$campo;
             if($index == 10 && $campo != ''){
               echo "<br /> <b>Encontrado : </b>".$campo;
             }
            }
        }

    }

}
?>

    Hope this can help you.

    • 1