phpcms v9 后台增加搜索关键字编辑管理功能

你的名字 2021-09-26 09:42 233阅读 0赞

![这里写图片描述][SouthEast]

后台使用效果如上,修改方法为:

一,运行sql
    
    alter table v9_search_keyword add keywordid int(16) unsigned NOT NULL auto_increment PRIMARY KEY ;
    alter table v9_search_keyword add title char(100) ;
    
    INSERT INTO v9_menu (name,parentid,m,c,a) VALUES ( 'search_keyword', '977', 'admin', 'search_keyword', 'init');
    INSERT INTO v9_menu (name,parentid,m,c,a) VALUES ( 'add_search_keyword', '1571', 'admin', 'search_keyword', 'add');
    INSERT INTO v9_menu (name,parentid,m,c,a)VALUES ( 'edit_search_keyword', '1571', 'admin', 'search_keyword', 'edit');
    INSERT INTO v9_menu (name,parentid,m,c,a)VALUES ( 'del_search_keyword', '1571', 'admin', 'search_keyword', 'del');
    
    
    2,进
    \phpcms\modules\admin
    
    增加目录中的search_keyword.php  文件
    
    3,进\phpcms\modules\admin\templates
    增加
    三个模板文件
    
    search_keyword_add.tpl.php
    search_keyword_edit.tpl.php
    search_keyword_list.tpl.php

一,search\_keyword.php文件内容为

