PHP - Export Data To Excel File (works On Ie/firefox But Not Google Chrome)

I have this form action that checks for errors, if none are found it should go to the confirmation page.  Works well in Firefox, however Chrome stays perpetually on the register page. 

Is there any way to make this work in Chrome as well?  Does anyone have any explanation? 

Thank you very much for your time.


Code: [Select]

<form action="<?php if(!empty($errors)){
echo "confirmation.php";
} else {
echo "register.php";
} ?>" method="POST">

Here is the scenario:

I have phpbb installed inside of an iframe and I have all of these features working .....in firefox only:
Iframe re-sizes to fit content
external links within the forum open in a new window
traffic to my /forum directory is redirected (with a javascript window.location.replace) to open inside of the iframe

Essentially phpbb works perfectly in firefox

When I load it in either Chrome or IE:
My site index will load fine (as will any site feature that is not within the iframe)
When I attempt to load my forum or request anything within the iframe IE and Chrome show the page for less than one second then continuously load a 404 page within the frame

This leads me to believe that it is a problem with my redirect...but I have no clue.

Here is the PHP, hopefully somebody can help:

Iframe re-size code (in iframefile.php):

<script type="text/javascript">

/***********************************************
* IFrame SSI script II- &#38;#169; Dynamic Drive DHTML code library (http://www.dynamicdrive.com)
* Visit DynamicDrive.com for hundreds of original DHTML scripts
* This notice must stay intact for legal use
***********************************************/

//Input the IDs of the IFRAMES you wish to dynamically resize to match its content height:
//Separate each ID with a comma. Examples: ["myframe1", "myframe2"] or ["myframe"] or [] for none:
var iframeids=["myframe"]

//Should script hide iframe from browsers that don't support this script (non IE5+/NS6+ browsers. Recommended):
var iframehide="yes"

var getFFVersion=navigator.userAgent.substring(navigator.userAgent.indexOf("Firefox")).split("/")[1]
var FFextraHeight=parseFloat(getFFVersion)>=0.1? 150 : 0 //extra height in px to add to iframe in FireFox 1.0+ browsers

function resizeCaller(){
var dyniframe=new Array()
for (i=0; i<iframeids.length; i++){
if (document.getElementById)
resizeIframe(iframeids[i])
//reveal iframe for lower end browsers? (see var above):
if ((document.all || document.getElementById) && iframehide=="no"){
var tempobj=document.all? document.all[iframeids[i]] : document.getElementById(iframeids[i])
tempobj.style.display="block"
}
}
}

function resizeIframe(frameid){
var currentfr=document.getElementById(frameid)
if (currentfr && !window.opera){
currentfr.style.display="block"
if (currentfr.contentDocument && currentfr.contentDocument.body.offsetHeight) //ns6 syntax
currentfr.height = currentfr.contentDocument.body.offsetHeight+FFextraHeight; 
else if (currentfr.Document && currentfr.Document.body.scrollHeight) //ie5+ syntax
currentfr.height = currentfr.Document.body.scrollHeight;
if (currentfr.addEventListener)
currentfr.addEventListener("load", readjustIframe, false)
else if (currentfr.attachEvent){
currentfr.detachEvent("onload", readjustIframe) // Bug fix line
currentfr.attachEvent("onload", readjustIframe)
}
}
}

function readjustIframe(loadevt) {
var crossevt=(window.event)? event : loadevt
var iframeroot=(crossevt.currentTarget)? crossevt.currentTarget : crossevt.srcElement
if (iframeroot)
resizeIframe(iframeroot.id);
}

function loadintoIframe(iframeid, url){
if (document.getElementById)
document.getElementById(iframeid).src=url
}

if (window.addEventListener)
window.addEventListener("load", resizeCaller, false)
else if (window.attachEvent)
window.attachEvent("onload", resizeCaller)
else
window.onload=resizeCaller

</script>
_________________________________________________ ___

This is (part of) the javascript redirect (in iframefile.php)

<script type="text/javascript">
var text = window.location.href;
function delineate(str) {
theleft = str.indexOf("=") + 1;
theright = str.indexOf("&");
return(str.substring(theleft, str.length));
}
url=delineate(text)

