PDO Export Function - CSV Export export data into csv directly using PDOModel helper functions

Description

PDOModel export to csv functions allows to export data to csv by passing array of data. Data needs to be passed in form of array and optionally you can define name of file to be exported.
Also, You can get data from select query and export data directly using this function.

Function Defination

  
                                void function arrayToCSV($csvArray, $fileName = "file.csv") ;

Parameters Details

Details Type Example
$csvArray - array of data array 2-D array of data
$fileName - optional name of file to be exported string any valid file name like "xyz.csv"

Examples

  
                                $pdomodel = new PDOModel(); //create object of the PDOModel class
                                /* array to csv function */
                                $data = array( array("row1col1","row1col2","row1col3","row1col4"),array("row2col1","row2col2","row2col3","row2col4"));
                                $pdomodel->arrayToCSV($data);

More Examples

 
                                //Example 1 
                                $records = $pdomodel->select("emp"); //get data from table
                                $pdomodel->arrayToCSV($records, "emp.csv");//export it to csv

Result/Output

By default, it exports csv file

Debug

Option Details Example
print_r($pdomodel->error) Print errors (if any)