After download the Sendgrid email activity exported data, create a SQLite to save some data

sendgrid_csv_import.php

<?php

$db = new PDO('sqlite:csvdata.sqlite');
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

if ($file = fopen("parsed.csv", "r")) {

    while(!feof($file)) {

        $line = fgets($file);
        $parts = explode(",", $line);

        $status  = $parts[0];
        $subject = $parts[1];
        $from    = $parts[2];
        $email   = $parts[3];

        $sql = 'INSERT INTO csv (`status`, `subject`, `from`, `email`) VALUES (?,?,?,?)';
        $stmt = $db->prepare($sql);
        $result = $stmt->execute([$status , $subject, $from, $email]);

    }
    fclose($file);
}