function refreshFrame() {
myframe.location.replace("http://www.mydomain/?var1='+window.location.href+'");
}
</script>

This is the other part of the above javascript redirect that is in the overall_header to redirect pages requested within the forum to target the iframe via the code above:

<script type="text/javascript">
if (window == top) {
var url='window.location.replace("/?var1='+window.location.href+'")';
eval(url);
}
</script>


This is the necessary code i had to add in my home directory index.php for the above two codes to work:

<?
ob_start();
$vary = $_GET['var1'];
$tee = $_GET['t'];
if ( $vary == "" ) {
// do nothing, no var
} else {
$gogogo = strtolower($vary);
$healthy = array("http://mydomain/forum/", "http://www.mydomain/forum/");
$yummy   = array("", "");
$newphrase = str_replace($healthy, $yummy, $gogogo);

$finalcode = base64_encode($newphrase);
$healthy = array("+", "=");
$yummy   = array("7PLUS7", "7EQUALS7");
$newphraseu = str_replace($healthy, $yummy, $finalcode);
if ( $tee == "" ) {
header("Location: http://www.mydomain/iframefile.php?var=$newphraseu");
} else {
header("Location: http://www.mydomain/iframefile.php?var=$newphraseu&t=$tee");
}
}
ob_flush();
?>
___________________________________

And finally this is the code for my actual iframe (in iframefile.php):

<?
$healthy = array("7PLUS7", "7EQUALS7");
$yummy   = array("+", "=");
$newphraseu = str_replace($healthy, $yummy, $vary);

$finally = base64_decode($newphraseu);
if ( $tee == "" ) {
$thedone = $finally;
} else {
$thedone = "$finally&t=$tee";
}
if ( $vary == "" ) {
?>
<center><iframe onload="refreshFrame();" id="myframe" src="/forum" scrolling="no" marginwidth="0" frameborder="0" marginheight="0" vspace="0" hspace="0" style="overflow:invisible; width:100%; display:none"></iframe></center>
<?
} else {
?>
<center><iframe onload="refreshFrame();" id="myframe" src="/forum/<? echo $thedone; ?>" scrolling="no" marginwidth="0" marginheight="0" frameborder="0" vspace="0" hspace="0" style="overflow:invisible; width:100%; display:none"></iframe></center>
<?
}
?>


Sorry for the long read.
Again this all works perfect in firefox but with IE and Chrome the iframe keeps reloading a 404 page after showing the requested page briefly.
Any and all help is appreciated!

Thanks in advance

I have been banging my head for quite a number of hours on this.........I am getting the below error with firefox 7 or chrome but NOT with IE

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/unlockth/public_html/motorola/insertmoto.php on line 35

Here is the code.......pls can anyone help me?

<?php
  $userip = ($_SERVER['X_FORWARDED_FOR']) ? $_SERVER['X_FORWARDED_FOR'] : $_SERVER['REMOTE_ADDR'];
  $name = $_POST['name'] ;
  $email = $_POST['email'] ;
  $phone = $_POST['phone'] ;
  $operator = $_POST['operator'] ;
  $imei = $_POST['imei'] ;
  $todayis = date("l, F j, Y, g:i a") ;

  @mail( "xxx@xxx.com", "ORDER SUBMISSION",
   $message = " $userip
   $message = $todayis
   Name: $name
   Email: $email
   Phone Model: $phone
   Phone Operator: $operator
   Phone Imei: $imei",
    "From: MOTOROLA SUBMISSION>");
?>

<?
$id = $_POST['id'];

include "/home/unlockth/password.php";
mysql_select_db("unlockth_unlocking",$db);

mysql_query("INSERT INTO custdetails VALUES ('','$name','$email','$phone','$operator','$imei')");
$insertid = mysql_insert_id();

include "/home/unlockth/password.php";
mysql_select_db("unlockth_unlocking",$db);

  $getdata = mysql_query("SELECT * FROM motorola WHERE id=$id", $db);

  $row = mysql_fetch_array($getdata);

               $title = $row["title"];
               $price_1 = $row["price_1"];
               $price_2 = $row["price_2"];
               $price_3 = $row["price_3"];
               $imageaddr = $row["imageaddr"];
               $description = $row["description"];
               $keywords = $row["keywords"];
               $time = $row["time"];

