Disable first line, when loading CSV - PHP

Question

As a title I have implemented within my project, a part in which the user can download a CSV model, and through pre-established fields upload their products in multiple ways, so as to make the work much faster.

The loading in CSV, works perfectly, plus I implemented within this loading also a check on a given product, so that in case they had to load a product with a code already registered in the db, leave out an alert, which warns the user of the fact.

My question once explained the procedure is: when the user downloads the CSV document, and this is formed by: -First name -Code etc...

the first line how can I ignore it from the code and record all the products from the second on?

Code:

<?php
$ESITO_POSITIVO = "";
$ESITO_NEGATIVO = "";

if(isset($_POST["submit"]))
{
include '../../connessione.php';

if(!$connessione){
die('Could not Connect My Sql:' .mysqli_error());
}
$file = $_FILES['file']['tmp_name'];
$handle = fopen($file, "r");
$c = 0;
while(($filesop = fgetcsv($handle, 1000, ",")) !== false)
{
$category_id = $_POST['category_id'];
$concessionaria = $filesop[0];
$proprietaria = $filesop[1];
$cimasa = $filesop[2];
$address = $filesop[3];
$city = $filesop[4];
$cap = $filesop[5];
$lat = $filesop[6];
$lng = $filesop[7];
$inpe = $filesop[8];
$tipo_impianto = $filesop[9];
$tipologia = $filesop[10];
$illuminato = $filesop[11];
$numero_facce = $filesop[12];
$quartiere = $filesop[13];
$comune = $filesop[14];
$ubicazione = $filesop[15];
$circuito = $filesop[16];
$costo_quattordici = $filesop[17];
$costo_mese = $filesop[18];

$CONTROLLA = mysqli_query($connessione,"SELECT cimasa FROM store_locator WHERE cimasa='".$cimasa."'");
$SE_IL_RISULTATO_IMMESSO=mysqli_num_rows($CONTROLLA);

if($SE_IL_RISULTATO_IMMESSO==0)  {
$connessione->query("insert into store_locator(category_id,concessionaria,proprietaria,cimasa,address,city,cap,lat,lng,inpe,tipo_impianto,tipologia,illuminato,numero_facce,quartiere,comune,ubicazione,circuito,costo_quattordici,costo_mese) values ('$category_id','$concessionaria','$proprietaria','$cimasa','$address','$city','$cap','$lat','$lng','$inpe','$tipo_impianto','$tipologia','$illuminato','$numero_facce','$quartiere','$comune','$ubicazione','$circuito','$costo_quattordici','$costo_mese')");
$stmt = mysqli_prepare($connessione);
mysqli_stmt_execute($stmt);
$c = $c + 1;
$ESITO_POSITIVO = '<div class="alert alert-success" role="alert">
  <strong>Impianto registrato con successo!</strong><br>
  <a href="../../gestisci/impianti/impianti.php" type="button" class="btn btn-success">Gestisci i tuoi Impianti</a>

</div>';
}
else
{ 
$ESITO_NEGATIVO = '<div class="alert alert-danger" role="alert">
  <strong>Attenzione! all&rsquo;interno del file che è stato caricato è presente un numero di Cimasa già registrato, si prega di controllare e ricaricare il file!</strong>
</div>';
}
}
}
?>

Add a counter and increment in the loop. If the counter is 0 at the beginning of the loop, it's the first row. — aynber
– aynber, Commented Dec 4, 2018 at 14:40
@aynber Perfect but ... heheheh could you give me an example with my code :) — user10735006
– user10735006, Commented Dec 4, 2018 at 14:42

Dave · Accepted Answer · 2018-12-04 14:54:51Z

1

I usually just retrieve a row to be thrown away/ignored if I know that there is a header row and I don't want or need it.

$file = $_FILES['file']['tmp_name'];
$handle = fopen($file, "r");
$trash = fgetcsv($handle, 1000, ",");  // retrieve the header line and ignore it
$c = 0;
while(($filesop = fgetcsv($handle, 1000, ",")) !== false)

answered Dec 4, 2018 at 14:54

Dave

5,19717 gold badges34 silver badges45 bronze badges

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

Comments

aynber · Accepted Answer · 2018-12-04 14:49:40Z

0

You need to create a counter to increment in your loop. If the counter is 1, then it's the first row and you need to use "continue" to have it skip that iteration of the loop. You need to increment before continue, or it will never increment:

<?php
$ESITO_POSITIVO = "";
$ESITO_NEGATIVO = "";

if(isset($_POST["submit"]))
{
    include '../../connessione.php';

    if(!$connessione){
        die('Could not Connect My Sql:' .mysqli_error());
    }
    $file = $_FILES['file']['tmp_name'];
    $handle = fopen($file, "r");
    $c = 0;
    $i = 0;
    while(($filesop = fgetcsv($handle, 1000, ",")) !== false)
    {
        $i++;
        if($i === 1) continue;

        // Rest of code here

    }
}
?>

answered Dec 4, 2018 at 14:49

aynber

23.2k9 gold badges57 silver badges69 bronze badges

1 Comment

user10735006 Over a year ago

Thank you so much sir! Work great!

Collectives™ on Stack Overflow

Disable first line, when loading CSV - PHP

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related