<?php defined('IN_PHPCMS') or exit('No permission resources.'); pc_base::load_app_class('admin','admin',0); class search_keyword extends admin { function __construct() { $this->db = pc_base::load_model('search_keyword_model'); parent::__construct(); } function init () { $page = $_GET['page'] ? intval($_GET['page']) : '1'; //根据搜索数量由大到小排序 $infos = $this->db->listinfo('','searchnums DESC',$page ,'20'); $pages = $this->db->pages; $big_menu = array('javascript:window.top.art.dialog({id:\'add\',iframe:\'?m=admin&c=search_keyword&a=add\', title:\''.L('search_word_add').'\', width:\'450\', height:\'150\'}, function(){var d = window.top.art.dialog({id:\'add\'}).data.iframe;var form = d.document.getElementById(\'dosubmit\');form.click();return false;}, function(){window.top.art.dialog({id:\'add\'}).close()});void(0);', L('search_word_add')); include $this->admin_tpl('search_keyword_list'); } /** * 关键词添加 */ function add() { if(isset($_POST['dosubmit'])){ if(empty($_POST['info']['keyword'])){ echo L('search_word_error_input'); return false; } $this->db->insert($_POST['info']); showmessage(L('operation_success'),'?m=admin&c=search_keyword&a=add','', 'add'); }else{ $show_validator = $show_scroll = $show_header = true; include $this->admin_tpl('search_keyword_add'); } } /** * 关键词修改 */ function edit() { if(isset($_POST['dosubmit'])){ $keywordid = intval($_GET['keywordid']); if(empty($_POST['info']['keyword']) ){ echo L('search_word_error_input'); return false; } $this->db->update($_POST['info'],array('keywordid'=>$keywordid)); showmessage(L('operation_success'),'?m=admin&c=search_keyword&a=edit','', 'edit'); }else{ $show_validator = $show_scroll = $show_header = true; $info = $this->db->get_one(array('keywordid'=>$_GET['keywordid'])); if(!$info) showmessage(L('specified_word_not_exist')); extract($info); include $this->admin_tpl('search_keyword_edit'); } } /** * 关键词删除 */ function delete() { if(is_array($_POST['keywordid'])){ foreach($_POST['keywordid'] as $keywordid_arr) { $this->db->delete(array('keywordid'=>$keywordid_arr)); } showmessage(L('operation_success'),'?m=admin&c=search_keyword'); } else { $keywordid = intval($_GET['keywordid']); if($keywordid < 1) return false; $result = $this->db->delete(array('keywordid'=>$keywordid)); if($result){ showmessage(L('operation_success'),'?m=admin&c=search_keyword'); }else { showmessage(L("operation_failure"),'?m=admin&c=search_keyword'); } } } } ?>

二,search\_keyword\_add.tpl.php模板内容为

<?php defined('IN_ADMIN') or exit('No permission resources.'); include $this->admin_tpl('header'); ?>
    <script type="text/javascript"> $(function(){ $.formValidator.initConfig({formid:"myform",autotip:true,onerror:function(msg,obj){ window.top.art.dialog({content:msg,lock:true,width:'200',height:'50'}, function(){ this.close();$(obj).focus();})}}); }) </script>
    <div>
    <table width="100%" cellpadding="2" cellspacing="1" class="table_form">
    <form action="?m=admin&c=search_keyword&a=add" method="post" name="myform" id="myform">
    <tr>
    <th width="25%"><?php echo L('search_word_name');?> :</th>
    <td><input type="text" name="info[keyword]" id="word" size="20"></td>
    </tr>
    <tr>
    <th>备注</th>
    <td><input type="text" name="info[title]" value="" id="title"></td>
    </tr>
    <tr>
    <th><?php echo L('search_word_nums');?> :</th>
    <td><input type="text" name="info[searchnums]" value="" id="searchnums"></td>
    </tr>
    <tr>
    <th><?php echo L('search_word_some');?> :</th>
    <td><input type="text" name="info[data]" value="" id="data"></td>
    </tr>
    <input type="submit" style="display:none"name="dosubmit" id="dosubmit" value=" <?php echo L('submit')?> ">
    </form>
    </table>
    </div>
    </body>
    </html>

三,search\_keyword\_edit.tpl.php内容为

<?php defined('IN_ADMIN') or exit('No permission resources.'); include $this->admin_tpl('header'); ?>
    <script type="text/javascript"> $(function(){ $.formValidator.initConfig({formid:"myform",autotip:true,onerror:function(msg,obj){ window.top.art.dialog({content:msg,lock:true,width:'200',height:'50'}, function(){ this.close();$(obj).focus();})}}); }) </script>
    
    <div>
    <table cellpadding="2" cellspacing="1" width="100%" class="table_form">
    <form action="?m=admin&c=search_keyword&a=edit&keywordid=<?php echo $keywordid?>" method="post" name="myform" id="myform">
    <tr>
    <th width="25%"><?php echo L('search_word_name');?> :</th>
    <td><input type="text" name="info[keyword]" size="20" value="<?php echo $keyword?>"></td>
    </tr>
    <tr>
    <th>备注</th>
    <td><input type="text" name="info[title]" value="<?php echo $title?>" ></td>
    </tr>
    <tr>
    <th><?php echo L('search_word_nums');?> :</th>
    <td><input type="text" name="info[searchnums]" value="<?php echo $searchnums?>" ></td>
    </tr>
    <tr>
    <th><?php echo L('search_word_some');?> :</th>
    <td><input type="text" name="info[data]" value="<?php echo $data?>"></td>
    </tr>
    
    <input type="submit" name="dosubmit" style="display:none" id="dosubmit" value=" <?php echo L('submit')?> ">
    </form>
    </table>
    </div>
    </body>
    </html>

四,search\_keyword\_list.tpl.php内容为

<?php defined('IN_ADMIN') or exit('No permission resources.'); $show_dialog = 1; include $this->admin_tpl('header','admin'); ?>
    <div class="pad-lr-10">
    <form name="myform" id="myform" action="?m=admin&c=search_keyword&a=delete" method="post" onsubmit="checkuid();return false;">
    <div class="table-list">
    <table width="100%" cellspacing="0">
    <thead>
    <tr>
    <th width="35" align="center"><input type="checkbox" value="" id="check_box" onclick="selectall('keywordid[]');"></th>
    <th width="30%"><?php echo L('keyword_name')?></th>
    <th >备注</th>
    <th ><?php echo L('search_word_nums')?></th>
    <th ><?php echo L('search_word_some')?></th>
    <th width="120"><?php echo L('operations_manage')?></th>
    </tr>
    </thead>
    <tbody>
    <?php if(is_array($infos)){ foreach($infos as $info){ ?>
    <tr>
    <td align="center">
    <input type="checkbox" name="keywordid[]" value="<?php echo $info['keywordid']?>">
    </td>
    <td width="30%" align="left"><span ><?php echo $info['keyword']?></span> </td>
    <td align="center"><?php echo $info['title']?></td>
    <td align="center"><?php echo $info['searchnums']?></td>
    <td align="center"><?php echo $info['data']?></td>
    <td align="center"><a href="javascript:edit(<?php echo $info['keywordid']?>, '<?php echo new_addslashes($info['keyword'])?>')"><?php echo L('edit')?></a> | <a href="javascript:confirmurl('?m=admin&c=search_keyword&a=delete&keywordid=<?php echo $info['keywordid']?>', '<?php echo L('search_word_confirm_del')?>')"><?php echo L('delete')?></a> </td>
    </tr>
    <?php } } ?></tbody>
    </table>
    <div>
    <a href="#" onClick="javascript:$('input[type=checkbox]').attr('checked', true)"><?php echo L('selected_all')?></a>/<a href="#" onClick="javascript:$('input[type=checkbox]').attr('checked', false)"><?php echo L('cancel')?></a>
    <input type="submit" name="submit" style="display:none" value="<?php echo L('remove_all_selected')?>" onClick="return confirm('<?php echo L('badword_confom_del')?>')" />
    </div>
    <div id="pages"><?php echo $pages?></div>
    </div>
    </form>
    </div>
    </body>
    </html>
    <script type="text/javascript"> function edit(id, name) { window.top.art.dialog({id:'edit'}).close(); window.top.art.dialog({title:'<?php echo L('edit')?> '+name+' ',id:'edit',iframe:'?m=admin&c=search_keyword&a=edit&keywordid='+id,width:'450',height:'150'}, function(){ var d = window.top.art.dialog({id:'edit'}).data.iframe;var form = d.document.getElementById('dosubmit');form.click();return false;}, function(){ window.top.art.dialog({id:'edit'}).close()}); } function checkuid() { var ids=''; $("input[name='keywordid[]']:checked").each(function(i, n){ ids += $(n).val() + ','; }); if(ids=='') { window.top.art.dialog({content:'<?php echo L('badword_pleasechose')?>',lock:true,width:'200',height:'50',time:1.5},function(){ }); return false; } else { myform.submit(); } } </script>

![请打赏谢谢大佬][70]

[SouthEast]: /images/20210923/89e7f1559c3447049b5745f9b6122145.png
[70]: /images/20210923/d0d5e3275a1b4e1cb77e1e4ccf761c99.png