PHP导出excel带图片

Question

你好，我可以使用下面的代码。导出功能工作正常，但没有图像导出，为什么？请帮帮我。

<?php
    header("Pragma: public");
    header("Expires: 0");
    header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
    header("Content-Type: application/vnd.ms-excel; charset=UTF-8");
    header("Content-Type: application/force-download");
    header("Content-Type: application/octet-stream");
    header("Content-Type: application/download");
    header("Content-Disposition: attachment; filename=member_list.xls");

    ?>
    <table cellpadding="0" cellspacing="0" border="0" class="table table-bordered">
    <thead>
        <tr><th colspan="6"><h3>Member List</h3></th></tr>
        <tr>
            <th>ID</th>
            <th>Name</th>
            <th>Email</th>
            <th>Phone No</th>
            <th>Date of Birth</th>
            <th>Profile Image</th>
            <th>Status</th> 
            <th>InsertDate</th> 
        </tr>
    </thead>
    <tbody>
      <?php 
      if(!empty($memberlist))
        {
        foreach ($memberlist as $row){  ?>
          <tr class="gradeX odd">
              <td><strong><?php echo $row->id;?></strong></td>
              <td><?php echo $row->display_name;?></td>
              <td><?php echo $row->user_email;?></td>
              <td><?php echo $row->phone;?></td>
              <td><?php echo $row->dob;?></td>
              <td><img src="<?php echo base_url().'uploads/images/member/'.$row->profile_image;?>" width="80" height="65" /><?php echo base_url().'uploads/images/member/'.$row->profile_image;?></td>
              <?php 
              if($row->is_active == 1)
              {
              ?>
                  <td>Active</td>
                  <?php 
              }
              else
              {
              ?>
                  <td>Inactive</td>
                  <?php 
              }
              ?>   
              <td><?php echo $row->insertdate;?></td>                   
          </tr>
      <?php } } ?> 
    </tbody>
    </table>
?>

如何用一列导出我excel，它们是显示图像。我们需要这个导出的文件与八列和第六列是显示图像，如果他们在我的数据中发现。

Answer 1

这就是我如何解决我的问题的。希望这能有所帮助！

    public function export_items_to_excel(){
    $items = $this->transaction->view_all_items();

    $output = '';

    $output .= "<table class='table' border='1'>
                    <thead>
                        <th style='background-color:#c7c7c7;'>NAME</th>  
                        <th style='background-color:#c7c7c7;'>DESCRIPTION</th>      
                        <th style='background-color:#c7c7c7;'>QUANTITY</th>
                        <th style='background-color:#c7c7c7;'>WEIGHT (KG)</th>
                        <th style='background-color:#c7c7c7;'>HS CODE</th>
                        <th style='background-color:#c7c7c7;'>SERIAL NO.</th>
                        <th style='background-color:#c7c7c7;'>UNIT VALUE</th>
                        <th style='background-color:#c7c7c7;'>CURRENCY</th>
                        <th style='width:220px !important;background-color:#c7c7c7;'>PICTURE</th>
                    </thead>
                    <tbody>
                ";
    foreach($items as $item){ 
    $output .= "
            <tr>
                <td style='text-align:center;'>".$item->item_name."</td>
                <td style='text-align:center;'>".$item->item_description."</td>
                <td style='text-align:center;'>".$item->item_quantity."</td>
                <td style='text-align:center;'>".number_format($item->item_weight, 2)."</td>
                <td style='text-align:center;'>".$item->item_hs_code."</td>
                <td style='text-align:center;'>".$item->item_serial_number."</td>
                <td style='text-align:center;'>".number_format($item->item_unit_value, 2)."</td>
                <td style='text-align:center;'>".$item->item_currency."</td>
                <td style='text-align:center;width:220px !important;height:220px !important;'><img src='".base_url()."assets/uploads/".$item->item_picture."' style='width:200px !important;height:152px !important;'> </td>
            </tr>
                ";
    }
    $output .= "</tbody>
            </table>
        ";
    header("Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
    header("Content-Disposition: attachment; filename=items.xls");
    header("Cache-Control: max-age=0");
    echo $output;
}

Answer 2

使用FCPATH而不是base_url();