PHP100 2019-03-27
代码如下:
<?php
defined('IN_PHPCMS') or exit('No permission resources.');
pc_base::load_sys_class('model', '', 0);
class keyword_ext_model extends model {
    public $table_name = '';
    public function __construct() {
        $this->db_config = pc_base::load_config('database');
        $this->db_setting = 'default';
        $this->table_name = 'keyword_ext';
        parent::__construct();
    }
}
?>代码如下:
CREATE TABLE `t_v9_keyword_ext` ( `tagid` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `tag` char(50) NOT NULL, `style` char(5) NOT NULL, `usetimes` smallint(5) unsigned NOT NULL DEFAULT '0', `lastusetime` int(10) unsigned NOT NULL DEFAULT '0', `hits` mediumint(8) unsigned NOT NULL DEFAULT '0', `lasthittime` int(10) unsigned NOT NULL DEFAULT '0', `listorder` tinyint(3) unsigned NOT NULL DEFAULT '0', `modelid` smallint(6) DEFAULT '0', PRIMARY KEY (`tagid`), UNIQUE KEY `tag` (`tag`), KEY `usetimes` (`usetimes`,`listorder`), KEY `hits` (`hits`,`listorder`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
代码如下:
function tags($field, $value)
    {
        if(!$value) return '';
        if(strpos($value, ','))
        {
            $s = ',';
        }
        else
        {
            $s = ',';
        }
        $keywords = isset($s) ? array_unique(array_filter(explode($s, $value))) : array($value);
        $keyword_db = pc_base::load_model('keyword_ext_model');
        foreach($keywords as $tag)
        {
            $tag = trim($tag);
            $keyword_db->delete(array("tag"=>$tag,"modelid"=>$this->modelid));
            $c=$this->db->count("keywords like '%".$tag."%'");
            $keyword_db->insert(array("modelid"=>$this->modelid,"tag"=>$tag,"usetimes"=>$c,"lastusetime"=>SYS_TIME),false,true);
        }
        return implode($s, $keywords);
}