php+excel通用成绩查询系统 手机网页sae版

夜敏吖_5146

夜敏吖_5146

2016-05-26

5358人浏览

原创

1.   index.php

<?php  include "inc/conn.php";?><?php  include "inc/excel.php";?>html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">


<meta><meta><meta><title><?php  echo $title;?></title><script></script><link><p></p>
<p>
    </p><p><?php  echo $title;?></p>
    <p><a>返回</a></p> 
    <!---<p class="menu" id="topmenus"><a href="admin/" class="d">后台</a></p>--->
<p>
<?php $stime=microtime(true);
$codes = trim($_POST['code']);
$shujus = trim($_POST['time']);
$shuru1 = trim($_POST['name']);
 
if(!$shujus){
?></p>

" id="Codes" onClick="this.src='inc/code.php?t='+new Date();"/>

说明:【+验证码】都输入正确才显示相应结果。

请认真输入你的

认真输入4数字验证码

 ';  echo $shujus;  echo ''; } $data = new Spreadsheet_Excel_Reader(); $data->setOutputEncoding('UTF-8'); $data->read($files); for ($i = 1; $i sheets[0]['numRows']; $i++) {  if($i=="1"){  $iaa=""; for ($j = 1; $j sheets[0]['numCols']; $j++) { $taba = ''.$data->sheets[0]['cells'][$i][$j].'';      $io++;     if($taba==$tiaojian1){       $iaa=$io-1;     } }  }else{  $Excelx=$data->sheets[0]['cells'][$i][$iaa+1]; if("_".$shuru1=="_".$Excelx){  $iae++; echo ''; echo ''; echo ''; for ($j = 1; $j sheets[0]['numCols']; $j++) {  $tabe = ''.$data->sheets[0]['cells']['1'][$j].''; $tabu = ''.$data->sheets[0]['cells'][$i][$j].'';  echo '';  echo '';  echo '';  echo '';  } echo ''; echo '
查询结果' . $iae . '
'.$tabe.''.$tabu.'
'; } } } if($iae';         echo "没有查询到 $shujus 中 $shuru1 相关信息哦";     echo ''; } echo ''; fclose($filer); ?>

"; ?>

  

    © 技术支持  " target="_blank">   


2.  conn.php

<?php error_reporting(0);
header("content-Type: text/html; charset=UTF-8");  //输出编码GBK
 
//设置好以下三项查询条件,得都输入
$tiaojian1="姓名";            //查询条件1列标题,跟excel列头一致,注意无空格;
$UpDir="shujukufangzheli";          //设置数据库所在目录(文件夹名称)请修改,修改后更名对应文件夹。
$title="某某中学成绩查询系统";            //设置查询标题,相信你懂的。
$copyr="某某中学";              //设置底部版权文字,相信你懂的。
$copyu="http://www.96448.cn/";          //设置底部版权连接,相信你懂的。
 
 
 
/*
//  「SAE」免费注册地址:http://t.cn/R4QorPE (免费空间,免费二级域名,免备案)
//  *************************
//  作者主页:http://12391.net
//  作者邮箱:admin@ewuyi.net
//  作者网店:https://aiyaha.taobao.com/
 
//  本店宝贝导航
//  成绩工资水电费通用查询系统解决方案:
  
//  方案3(荐):微信公众号一对一绑定才可以查询工资、成绩、水电费等
//  自助开通试用:http://add.96cha.com/
//  代码购买:https://item.taobao.com/item.htm?id=44248394675
//  整体服务:https://item.taobao.com/item.htm?id=528187132312
  
//  方案2(荐):用户在线登录查询工资成绩水电费等,可自助修改密码
//  自助开通试用:http://add.dbcha.com/
//  代码购买:https://item.taobao.com/item.htm?id=43193387085
//  整体服务:https://item.taobao.com/item.htm?id=528108807297
  
//  方案1:直接通过设定的(1-3个)查询条件查询
//  自助开通试用:http://add.12391.net/ (免费)
//  代码购买:https://item.taobao.com/item.htm?id=528692002051
//  整体服务:https://item.taobao.com/item.htm?id=520023732507
  
//  成绩工资水电费通用查询系统其他方案:
  
//  asp无需后台版(12款): https://item.taobao.com/item.htm?id=45703415332
//  PHP无需后台版(12款):https://item.taobao.com/item.htm?id=45808268273
//  PHP多级下拉版(8款):https://item.taobao.com/item.htm?id=43263796985
//  公众号回复简易版: https://item.taobao.com/item.htm?id=520496908275
//  公众号回复后台简易版即时开通体验: http://new.12391.net
  
//  模糊查询系统解决方案(超过8款):
//  https://item.taobao.com/item.htm?id=520167788658
  
//  网店发货查询系统后台导入通用版网页版加微信自动回复机器人查询
//  即时开通试用:http://add.mabida.cn:1111/
//  整体服务:https://item.taobao.com/item.htm?id=528166721835
//  源码购买:https://item.taobao.com/item.htm?id=44194950836
 
//  农产品质量溯源查询系统 二维码防伪查询微信防伪查询
//  即时开通试用:http://add.mabida.cn/
//  整体服务:https://item.taobao.com/item.htm?id=43525422046
//  源码购买:https://item.taobao.com/item.htm?id=43525422046
 
//  #####以上无需修改但有用注意查看哦######
*/
 
$filephp=".xls";            //数据库文件后缀不要修改
function charaget($data){
  if(!empty($data) ){   
    $fileType = mb_detect_encoding($data , array('UTF-8','GBK','LATIN1','BIG5')) ;  
    if( $fileType != 'UTF-8'){  
      $data = mb_convert_encoding($data ,'utf-8' , $fileType);  
    }  
  }  
  return $data;   
}
//  方案1:直接通过设定的(1-3个)查询条件查询
//  自助开通试用:http://add.12391.net/
//  代码购买:https://item.taobao.com/item.htm?id=528692002051
//  整体服务:https://item.taobao.com/item.htm?id=520023732507
function characet($data){
  if(!empty($data) ){   
    $fileType = mb_detect_encoding($data , array('UTF-8','GBK','LATIN1','BIG5')) ;  
    if( $fileType != 'GBK'){  
      $data = mb_convert_encoding($data ,'GBK' , $fileType);  
    }  
  }  
  return $data;   
}
function webalert($Key){
 $html="<script>
";
 $html.="alert('".$Key."');
";
 $html.="history.go(-1);
";
 $html.="";
 exit($html);
}
function traverse($path = '.',$filephp) {
 $current_dir = opendir($path);    //opendir()返回一个目录句柄,失败返回false
 while(($file = readdir($current_dir)) !== false) {    //readdir()返回打开目录句柄中的一个条目
 $sub_dir = $path . DIRECTORY_SEPARATOR . $file;    //构建子目录路径
 if($file == '.' || $file == '..') {
 //continue;
 } else if(is_dir($sub_dir)) {    //如果是目录,进行递归
 //echo 'Directory ' . $file . ':<br>';
 //traverse($sub_dir);
 } else {    //如果是文件,直接输出
 // echo 'File in Directory ' . $path . ': ' . $file . '<br>';
 $file = str_replace($filephp,"",$file);    //文件名除了后缀,不要包含.php
 echo '<option>' . charaget($file) . '</option>';
 }
 }
}
 
function fileline1($path = '.') {
$data = new Spreadsheet_Excel_Reader();
$data->setOutputEncoding('UTF-8');
$data->read($path);
for ($j = 1; $j sheets[0]['numCols']; $j++) {
$str .= ''.$data->sheets[0]['cells']['1'][$j].'';
}
$str = iconv('UTF-8', 'GB2312', $str);
   return $str;
}
 
function get_file_line( $file_name, $line ){
  $n = 0;
  $handle = fopen($file_name,'r');
  if ($handle) {
    while (!feof($handle)) {
        ++$n;
        $out = fgets($handle, 4096);
        if($line==$n) break;
    }
    fclose($handle);
  }
  if( $line==$n) return $out;
  return false;
}
 
?>

3.   excel.php

<?php define('NUM_BIG_BLOCK_DEPOT_BLOCKS_POS', 0x2c);
define('SMALL_BLOCK_DEPOT_BLOCK_POS', 0x3c);
define('ROOT_START_BLOCK_POS', 0x30);
define('BIG_BLOCK_SIZE', 0x200);
define('SMALL_BLOCK_SIZE', 0x40);
define('EXTENSION_BLOCK_POS', 0x44);
define('NUM_EXTENSION_BLOCK_POS', 0x48);
define('PROPERTY_STORAGE_BLOCK_SIZE', 0x80);
define('BIG_BLOCK_DEPOT_BLOCKS_POS', 0x4c);
define('SMALL_BLOCK_THRESHOLD', 0x1000);
// property storage offsets
define('SIZE_OF_NAME_POS', 0x40);
define('TYPE_POS', 0x42);
define('START_BLOCK_POS', 0x74);
define('SIZE_POS', 0x78);
define('IDENTIFIER_OLE', pack("CCCCCCCC",0xd0,0xcf,0x11,0xe0,0xa1,0xb1,0x1a,0xe1));


