Get the latest Laravel/PHP jobs, events and curated articles straight to your inbox, once a week
Source: codebrisk.com
Laravel Package to Help with Loading Files into MySQL Tables
Laravel Load File is a package to help with loading files into MySQL tables. This uses MySQL's LOAD DATA statement to load text files quickly into your database.
This library currently can handle any of the options in a normal LOAD DATA statement except for the partitioned table support.
LoadFile::file('/path/to/employees.csv', $local = true) ->into('employees') ->columns(['forename', 'surname', 'employee_id']) // like this ->fieldsTerminatedBy(',') ->fieldsEscapedBy('\\\\') ->fieldsEnclosedBy('"') // or ->fields(',', '\\\\', '"') ->load(); Loading data into Eloquent Models
Then you can use the following method to load a file into that table: User::loadFile('/path/to/users.csv', $local = true); Need to specify options to load the file with?
This library currently can handle any of the options in a normal LOAD DATA statement except for the partitioned table support.
LoadFile::file('/path/to/employees.csv', $local = true) ->into('employees') ->columns(['forename', 'surname', 'employee_id']) // like this ->fieldsTerminatedBy(',') ->fieldsEscapedBy('\\\\') ->fieldsEnclosedBy('"') // or ->fields(',', '\\\\', '"') ->load(); Loading data into Eloquent Models
Then you can use the following method to load a file into that table: User::loadFile('/path/to/users.csv', $local = true); Need to specify options to load the file with?
Newsletter
ToastMail
Achieve superior email deliverability with ToastMail! Our AI-driven tool warms up inboxes, monitors reputation, and ensures emails reach their intended destination. Sign up today for a spam-free future.
Community Partners
Laravel/PHP Careers