日历
| |||||||||
| 日 | 一 | 二 | 三 | 四 | 五 | 六 | |||
| 1 | 2 | 3 | 4 | ||||||
| 5 | 6 | 7 | 8 | 9 | 10 | 11 | |||
| 12 | 13 | 14 | 15 | 16 | 17 | 18 | |||
| 19 | 20 | 21 | 22 | 23 | 24 | 25 | |||
| 26 | 27 | 28 | 29 | 30 | 31 | ||||
搜索标题
最新来客
最新评论
统计信息
- 访问量: 1123
- 日志数: 17
- 建立时间: 2008-03-20
- 更新时间: 2008-04-07
RSS订阅
困难中寻找快乐的信念
我的最新日志
-
Header函式的使用
2008-4-07
-
php 无限级分类 缓存
2008-3-31
<?php/** * 功能: 根据条件建立分类缓存减少类别使用 * 创建日期:Thu May 31 15:55:11 CST 2007 * 最后更新: * 作者: sanshi <sanshi0815@tom.com> */class treeCache{ var $tableName = "index_category"; //表名 var $where = "1"; //where条件 var $pidStr ="i_c_pid"; //pid 的字段名 var $tempCode = array(); //生成文件的数组 var $pid = 0; //pid的初始值 var $db ; //数据库句柄 var $idStr="i_c_id"; //取得的数据id var $title = "i_c_cn"; //名字字段 var $createArrayName = "treeCache"; //建立的数组名字 var $createFileName =""; //建立文件的名字 var $appendArr = array(); //附加的属性，需要字段名与数据里的名对应 function treeCache($db) { $this->db = $db; $this->tempCode[] = "<?php"; } //取得所有的一级 function getRootID() { $sql = "SELECT {$this->idStr} FROM {$this->tableName} WHERE {$this->pidStr}={$this->pid} AND {$this->where} "; $result = $this->db->select($sql); $temp = array(); foreach ($result as $r) { $temp[]=$r["{$this->idStr}"]; } $this->tempCode[] = "${$this->createArrayName}['root']='".implode(',',$temp)."';"; //print_r($temp); return $temp; } //取得子id function getChildren($pid) { $sql = "SELECT {$this->idStr} FROM {$this->tableName} WHERE {$this->pidStr}={$pid} AND {$this->where} "; $result = $this->db->select($sql); $temp = array(); foreach ($result as $r) { $temp[]=$r["{$this->idStr}"]; } return $temp; } //取得夫id function getParent($cid) { $sql = "SELECT {$this->pidStr} FROM {$this->tableName} WHERE {$this->idStr}={$cid} AND {$this->where} "; $result = $this->db->select($sql); return $result[0]["{$this->pidStr}"]; } //取得上级的id function getPidStr($cid,$pidStr="") { $pid=$this->getParent($cid); $temp = array(); while ($pid!=$this->pid && !empty($pid)) { $temp[] = $pid; $pid=$this->getParent($pid); } //print_r($temp); return implode(',',$temp); } //取得深度 function getDepth($cid,$depth=0) { $pid=$this->getParent($cid); $depth++; if($pid!=$this->pid && !empty($pid)) $depth = $this->getDepth($pid,$depth); return $depth; } //建立文件 function make() { if(empty($this->createFileName)) $this->createFileName = "{$this->createArrayName}.data.php"; $rootArr = $this->getRootID(); $selectF = "{$this->idStr},{$this->title},{$this->pidStr}"; foreach ($this->appendArr as $app) { if(empty($app)) continue; $selectF .=",{$app}"; } $sql = "SELECT {$selectF} FROM {$this->tableName} WHERE {$this->where} ORDER BY {$this->idStr} ASC"; $result = $this->db->select($sql); for ($i=0;$i<count($result);$i++) { //id值 $this->tempCode[] = "${$this->createArrayName}[{$result[$i]["$this->idStr"]}]['id']='{$result[$i]["$this->idStr"]}';"; //标题 $this->tempCode[] = "${$this->createArrayName}[{$result[$i]["$this->idStr"]}]['title']='{$result[$i]["$this->title"]}';"; //父id $this->tempCode[] = "${$this->createArrayName}[{$result[$i]["$this->idStr"]}]['pid']='{$result[$i]["$this->pidStr"]}';"; //子id $this->tempCode[] = "${$this->createArrayName}[{$result[$i]["$this->idStr"]}]['cid']='".implode(',',$this->getChildren($result[$i]["$this->idStr"]))."';"; //目录深度 $this->tempCode[] = "${$this->createArrayName}[{$result[$i]["$this->idStr"]}]['depth']='".$this->getDepth($result[$i]["$this->idStr"])."';"; //父id的id串 $this->tempCode[] = "${$this->createArrayName}[{$result[$i]["$this->idStr"]}]['pstr']='".$this->getPidStr($result[$i]["$this->idStr"])."';"; //添加的附加属性 foreach ($this->appendArr as $app) { if(empty($app)) continue; $this->tempCode[] = "${$this->createArrayName}[{$result[$i]["$this->idStr"]}]['{$app}']='{$result[$i]["{$app}"]}';"; } } $this->tempCode[] = "?>"; //$content = implode(" ",$this->tempCode); //print_r($this->tempCode); include_once(CLASSES_PATH."FileIO.class.php"); $content = implode(" ",$this->tempCode); //建立文件 FileIO::writeFile($this->createFileName,$content); return $content ; }}现在发一段简单的解析
//做分析include_once("treeCache.data.php");$treeCache=isset($treeCache) ? $treeCache : array();$rootStr = isset($treeCache['root']) ? $treeCache['root'] : "";echo parseTree($treeCache,$rootStr);function parseTree($treeCache,$rootStr){ $tempStr = ""; $temp = explode(',',$rootStr); foreach ($temp AS $cid) { $info = $treeCache[$cid]; $cidStr = $info['cid']; $tempStr .= str_repeat('-',($info['depth']-1)*3); $tempStr.=$info['title']; if(empty($info['pid'])) { //附加操作 } $tempStr .= "<br/>";查看(47) 评论(0)
关于IFRAME自适应高度的研究
2008-3-28
HTML文件中也玩include文件包含
2008-3-28
比较好看的css按钮
2008-3-26
PHP初学者头疼问题总结!(转)
2008-3-24
php单件模式
2008-3-22
网页或文件加载Loading进度条效果之四
2008-3-22
网页或文件加载Loading进度条效果之三
2008-3-22
网页或文件加载Loading进度条效果之二
2008-3-22