include '/home/unlockth/public_html/motorola/outputmotocode.php';?>

hello everyone, please anyone can help me how to read data of excel file in php

ok, so I am not good with arrays, they confuse me.  how can I set this up so that $data is all results that are returned from the database that correspond to it? 

Code: [Select]
$data = array(
 array("firstname" => '$firstname', "lastname" => '$lastname', "age" => '$age'));
the original code looked like:
Code: [Select]
<?PHP $data = array( array("firstname" => "Mary", "lastname" => "Johnson", "age" => 25), array("firstname" => "Amanda", "lastname" => "Miller", "age" => 18), array("firstname" => "James", "lastname" => "Brown", "age" => 31), array("firstname" => "Patricia", "lastname" => "Williams", "age" => 7), array("firstname" => "Michael", "lastname" => "Davis", "age" => 43), array("firstname" => "Sarah", "lastname" => "Miller", "age" => 24), array("firstname" => "Patrick", "lastname" => "Miller", "age" => 27) ); ?>
but that won't do it for me.  I need it so that the results from the database will automatically be filled in.  basically, everyone that is in the database, so when a new member is added, they will show up too.  please help

Is it possible to export a single value from a mysql DB into a pre-existing excel spread sheet?

I know how to create a spread sheet from php and mysql, but not a single value into a pre-existing excel document cell.

here's basically what I'm doing:

Creating a financial expense tracking report in php, user will input each expense,  it will keep a running tally of the available funds in user's bank account. The user has an excel spread sheet that requires the current value of available funds and updates a budget forecast according. SO, I need to somehow get the available balance of the bank account (generated by user input) into the pre-existing excel spreadsheet.

Any thoughts? I'm totally at a loss.

Thanks!

Hi
I have a page displaying orders from a mysql table. How can i add a button which exports this to an excel file?

Hi, this is my first time here.

