Import Bulk Data Import bulk data using csv, xml and excel file (Addded in v 1.9)

You can import bulk data from csv/xml/excel file directly in database table using the bulk import function. You need to specify the filename and table name only. Your file must have header as the column name of the table.
Please note xml file must have simple column-value... structure. Apart from these, three more functions are added (csvToArray, xmlToArray and excelToArray), that converts csv/xml/excel To Array.

  
                                $pdocrud = new PDOCrud(); 
                                echo "Records Imported: ". $pdocrud->bulkImport("upload/advertisement.csv", "advertisement");
                                echo $pdocrud->dbTable("advertisement")->render();
                                

Advertisement

Showing 1 to 1 of 1 entries

# Ad id Ad title Ad description Ad category Country Featured image1 Featured image2 Actions
1 2 test 1 test desc test cate test count test image1 test image2
# Ad id Ad title Ad description Ad category Country Featured image1 Featured image2 Actions