Jump to content

[SOLVED] Export CSV and Internet Explorer


MichaelMackey

Recommended Posts

I've been using an export that works great with firefox, but IE exports all of the data to a single page.  Would anyone be able to help me out with why IE doesn't like it?

 

This is my code for it:

 

    if (isset($_SESSION['searchData']) AND isset($_SESSION['searchFields']) AND $valid == 1)
    {
    header("Content-Disposition: attachment; filename=branch.csv");

          $errorList = array();

          if (sizeof($errorList) == 0)
          {
                echo $_SESSION['searchTitle']."\n\n";
                echo $_SESSION['searchFields'];
                echo ("\n\n");

                //START FILLING IN THE ROWS IN EXCEL SHEET.
                $sql = $_SESSION['searchData'];
                $getInfo = mysql_query($sql);
                while($row = mysql_fetch_array($getInfo, MYSQL_ASSOC))
                {
                  while (list($key, $value) = each($row))
                  {
                    //If a row needs to have it's value changed before going into the cls file, perform it here using it's sql name
                    if($key == 'registration'){if($value == 1) $value = 'Yes'; else $value = 'No';}
                    if($key == 'training'){if($value == 1) $value = 'Yes'; else $value = 'No';}
                    if($key == 'language'){if($value == 'e') $value = 'English'; else $value = 'French';}
                    if($key == 'photograph'){if($value == 1) $value = 'Yes'; else $value = 'No';}

                    echo ("$value" . ",");
                  }
                  echo ("\n");
                }
                mysql_close($conn);
           }
           else
           {
              listErrors();
           }
   }

 

Thanks

Link to comment
https://forums.phpfreaks.com/topic/111694-solved-export-csv-and-internet-explorer/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.