PHP - Export Excel Error

Hello,

I want to export data from php-mysql to excel in a particular cell.

1. Get the data from php-Mysql and export data to excel sheet. I already create a template excel sheet format.I want to export data from mysql to a particular cell. Sorry I can't able to attach my template excel sheet.
2. Is it possible to export image?


Thanks in advance

Hi,

i have export the search result to excel file, but arabic characters not displaying properly in excel file, eventhough i mention the header content type as utf-8

here my code...

Code: [Select]
<?php
include("global.php");
// Original PHP code by Chirp Internet: www.chirp.com.au 
// Please acknowledge use of this code by including this header. 

function cleanData(&$str) 
{
 $str = preg_replace("/\t/", "\\t", $str); $str = preg_replace("/\r?\n/", "\\n", $str); 
 if(strstr($str, '"')) $str = '"' . str_replace('"', '""', $str) . '"'; 
} 

$sql = $_SESSION['emp_search_sql'];
// file name for download 
$filename = "employees_" . date('Ymd') . ".xls";
header("Content-Disposition: attachment; filename=\"$filename\"");
header("Content-Type: application/vnd.ms-excel; charset=UTF-8"); 
header("Pragma: no-cache";


$flag = false;
 $result = $DB_site->query($sql) or die('Query failed!');
while(false !== ($row = mysql_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";
}

?>


Thanks,

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.

Hi Guys....

I need to export data into excel file. So far its works on IE and Firefox. But if i using Google Chrome it download only php file. Eg(suppose file test.xls but it goes to test.php). 

Why it happen??

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?

can't seem to find the error. helppp


Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /export/SOI-50/students/m2009/abhr428/web/WebIbs/view_user.php on line 20

<?php

require_once( "common.inc.php");
require_once( "config.php" );
require_once( "users.class.php" );
require_once( "LogEntry.class.php" );


$userid = isset( $_GET["userid"] ) ? (int)$_GET["userid"] : 0;


   if ( !$user = user::getuser( $userid) ) {
   displayPageHeader( "Error" );
   echo "<div>User not found.</div>;
   displayPageFooter();
   exit;
}

$logEntries = LogEntry::getLogEntries( $userid );
displayPageHeader( "View user: ". $user->getValueEncoded( "usr_name")
." ". $user->getValueEncoded( "usr_surname") );

?>

   <dl style="width: 30em;">
   <dt>Username</dt>
   <dd><?php echo $user->getValueEncoded( "usr_username" ) ?></dd>
   <dt>First name</dt>
   <dd><?php echo $user->getValueEncoded( "usr_name" ) ?></dd>
   <dt> Last name</dt>
   <dd><?php echo $user->getValueEncoded( "usr_surename" ) ?></dd>
   <dt>Joined on</dt>
   <dd><?php echo $user->getValueEncoded( "usr_recordtime") ?></dd>
   <dt>Last time active</dt>
   <dd><?php echo $user->getValueEncoded( "usr_lastlogintime" ) ?></dd>
   
   </dl>
   
   <h2> Access Log </h2>
   
   
   <table cellspacing="0" style="width":30em; border: 1px solid #667;">
   <tr>
      <th>Web Page</th>
      <th>Number of visits</th>
      <th> Last visit</th>
   </tr>
   
   <?php
      
      $rowCount = 0;
      foreach ~( $logEntries as $logEntry ) {
      $rowCount++;
   ?>
   
   
       <tr<?php if ( $rowCount % 2 == 0 ) echo ' class="alt"' ?>>
        <td><?php echo $logEntry->getValueEncoded( "pageUrl" ) ?></td>
        <td><?php echo $logEntry->getValueEncoded( "numVisits") ?></td>
        <td><?php echo $logEntry->getValueEncoded( "lastAccess") ?> </td>
       
        </tr>
       
      <?php
    
    
     </table>
    
     <div style="width: 30em; margin-top: 20px; text-align: center;">
        <a href="javascript:history.go(-1)">back</a> 
    </div>
   
    <?php
    displayPageFooter();
    ?>
   
     

i keep getting the above error.. help this is a class of the log entry


<?php

require_once "config.php";

abstract class DataObject {

protected $data = array();

public function__construct( $data ) {
   foreach ( $data as $key => $value ) {
      if ( array_key_exists( $key, $this->data )) $this->data[$key] =
   $value;
   }
   
}

public function getValue( $field ) {
   if ( array_key_exists( $field, $this->data )) {
      return $this->data[$field];
   } else {
     die( "field not found" );
     }
   }
   
public function getValueEncoded( $field ) {
   return htmlspecialchars( $this->getValue( $field ));
   
}

protected function connect() {
   try {
      $conn = new PDO(DB_DSN, DB_USERNAME, DB_PASSWORD );
      $Conn->setAttribute( PDO::ATTR_PERSISTENT, true );
      $conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
   }    catch ( PDOException $e->getMessage() );
      die( "connection failed: " . $e->getMessage() );
   }
   
   return $conn;
   
}

protected function disconnect( $conn ) {
      $conn = "";
   }
   
}                          
?>

sorry this was the actuall php code for this error...



<?php

require_once "DataObject.class.php";

class LogEntry extends DataObject {

   protected $data = array(
   "userid" => "",
   "pageUrl" => "",
   "numVisits" => "",
   "lastAcces" => "",
);

public static function getLogEntries( $userid ) {
   $conn = parent::connect();
   $sql = "SELECT * FROM " . TBL_accesslog . " WHERE userid = : userid
   
   ORDER BY lastAcces DESC";
   
   try {
      $st = conn->prepare( $sql );
      $st->bindValue( ":userid", $userid, PDO::PARAM_INT );
      $st->execute();
      $logEntries = array();
      foreach ( $st->fetchAll() as $row ) {
         $logEntries[] = new logEntry( $row);
      }
      
      parent::disconnect( $conn );
      return $logEntries;
   }   catch ( PDOExeception $e ) {
      parent::disconnect( $conn );
      die( "Query failed: " . $e->getMessage() );
      
      }   
   }
   
}

?>
   

cant seemed to solve this... helppp

Code: [Select]
<?php

require_once( "common.inc.php" );
require_once( "config.php");
require_once("users.class.php");


$start = isset( $_GET["start"] ) ? (int)$_GET["start"] : 0;
$order = isset( $_GET["order"] ) ? preg_replace( "/[^a-zA-Z]/", "",
$_GET["order"] ) : "usr_username";
list( $users, $totalRows ) =users::getusers( $start, PAGE_SIZE,
$order );
displayPageHeader( "View  project Employees" );

?>

      <h2> Displaying Available Project Employees <?php echo $start + 1 ?> - <?php echo min( $start + PAGE_SIZE, $totalRows ) ?> of <?php echo $totalRows ?></h2>

      <table cellspacing="0" style="width: 30em; border: 1px solid #667;">
        <tr>
           <th><?php if ( $order != " usr_username" ) { ?><a href="view_users.php? order= usr_username"><?php } ?>Username<?php if ( $order != "usr_username")
   { ?></a><?php } ?></th>
   
     <th><?php if ( $order != "usr_name" ) { ?><a href= "view_users.php? order= usr_name"> <?php } ?>First name<?php if ( $order != "usr_name" )
    { ?></a><?php } ?></th>
     
       
     <th><?php if ( $order != "usr_surname" ) { ?><a href= "view_users.php? order= usr_surname"> <?php } ?>Last name<?php if ( $order != "usr_surname" )
    { ?></a><?php } ?></th>
     </tr>
     
   <?php
   $rowCount= 0;
   
   foreach ( $users as $users ) {
   $rowCount++;
   
   ?>
   
         <tr<?php if ( $rowCount % 2 == 0 ) echo ' class="alt"' ?>>
           <td><a href="view_user.php?userid=<?php echo $user->
         
   getValueEncoded ( "id" ) ?><?php echo $user->getValueEncoded( "usr_username" )
   ?></a></td>
          <td><?php echo $user->getValueEncoded( "usr_name" ) ?></td>
            <td><?php echo $user->getValueEncoded( "usr_surname") ?> </td>
           </tr>
           
           
   <?php
   }
   
   ?>
   
   </table>
   
   <div style="width: 30em; margin-top: 20px; text-align; center;">
   <?php if ( $start > 0 ) { ?>
   
         <a href="view_users.php?start=<?php echo max( $start - PAGE_SIZE, 0 )?>
        &amp;order=<?php echo $order ?>">Previous Page</a>
    &nbsp;
    <?php if ( $start + PAGE_SIZE < $totalRows ) { ?>
       <a href="view_users.php?start=<?php echo min( $start + PAGE_SIZE,
      $totalRows ) ?>&amp; order=<?php echo $order ?>">Next Page</a>
        <?php
      displayPageFooter();
      ?>



MOD EDIT: [code] . . . [/code] tags added.

does anyone know who to resolve this issue of importing a CSV file from excel into sql? I get this error when I do.

LOAD DATA LOCAL INFILE  '/tmp/phpq2aAbU' INTO TABLE  `Events` FIELDS TERMINATED BY  ',' ENCLOSED BY  '\\"' ESCAPED BY  '\\\\' LINES TERMINATED BY  '\r\n'

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 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.

I need to write a cron job that will sync 2 databases.
Is there a quick way to write an export from one database for import into another?
Or do i manually have to write the select statements per table, format them as insert ignore strings, then execute them on the other database?

Thanks guys!

Dear freak gurus out there,
I'm new to php and sql as i learn from online examples  .

Though there are lots of links and answers out there related to my post but none reflects what i need. You guys my only hope.

What i have:

3 tables : each has its own number of fields (tbl1=14 ,tbl2=9,tbl3=9). There is a field in each tables that can be related (FamilyField).

What i need:

export to csv all the records from all 3 tables which relates to search criteria (by user) based on a field (MembershipField) which the data may vary from other tables.

pseudo code:
$membership_type =$_POST['mtype'];

$sql=" SELECT field1,field2,field5,MembershipField from tbl1, (SELECT field1,field2,MembershipField from tbl2), (SELECT field3,field6,field8,MembershipField from tbl3) WHERE MembershipFied=$membership_type";

export to csv file by using INTO OUTFILE;

I have tried all the code i can find to export from 1 table to csv, and i manage to use UNION to get output from 3 tables but unable to export
as the error message was "incorrect usage of UNION and INTO.

is this possible? or any workaround?
guides with samples will be a great help.