本页文章导读:

    ▪php导出数据为execel文件的实例分享      1，首先，创建文件，命名为out.php   代码示例: <?php /** * * 导出数据为execl文件 * edit: www. */ $conn=mysql_connect()("localhost","hostname","****"); mysql_select_db("dbname",$conn); $result=mysql_query()("select * f.........

    ▪php常用功能函数二则      本节内容： php常用功能函数、html代码过滤函数、html文本截取函数 例1，html代码过滤函数   代码示例: <?php function html2text($str){   $str = preg_replace("/<style .*?<\/style>/is", "", $str);  $.........

    ▪PHP 传引用调用的实例解析      本节内容： PHP 传引用调用 原来的理解： 基础数据类型都是传值调用，而具体的类都是传引用调用， 其实没有传引用调用，所有的函数参数都是传值调用(除了PHP的&或指针调用) 例1，   .........

代码示例:

<?php
/**
*
* 导出数据为execl文件
* edit: www.
*/
$conn=mysql_connect()("localhost","hostname","****");
mysql_select_db("dbname",$conn);
$result=mysql_query()("select * from hjsm_admin_qqreader");
require_once './phpexecl.class.php';
//$data=$_GET['ac'];
 $data = array(
1 => array ('id', "名字","其他"),//标题使用中文则到表格里面值为空，待解决
);
while($row=mysql_fetch_array($result))
{
array_push($data,array($row['id'], $row['name'], $row['others'], ));
}
// generate file (constructor parameters are optional)
$xls = new Excel_XML('utf-8', false, 'My Test Sheet');
$xls->addArray($data);
$xls->generateXML('my-test');
?>

代码示例:

<?php
/**
* Simple excel generating from PHP5
* @version 1.0
*/

/**
* Generating excel documents on-the-fly from PHP5
*
* Uses the excel XML-specification to generate a native
* XML document, readable/processable by excel.
*
* @package Utilities
* @subpackage Excel
* @author Oliver Schwarz <oliver.schwarz@vaicon.de>
* @version 1.1
*
* @todo Issue #4: Internet Explorer 7 does not work well with the given header
* @todo Add option to give out first line as header (bold text)
* @todo Add option to give out last line as footer (bold text)
* @todo Add option to write to file
*/
class Excel_XML
{

/**
* Header (of document)
* @var string
*/
private $header = "<?xml version=\"1.0\" encoding=\"%s\"?\>\n<Workbook xmlns=\"urn:schemas-microsoft-com:office:spreadsheet\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns:ss=\"urn:schemas-microsoft-com:office:spreadsheet\" xmlns:html=\"http://www.w3.org/TR/REC-html40\">";

/**
* Footer (of document)
* @var string
*/
private $footer = "</Workbook>";

/**
* Lines to output in the excel document
* @var array
*/
private $lines = array();

/**
* Used encoding
* @var string
*/
private $sEncoding;

/**
* Convert variable types
* @var boolean
*/
private $bConvertTypes;

/**
* Worksheet title
* @var string
*/
private $sWorksheetTitle;

/**
* Constructor
*
* The constructor allows the setting of some additional
* parameters so that the library may be configured to
* one's needs.
*
* On converting types:
* When set to true, the library tries to identify the type of
* the variable value and set the field specification for Excel
* accordingly. Be careful with article numbers or postcodes
* starting with a '0' (zero)!
*
* @param string $sEncoding Encoding to be used (defaults to UTF-8)
* @param boolean $bConvertTypes Convert variables to field specification
* @param string $sWorksheetTitle Title for the worksheet
*/
public function __construct($sEncoding = 'UTF-8', $bConvertTypes = false, $sWorksheetTitle = 'Table1')
{
$this->bConvertTypes = $bConvertTypes;
$this->setEncoding($sEncoding);
$this->setWorksheetTitle($sWorksheetTitle);
}

/**
* Set encoding
* @param string Encoding type to set
*/
public function setEncoding($sEncoding)
{
$this->sEncoding = $sEncoding;
}

/**
* Set worksheet title
*
* Strips out not allowed characters and trims the
* title to a maximum length of 31.
*
* @param string $title Title for worksheet
*/
public function setWorksheetTitle ($title)
{
$title = preg_replace ("/[\\\|:|\/|\?|\*|\[|\]]/", "", $title);
$title = substr ($title, 0, 31);
$this->sWorksheetTitle = $title;
}

/**
* Add row
*
* Adds a single row to the document. If set to true, self::bConvertTypes
* checks the type of variable and returns the specific field settings
* for the cell.
*
* @param array $array One-dimensional array with row content
*/
private function addRow ($array)
{
$cells = "";
foreach ($array as $k => $v):
$type = 'String';
if ($this->bConvertTypes === true && is_numeric($v)):
$type = 'Number';
endif;
$v = htmlentities($v, ENT_COMPAT, $this->sEncoding);
$cells .= "<Cell><Data ss:Type=\"$type\">" . $v . "</Data></Cell>\n";
endforeach;
$this->lines[] = "<Row>\n" . $cells . "</Row>\n";
}

/**
* Add an array to the document
* @param array 2-dimensional array
*/
public function addArray ($array)
{
foreach ($array as $k => $v)
$this->addRow ($v);
}

/**
* Generate the excel file
* @param string $filename Name of excel file to generate (...xls)
*/
public function generateXML ($filename = 'excel-export')
{
// correct/validate filename
$filename = preg_replace('/[^aA-zZ0-9\_\-]/', '', $filename);

// deliver header (as recommended in php manual)
header("Content-Type: application/vnd.ms-excel; charset=" . $this->sEncoding);
header("Content-Disposition: inline; filename=\"" . $filename . ".xls\"");

// print out document to the browser
// need to use stripslashes() for the damn ">"
echo stripslashes (sprintf()($this->header, $this->sEncoding));
echo "\n<Worksheet ss:Name=\"" . $this->sWorksheetTitle . "\">\n<Table>\n";
foreach ($this->lines as $line)
echo $line;

echo "</Table>\n</Worksheet>\n";
echo $this->footer;
}
}
?>

代码示例:

<?php
function html2text($str){  
$str = preg_replace("/<style .*?<\/style>/is", "", $str); 
$str = preg_replace("/<script .*?<\/script>/is", "", $str); 
$str = preg_replace("/<br \s*\/?\/>/i", "\n", $str);
$str = preg_replace("/<\/?p>/i", "\n\n", $str);
$str = preg_replace("/<\/?td>/i", "\n", $str);
$str = preg_replace("/<\/?div>/i", "\n", $str);
$str = preg_replace("/<\/?blockquote>/i", "\n", $str);
$str = preg_replace("/<\/?li>/i", "\n", $str);
$str = preg_replace("/\&nbsp\;/i", " ", $str);
$str = preg_replace("/\&nbsp/i", " ", $str);
$str = preg_replace("/\&amp\;/i", "&", $str);
$str = preg_replace("/\&amp/i", "&", $str); 
$str = preg_replace("/\&lt\;/i", "<", $str);
$str = preg_replace("/\&lt/i", "<", $str);
$str = preg_replace("/\&ldquo\;/i", '"', $str);
$str = preg_replace("/\&ldquo/i", '"', $str);
$str = preg_replace("/\&lsquo\;/i", "'", $str);
$str = preg_replace("/\&lsquo/i", "'", $str);
$str = preg_replace("/\&rsquo\;/i", "'", $str);
$str = preg_replace("/\&rsquo/i", "'", $str);
$str = preg_replace("/\&gt\;/i", ">", $str);
$str = preg_replace("/\&gt/i", ">", $str); 
$str = preg_replace("/\&rdquo\;/i", '"', $str);
$str = preg_replace("/\&rdquo/i", '"', $str);
$str = strip_tags()($str); 
$str = html_entity_decode($str, ENT_QUOTES, $encode);
$str = preg_replace("/\&\#.*?\;/i", "", $str);
return $str;
}

代码示例:

<?php
function mysubstr($str, $start, $len) {
     $tmpstr = "";
     $strlen = $start + $len;
     for($i = 0; $i < $strlen; $i++) {
         if(ord(substr($str, $i, 1)) > 0xa0) {
             $tmpstr .= substr($str, $i, 2);
             $i++;
         } else
         $tmpstr .= substr($str, $i, 1);
     }
     return $tmpstr;
}

代码示例:

<?php
$a = 1;
test($a);
echo $a;

function test($a) {
    $a = 2;        
}
 

代码示例:

<?php
$a = new Man;
$a->age = 1;
test($a)
echo $a->age;

class Man {
    public $age;  
}

function test(Man $a) {
    $a->age = 2;  
}

代码示例:

<?php
$a = new Man;
$a->age = 1;
test($a);
echo $a->age;

class Man {
    public $age;  
}

function test(Man $a) {
    $a = new Man;
    $a->age = 2;  
}
 

代码示例:

<?php
$a = new Man;
$a->age = 1;
$b = $a;
$b->age = 3;
echo $a->age;

class Man {
    public $age;  
}

代码示例:

<?php
$a = new Man;
$a->age = 1;
$b = $a;
$b = new Man;
$b->age = 3;
echo $a->age;

class Man {
    public $age;  
}
 

代码示例:

function test(Man $a) {
    $a = new Man;
}

代码示例:

function test(Man &$a) {
    $a = new Man;
}