php - How to convert xls to mysql? -
how convert large xls or csv dataset mysql data using php , preferably using silverstripe api? can directly or need convert first text? silverstripe has number of ways import csv files datamodel. the documentation worth reading on section: https://docs.silverstripe.org/en/3.1/developer_guides/integration/csv_import/ the quickest , simplest way manage custom dataobject modeladmin interface , use built in csv importer. class playeradmin extends modeladmin { private static $managed_models = array( 'player' ); private static $url_segment = 'players'; } when go player modeladmin see csv import form on left. make sure column titles in csv file line variable names of data object. for more complex import methods read documentation alternative methods allow so.