function GetInt4d($data, $pos) {
    $value = ord($data[$pos]) | (ord($data[$pos+1])    << 8) | (ord($data[$pos+2]) << 16) | (ord($data[$pos+3]) << 24);
    if ($value>=4294967294) {
        $value=-2;
    }
    return $value;
}

function gmgetdate($ts = null){
    $k = array('seconds','minutes','hours','mday','wday','mon','year','yday','weekday','month',0);
    return(array_comb($k,split(":",gmdate('s:i:G:j:w:n:Y:z:l:F:U',is_null($ts)?time():$ts))));
}

// Added for PHP4 compatibility
function array_comb($array1, $array2) {
    $out = array();
    foreach ($array1 as $key => $value) {
        $out[$value] = $array2[$key];
    }
    return $out;
}

function v($data,$pos) {
    return ord($data[$pos]) | ord($data[$pos+1])error = 1;
            return false;
        }
        $this->data = @file_get_contents($sFileName);
        if (!$this->data) {
            $this->error = 1;
            return false;
        }
        if (substr($this->data, 0, 8) != IDENTIFIER_OLE) {
            $this->error = 1;
            return false;
        }
        $this->numBigBlockDepotBlocks = GetInt4d($this->data, NUM_BIG_BLOCK_DEPOT_BLOCKS_POS);
        $this->sbdStartBlock = GetInt4d($this->data, SMALL_BLOCK_DEPOT_BLOCK_POS);
        $this->rootStartBlock = GetInt4d($this->data, ROOT_START_BLOCK_POS);
        $this->extensionBlock = GetInt4d($this->data, EXTENSION_BLOCK_POS);
        $this->numExtensionBlocks = GetInt4d($this->data, NUM_EXTENSION_BLOCK_POS);

        $bigBlockDepotBlocks = array();
        $pos = BIG_BLOCK_DEPOT_BLOCKS_POS;
        $bbdBlocks = $this->numBigBlockDepotBlocks;
        if ($this->numExtensionBlocks != 0) {
            $bbdBlocks = (BIG_BLOCK_SIZE - BIG_BLOCK_DEPOT_BLOCKS_POS)/4;
        }

        for ($i = 0; $i data, $pos);
            $pos += 4;
        }


        for ($j = 0; $j numExtensionBlocks; $j++) {
            $pos = ($this->extensionBlock + 1) * BIG_BLOCK_SIZE;
            $blocksToRead = min($this->numBigBlockDepotBlocks - $bbdBlocks, BIG_BLOCK_SIZE / 4 - 1);

            for ($i = $bbdBlocks; $i data, $pos);
                $pos += 4;
            }

            $bbdBlocks += $blocksToRead;
            if ($bbdBlocks numBigBlockDepotBlocks) {
                $this->extensionBlock = GetInt4d($this->data, $pos);
            }
        }

        // readBigBlockDepot
        $pos = 0;
        $index = 0;
        $this->bigBlockChain = array();

        for ($i = 0; $i numBigBlockDepotBlocks; $i++) {
            $pos = ($bigBlockDepotBlocks[$i] + 1) * BIG_BLOCK_SIZE;
            //echo "pos = $pos";
            for ($j = 0 ; $j bigBlockChain[$index] = GetInt4d($this->data, $pos);
                $pos += 4 ;
                $index++;
            }
        }

        // readSmallBlockDepot();
        $pos = 0;
        $index = 0;
        $sbdBlock = $this->sbdStartBlock;
        $this->smallBlockChain = array();

        while ($sbdBlock != -2) {
            $pos = ($sbdBlock + 1) * BIG_BLOCK_SIZE;
            for ($j = 0; $j smallBlockChain[$index] = GetInt4d($this->data, $pos);
                $pos += 4;
                $index++;
            }
            $sbdBlock = $this->bigBlockChain[$sbdBlock];
        }


        // readData(rootStartBlock)
        $block = $this->rootStartBlock;
        $pos = 0;
        $this->entry = $this->__readData($block);
        $this->__readPropertySets();
    }

    function __readData($bl) {
        $block = $bl;
        $pos = 0;
        $data = '';
        while ($block != -2)  {
            $pos = ($block + 1) * BIG_BLOCK_SIZE;
            $data = $data.substr($this->data, $pos, BIG_BLOCK_SIZE);
            $block = $this->bigBlockChain[$block];
        }
        return $data;
    }

    function __readPropertySets(){
        $offset = 0;
        while ($offset entry)) {
            $d = substr($this->entry, $offset, PROPERTY_STORAGE_BLOCK_SIZE);
            $nameSize = ord($d[SIZE_OF_NAME_POS]) | (ord($d[SIZE_OF_NAME_POS+1]) props[] = array (
                'name' => $name,
                'type' => $type,
                'startBlock' => $startBlock,
                'size' => $size);
            if ((strtolower($name) == "workbook") || ( strtolower($name) == "book")) {
                $this->wrkbook = count($this->props) - 1;
            }
            if ($name == "Root Entry") {
                $this->rootentry = count($this->props) - 1;
            }
            $offset += PROPERTY_STORAGE_BLOCK_SIZE;
        }

    }


    function getWorkBook(){
        if ($this->props[$this->wrkbook]['size'] __readData($this->props[$this->rootentry]['startBlock']);
            $streamData = '';
            $block = $this->props[$this->wrkbook]['startBlock'];
            $pos = 0;
            while ($block != -2) {
                $pos = $block * SMALL_BLOCK_SIZE;
                $streamData .= substr($rootdata, $pos, SMALL_BLOCK_SIZE);
                $block = $this->smallBlockChain[$block];
            }
            return $streamData;
        }else{
            $numBlocks = $this->props[$this->wrkbook]['size'] / BIG_BLOCK_SIZE;
            if ($this->props[$this->wrkbook]['size'] % BIG_BLOCK_SIZE != 0) {
                $numBlocks++;
            }

            if ($numBlocks == 0) return '';
            $streamData = '';
             $block = $this->props[$this->wrkbook]['startBlock'];
            $pos = 0;
            while ($block != -2) {
                $pos = ($block + 1) * BIG_BLOCK_SIZE;
                $streamData .= substr($this->data, $pos, BIG_BLOCK_SIZE);
                $block = $this->bigBlockChain[$block];
            }
            return $streamData;
        }
    }

}

define('SPREADSHEET_EXCEL_READER_BIFF8',          0x600);
define('SPREADSHEET_EXCEL_READER_BIFF7',          0x500);
define('SPREADSHEET_EXCEL_READER_WORKBOOKGLOBALS',   0x5);
define('SPREADSHEET_EXCEL_READER_WORKSHEET',       0x10);
define('SPREADSHEET_EXCEL_READER_TYPE_BOF',         0x809);
define('SPREADSHEET_EXCEL_READER_TYPE_EOF',         0x0a);
define('SPREADSHEET_EXCEL_READER_TYPE_BOUNDSHEET',   0x85);
define('SPREADSHEET_EXCEL_READER_TYPE_DIMENSION',  0x200);
define('SPREADSHEET_EXCEL_READER_TYPE_ROW',         0x208);
define('SPREADSHEET_EXCEL_READER_TYPE_DBCELL',    0xd7);
define('SPREADSHEET_EXCEL_READER_TYPE_FILEPASS',    0x2f);
define('SPREADSHEET_EXCEL_READER_TYPE_NOTE',       0x1c);
define('SPREADSHEET_EXCEL_READER_TYPE_TXO',         0x1b6);
define('SPREADSHEET_EXCEL_READER_TYPE_RK',       0x7e);
define('SPREADSHEET_EXCEL_READER_TYPE_RK2',         0x27e);
define('SPREADSHEET_EXCEL_READER_TYPE_MULRK',     0xbd);
define('SPREADSHEET_EXCEL_READER_TYPE_MULBLANK',    0xbe);
define('SPREADSHEET_EXCEL_READER_TYPE_INDEX',     0x20b);
define('SPREADSHEET_EXCEL_READER_TYPE_SST',         0xfc);
define('SPREADSHEET_EXCEL_READER_TYPE_EXTSST',    0xff);
define('SPREADSHEET_EXCEL_READER_TYPE_CONTINUE',    0x3c);
define('SPREADSHEET_EXCEL_READER_TYPE_LABEL',     0x204);
define('SPREADSHEET_EXCEL_READER_TYPE_LABELSST',    0xfd);
define('SPREADSHEET_EXCEL_READER_TYPE_NUMBER',    0x203);
define('SPREADSHEET_EXCEL_READER_TYPE_NAME',       0x18);
define('SPREADSHEET_EXCEL_READER_TYPE_ARRAY',     0x221);
define('SPREADSHEET_EXCEL_READER_TYPE_STRING',    0x207);
define('SPREADSHEET_EXCEL_READER_TYPE_FORMULA',      0x406);
define('SPREADSHEET_EXCEL_READER_TYPE_FORMULA2',    0x6);
define('SPREADSHEET_EXCEL_READER_TYPE_FORMAT',    0x41e);
define('SPREADSHEET_EXCEL_READER_TYPE_XF',       0xe0);
define('SPREADSHEET_EXCEL_READER_TYPE_BOOLERR',      0x205);
define('SPREADSHEET_EXCEL_READER_TYPE_FONT',     0x0031);
define('SPREADSHEET_EXCEL_READER_TYPE_PALETTE',      0x0092);
define('SPREADSHEET_EXCEL_READER_TYPE_UNKNOWN',      0xffff);
define('SPREADSHEET_EXCEL_READER_TYPE_NINETEENFOUR', 0x22);
define('SPREADSHEET_EXCEL_READER_TYPE_MERGEDCELLS',  0xE5);
define('SPREADSHEET_EXCEL_READER_UTCOFFSETDAYS' ,  25569);
define('SPREADSHEET_EXCEL_READER_UTCOFFSETDAYS1904', 24107);
define('SPREADSHEET_EXCEL_READER_MSINADAY',         86400);
define('SPREADSHEET_EXCEL_READER_TYPE_HYPER',       0x01b8);
define('SPREADSHEET_EXCEL_READER_TYPE_COLINFO',         0x7d);
define('SPREADSHEET_EXCEL_READER_TYPE_DEFCOLWIDTH',  0x55);
define('SPREADSHEET_EXCEL_READER_TYPE_STANDARDWIDTH', 0x99);
define('SPREADSHEET_EXCEL_READER_DEF_NUM_FORMAT',  "%s");


