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); }