PHP学习之提示标签

1.鼠标停留在lable上时，调用jquery-1.8.3.min.js在lable的上方显示title的值。

2.导出利用PHPExcel包，

   将数据输出至浏览器

 

function array_to_excel($arrayHeader,$arrayContent,$download)
    {
          $objExcel = new PHPExcel();//创建一个处理对象实例 
          $objWriter  = new PHPExcel_Writer_Excel2007($objExcel); // 用于 2007 格式 
          $objProps = $objExcel->getProperties(); 
      
          $objExcel->setActiveSheetIndex(0);       
          $objActSheet = $objExcel->getActiveSheet();  

           $objActSheet->setTitle('广告活动（For CPA）报表'); 
           $arrayTitle=array(
               "A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","x"
               ,"Y","Z"
           );
            header_to_excel($arrayHeader,$arrayTitle, $objActSheet);
            content_to_excel($arrayContent,$arrayTitle, $objActSheet);
            
            

          //直接输出到浏览器
        
           $objWriter = new PHPExcel_Writer_Excel5($objExcel);
          header("Pragma: public");
          header("Expires: 0");
          header("Cache-Control:must-revalidate, post-check=0, pre-check=0");
          header("Content-Type:application/force-download");
          header("Content-Type:application/vnd.ms-execl");
          header('Content-Type: application/vnd.ms-excel;charset=utf-8');
          header("Content-Type:application/octet-stream");
          header("Content-Type:application/download");
          header("Content-Disposition:attachment;filename=$download");
          header("Content-Transfer-Encoding:binary");
          $objWriter->save("php://output");
          
    }

3.验证码，加载Authcode.php

 1  <?php
 2  /**
 3   * 验证码类
 4   * @author ZhouHr
 5   * @version 0.1 <2013.10.28>
 6   */
 7 class Imgauthcode extends CI_Controller
 8 {
 9  
10         public function __construct()
11         {
12                 parent::__construct();
13                 $this->load->library('Authcode');
14         }
15  
16         /**
17          * 显示图片
18          *
19          */
20         public function show()
21         {
22                 $this->authcode->show();
23         }
24  
25         /**
26          * js调用显示图片
27          *
28          */
29         public function show_script()
30         {
31                 $this->authcode->showScript();
32         }
33         
34         /**
35          * ajax验证
36          *
37          */
38         /*
39         public function check()
40         {
41                 if ($this->authcode->check($this->uri->segment(3))) {
42                         $xml_data['result'] = 'succeed';
43                         $this->load->library('My_Xml');
44                         echo XML_serialize($xml_data);
45                 } else {
46                         echo '验证码不正确，请重新输入';
47                 }               
48         }
49         */
50 }