string(104) "INSERT INTO metricas values (null, 'Andres Avila Hernandez', $1,457.94 , 9.69, 14,127 , 120%, 16,953 )"

<?php

if(isset($_POST["submit_file"]))
    $file = $_FILES["file"]["tmp_name"];
    $file_open = fopen($file,"r");
    $count = 0;
    while(($csv = fgetcsv($file_open, 100000, ",")) !== false)
    {
        $agente = isset($csv[0])? $csv[0]: null;
        $revenue = isset($csv[1])? $csv[1]: null;
        $css = isset($csv[2])? $csv[2]: null;
        $rating = isset($csv[3])? $csv[3]: null;
        $absent = isset($csv[4])? $csv[4]: null;
        $score = isset($csv[5])? $csv[5]: null;
        $count++;
        if($count>1){
            $query = "INSERT INTO metricas
                        values (null, '$agente', $revenue,
                                $css, $rating, $absent, $score)";
            var_dump($query);
        }
    }

?>