<?php
    $host = '127.0.0.1';
    $port = 3306;
    $user = 'root';
    $pass = 'root';
    $name = 'mydb';

    try {
        $conn = new PDO("mysql:host=$host;port=$port;dbname=$name", $user, $pass);
        $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

        echo "DB: Connected successfully\n";




       {
            $file = escapeshellarg('/var/www/results_m.csv');
            $last_line = `tail -n 1 $file`;
            echo $last_line;
            $sql = $conn->prepare("INSERT INTO dust1 VALUES (?, ?, ?, ?, ?, ?)");
            $sql->execute($last_line);

        echo 'DONE';
    } catch(PDOException $e) {
        echo "DB: Connection failed: ".$e->getMessage();
    } catch(Exception $e) {
        echo 'ERROR: '.$e->getMessage();
    }
?>