Skip to main content

Export to Excel using header disposition

     


     $output.="YOUR HTML TABLE HERE";


    header("Content-Type: application/vnd.ms-excel");

    header("Content-Disposition: attachment; filename=excel.xls");

    echo $output;

Comments

Post a Comment

Popular posts from this blog

Restoring MySQL on XAMMP

  Follow these steps and save your time and databases:- Go to your  XAMMP  installation, it’s mostly in  C drive . Now inside  mysql  folder rename the folder  data  to  data-old  (or any other name you like) Create a new folder  data  under  mysql  folder Copy the contents of  backup  folder to the new  data  folder Now copy all your  database  folders that are in  data-old  folder to the new  data  folder (skip the mysql, performance_scheme and phpmyadmin folder) And the last, copy the  ibdata1  file from  data-old  folder and replace it inside new  data  folder Restart your  MYSQL  server from  XAMPP control panel . And done!
Post a Comment
Read more

File upload in php

Simple way to upload file using php.     //HTML code <input type="file" required="" name="avatarUrl"/>   //On action page code where form is being submitted. if($_FILES['avatarUrl']['name']!='') {                        $fileTmpPath = $_FILES['avatarUrl']['tmp_name'];           $fileName = $_FILES['avatarUrl']['name'];           $fileSize = $_FILES['avatarUrl']['size'];           $fileType = $_FILES['avatarUrl']['type'];           $fileNameCmps = explode(".", $fileName);           $fileExtension = strtolower(end($fileNameCmps));              $dateMin = date('Ymdhms');           $rand = $dateMin;    ...
Post a Comment
Read more