PHP基础

1.将整数转成带2位有效数字的小数  sprintf("%1\$.2f",199);

2.excel中日期接收转换： date("Y-m-d H:i:s",intval(($get_row['开票日期']- 25569) * 3600 * 24));

3. excel导出流模式，easy_excel

        Excel::export($data)->store($fileName);
        //$fileName = "./a.xls";
        ob_clean();
        ob_start();
        $handler            = fopen($fileName, 'r+b');
        $file_size          = filesize($fileName);
        Header("Content-type: application/octet-stream");
        Header("Accept-Ranges: bytes");
        Header("Accept-Length: ".$file_size);
        Header("Content-Disposition: attachment; filename=" . basename( $fileName));
        Header('Access-Control-Allow-Origin:*');
        Header('Access-Control-Allow-Methods:POST,GET,OPTIONS,DELETE');
        echo fread($handler,$file_size);
        fclose($handler);
        unlink($fileName);
        ob_end_flush();
        exit;

 

4.excel中创建sql句子

="update waybills set aa='"&B2&"' where goods_order='"&A2&"';"