Some code help please

[chalfontgifts]

This is part of an import routine I have been writing.

$row = 1;
$handle = fopen("http://www.supplierurl.com/feed/feed6.csv", "r");
$new_products="";
$existing_products="";
$to_remove_products="";
$instock = 0;
$outstock = 0;
$totalproducts = 0;
$newproducts = 0;
$deletedproducts = 0;
mysql_query("update products set products_status=99 ");
while (($data = fgetcsv($handle, 1000, ",")) !== false) {
    $num = count($data);
 //
    $row++;
    if($row>2){
    for ($c = 0; $c < $num; $c++) {
        if ($c == 0) $pname_orig = str_replace('"', '' , $data[$c]);
        if ($c == 2) $pid = str_replace('"', '' , $data[$c]);
        if ($c == 4) $cat = str_replace('"', '' , $data[$c]);
        if ($c == 5) $subcat = str_replace('"', '' , $data[$c]);
        if ($c == 7) $prod_description_orig = str_replace('"', '' , $data[$c]);
        if ($c == 11) $price = str_replace('"', '' , $data[$c]);
        if ($c == 8)$img = str_replace('"', '' , $data[$c]);
        if ($c == 9)$img2 = str_replace('"', '' , $data[$c]);// Get 2nd image file name
        if ($c == 14) {
  $stock = str_replace('"', '' , $data[$c]);
  if($stock=='True'){ $q=100;$instock++;} else {$q=0; $outstock++;}
  }
        if ($c == 15)$weight = str_replace('"', '' , $data[$c]);
    } 

Most of the time this works, but sometimes it does not pick the feed file up properly, and sees the file as empty. This clears all my products and ends up placing lots of empty rows in the database.

Can someone help me with the code required to check that the file is present, and check it is not empty. If there is a problem with the file, I would rather it did not run the the import, and just send an email saying import file error.

Any help would be appreciated.

Thanks
Laurie

[DrByte]

Try wrapping it in an if/else condition, perhaps akin to this:

 
$row = 1;
$handle = fopen("http://www.supplierurl.com/feed/feed6.csv", "r");
if ($handle) {
  $new_products="";
  $existing_products="";
  $to_remove_products="";
  $instock = 0;
  $outstock = 0;
  $totalproducts = 0;
  $newproducts = 0;
  $deletedproducts = 0;
  mysql_query("update products set products_status=99 ");
  while (($data = fgetcsv($handle, 1000, ",")) !== false) {
      $num = count($data);
 //
      $row++;
      if($row>2){
      for ($c = 0; $c < $num; $c++) {
          if ($c == 0) $pname_orig = str_replace('"', '' , $data[$c]);
          if ($c == 2) $pid = str_replace('"', '' , $data[$c]);
          if ($c == 4) $cat = str_replace('"', '' , $data[$c]);
          if ($c == 5) $subcat = str_replace('"', '' , $data[$c]);
          if ($c == 7) $prod_description_orig = str_replace('"', '' , $data[$c]);
          if ($c == 11) $price = str_replace('"', '' , $data[$c]);
          if ($c == 8)$img = str_replace('"', '' , $data[$c]);
          if ($c == 9)$img2 = str_replace('"', '' , $data[$c]);// Get 2nd image file name
          if ($c == 14) {
    $stock = str_replace('"', '' , $data[$c]);
    if($stock=='True'){ $q=100;$instock++;} else {$q=0; $outstock++;}
    }
        if ($c == 15)$weight = str_replace('"', '' , $data[$c]);
  }
} else {
 // send email here, or simply display some sort of message indicating that no data was found 
}

[chalfontgifts]

Hi DR Byte

Thanks for that.

Tried to find some info on what $handle is about. Will that pickup if the file is not found or if it is an empty file ?

Please could you explain a bit, so I can understand.

Regards
Laurie

[DrByte]

PHP.net documentation on fopen(): http://www.php.net/manual/en/function.fopen.php