/*
* Main Class
*/
class Spreadsheet_Excel_Reader {

    // MK: Added to make data retrieval easier
    var $colnames = array();
    var $colindexes = array();
    var $standardColWidth = 0;
    var $defaultColWidth = 0;

    function myHex($d) {
        if ($d myHex(ord($data[$pos + $i])) . (ord($data[$pos + $i])>31? "[" . $data[$pos + $i] . "]":'');
        }
        return $info;
    }

    function getCol($col) {
        if (is_string($col)) {
            $col = strtolower($col);
            if (array_key_exists($col,$this->colnames)) {
                $col = $this->colnames[$col];
            }
        }
        return $col;
    }

    // PUBLIC API FUNCTIONS
    // --------------------

    function val($row,$col,$sheet=0) {
        $col = $this->getCol($col);
        if (array_key_exists($row,$this->sheets[$sheet]['cells']) && array_key_exists($col,$this->sheets[$sheet]['cells'][$row])) {
            return $this->sheets[$sheet]['cells'][$row][$col];
        }
        return "";
    }
    function value($row,$col,$sheet=0) {
        return $this->val($row,$col,$sheet);
    }
    function info($row,$col,$type='',$sheet=0) {
        $col = $this->getCol($col);
        if (array_key_exists('cellsInfo',$this->sheets[$sheet])
            && array_key_exists($row,$this->sheets[$sheet]['cellsInfo'])
            && array_key_exists($col,$this->sheets[$sheet]['cellsInfo'][$row])
            && array_key_exists($type,$this->sheets[$sheet]['cellsInfo'][$row][$col])) {
            return $this->sheets[$sheet]['cellsInfo'][$row][$col][$type];
        }
        return "";
    }
    function type($row,$col,$sheet=0) {
        return $this->info($row,$col,'type',$sheet);
    }
    function raw($row,$col,$sheet=0) {
        return $this->info($row,$col,'raw',$sheet);
    }
    function rowspan($row,$col,$sheet=0) {
        $val = $this->info($row,$col,'rowspan',$sheet);
        if ($val=="") { return 1; }
        return $val;
    }
    function colspan($row,$col,$sheet=0) {
        $val = $this->info($row,$col,'colspan',$sheet);
        if ($val=="") { return 1; }
        return $val;
    }
    function hyperlink($row,$col,$sheet=0) {
        $link = $this->sheets[$sheet]['cellsInfo'][$row][$col]['hyperlink'];
        if ($link) {
            return $link['link'];
        }
        return '';
    }
    function rowcount($sheet=0) {
        return $this->sheets[$sheet]['numRows'];
    }
    function colcount($sheet=0) {
        return $this->sheets[$sheet]['numCols'];
    }
    function colwidth($col,$sheet=0) {
        // Col width is actually the width of the number 0. So we have to estimate and come close
        return $this->colInfo[$sheet][$col]['width']/9142*200;
    }
    function colhidden($col,$sheet=0) {
        return !!$this->colInfo[$sheet][$col]['hidden'];
    }
    function rowheight($row,$sheet=0) {
        return $this->rowInfo[$sheet][$row]['height'];
    }
    function rowhidden($row,$sheet=0) {
        return !!$this->rowInfo[$sheet][$row]['hidden'];
    }

