 <?
    include "../classes/db.class.php";
    $db = new db();


    if (($open = fopen("assetsa.csv", "r")) !== false) {
        while (($data = fgetcsv($open, 1000, ",")) !== false) {
            $row = explode(';', $data[0]);
            echo $row[1];
            echo $row[2];
            echo $row[3];
            echo $row[4];
            echo $row[5];
            echo $row[6];
            echo $row[7];
            echo $row[8];
            echo $row[9];
            echo $row[10];

            $db->insert("INSERT INTO `assets` (`asset_type_id`,`asset_id`,`fleet_no`,`status`,`farm_id`,`qr_code`,`license_exp_date`,`description`,`vin`,`fuel_size`) VALUES ('{$row[1]}','{$row[2]}','{$row[3]}','{$row[4]}','{$row[5]}','{$row[6]}','{$row[7]}','{$row[8]}','{$row[9]}','{$row[10]}')");
        }

        fclose($open);
    }