Error Handling when running a CSV Import to MySQL using PHP

Thanks to @jpheldson for the help with $conn->errorInfo() to get the error message, as suspected in the above comments my provider doesn't allow LOAD DATA LOCAL INFILE on shared hosting (nor Events in PHPMyAdmin) so had to find a different way around my problem:

include '/php_include/db_details.php';
session_start();
try {
    $conn = new PDO($dsn, $username, $password);
} catch (PDOException $e) {
    echo '<h1>bachHa\'!</h1><p>Connection failed: ' . $e->getMessage(). '</p>';
}

//set import data file:
foreach (glob("/ftp/raw_survey/*.csv") as $csvfile)

//check we can open it
$file = fopen($csvfile,"r");

if (!$file) {
        echo "<h1>bachHa'!</h1><p>Error opening data file.</p>\n";
        exit;
}

//push it into MySQL
$file = fopen($csvfile, "r");
        fgetcsv($file, 10000, ',', '"'); //cheat to ignore header
        while (($column = fgetcsv($file, 10000, ',', '"')) !== FALSE) {

            $sqlInsert = "INSERT INTO test_upload(response_id,date_submitted,status,q1,q2,q3,q4_1,q4_2,q4_3,q4_4,q4_5,q5_text,StoreName)
                   values ('" . $column[0] . "','" . $column[1] . "','" . $column[2] . "','" . $column[3] . "','" . $column[4] . "','" . $column[5] . "','" . $column[6] . "','" . $column[7] . "','" . $column[8] . "','" . $column[9] . "','" . $column[10] . "','" . htmlentities($column[11], ENT_QUOTES, 'UTF-8') . "','" . $column[12] . "')";
            mysqli_real_escape_string(q5_text);
            $result = $conn->query($sqlInsert);

            if (! empty($result)) {
                $type = "Qapla'";
                $message = "CSV Data uploaded into the database";
            } else {
                $type = "bachHa'";
                $message = "Problem in Importing CSV Data";
            }
        }
//var_dump($conn->errorInfo());

//close file now we're done with it
fclose($file);

//transfer from temp upload to main data
        if (! empty($result)) {        
            $sqlUpdate = "INSERT INTO data (response_id,date_submitted,status,q1,q2,q3,q4_1,q4_2,q4_3,q4_4,q4_5,q5_text,StoreName)
                SELECT u.response_id,u.date_submitted,u.status,u.q1,u.q2,u.q3,u.q4_1,u.q4_2,u.q4_3,u.q4_4,u.q4_5,u.q5_text,u.StoreName
                FROM test_upload AS u
                WHERE u.`status` = 'Complete' AND u.store_list IS NOT NULL AND u.response_id NOT IN (SELECT response_id FROM data)";
            $result2 = $conn->query($sqlUpdate);

            if (! empty($result2)) {
                $type = "Qapla'";
                $message = "CSV Data uploaded & transferred to main dataset";
            } else {
                $type = "bachHa'";
                $message = "Data uploaded but not imported";
            }
        }

// Verify Load
$sql = "SELECT StoreName AS 'STORE', COUNT(*) AS 'RECORDS' FROM test_upload WHERE `status` = 'Complete' AND store_list IS NOT NULL AND response_id NOT IN (SELECT response_id FROM data) GROUP BY StoreName ORDER BY StoreName";
$verify = $conn->query($sql);

//clear temp
        if (! empty($result2)) {       
            $sqlClear = "DELETE FROM test_upload";
            $result3 = $conn->query($sqlClear);

            if (! empty($result3)) {
                $type = "Qapla'";
                $message = "CSV Data uploaded, transferred to main dataset & temp table cleared";
            } else {
                $type = "bachHa'";
                $message = "Data imported but temp not cleared";
            }
        }   

//disconnect SQL
$conn = null;       
//delete csv to prevent it being re-imported in the future
unlink($csvfile);
?>
<h1><?php echo($type); ?></h1><p><?php echo($message); ?></p>
<table>
        <?php while($row = $verify->fetch(PDO::FETCH_ASSOC)) {
            echo "<tr><td>" . $row['STORE']. '</td><td>'. $row['RECORDS']. '</td></tr>';
        }?>
</table>

This works perfectly fine when opening in the browser and called as a cronjob, so, job done, example placed above to help anyone who comes across this in the future and needs a similar alternative. Using PDO, htmlentities on the open text and mysqli_real_escape_string so hopefully this is SQL injection proof - if I've missed anything please feel free to tell me why I'm stupid!