Showing posts with the label ExcelShow all
Import CSV File Data into MySQL Database in CodeIgniter
CodeIgniter

Import CSV File Data into MySQL Database in CodeIgniter

Solution Doodz August 26, 2021

Controller file   function import()     {         $filename = $_FILES["file"]["tmp_name"];         if ($_FILES['file']['size'] > 0) {             $file              = fopen($filename, "r");             $is_header_removed = FALSE;             while (($importdata = fgetcsv($file, 1000…

Load more »
Export MySQL data to Excel in PHP
Excel

Export MySQL data to Excel in PHP

Solution Doodz August 26, 2021

<?php      $conn = new mysqli('localhost', 'root', '');          mysqli_select_db($conn, 'dixit-test');          $sql = "SELECT * FROM `test-table`";          $setRec = mysqli_query($conn, $sql);          $columnHeader = '';          $columnHeader = "User Id" . "\t…

Load more »