How to add a keyword table to phpcms v9 similar to that in phpcms 2008_PHP Tutorial

Recently, I used phpcms v9 to develop a personal website for the second time. I used to use 2008 to have a more comfortable function of displaying all keywords, and v9 added the keyword list function to the search. If you search for a keyword, an increase will be automatically generated. When it comes to the search_keyword table, I don’t like v9 very much about this; I think the in-site search function is generally used less, and when we add articles, we actually separate the keywords. Why do we need to do this more? In fact, It is relatively simple to change

Add a keyword_ext_model.class.php in the model folder. keyword_model actually exists in the model folder. I don’t know why there is no keyword table?

So don’t add anything based on this. Maybe this model will be used in the future.

Copy code The code is as follows :

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

Then create a table

Copy the code The code is as follows:

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;

The last step is in phpcms/modules/content/fields Add an input.inc.php in /keyword

Copy the code The code is as follows:

function tags($field , $value)
{
if(!$value) return '';
if(strpos($value, ','))
{
$s = ',';
}
else
$s = ',';
}

$keywords = isset($s) ? array_unique(array_fil) ter(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);
}


In this way, when keywords are added to the article, they will be automatically added to keyword_ext. When calling the site-wide tags, just adjust this table directly. Please clear the site cache first, otherwise you will not see the effect after modification.

http://www.bkjia.com/PHPjc/327977.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/327977.htmlTechArticleRecently used phpcms v9 to develop a personal website for the second time. Previously, I used 2008 to have a more comfortable keyword display. function, and v9 adds the keyword list function to the search. If you search...