i am trying to create an xls file from the data i get from mysql. here is the code i tried but i am not able to use it correctly.
Code: [Select]
ob_start();
include('config');
$datacat = mysql_query("SELECT *
FROM `leads`") or die(mysql_error());
$name = mysql_fetch_assoc($datacat);

$line1="Industry,Company Name,Officials Name,Job Title,Country,Direct Number Mobile Number,Switch Board Number,E-mail,Executive NamePitch Date,Call Back Date,Comments\t";
while($row = mysql_fetch_array($datacat, MYSQL_ASSOC)) {
$line2= $name['industry'].",".$name['company_name'].",".$name['officials_name'].",".$name['job_title'].",".$name['country'].",".$name['direct_number_mobile_number'].",".$name['switch_board_number'].",".$name['email'].",".$name['executive_name'].",".$name['pitch_date'].",".$name['call_back_date'].",".$name['comment']."\t"."\n";
}
$data="$line1\n$line2\n";
 
header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=extraction.xls");
header("Pragma: no-cache");
header("Expires: 0");
print "$header\n$data";

i get my webpage title in the top of xls file and all the fields in xls file are separated by commas, whereas i want them to be in proper tables.

Help would be much appreciated.

So i have this script, it pull data via mysql and inserts it into an excel file.
However it does not properly tab each field as it should nor go to a new lines as it should instead it stick everything into 1 whole row.

Ok but here's the kicker... this same identical script runs 100% fine on another website. The only difference is the query string. There it works fine on this new site it bugs out.

any idea where the bug is?


<?php
include('dbcon.php');

$tablename = $_POST['tablename'];

$full_query = "SELECT * FROM $tablename";   

$header = '';
$data = '';
$export = mysql_query($full_query);
$fields = mysql_num_fields($export);

for ($i = 0; $i < $fields; $i++) 

{ 

$header .= mysql_field_name($export, $i) . "\t"; 

} 

while($row = mysql_fetch_row($export)) 

{ 

$line = ''; 

foreach($row as $value) 

{                                             

if ((!isset($value)) OR ($value == "")) 

{ 

$value = "\t"; 

} 

else 

{ 

$value = str_replace('"', '""', $value); 

$value = '"' . $value . '"' . "\t"; 

} 

$line .= $value; 

} 

$data .= trim($line)."\n"; 

} 
$data = str_replace("\r","",$data); 

if ($data == "") 

{ 
    

$data = "\n(0) Records Found!\n";                         

} 

header("Content-type: application/octet-stream"); 
header("Content-Disposition: attachment; filename=monet_search_results.xls"); 
header("Pragma: no-cache"); 
header("Expires: 0"); 
print "$header\n$data"; 

?>


PS: This is a linux box if that makes a difference.

THANKS!

am using this code
Code: [Select]
<?php
   require_once 'PHPExcel.php';
   require_once 'PHPExcel/IOFactory.php';
   
   $objPHPExcel = new PHPExcel();
   
   $objPHPExcel->getProperties()->setCreator("Matthew Casperson")
                      ->setLastModifiedBy("Matthew Casperson")
                      ->setTitle("Office 2007 XLSX Test Document")
                      ->setSubject("Office 2007 XLSX Test Document")
                      ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.");
                     
   $objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A1', 'Hello')
            ->setCellValue('B2', 'world!')
            ->setCellValue('C1', 'Hello')
            ->setCellValue('D2', 'world!');                     
   
   header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
   header('Content-Disposition: attachment;filename="test.xlsx"');
   header('Cache-Control: max-age=0');
   
   $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
   $objWriter->save('php://output');
?>
but excelsheet contain following  error.............

<b>Fatal error</b>:  Class 'ZipArchive' not found in <b>C:\Program Files\xampp\htdocs\immigration\PHPExcelSourceCode\PHPExcel\Writer\Excel2007.php</b> on line <b>224</b><br />

but excelsheet contain this error.............
please help how to fix it?

Hello,
i am currently getting an Microsoft Excel formatted text file whose save type is .Txt from a URL.I used to open it and will change the save type  as excel file. Please suggest whether we can do this with php code.

currently my code is like this,
<? php
copy("http://www.faa.gov/airports/airport_safety/airportdata_5010/menu/emergencyplanexport.cfm?Region=&District=&State=&County=&City=LAS%20VEGAS&Use=&Certification=","./contactsexport.xls");
?>

where as the contactsexport.xls type is .Txt which i need it in .xls

Thanks in Advance.

Hi All,

I am exporting data to excel, but run into a problem if the text contains a line break.  When it gets to the line break, it cuts off the rest of the text.

Here is my printer code:

Code: [Select]
$file = 'Notes_Export';
$csv_output = array();


$tmp = array();
$tmp[] = 'Created On';
$tmp[] = 'Created By';
$tmp[] = 'Note';

$csv_output[] = '"' . implode('","', $tmp) . '"';

$sql  = "SELECT pn.created_on, CONCAT( u.firstname,' ', u.lastname) AS created_by, pn.note FROM prop_notes pn LEFT JOIN users u ON pn.created_by = u.user_id ";
$sql .= "WHERE pn.deleted_by IS NULL AND pn.archive = '0' AND pn.property_id = '".$_GET['pid']."'";
      $result = mysqli_query($connect, $sql);

         while($rowr = mysqli_fetch_row($result))
         {
$tmp = array();
for ($j=0; $j<3; $j++) {$tmp[] = $rowr[$j];}
$csv_output[] = '"' . implode('","', $tmp) . '"';
         }


$filename = $file."_".date("Y-m-d_H-i",time());
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: csv" . date("Y-m-d") . ".csv");
// header( "Content-disposition: filename=".$filename.".csv");
header("Content-disposition: attachment; filename=".$filename.".csv");
print implode("\n",$csv_output) . "\n";
exit;

Hi..,
I use below method to export data to excel.

header('Content-type: application/ms-excel');
header('Content-Disposition: attachment; filename=abc.xls');

if I run the script from the server. (http://localhost/export.php) it is work. (pop-up window if i want save or open the file)

but if i run the script from the client (http://192.168.1.5/export.php) it is not work. (nothing happen)

any idea how to solve this?

Hello,
I had page that display results dynamically from the database, I need to export that html table to pdf.
Any help?
Thanks