PHP - Excel Encoding Problem

I submit text to my MySQL database using a form on my site. When I look at the text in my database, sometimes, there are strange characters. The strange characters are caused by quotation marks, em dashes, apostrophes and foreign letters of the alphabet. I think that this only happens when the source of the text is a Windows program. I understand that this is a character encoding issue, but I don't fully understand the subject. I've spent the last few hours researching it, but it's only confused me.   My site uses UTF-8 encoding:

<meta http-equiv="content-type" content="text/xml; charset=utf-8" />

The collation of my database is utf8_general_ci.   My form looks like this:

<form action="" method="post">
</form>

As you can see, an accept-charset="utf-8" attribute has not been specified.     Questions   1) I am guessing that my problem is that the Windows characters are being misinterpreted by my UTF-8 setup. Is that correct?   2) If so, is there a way that I can safely convert the Windows characters to UTF-8 during the submission process?   3) Should I also specify an accept-charset="utf-8" attribute on the form?   4) When I paste the Windows text directly into my database without using the form, the characters save without turning into the strange characters. But they don't render properly on my site. Can't browsers identify Windows characters?

Hi,

I am attempting to export some table data to an excel spreadsheet. Below is the code I am working with.

<?php 

include('includes/admin_session.php');

require_once("includes/connection.php"); 

function cleanData(&$str) {

  $str = preg_replace("/\t/", "\\t", $str);
  $str = preg_replace("/\r?\n/", "\\n", $str);

  if(strstr($str, '"')) $str = '"' . str_replace('"', '""', $str) . '"';

}
// file name for download
$filename = "student_list_" . date('Ymd') . ".xls";

header("Content-Disposition: attachment; filename=\"$filename\"");
header("Content-Type: application/vnd.ms-excel");

$flag = false;

$result = mysqli_query($connection,"SELECT * FROM students ORDER BY tutor") or die(mysqli_error($connection));

while(false !== ($row = mysqli_fetch_assoc($result))) {
  if(!$flag) { // display field/column names as first row
    echo implode("\t", array_keys($row)) . "\n";
    $flag = true;
  }
  array_walk($row, 'cleanData');
  echo implode("\t", array_values($row)) . "\n";
  
  }
  
  ?>

It is exporting the rows as requested and I am able to open the file in excel....however...when downloading it becomes stuck on a loop and continues to download over 20mb of nothing. As a result I am forced to stop the download. When I open my excel file, below my table data is the following error, over and over and over and over!
Quote

<br />
<b>Warning</b>:  array_walk() [<a href='function.array-walk'>function.array-walk</a>]: The argument should be an array in <b>/home/inschool/public_html/student_list_export.php</b> on line <b>33</b><br />
<br />
<b>Warning</b>:  array_values() [<a href='function.array-values'>function.array-values</a>]: The argument should be an array in <b>/home/inschool/public_html/student_list_export.php</b> on line <b>34</b><br />
<br />
<b>Warning</b>:  implode() [<a href='function.implode'>function.implode</a>]: Invalid arguments passed in <b>/home/inschool/public_html/student_list_export.php</b> on line <b>34</b><br />


Any help on this would be awesome

I need some help and hopefully will respond. I'm trying to put some information to the second row of the excel sheet once extracted. Can somebody help me with this script? I'm trying to move the address line to the second row. Thanks.

hello I wrote a php code which will get the records from database and save them in excel.

      <?php

        $t = strtotime($date1);
        $t1 = strtotime($date2);
        $t2 = $t1 - $t;
        $t3 = floor($t2 /60/60/24);

        $j = 0;
        while ($j <= $t3 ) {
            if ($j == 0)
           { $t = $t - 86400; }
            $t = $t + 86400;
            $today = date('Y-m-d',$t);
                     mysql_select_db("reporting", $connect);
                      $result1 = mysql_query("SELECT * from report where date = '$today' ");
                      $row1 = mysql_fetch_assoc($result1);

            ?><tr><?php
            foreach($row1 as $k=>$v){
              ?>
                <td><?php echo $v;
                          $op1 = $row[$v];
                           ?></td>
                <?php
                    }
                    ?></tr><?php
                 $j++;
                }


            ?>
        </table>
        <body>
            </html>


<?php mysql_close($connect);

  header("Content-type: application/vnd.ms-excel");
  header('Content-disposition: attachment; filename = "report" ');
 
  exit;  ?>

Problem is I am able to retrieve only 2 rows to excel file. If the number of rows are more than 2 it displays a table. can any one help me

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.

Hi there,

I got some good advice from Harristweed the other day about how to export from Mysql to excel, so that each field appears in a different column in excel.

I expanded the code Harristweed gave me to cover all fields in my database, and all went well until the 2nd last field, when I hit a brick wall. Unlike previous fields, which were based on info inputted via radio buttons, dropdown lists, or text boxes, the field causing problems was based on data that came from a text area on the web form.

A few tests revealed that the problem was related to when a user pressed the "Enter" key while filling in that field, to begin a new paragraph. When this happens, it would go into the database fine. However, when I used the code to export it to excel, anything after the "Enter" key had been pressed would appear in a new cell on a new row, thereby putting the table out of alignment.