    // GET THE CSS FOR FORMATTING
    // ==========================
    function style($row,$col,$sheet=0,$properties='') {
        $css = "";
        $font=$this->font($row,$col,$sheet);
        if ($font!="") {
            $css .= "font-family:$font;";
        }
        $align=$this->align($row,$col,$sheet);
        if ($align!="") {
            $css .= "text-align:$align;";
        }
        $height=$this->height($row,$col,$sheet);
        if ($height!="") {
            $css .= "font-size:$height"."px;";
        }
        $bgcolor=$this->bgColor($row,$col,$sheet);
        if ($bgcolor!="") {
            $bgcolor = $this->colors[$bgcolor];
            $css .= "background-color:$bgcolor;";
        }
        $color=$this->color($row,$col,$sheet);
        if ($color!="") {
            $css .= "color:$color;";
        }
         $bold=$this->bold($row,$col,$sheet);
    if ($bold) {
        $css .= "font-weight:bold;";
    }
    $italic=$this->italic($row,$col,$sheet);
    if ($italic) {
        $css .= "font-style:italic;";
    }
    $underline=$this->underline($row,$col,$sheet);
    if ($underline) {
        $css .= "text-decoration:underline;";
    }
    // Borders
    $bLeft = $this->borderLeft($row,$col,$sheet);
    $bRight = $this->borderRight($row,$col,$sheet);
    $bTop = $this->borderTop($row,$col,$sheet);
    $bBottom = $this->borderBottom($row,$col,$sheet);
    $bLeftCol = $this->borderLeftColor($row,$col,$sheet);
    $bRightCol = $this->borderRightColor($row,$col,$sheet);
    $bTopCol = $this->borderTopColor($row,$col,$sheet);
    $bBottomCol = $this->borderBottomColor($row,$col,$sheet);
    // Try to output the minimal required style
    if ($bLeft!="" && $bLeft==$bRight && $bRight==$bTop && $bTop==$bBottom) {
        $css .= "border:" . $this->lineStylesCss[$bLeft] .";";
    }
    else {
        if ($bLeft!="") { $css .= "border-left:" . $this->lineStylesCss[$bLeft] .";"; }
        if ($bRight!="") { $css .= "border-right:" . $this->lineStylesCss[$bRight] .";"; }
        if ($bTop!="") { $css .= "border-top:" . $this->lineStylesCss[$bTop] .";"; }
        if ($bBottom!="") { $css .= "border-bottom:" . $this->lineStylesCss[$bBottom] .";"; }
    }
    // Only output border colors if there is an actual border specified
    if ($bLeft!="" && $bLeftCol!="") { $css .= "border-left-color:" . $bLeftCol .";"; }
    if ($bRight!="" && $bRightCol!="") { $css .= "border-right-color:" . $bRightCol .";"; }
    if ($bTop!="" && $bTopCol!="") { $css .= "border-top-color:" . $bTopCol . ";"; }
    if ($bBottom!="" && $bBottomCol!="") { $css .= "border-bottom-color:" . $bBottomCol .";"; }

    return $css;
}

// FORMAT PROPERTIES
// =================
function format($row,$col,$sheet=0) {
    return $this->info($row,$col,'format',$sheet);
}
function formatIndex($row,$col,$sheet=0) {
    return $this->info($row,$col,'formatIndex',$sheet);
}
function formatColor($row,$col,$sheet=0) {
    return $this->info($row,$col,'formatColor',$sheet);
}

// CELL (XF) PROPERTIES
// ====================
function xfRecord($row,$col,$sheet=0) {
    $xfIndex = $this->info($row,$col,'xfIndex',$sheet);
    if ($xfIndex!="") {
        return $this->xfRecords[$xfIndex];
    }
    return null;
}
function xfProperty($row,$col,$sheet,$prop) {
    $xfRecord = $this->xfRecord($row,$col,$sheet);
    if ($xfRecord!=null) {
        return $xfRecord[$prop];
    }
    return "";
}
function align($row,$col,$sheet=0) {
    return $this->xfProperty($row,$col,$sheet,'align');
}
function bgColor($row,$col,$sheet=0) {
    return $this->xfProperty($row,$col,$sheet,'bgColor');
}
function borderLeft($row,$col,$sheet=0) {
    return $this->xfProperty($row,$col,$sheet,'borderLeft');
}
function borderRight($row,$col,$sheet=0) {
    return $this->xfProperty($row,$col,$sheet,'borderRight');
}
function borderTop($row,$col,$sheet=0) {
    return $this->xfProperty($row,$col,$sheet,'borderTop');
}
function borderBottom($row,$col,$sheet=0) {
    return $this->xfProperty($row,$col,$sheet,'borderBottom');
}
function borderLeftColor($row,$col,$sheet=0) {
    return $this->colors[$this->xfProperty($row,$col,$sheet,'borderLeftColor')];
}
function borderRightColor($row,$col,$sheet=0) {
    return $this->colors[$this->xfProperty($row,$col,$sheet,'borderRightColor')];
}
function borderTopColor($row,$col,$sheet=0) {
    return $this->colors[$this->xfProperty($row,$col,$sheet,'borderTopColor')];
}
function borderBottomColor($row,$col,$sheet=0) {
    return $this->colors[$this->xfProperty($row,$col,$sheet,'borderBottomColor')];
}

// FONT PROPERTIES
// ===============
function fontRecord($row,$col,$sheet=0) {
    $xfRecord = $this->xfRecord($row,$col,$sheet);
    if ($xfRecord!=null) {
        $font = $xfRecord['fontIndex'];
        if ($font!=null) {
            return $this->fontRecords[$font];
        }
    }
    return null;
}
function fontProperty($row,$col,$sheet=0,$prop) {
    $font = $this->fontRecord($row,$col,$sheet);
    if ($font!=null) {
        return $font[$prop];
    }
    return false;
}
function fontIndex($row,$col,$sheet=0) {
    return $this->xfProperty($row,$col,$sheet,'fontIndex');
}
function color($row,$col,$sheet=0) {
    $formatColor = $this->formatColor($row,$col,$sheet);
    if ($formatColor!="") {
        return $formatColor;
    }
    $ci = $this->fontProperty($row,$col,$sheet,'color');
    return $this->rawColor($ci);
}
function rawColor($ci) {
    if (($ci  0x7FFF) && ($ci  '')) {
        return $this->colors[$ci];
    }
    return "";
}
function bold($row,$col,$sheet=0) {
    return $this->fontProperty($row,$col,$sheet,'bold');
}
function italic($row,$col,$sheet=0) {
    return $this->fontProperty($row,$col,$sheet,'italic');
}
function underline($row,$col,$sheet=0) {
    return $this->fontProperty($row,$col,$sheet,'under');
}
function height($row,$col,$sheet=0) {
    return $this->fontProperty($row,$col,$sheet,'height');
}
function font($row,$col,$sheet=0) {
    return $this->fontProperty($row,$col,$sheet,'font');
}

// DUMP AN HTML TABLE OF THE ENTIRE XLS DATA
// =========================================
function dump($row_numbers=false,$col_letters=false,$sheet=0,$table_class='excel') {
    $out = "
";     if ($col_letters) {         $out .= "";         if ($row_numbers) {             $out .= " ";         }         for($i=1;$icolcount($sheet);$i++) {             $style = "width:" . ($this->colwidth($i,$sheet)*1) . "px;";             if ($this->colhidden($i,$sheet)) {                 $style .= "display:none;";             }             $out .= " ";         }         $out .= " ";     }     $out .= " ";     for($row=1;$rowrowcount($sheet);$row++) {         $rowheight = $this->rowheight($row,$sheet);         $style = "height:" . ($rowheight*(4/3)) . "px;";         if ($this->rowhidden($row,$sheet)) {             $style .= "display:none;";         }         $out .= " ";         if ($row_numbers) {             $out .= " ";         }         for($col=1;$colcolcount($sheet);$col++) {             // Account for Rowspans/Colspans             $rowspan = $this->rowspan($row,$col,$sheet);             $colspan = $this->colspan($row,$col,$sheet);             for($i=0;$i0 || $j>0) {                         $this->sheets[$sheet]['cellsInfo'][$row+$i][$col+$j]['dontprint']=1;                     }                 }             }             if(!$this->sheets[$sheet]['cellsInfo'][$row][$col]['dontprint']) {                 $style = $this->style($row,$col,$sheet);                 if ($this->colhidden($col,$sheet)) {                     $style .= "display:none;";                 }                 $out .= " ";             }         }         $out .= " ";     }     $out .= "
&nbsp" . strtoupper($this->colindexes[$i]) . "
$row 1?" colspan=$colspan":"") . ($rowspan > 1?" rowspan=$rowspan":"") . ">";                 $val = $this->val($row,$col,$sheet);                 if ($val=='') { $val=" "; }                 else {                     $val = htmlentities($val);                     $link = $this->hyperlink($row,$col,$sheet);                     if ($link!='') {                         $val = "$val";                     }                 }                 $out .= "".nl2br($val)."";                 $out .= "
";     return $out; } // -------------- // END PUBLIC API var $boundsheets = array(); var $formatRecords = array(); var $fontRecords = array(); var $xfRecords = array(); var $colInfo = array(); var $rowInfo = array(); var $sst = array(); var $sheets = array(); var $data; var $_ole; var $_defaultEncoding = "gb2312"; var $_defaultFormat = SPREADSHEET_EXCEL_READER_DEF_NUM_FORMAT; var $_columnsFormat = array(); var $_rowoffset = 1; var $_coloffset = 1; /**  * List of default date formats used by Excel  */  var $dateFormats = array (     0xe => "m/d/Y",     0xf => "M-d-Y",     0x10 => "d-M",     0x11 => "M-Y",     0x12 => "h:i a",     0x13 => "h:i:s a",     0x14 => "H:i",     0x15 => "H:i:s",     0x16 => "d/m/Y H:i",     0x2d => "i:s",     0x2e => "H:i:s",     0x2f => "i:s.S" ); /**  * Default number formats used by Excel  */ var $numberFormats = array(     0x1 => "0",     0x2 => "0.00",     0x3 => "#,##0",     0x4 => "#,##0.00",     0x5 => "$#,##0;($#,##0)",     0x6 => "$#,##0;[Red]($#,##0)",     0x7 => "$#,##0.00;($#,##0.00)",     0x8 => "$#,##0.00;[Red]($#,##0.00)",     0x9 => "0%",     0xa => "0.00%",     0xb => "0.00E+00",     0x25 => "#,##0;(#,##0)",     0x26 => "#,##0;[Red](#,##0)",     0x27 => "#,##0.00;(#,##0.00)",     0x28 => "#,##0.00;[Red](#,##0.00)",     0x29 => "#,##0;(#,##0)",  // Not exactly     0x2a => "$#,##0;($#,##0)",  // Not exactly     0x2b => "#,##0.00;(#,##0.00)",  // Not exactly     0x2c => "$#,##0.00;($#,##0.00)",  // Not exactly     0x30 => "##0.0E+0" ); var $colors = Array(     0x00 => "#000000",     0x01 => "#FFFFFF",     0x02 => "#FF0000",     0x03 => "#00FF00",     0x04 => "#0000FF",     0x05 => "#FFFF00",     0x06 => "#FF00FF",     0x07 => "#00FFFF",     0x08 => "#000000",     0x09 => "#FFFFFF",     0x0A => "#FF0000",     0x0B => "#00FF00",     0x0C => "#0000FF",     0x0D => "#FFFF00",     0x0E => "#FF00FF",     0x0F => "#00FFFF",     0x10 => "#800000",     0x11 => "#008000",     0x12 => "#000080",     0x13 => "#808000",     0x14 => "#800080",     0x15 => "#008080",     0x16 => "#C0C0C0",     0x17 => "#808080",     0x18 => "#9999FF",     0x19 => "#993366",     0x1A => "#FFFFCC",     0x1B => "#CCFFFF",     0x1C => "#660066",     0x1D => "#FF8080",     0x1E => "#0066CC",     0x1F => "#CCCCFF",     0x20 => "#000080",     0x21 => "#FF00FF",     0x22 => "#FFFF00",     0x23 => "#00FFFF",     0x24 => "#800080",     0x25 => "#800000",     0x26 => "#008080",     0x27 => "#0000FF",     0x28 => "#00CCFF",     0x29 => "#CCFFFF",     0x2A => "#CCFFCC",     0x2B => "#FFFF99",     0x2C => "#99CCFF",     0x2D => "#FF99CC",     0x2E => "#CC99FF",     0x2F => "#FFCC99",     0x30 => "#3366FF",     0x31 => "#33CCCC",     0x32 => "#99CC00",     0x33 => "#FFCC00",     0x34 => "#FF9900",     0x35 => "#FF6600",     0x36 => "#666699",     0x37 => "#969696",     0x38 => "#003366",     0x39 => "#339966",     0x3A => "#003300",     0x3B => "#333300",     0x3C => "#993300",     0x3D => "#993366",     0x3E => "#333399",     0x3F => "#333333",     0x40 => "#000000",     0x41 => "#FFFFFF",     0x43 => "#000000",     0x4D => "#000000",     0x4E => "#FFFFFF",     0x4F => "#000000",     0x50 => "#FFFFFF",     0x51 => "#000000",     0x7FFF => "#000000" ); var $lineStyles = array(     0x00 => "",     0x01 => "Thin",     0x02 => "Medium",     0x03 => "Dashed",     0x04 => "Dotted",     0x05 => "Thick",     0x06 => "Double",     0x07 => "Hair",     0x08 => "Medium dashed",     0x09 => "Thin dash-dotted",     0x0A => "Medium dash-dotted",     0x0B => "Thin dash-dot-dotted",     0x0C => "Medium dash-dot-dotted",     0x0D => "Slanted medium dash-dotted" ); var $lineStylesCss = array(     "Thin" => "1px solid",     "Medium" => "2px solid",     "Dashed" => "1px dashed",     "Dotted" => "1px dotted",     "Thick" => "3px solid",     "Double" => "double",     "Hair" => "1px solid",     "Medium dashed" => "2px dashed",     "Thin dash-dotted" => "1px dashed",     "Medium dash-dotted" => "2px dashed",     "Thin dash-dot-dotted" => "1px dashed",     "Medium dash-dot-dotted" => "2px dashed",     "Slanted medium dash-dotte" => "2px dashed" ); function read16bitstring($data, $start) {     $len = 0;     while (ord($data[$start + $len]) + ord($data[$start + $len + 1]) > 0) $len++;     return substr($data, $start, $len); } // ADDED by Matt Kruse for better formatting function _format_value($format,$num,$f) {     // 49==TEXT format     // http://code.google.com/p/php-excel-reader/issues/detail?id=7     if ( (!$f && $format=="%s") || ($f==49) || ($format=="GENERAL") ) {         return array('string'=>$num, 'formatColor'=>null);     }     // Custom pattern can be POSITIVE;NEGATIVE;ZERO     // The "text" option as 4th parameter is not handled     $parts = split(";",$format);     $pattern = $parts[0];     // Negative pattern     if (count($parts)>2 && $num==0) {         $pattern = $parts[2];     }     // Zero pattern     if (count($parts)>1 && $num$pattern,         'formatColor'=>$color     ); } /**  * Constructor  *  * Some basic initialisation  */ function Spreadsheet_Excel_Reader($file='',$store_extended_info=true,$outputEncoding='') {     $this->_ole =& new OLERead();     $this->setUTFEncoder('iconv');     if ($outputEncoding != '') {         $this->setOutputEncoding($outputEncoding);     }     for ($i=1; $i=1)?chr(($i-1)/26+64):'') . chr(($i-1)%26+65));         $this->colnames[$name] = $i;         $this->colindexes[$i] = $name;     }     $this->store_extended_info = $store_extended_info;     if ($file!="") {         $this->read($file);     } } /**  * Set the encoding method  */ function setOutputEncoding($encoding) {     $this->_defaultEncoding = $encoding; } /**  *  $encoder = 'iconv' or 'mb'  *  set iconv if you would like use 'iconv' for encode UTF-16LE to your encoding  *  set mb if you would like use 'mb_convert_encoding' for encode UTF-16LE to your encoding  */ function setUTFEncoder($encoder = 'iconv') {     $this->_encoderFunction = '';     if ($encoder == 'iconv') {         $this->_encoderFunction = function_exists('iconv') ? 'iconv' : '';     } elseif ($encoder == 'mb') {         $this->_encoderFunction = function_exists('mb_convert_encoding') ? 'mb_convert_encoding' : '';     } } function setRowColOffset($iOffset) {     $this->_rowoffset = $iOffset;     $this->_coloffset = $iOffset; } /**  * Set the default number format  */ function setDefaultFormat($sFormat) {     $this->_defaultFormat = $sFormat; } /**  * Force a column to use a certain format  */ function setColumnFormat($column, $sFormat) {     $this->_columnsFormat[$column] = $sFormat; } /**  * Read the spreadsheet file using OLE, then parse  */ function read($sFileName) {     $res = $this->_ole->read($sFileName);     // oops, something goes wrong (Darko Miljanovic)     if($res === false) {         // check error code         if($this->_ole->error == 1) {             // bad file             die('The filename ' . $sFileName . ' is not readable');         }         // check other error codes here (eg bad fileformat, etc...)     }     $this->data = $this->_ole->getWorkBook();     $this->_parse(); } /**  * Parse a workbook  *  * @access private  * @return bool  */ function _parse() {     $pos = 0;     $data = $this->data;     $code = v($data,$pos);     $length = v($data,$pos+2);     $version = v($data,$pos+4);     $substreamType = v($data,$pos+6);     $this->version = $version;     if (($version != SPREADSHEET_EXCEL_READER_BIFF8) &&         ($version != SPREADSHEET_EXCEL_READER_BIFF7)) {         return false;     }     if ($substreamType != SPREADSHEET_EXCEL_READER_WORKBOOKGLOBALS){         return false;     }     $pos += $length + 4;     $code = v($data,$pos);     $length = v($data,$pos+2);     while ($code != SPREADSHEET_EXCEL_READER_TYPE_EOF) {         switch ($code) {             case SPREADSHEET_EXCEL_READER_TYPE_SST:                 $spos = $pos + 4;                 $limitpos = $spos + $length;                 $uniqueStrings = $this->_GetInt4d($data, $spos+4);                 $spos += 8;                 for ($i = 0; $i _GetInt4d($data, $spos);                             $spos += 4;                         }                         $len = ($asciiEncoding)? $numChars : $numChars*2;                         if ($spos + $len  0){                                 $opcode = v($data,$spos);                                 $conlength = v($data,$spos+2);                                 if ($opcode != 0x3c) {                                     return -1;                                 }                                 $spos += 4;                                 $limitpos = $spos + $conlength;                                 $option = ord($data[$spos]);                                 $spos += 1;                                 if ($asciiEncoding && ($option == 0)) {                                     $len = min($charsLeft, $limitpos - $spos); // min($charsLeft, $conlength);                                     $retstr .= substr($data, $spos, $len);                                     $charsLeft -= $len;                                     $asciiEncoding = true;                                 }                                 elseif (!$asciiEncoding && ($option != 0)) {                                     $len = min($charsLeft * 2, $limitpos - $spos); // min($charsLeft, $conlength);                                     $retstr .= substr($data, $spos, $len);                                     $charsLeft -= $len/2;                                     $asciiEncoding = false;                                 }                                 elseif (!$asciiEncoding && ($option == 0)) {                                     // Bummer - the string starts off as Unicode, but after the                                     // continuation it is in straightforward ASCII encoding                                     $len = min($charsLeft, $limitpos - $spos); // min($charsLeft, $conlength);                                     for ($j = 0; $j _encodeUTF16($retstr);                         if ($richString){                             $spos += 4 * $formattingRuns;                         }                         // For extended strings, skip over the extended string data                         if ($extendedString) {                             $spos += $extendedRunLength;                         }                         $this->sst[]=$retstr;                     }                     break;                 case SPREADSHEET_EXCEL_READER_TYPE_FILEPASS:                     return false;                     break;                 case SPREADSHEET_EXCEL_READER_TYPE_NAME:                     break;                 case SPREADSHEET_EXCEL_READER_TYPE_FORMAT:                     $indexCode = v($data,$pos+4);                     if ($version == SPREADSHEET_EXCEL_READER_BIFF8) {                         $numchars = v($data,$pos+6);                         if (ord($data[$pos+8]) == 0){                             $formatString = substr($data, $pos+9, $numchars);                         } else {                             $formatString = substr($data, $pos+9, $numchars*2);                         }                     } else {                         $numchars = ord($data[$pos+6]);                         $formatString = substr($data, $pos+7, $numchars*2);                     }                     $this->formatRecords[$indexCode] = $formatString;                     break;                 case SPREADSHEET_EXCEL_READER_TYPE_FONT:                     $height = v($data,$pos+4);                     $option = v($data,$pos+6);                     $color = v($data,$pos+8);                     $weight = v($data,$pos+10);                     $under  = ord($data[$pos+14]);                     $font = "";                     // Font name                     $numchars = ord($data[$pos+18]);                     if ((ord($data[$pos+19]) & 1) == 0){                         $font = substr($data, $pos+20, $numchars);                     } else {                         $font = substr($data, $pos+20, $numchars*2);                         $font =  $this->_encodeUTF16($font);                     }                     $this->fontRecords[] = array(                         'height' => $height / 20,                         'italic' => !!($option & 2),                         'color' => $color,                         'under' => !($under==0),                         'bold' => ($weight==700),                         'font' => $font,                         'raw' => $this->dumpHexData($data, $pos+3, $length)                     );                     break;                 case SPREADSHEET_EXCEL_READER_TYPE_PALETTE:                     $colors = ord($data[$pos+4]) | ord($data[$pos+5]) colors[0x07 + $coli] = '#' . $this->myhex($colr) . $this->myhex($colg) . $this->myhex($colb);                     }                     break;                 case SPREADSHEET_EXCEL_READER_TYPE_XF:                     $fontIndexCode = (ord($data[$pos+4]) | ord($data[$pos+5]) > 7;                     $align = "";                     if ($alignbit==3) { $align="right"; }                     if ($alignbit==2) { $align="center"; }                     $fillPattern = (ord($data[$pos+21]) & 0xFC) >> 2;                     if ($fillPattern == 0) {                         $bgcolor = "";                     }                     $xf = array();                     $xf['formatIndex'] = $indexCode;                     $xf['align'] = $align;                     $xf['fontIndex'] = $fontIndexCode;                     $xf['bgColor'] = $bgcolor;                     $xf['fillPattern'] = $fillPattern;                     $border = ord($data[$pos+14]) | (ord($data[$pos+15]) lineStyles[($border & 0xF)];                     $xf['borderRight'] = $this->lineStyles[($border & 0xF0) >> 4];                     $xf['borderTop'] = $this->lineStyles[($border & 0xF00) >> 8];                     $xf['borderBottom'] = $this->lineStyles[($border & 0xF000) >> 12];                     $xf['borderLeftColor'] = ($border & 0x7F0000) >> 16;                     $xf['borderRightColor'] = ($border & 0x3F800000) >> 23;                     $border = (ord($data[$pos+18]) | ord($data[$pos+19]) > 7;                     if (array_key_exists($indexCode, $this->dateFormats)) {                         $xf['type'] = 'date';                         $xf['format'] = $this->dateFormats[$indexCode];                         if ($align=='') { $xf['align'] = 'right'; }                     }elseif (array_key_exists($indexCode, $this->numberFormats)) {                         $xf['type'] = 'number';                         $xf['format'] = $this->numberFormats[$indexCode];                         if ($align=='') { $xf['align'] = 'right'; }                     }else{                         $isdate = FALSE;                         $formatstr = '';                         if ($indexCode > 0){                             if (isset($this->formatRecords[$indexCode]))                                 $formatstr = $this->formatRecords[$indexCode];                             if ($formatstr!="") {                                 $tmp = preg_replace("/;.*/","",$formatstr);                                 $tmp = preg_replace("/^[[^]]*]/","",$tmp);                                 if (preg_match("/[^hmsday/-:s\,AMP]/i", $tmp) == 0) { // found day and time format                                     $isdate = TRUE;                                     $formatstr = $tmp;                                     $formatstr = str_replace(array('AM/PM','mmmm','mmm'), array('a','F','M'), $formatstr);                                     // m/mm are used for both minutes and months - oh SNAP!                                     // This mess tries to fix for that.                                     // 'm' == minutes only if following h/hh or preceding s/ss                                     $formatstr = preg_replace("/(h:?)mm?/","$1i", $formatstr);                                     $formatstr = preg_replace("/mm?(:?s)/","i$1", $formatstr);                                     // A single 'm' = n in PHP                                     $formatstr = preg_replace("/(^|[^m])m([^m]|$)/", '$1n$2', $formatstr);                                     $formatstr = preg_replace("/(^|[^m])m([^m]|$)/", '$1n$2', $formatstr);                                     // else it's months                                     $formatstr = str_replace('mm', 'm', $formatstr);                                     // Convert single 'd' to 'j'                                     $formatstr = preg_replace("/(^|[^d])d([^d]|$)/", '$1j$2', $formatstr);                                     $formatstr = str_replace(array('dddd','ddd','dd','yyyy','yy','hh','h'), array('l','D','d','Y','y','H','g'), $formatstr);                                     $formatstr = preg_replace("/ss?/", 's', $formatstr);                                 }                             }                         }                         if ($isdate){                             $xf['type'] = 'date';                             $xf['format'] = $formatstr;                             if ($align=='') { $xf['align'] = 'right'; }                         }else{                             // If the format string has a 0 or # in it, we'll assume it's a number                             if (preg_match("/[0#]/", $formatstr)) {                                 $xf['type'] = 'number';                                 if ($align=='') { $xf['align']='right'; }                             }                             else {                                 $xf['type'] = 'other';                             }                             $xf['format'] = $formatstr;                             $xf['code'] = $indexCode;                         }                     }                     $this->xfRecords[] = $xf;                     break;                      case SPREADSHEET_EXCEL_READER_TYPE_NINETEENFOUR:                 $this->nineteenFour = (ord($data[$pos+4]) == 1);                 break;             case SPREADSHEET_EXCEL_READER_TYPE_BOUNDSHEET:                 $rec_offset = $this->_GetInt4d($data, $pos+4);                 $rec_typeFlag = ord($data[$pos+8]);                 $rec_visibilityFlag = ord($data[$pos+9]);                 $rec_length = ord($data[$pos+10]);                 if ($version == SPREADSHEET_EXCEL_READER_BIFF8){                     $chartype =  ord($data[$pos+11]);                     if ($chartype == 0){                         $rec_name  = substr($data, $pos+12, $rec_length);                     } else {                         $rec_name  = $this->_encodeUTF16(substr($data, $pos+12, $rec_length*2));                     }                 }elseif ($version == SPREADSHEET_EXCEL_READER_BIFF7){                     $rec_name  = substr($data, $pos+11, $rec_length);                 }                 $this->boundsheets[] = array('name'=>$rec_name,'offset'=>$rec_offset);                 break;         }         $pos += $length + 4;         $code = ord($data[$pos]) | ord($data[$pos+1])boundsheets as $key=>$val){         $this->sn = $key;         $this->_parsesheet($val['offset']);     }     return true; } /**  * Parse a worksheet  */ function _parsesheet($spos) {     $cont = true;     $data = $this->data;     // read BOF     $code = ord($data[$spos]) | ord($data[$spos+1])sheets[$this->sn]['maxrow'] = $this->_rowoffset - 1;         $this->sheets[$this->sn]['maxcol'] = $this->_coloffset - 1;         unset($this->rectype);         switch ($code) {             case SPREADSHEET_EXCEL_READER_TYPE_DIMENSION:                 if (!isset($this->numRows)) {                     if (($length == 10) ||  ($version == SPREADSHEET_EXCEL_READER_BIFF7)){                         $this->sheets[$this->sn]['numRows'] = ord($data[$spos+2]) | ord($data[$spos+3]) sheets[$this->sn]['numCols'] = ord($data[$spos+6]) | ord($data[$spos+7]) sheets[$this->sn]['numRows'] = ord($data[$spos+4]) | ord($data[$spos+5]) sheets[$this->sn]['numCols'] = ord($data[$spos+10]) | ord($data[$spos+11])  0) {                         $this->sheets[$this->sn]['cellsInfo'][$fr+1][$fc+1]['rowspan'] = $lr - $fr + 1;                     }                     if ($lc - $fc > 0) {                         $this->sheets[$this->sn]['cellsInfo'][$fr+1][$fc+1]['colspan'] = $lc - $fc + 1;                     }                 }                 break;             case SPREADSHEET_EXCEL_READER_TYPE_RK:             case SPREADSHEET_EXCEL_READER_TYPE_RK2:                 $row = ord($data[$spos]) | ord($data[$spos+1])_GetInt4d($data, $spos + 6);                 $numValue = $this->_GetIEEE754($rknum);                 $info = $this->_getCellDetails($spos,$numValue,$column);                 $this->addcell($row, $column, $info['string'],$info);                 break;             case SPREADSHEET_EXCEL_READER_TYPE_LABELSST:                 $row      = ord($data[$spos]) | ord($data[$spos+1])_GetInt4d($data, $spos + 6);                 $this->addcell($row, $column, $this->sst[$index], array('xfIndex'=>$xfindex) );                 break;             case SPREADSHEET_EXCEL_READER_TYPE_MULRK:                 $row      = ord($data[$spos]) | ord($data[$spos+1])_GetIEEE754($this->_GetInt4d($data, $tmppos + 2));                     $info = $this->_getCellDetails($tmppos-4,$numValue,$colFirst + $i + 1);                     $tmppos += 6;                     $this->addcell($row, $colFirst + $i, $info['string'], $info);                 }                 break;             case SPREADSHEET_EXCEL_READER_TYPE_NUMBER:                 $row   = ord($data[$spos]) | ord($data[$spos+1])isDate($spos)) {                     $numValue = $tmp['double'];                 }                 else {                     $numValue = $this->createNumber($spos);                 }                 $info = $this->_getCellDetails($spos,$numValue,$column);                 $this->addcell($row, $column, $info['string'], $info);                 break;                 case SPREADSHEET_EXCEL_READER_TYPE_FORMULA: case SPREADSHEET_EXCEL_READER_TYPE_FORMULA2:     $row   = ord($data[$spos]) | ord($data[$spos+1])data[$spos+8])==1) {             $this->addcell($row, $column, "TRUE");         } else {             $this->addcell($row, $column, "FALSE");         }     } elseif ((ord($data[$spos+6])==2) && (ord($data[$spos+12])==255) && (ord($data[$spos+13])==255)) {         //Error formula. Error code is in +2;     } elseif ((ord($data[$spos+6])==3) && (ord($data[$spos+12])==255) && (ord($data[$spos+13])==255)) {         //Formula result is a null string.         $this->addcell($row, $column, '');     } else {         // result is a number, so first 14 bytes are just like a _NUMBER record         $tmp = unpack("ddouble", substr($data, $spos + 6, 8)); // It machine machine dependent         if ($this->isDate($spos)) {             $numValue = $tmp['double'];         }         else {             $numValue = $this->createNumber($spos);         }         $info = $this->_getCellDetails($spos,$numValue,$column);         $this->addcell($row, $column, $info['string'], $info);     }     break; case SPREADSHEET_EXCEL_READER_TYPE_BOOLERR:     $row   = ord($data[$spos]) | ord($data[$spos+1])addcell($row, $column, $string);     break; case SPREADSHEET_EXCEL_READER_TYPE_STRING:     // http://code.google.com/p/php-excel-reader/issues/detail?id=4     if ($version == SPREADSHEET_EXCEL_READER_BIFF8){         // Unicode 16 string, like an SST record         $xpos = $spos;         $numChars =ord($data[$xpos]) | (ord($data[$xpos+1]) _GetInt4d($this->data, $xpos);             $xpos += 4;         }         $len = ($asciiEncoding)?$numChars : $numChars*2;         $retstr =substr($data, $xpos, $len);         $xpos += $len;         $retstr = ($asciiEncoding)? $retstr : $this->_encodeUTF16($retstr);     }     elseif ($version == SPREADSHEET_EXCEL_READER_BIFF7){         // Simple byte string         $xpos = $spos;         $numChars =ord($data[$xpos]) | (ord($data[$xpos+1]) addcell($previousRow, $previousCol, $retstr);     break; case SPREADSHEET_EXCEL_READER_TYPE_ROW:     $row   = ord($data[$spos]) | ord($data[$spos+1]) 0) {         $rowHeight = -1;     } else {         $rowHeight = $rowInfo & 0x7FFF;     }     $rowHidden = (ord($data[$spos + 12]) & 0x20) >> 5;     $this->rowInfo[$this->sn][$row+1] = Array('height' => $rowHeight / 20, 'hidden'=>$rowHidden );     break; case SPREADSHEET_EXCEL_READER_TYPE_DBCELL:     break; case SPREADSHEET_EXCEL_READER_TYPE_MULBLANK:     $row = ord($data[$spos]) | ord($data[$spos+1])addcell($row, $column + $c, "", array('xfIndex'=>$xfindex));     }     break; case SPREADSHEET_EXCEL_READER_TYPE_LABEL:     $row   = ord($data[$spos]) | ord($data[$spos+1])addcell($row, $column, substr($data, $spos + 8, ord($data[$spos + 6]) | ord($data[$spos + 7])data[$spos]) | ord($this->data[$spos+1])data[$spos+2]) | ord($this->data[$spos+3])data[$spos+4]) | ord($this->data[$spos+5])data[$spos+6]) | ord($this->data[$spos+7])data[$spos + 28]);     $udesc = "";     $ulink = "";     $uloc = 32;     $linkdata['flags'] = $flags;     if (($flags & 1) > 0 ) {   // is a type we understand         //  is there a description ?         if (($flags & 0x14) == 0x14 ) {   // has a description             $uloc += 4;             $descLen = ord($this->data[$spos + 32]) | ord($this->data[$spos + 33]) data, $spos + $uloc, $descLen * 2);             $uloc += 2 * $descLen;         }         $ulink = $this->read16bitstring($this->data, $spos + $uloc + 20);         if ($udesc == "") {             $udesc = $ulink;         }     }     $linkdata['desc'] = $udesc;     $linkdata['link'] = $this->_encodeUTF16($ulink);     for ($r=$row; $rsheets[$this->sn]['cellsInfo'][$r+1][$c+1]['hyperlink'] = $linkdata;         }     }     break;      case SPREADSHEET_EXCEL_READER_TYPE_DEFCOLWIDTH:                     $this->defaultColWidth  = ord($data[$spos+4]) | ord($data[$spos+5]) standardColWidth  = ord($data[$spos+4]) | ord($data[$spos+5]) colInfo[$this->sn][$coli+1] = Array('width' => $cw, 'xf' => $cxf, 'hidden' => ($co & 0x01), 'collapsed' => ($co & 0x1000) >> 12);                     }                     break;                 default:                     break;             }             $spos += $length;         }         if (!isset($this->sheets[$this->sn]['numRows']))             $this->sheets[$this->sn]['numRows'] = $this->sheets[$this->sn]['maxrow'];         if (!isset($this->sheets[$this->sn]['numCols']))             $this->sheets[$this->sn]['numCols'] = $this->sheets[$this->sn]['maxcol'];     }     function isDate($spos) {         $xfindex = ord($this->data[$spos+4]) | ord($this->data[$spos+5]) xfRecords[$xfindex]['type'] == 'date');     }     // Get the details for a particular cell     function _getCellDetails($spos,$numValue,$column) {         $xfindex = ord($this->data[$spos+4]) | ord($this->data[$spos+5]) xfRecords[$xfindex];         $type = $xfrecord['type'];         $format = $xfrecord['format'];         $formatIndex = $xfrecord['formatIndex'];         $fontIndex = $xfrecord['fontIndex'];         $formatColor = "";         $rectype = '';         $string = '';         $raw = '';         if (isset($this->_columnsFormat[$column + 1])){             $format = $this->_columnsFormat[$column + 1];         }         if ($type == 'date') {             $rectype = 'date';             $utcDays = floor($numValue - ($this->nineteenFour ? SPREADSHEET_EXCEL_READER_UTCOFFSETDAYS1904 : SPREADSHEET_EXCEL_READER_UTCOFFSETDAYS));             $utcValue = ($utcDays) * SPREADSHEET_EXCEL_READER_MSINADAY;             $dateinfo = gmgetdate($utcValue);             $raw = $numValue;             $fractionalDay = $numValue - floor($numValue) + .0000001; // The .0000001 is to fix for php/excel fractional diffs             $totalseconds = floor(SPREADSHEET_EXCEL_READER_MSINADAY * $fractionalDay);             $secs = $totalseconds % 60;             $totalseconds -= $secs;             $hours = floor($totalseconds / (60 * 60));             $mins = floor($totalseconds / 60) % 60;             $string = date ($format, mktime($hours, $mins, $secs, $dateinfo["mon"], $dateinfo["mday"], $dateinfo["year"]));         } else if ($type == 'number') {             $rectype = 'number';             $formatted = $this->_format_value($format, $numValue, $formatIndex);             $string = $formatted['string'];             $formatColor = $formatted['formatColor'];             $raw = $numValue;         } else{             if ($format=="") {                 $format = $this->_defaultFormat;             }             $rectype = 'unknown';             $formatted = $this->_format_value($format, $numValue, $formatIndex);             $string = $formatted['string'];             $formatColor = $formatted['formatColor'];             $raw = $numValue;         }         return array(             'string'=>$string,             'raw'=>$raw,             'rectype'=>$rectype,             'format'=>$format,             'formatIndex'=>$formatIndex,             'fontIndex'=>$fontIndex,             'formatColor'=>$formatColor,             'xfIndex'=>$xfindex         );     }     function createNumber($spos) {         $rknumhigh = $this->_GetInt4d($this->data, $spos + 10);         $rknumlow = $this->_GetInt4d($this->data, $spos + 6);         $sign = ($rknumhigh & 0x80000000) >> 31;         $exp =  ($rknumhigh & 0x7ff00000) >> 20;         $mantissa = (0x100000 | ($rknumhigh & 0x000fffff));         $mantissalow1 = ($rknumlow & 0x80000000) >> 31;         $mantissalow2 = ($rknumlow & 0x7fffffff);         $value = $mantissa / pow( 2 , (20- ($exp - 1023)));         if ($mantissalow1 != 0) $value += 1 / pow (2 , (21 - ($exp - 1023)));         $value += $mantissalow2 / pow (2 , (52 - ($exp - 1023)));         if ($sign) {$value = -1 * $value;}         return  $value;     }     function addcell($row, $col, $string, $info=null) {         $this->sheets[$this->sn]['maxrow'] = max($this->sheets[$this->sn]['maxrow'], $row + $this->_rowoffset);         $this->sheets[$this->sn]['maxcol'] = max($this->sheets[$this->sn]['maxcol'], $col + $this->_coloffset);         $this->sheets[$this->sn]['cells'][$row + $this->_rowoffset][$col + $this->_coloffset] = $string;         if ($this->store_extended_info && $info) {             foreach ($info as $key=>$val) {                 $this->sheets[$this->sn]['cellsInfo'][$row + $this->_rowoffset][$col + $this->_coloffset][$key] = $val;             }         }     }     function _GetIEEE754($rknum) {         if (($rknum & 0x02) != 0) {             $value = $rknum >> 2;         } else {             //mmp             // I got my info on IEEE754 encoding from             // http://research.microsoft.com/~hollasch/cgindex/coding/ieeefloat.html             // The RK format calls for using only the most significant 30 bits of the             // 64 bit floating point value. The other 34 bits are assumed to be 0             // So, we use the upper 30 bits of $rknum as follows...             $sign = ($rknum & 0x80000000) >> 31;             $exp = ($rknum & 0x7ff00000) >> 20;             $mantissa = (0x100000 | ($rknum & 0x000ffffc));             $value = $mantissa / pow( 2 , (20- ($exp - 1023)));             if ($sign) {                 $value = -1 * $value;             }             //end of changes by mmp         }         if (($rknum & 0x01) != 0) {             $value /= 100;         }         return $value;     }     function _encodeUTF16($string) {         $result = $string;         if ($this->_defaultEncoding){             switch ($this->_encoderFunction){                 case 'iconv' :  $result = iconv('UTF-16LE', $this->_defaultEncoding, $string);                     break;                 case 'mb_convert_encoding' :    $result = mb_convert_encoding($string, $this->_defaultEncoding, 'UTF-16LE' );                     break;             }         }         return $result;     }     function _GetInt4d($data, $pos) {         $value = ord($data[$pos]) | (ord($data[$pos+1]) =4294967294) {             $value=-2;         }         return $value;     } } ?>


4.  code.php 

<?php session_start();
getCode(4,50,20);
 
function getCode($num,$w,$h) {
    $code = "";
    for ($i = 0; $i < $num; $i++) {
        $code .= rand(0, 9);
    }
    //4位验证码也可以用rand(1000,9999)直接生成
    //将生成的验证码写入session,备验证页面使用
    $_SESSION['PHP_M2T'] = $code;
    setcookie("mimi", md5($code), time()+1200);
    //创建图片,定义颜色值
    Header("Content-type: image/PNG");
    $im = imagecreate($w, $h);
    $black = imagecolorallocate($im, 255, 0, 63);
    $gray = imagecolorallocate($im, 200, 200, 200);
    $bgcolor = imagecolorallocate($im, 255, 255, 255);
 
    imagefill($im, 0, 0, $bgcolor);
 
    //画边框
    //imagerectangle($im, 0, 0, $w-1, $h-1, $black);
 
    //在画布上随机生成大量黑点,起干扰作用;
    for ($i = 0; $i < 10; $i++) {
        imagesetpixel($im, rand(0, $w), rand(0, $h), $black);
    }
    //将数字随机显示在画布上,字符的水平间距和位置都按一定波动范围随机生成
    $strx = rand(1,3);
    for ($i = 0; $i < $num; $i++) {
        $strpos = rand(2, 6);
        imagestring($im, 5, $strx, $strpos, substr($code, $i, 1), $black);
        $strx += rand(8, 12);
    }
    imagepng($im);
    imagedestroy($im);
}
?>


php免费学习视频:立即使用
踏上前端学习之旅,开启通往精通之路!从前端基础到项目实战,循序渐进,一步一个脚印,迈向巅峰!

WPS零基础入门到精通全套教程!
WPS零基础入门到精通全套教程!

全网最新最细最实用WPS零基础入门到精通全套教程!带你真正掌握WPS办公! 内含Excel基础操作、函数设计、数据透视表等

下载

相关标签:

本站声明:本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn

相关专题

更多
Navicat创建数据库教程
Navicat创建数据库教程

本专题整理Navicat创建数据库相关教程,介绍新建前的准备、基础设置和创建后的检查方法。内容兼顾入门学习及实际使用需求,帮助用户了解不同数据库类型下的操作差异,为后续建表、保存数据和日常管理提供参考。

2026.11.20

20

7

Navicat入门教程大全
Navicat入门教程大全

本专题整理Navicat入门教程,从认识软件界面到开展数据库操作,介绍初次使用需要了解的知识和方法。内容兼顾连接配置、数据管理及日常使用中的疑问,方便用户按学习进度查阅,为后续实践和独立操作打好基础。

2026.11.20

20

17

Navicat数据库连接配置指南
Navicat数据库连接配置指南

从确认数据库信息到建立可用连接,本专题串联Navicat连接数据库的相关知识和操作方法。既有初次配置时需要了解的基础内容,也有连接后的检查思路,方便用户按实际需求查阅教程,逐步熟悉数据库连接的设置流程。

2026.11.20

0

10

PHP8.6数组与数据处理教程
PHP8.6数组与数据处理教程

本专题汇总PHP8.6数组与数据处理教程,涵盖CSV读取和导出、引用遍历删除、array_filter回调模式、配置键名冲突、pathinfo文件名校验、GMP大整数进制转换及UTF-8正则筛选,说明升级兼容变化、输入范围和失败处理方法。

2026.11.20

60

8

PHP8.6升级迁移教程
PHP8.6升级迁移教程

本专题汇总PHP8.6升级迁移与弃用接口改造教程,涵盖反射调用、对象属性赋值、标识符更名、构造函数与__debugInfo调整,以及插件类名检查、常量导出、ArrayIterator排序、SPL和DTO查询参数转换,帮助梳理弃用提示并完成代码兼容改造。

2026.11.20

0

10

PHP8.6安装配置与FPM运维教程
PHP8.6安装配置与FPM运维教程

本专题汇总PHP8.6正式版安装部署与FPM运维教程,涵盖Linux并存安装、独立ini配置、扩展重新编译、Nginx切换与回滚、FPM状态监控和慢日志排查,以及环境变量、请求超时、OPcache刷新和预加载配置。

2026.11.20

40

10

Nginx CVE-2026-123007排查与防护指南
Nginx CVE-2026-123007排查与防护指南

Nginx HTTP/2漏洞该怎么修复?本专题围绕CVE-2026-123007,介绍安全版本升级、模块兼容检查和配置恢复方法,以及日志排查、权限设置等后续加固操作,方便你按实际部署情况查找对应教程。

2026.11.20

40

8

GoFrame框架Web开发与路由中间件
GoFrame框架Web开发与路由中间件

本专题聚焦GoFrame框架的Web开发,拆解路由注册与匹配规则、请求参数获取、参数校验与中间件执行顺序,说明统一响应、JWT鉴权、文件上传与接口文档生成的落地方式,并补充优雅重启与测试实践。

2026.11.17

80

15

GoFrame框架安装与gf命令行工具
GoFrame框架安装与gf命令行工具

本专题围绕GoFrame框架的安装与工具链配置展开,讲清Go版本要求、gf命令行的安装方式、代理镜像与依赖准备,说明项目初始化、热编译、交叉编译打包的做法,并整理安装阶段的常见报错与验证步骤。

2026.11.17

100

15

热门下载

更多
网站特效
/
网站源码
/
网站素材
/
前端模板

精品课程

更多
热门推荐
/
最新课程
phpStudy极速入门视频教程
phpStudy极速入门视频教程

共6课时 | 54.8万人学习

独孤九贱(4)_PHP视频教程
独孤九贱(4)_PHP视频教程

共89课时 | 134.5万人学习