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