info.class.php

phpcms2007很好的cms内容管理系统,操作方便

<?php 
defined('IN_PHPCMS') or exit('Access Denied');

class info
{
	var $channelid;
	var $infoid;
	var $db;
	var $table_info;

	function info($channelid)
    {
		global $db;
		$this->channelid = $channelid;
		$this->infoid = 0;
		$this->db = &$db;
		$this->table_info = channel_table('info', $channelid);
		register_shutdown_function(array(&$this, '__destruct'));
    }

	function __destruct()
	{
		unset($this->channelid);
		unset($this->infoid);
		unset($this->db);
		unset($this->table_info);
	}
	function add($info)
	{
		$sql1 = $sql2 = $s = "";
		foreach($info as $key=>$value)
		{
			$sql1 .= $s.$key;
			$sql2 .= $s."'".$value."'";
			$s = ",";
		}
		$this->db->query("INSERT INTO ".$this->table_info." ($sql1) VALUES($sql2) ");
		if(!$this->db->affected_rows()) return FALSE;
		$infoid = $this->db->insert_id();
		if(!$info['islink'])
		{
			global $CHA;
			$linkurl = item_url('url', $info['catid'], $info['ishtml'], $info['urlruleid'], $info['htmldir'], $info['prefix'], $infoid, $info['addtime']);
			$this->db->query("UPDATE ".$this->table_info." SET linkurl='$linkurl' WHERE infoid=$infoid ");
		}
		return $infoid;
	}

	function edit($info)
	{
		$infoid = $this->infoid;
		if(!$info['islink'])
		{
			global $CHA;
			$info['linkurl'] = item_url('url', $info['catid'], $info['ishtml'], $info['urlruleid'], $info['htmldir'], $info['prefix'], $infoid, $info['addtime']);
		}
		$sql = $s = "";
		foreach($info as $key=>$value)
		{
			$sql .= $s.$key."='".$value."'";
			$s = ",";
		}
		$this->db->query("UPDATE ".$this->table_info." SET $sql WHERE infoid=$infoid ");
		return TRUE;
	}

	function delete($infoids, $file = 0)//File涓