Eggs Lab

Tag: Excel

  • Import Excel File Data in MySQL Database using PHP

    Import Excel File Data in MySQL Database using PHP

    [button-blue url=”http://demos.eggslab.net/downloads/2″ target=”_blank” position=””]DOWNLOAD[/button-blue][button-green url=”http://demos.eggslab.net/Import-Excel-Sheet-to-MySQL-Database/” target=”_blank” position=””]DEMO[/button-green] In this tutorial we will learn how to “Import Excel Sheet Data in MySQL Database using PHP. When we develop some database linked website where we have to enter data in database, sometime we have to upload bulk data in database. If we insert data one by one it will be very difficult… …

    Click or not: Import Excel File Data in MySQL Database using PHP
  • Export MySQL Table Data into Excel Sheet Format in PHP

    Export MySQL Table Data into Excel Sheet Format in PHP

    [button-blue url=”http://demos.eggslab.net/downloads/1″ target=”_blank” position=””]DOWNLOAD[/button-blue][button-green url=”http://demos.eggslab.net/ExportDatabaseToExcel/” target=”_blank” position=””]DEMO[/button-green] We often need to generate reports in excel sheet, but sometime we have our data stored in MySQL database. It is quiet easy to fetch records from MySQL and export the result in .csv file or .xls file and let user to force download it. We will make use of PHP and MySQL to do this… …

    Click or not: Export MySQL Table Data into Excel Sheet Format in PHP