Archive for category Php+Mysql

Date: 10月 26th, 2008
Cate: Php+Mysql

php2excel

php 导出EXCEL 的开源类

require (dirname (__FILE__) . "/class-excel-xml.inc.php");

// create a dummy array
$doc = array (
1 => array ("Oliver", "Peter", "Paul", "Paul", "Paul", "Paul", "Paul", "Paul", "Paul", "Paul", "Paul", "Paul"),
array ("fasd", "Lucy", "Lina", "Lina", "Lina", "Lina", "Lina", "Lina", "Lina"),
array ("fasdf", "Lucy", "Lina"),
array ("fasd", "Lucy", "Lina"),
array ("fasd", "Lucy", "Lina"),
array ("fasd", "Lucy", "Lina"),
array ("fasd", "Lucy", "Lina"),
array ("fasd", "Lucy", "Lina")
);

// generate excel file
$xls = new Excel_XML;
$xls->addArray ( $doc );
$xls->generateXML ("mytest");

测试 demo

另一个

biffwriter

Date: 10月 23rd, 2008
Cate: Php+Mysql

Php 随机列表应用

PHP 代码部分

$file = “yanyu.txt”; //存放谚语的文件位置;
//$refresh = 60; //刷新的时间间隔;
$data = file($file); //将文件存放在一个数组中;
$num = count($data); //谚语的条数;
$id = mt_rand(0,$num-1); //随机数字;
$text = chop($data[$id]); //显示第几行数据,并去除空格;
echo $text;
?>

随机列表都存放于yanyu.txt中 一行一个