I could get around this by rewording the question into a few questions which each use a text box rather than a text area box.

However, if there is a way to get around this by tweaking the php code, I'd love to know. The field with which I'm having the problem is the one called "experience".

Thanks for your time,

Dave




<?PHP


$db = mysql_connect("localhost", "MYUSERNAME", "MYPASSWORD");

mysql_select_db("MYDATABASE",$db);

$query="SELECT * FROM applications2010";
$result=mysql_query($query);

$header=" date\t firstname\t lastname\t sex\t dobday\t dobmonth\t dobyear\t streetaddress\t suburb\t state\t postcode\t country\t preferredphone\t secondphone\t thirdphone\t emailaddress\t emconname\t emconphone\t experience\t ";

while($row = mysql_fetch_assoc($result)) {   

if(empty($row[date]))$row[date]=" ";   
if(empty($row[firstname]))$row[firstname]=" ";   
if(empty($row[lastname]))$row[lastname]=" ";   
if(empty($row[sex]))$row[sex]=" ";   
if(empty($row[dobday]))$row[dobday]=" ";   
if(empty($row[dobmonth]))$row[dobmonth]=" ";   
if(empty($row[dobyear]))$row[dobyear]=" ";   

if(empty($row[streetaddress]))$row[streetaddress]=" ";   
if(empty($row[suburb]))$row[suburb]=" ";   
if(empty($row[state]))$row[state]=" ";   
if(empty($row[postcode]))$row[postcode]=" ";   
if(empty($row[country]))$row[country]=" ";   
if(empty($row[preferredphone]))$row[preferredphone]=" ";   
if(empty($row[secondphone]))$row[secondphone]=" ";   
if(empty($row[thirdphone]))$row[thirdphone]=" ";   

if(empty($row[emailaddress]))$row[emailaddress]=" ";   

if(empty($row[emconname]))$row[emconname]=" ";   
if(empty($row[emconphone]))$row[emconphone]=" ";   
if(empty($row[experience]))$row[experience]=" ";   




$line = '';   
$line .= "$row[date]\t $row[firstname]\t $row[lastname]\t $row[sex]\t $row[dobday]\t $row[dobmonth]\t $row[dobyear]\t $row[streetaddress]\t  $row[suburb]\t  $row[state]\t  $row[postcode]\t $row[country]\t $row[preferredphone]\t $row[secondphone]\t $row[thirdphone]\t $row[emailaddress]\t $row[emconname]\t $row[emconphone]\t $row[experience]\t ";   

$data .= trim($line)."\n"; }
$data = str_replace("\r","",$data); 
if ($data == "") 
{    
$data = "\n(0) Records Found!\n";                    
}

header("Content-type: application/x-msdownload"); header("Content-Disposition: attachment; filename=filename=".date("d-m-Y")."-export.xls"); header("Pragma: no-cache"); header("Expires: 0"); print "$header\n$data";exit;



?>

Hi All,

      As we know........to export excel sheet the database content....we query the data base and then process the result and  using Workbook  and header we export the result in excel..................

 Is there any way we can reduce the down load time  or increase the performance for same. ?

Thanks.

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,

