/PHP/Laravel/Laravel import csv to database

Laravel import csv to database

function csvToArray($filename = '', $delimiter = ',')
{
    if (!file_exists($filename) || !is_readable($filename))
        return false;

    $header = null;
    $data = array();
    if (($handle = fopen($filename, 'r')) !== false)
    {
        while (($row = fgetcsv($handle, 1000, $delimiter)) !== false)
        {
            if (!$header)
                $header = $row;
            else
                $data[] = array_combine($header, $row);
        }
        fclose($handle);
    }

    return $data;
}

Source: stackoverflow.com

Similar codes

6 votes210 views1 answer
PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes") laravel 8
PHP Laravel
36 votes204 views6 answers
Laravel 8 foreign key migration
PHP Laravel
1 vote221 views1 answer
Where date laravel
PHP Laravel
0 vote227 views1 answer
Laravel collection average
PHP Laravel
3 votes208 views1 answer
Laravel carbon get year number
PHP Laravel
0 vote253 views1 answer
Laravel use npm package
PHP Laravel
0 vote230 views2 answers
Laravel bootstrap nav active
PHP Laravel
0 vote220 views1 answer
Route::auth(); giving error in laravel 7
PHP Laravel
4 votes222 views4 answers
Delete all rows from table laravel
PHP Laravel
0 vote219 views1 answer
Laravel capsule schema datatime CURRENT_TIMESTAMP
PHP Laravel