Hi wondered if someone could help me i have a csv import script and i need it to skip the cells which are EMPTY for additional images which is product_image and only insert the data which is in the cells for product_image
here is the code i have:
[php]if (isset($data[‘product_image’])) {
foreach ($data[‘product_image’] as $image) {
$image = $image.".jpg";
$image = str_replace (" ", "", $image);
$filename = '/home/purchase/public_html/fancydresscostumesonline.co.uk/image/'. $image;
if (file_exists($filename)) {
$this->db->query("INSERT INTO " . DB_PREFIX . "product_image SET product_id = '" . (int)$product_id . "', image = '" . $this->db->escape($image) . "'");
} else {
$this->db->query("INSERT INTO " . DB_PREFIX . "product_image SET product_id = '" . (int)$product_id . "', image = 'no_image.jpg'");
}
}
}[/php]
this code at moment addds a .jpg at the end of the numbers which are in the additional images column in the csv and the else statement no_image.jpg adds a no_image for all the empty CELLS for product_image so i need it customised so it skips the empty rows/cells and just cant think what to do:
This is code i though would work:
[php]foreach($file as $row){
if(empty($row['date'])){
continue;
}
$image = 'default.jpg';
if( ! empty($row['product_image'])){
$image = trim($row['product_image']) . '.jpg';
}
$image = '/home/purchase/public_html/fancydresscostumesonline.co.uk/image/' . $image ;
if( ! file_exists($image)){
continue;
}
$this->db->query(sprintf(
"INSERT INTO %s SET product_id = %d, image = '%s';",
DB_PREFIX . 'product_image',
$product_id,
$this->db->escape($image)
));
} [/php]
but i not sure if it will as not sure what goes before the foreach hope someone can help i am a beginner at this.
Regards,
Aaron