Image intervention - image source not readable

@Sinnbeck basically this is worksheet and contains more than 100 products, even I do not know, which url fails

@barki Does it throw an exception that you can catch?

@Sinnbeck no, basically I am using try catch block, unfortunately I cannot get which url is throwing error

$data = $xlsx->rows();
DB::beginTransaction();
try {
        foreach ($data as $key => $value) {
		// ignore error
            $image = null;
            if (!empty($value[1]) AND @fopen($value[1], 'r')) {
                $image = @file_get_contents($value[1]);
            }

            // if image is not found in the url 

            // return is_file($image);
            $product_image = '';
            if ($image) {
                $directory = 'products';
                $name = $this->runCode() . '-' . Str::slug($value[0]) . time();
                $image_url = $directory . $name;
                $product_image = env('OBJECT_URL') .  $image_url . '.png';
                UploadHelper::base64($directory, $image, $name, 'png');
            }
            MproductToImages::create([
                'product_id' => $product->product_id,
                'product_image' => $product_image
            ]);
DB::commit();

        return response()->json(['msg' => 'Product has been successfully imported.']);
    } catch (\Exception $e) {
        DB::rollBack();

        return response()->json(['msgErr' => $e->getMessage()]);
    }

@barki So when it fails it hits this?

DB::rollBack();

 return response()->json(['msgErr' => $e->getMessage()]);

If so, you should be able to get the last used image. While debugging you can move it inside the foreach to easily get the last $value

@Sinnbeck I can not, could you help me that as well?

@barki I tried copying the code into my editor but it seems broken. Missing } somewhere

Try this

} catch (\Exception $e) {
        DB::rollBack();

        return response()->json(['msgErr' =>$value[1]]);
    }

@Sinnbeck got it, this is the image https://petzone.com/media/catalog/product/cache/5/image/450x450/9df78eab33525d08d6e5fb8d27136e95/8/8/8858772602173.png

@barki I cannot open that in the browser either :) You can then update the error to specifiy the bad url

@Sinnbeck that's why it throws exception, how to handle this kind of scenario?

@Sinnbeck and what about this function

@fopen($value[1], 'r')

@barki Not sure what you mean? Your exception is being caught the problem is reported to the user? What else do you want ?

@barki I dont think fopen makes much sense in this case. I would just go with file_get_contents()

@Sinnbeck I want, basically, to skip that image where image source not found or forbidden like the above, which php function is meaningful in this scenario, image can be empty string but I dont want the overall process to be stopped

@barki Just dont return then

} catch (\Exception $e) {
        DB::rollBack();
    }