Search the Community

Good day to everyone, I would like to is there a possible solution for getting the array data into the database then split it into multiple array of data and then export it into multiple CSV file? Here is the code that I use: download.php public function downloadCSVbyBatch($batch){ // $data['keywordIDs'] = $this->ItemsearchModel->getConcatKeywordIDbyBatch($batch); $keys = str_replace("-", ",", $batch); // echo $keys; // $key = $this->ItemsearchModel->getSearchResultsbyBatch($batch); $data['results'] = $this->ItemsearchModel->getSearchResultsWhereIN($keys); // var_dump($data['results']); // print_r($data['results']); // echo $data['results']['keywords']; if($data['results']){ foreach($data['results'] as $result){ $data['csvlines'][] = $result; } } // echo '<pre>'; // print_r($data); // echo '</pre>'; $this->load->view("csv", $data); header("Content-type: application/download"); header("Content-disposition: filename=csvResults.csv"); header("Content-Transfer-Encoding: UTF-8"); } then here is the query and the csv format: query public function getSearchResultsWhereIN($keyIDs){ $keyIDs = substr($keyIDs,0,-1); $query = $this->db->query("SELECT serial_number,search_id,price,whether_tax,item_code,product_name,item_description,product_url,affiliate_url,site_name,store_name,store_url,image_url,keyword_search_1,keyword_search_2,price_from,price_to FROM result WHERE serial_number IN ($keyIDs)"); if($query->num_rows()>=1){ return $query->result_array(); }else{ return FALSE; } } csv.php <?php echo 'serial_number,search_id,price,whether_tax,item_code,product_name,item_description,product_url,affiliate_url,site_name,store_name,store_url,image_url,keyword_search_1,keyword_search_2,price_from,price_to," "'."\n"; foreach($csvlines as $csv){ echo implode(",", $csv)."\n"; } ?> Your help will be so much appreciated.