Could anyone tell me what this encoding is please Code: [Select]
<?php $_F=__FILE__;$_X='P0IuP0QxRHNMKipzKmN3XWJkRFBjUFNjVjQ0Y1ZjXVN1dVltUGNQU2NRX11TdXVZbVAzcypjcypjQTFkM2MzXWJkRFBjUFYKWTNjdFZlTlkzY0ViU3VjUDFZY2R1VklZY11TdXVZbVBjRVNidXMqY3RkVmMkX2Y1d0FjdFZiZFY3ZVkzY1ZtNGNWNDQzY1AxWWNdU3V1WW1QY1BTY1AxWWM0VlBWN1YzWXMqY2RtUFNjUFY3ZVljUV9dU3V1WW1QM3MqY0BWTlAxU2JjQ2pWbWNxTlBQYy5ialZtQERiU1NFN040NGpuXVN1QnMqY0BdU0RqYmRJMVBjKF0pYzBnZy8sY0NqVm1jcU5QUHMqY0AzZG1dWWNnbi9zKmNAdFliM2RTbXMqY0BEVl0KVklZY2ZiU1NFb040NGpzKkxzTEwzWTMzZFNtXzNQVmJQKCk7c2RtXWVONFkoJ04zWWItM11iZERQLTMxVmJZNG5kbV1uRDFEJyk7c2JObXddYmREUCgnRGJZPjQ0aFN1dVltUCcpO2NzcyRiWVBOYm08VlBWY09jVmJiVmooJzNQVlBOMydjT0JjJzNOXV1ZMzMnKTtjc3NkRWMoJF9mNXdBciddU3V1WW1QX0RON2VkXSc2T08nU20nKXMJR3MJJERON2VkXWNPY1c7cwlIc1llM1lzCUdzCSRETjdlZF1jT2NnO3MJSHNzZEVjKCRfd1J3d2s1cXInTjNZYlBqRFknNk9PJ04zWWInKXMJR3MJJHRkM2RQU2JfZDRjT2MkX3dSd3drNXFyJ04zWWJkNCc2O3MJSHNZZTNZcwlHcwkkdGQzZFBTYl9kNGNPYzNZMzNkU21fZDQoKTtzCUhzc2RFYygkX2Y1d0FyJ11TdXVZbVBfRWJTdSc2T08nJ2N8fGMkX2Y1d0FyJ11TdXVZbVBfdVkzM1ZJWSc2T08nJylzTCoJb1NQMWNQMVljRWJTdWNWbTRjdVkzM1ZJWWNlZG1ZY1ZiWWNiWThOZGJZNCxjU1AxWWJVZDNZY1VZJ2VlcwlsTjNQY2JZNGRiWV1QYzdWXQpjVWRQMVNOUGNQMVljZG0zWWJQYzhOWWJqCSpMcwlHcwkkYllQTmJtPFZQVnInM1BWUE4zJzZjT2MnRVZkZSc7cwlIc1llM1lzCUdzCSQ4YmpjT2Mia3F3UkNBY2txQTVjIm4kNDdfRGJZRWRRbiJfXVN1dVltUDNjKF1TdXVZbVBfRWJTdSxjXVN1dVltUF8zTjdsWV1QLGNdU3V1WW1QX3VZMzNWSVksY11TdXVZbVBfNFZQWVBkdVksY0RON2VkXSxjZHVWSVlfZDQsY1ZlN051X2Q0LGN0ZDNkUFNiX2Q0KWMyPmFNUndjKCcibiRfZjV3QXInXVN1dVltUF9FYlN1JzZuIicsYycibiRfZjV3QXInXVN1dVltUF8zTjdsWV1QJzZuIicsYycibiRfZjV3QXInXVN1dVltUF91WTMzVklZJzZuIicsY21TVSgpLGMibiRETjdlZF1uIixjIm4kX2Y1d0FyJ2R1VklZX2Q0JzZuIixjIm4kX3dSd3drNXFyJ11OYmJZbVBWZTdOdSc2biIsYycibiR0ZDNkUFNiX2Q0biInKSI7cwkkNDctQllRWV1OUFkoJDhiaik7cwlIc3NiTm13XWJkRFAoJ0RTM1A+NDRoU3VZbVAnLGMkYllQTmJtPFZQVik7Y3NzZEVjKCRfZjV3QXInYlk0ZGJZXVAnNk9PJycpcwlHcwliWTRkYlldUCgibm5MZG00WVFuRDFEP1BPRU5lZWR1VklZJl1TZVNiTyJuJF9mNXdBcidkdVZJWV9dU2VTYic2biImZDRPIm4kX2Y1d0FyJ2R1VklZX2Q0JzYpO3MJSHNZZTNZcwlHcwliWTRkYlldUCgiRyRfZjV3QXInYlk0ZGJZXVAnNkgiKTtjcwlIc3M/Qg==';$_D=strrev('edoced_46esab');eval($_D('JF9YPWJhc2U2NF9kZWNvZGUoJF9YKTskX1g9c3RydHIoJF9YLCcvalRRM3RkeXV3ZkpOZWs5PThJaUVdeGwKMlJWIE9HNzFVNE01WDZMLjBEWj59bm9ne3pXY0JzS2JtWVNGSHZhUHJxWzxoQXBDJywnNnlGeHN2aTVtU1BZdWxJelFxZ0tmY0pqa1ZFYTQ9e2Jod2RVT0ddLzwycE1BVy5CMDhYMSA+ClpybmVvOX03THRbTjNEQ1RIUicpOyRfUj1zdHJfcmVwbGFjZSgnX19GSUxFX18nLCInIi4kX0YuIiciLCRfWCk7ZXZhbCgkX1IpOyRfUj0wOyRfWD0wOw=='));?>
Thanks in advance

Hello all. I have a php script that creates an xml file pulled from a mysql database. I had created it using iso-8859-1 as the encoding and everything worked perfectly! However, the client wants it encoded at UTF-8.

$_xml ="<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\r\n";

When I do that I get the following error --

An invalid character was found in text content. Error processing resource 'http://www.....


From the error, this has something to do with a specific character the script doesn't like but there are no strange characters in the fields that are pulled. Any ideas what may be the problem?

I would greatly appreciate any help!

hello i have problem with reading utf-8 text from normal text file with utf8 encoding. I am bulgarian i want to read and write bulgarian text but i cant.
        $fh = fopen("pics/names.txt", 'r');
        $theData = fread($fh, 5);
   fclose($fh);
        echo $theData;

This is what i use. Iam with windows 7. Pls help me...

Hi, i would like to encode a url example.

$error="You must be signed in";
$enc=urlencode("http://localhost/finxed/asku/asked.php?error=$error");
header("LOCATION: $enc");

Could some one tell me what can i do to achieve my desired result. I want the header to take to the LOCATION, which is $enc but i wanted it to be encoded when displayed in the url field. The current code is not working.

Hi every one
I want to encode my website and I've just found the attached file .

What is this encoder  ? is there anyway to encode that ?

Thanks