Empire cms multi-condition search:
1. Support multi-column simultaneous search:
Use commas to search for multiple columns. Can
Example: The following is the search for information in the three columns of id=1, id=2, and id=3:
2. Support topic search:
Search topic variable name: ztid
Search for multiple topics can be separated by commas, the same as the above multi-column search
Example: The following is Search information for topic ID=1
3. Support various logical operation connectors:
Logic Operation connector variable name: hh
LT: less than
GT: greater than
EQ: equal to
LE: less than or equal to
GE: greater than or equal to
NE: not equal to
IN : Contains (the search keyword separates each value with a space)
BT: Range, between two values (the search keyword separates the two values with a space)
LK: Fuzzy query (default)
Example:
Fuzzy query:
4. Support setting the association between multi-condition queries
The associated relationship variable name is: andor
There are two associated relationships:
or: or relationship (default)
and: and relationship
Example:
5. Support multi-field, multi-logical operation connector parallel search
(1), multi-field parallel search Search: There are two transmission methods: "string" and "array"
1. String transmission is an example:
<input type="hidden" name="hh" value="LK"> <input type="hidden" name="show" value="title,writer"> <input type="hidden" name="keyboard" value="标题,作者">
(Note: The above is a fuzzy query where the title field contains " Title" character or the writer field contains "author" information)
2. Array transfer is an example:
<input type="hidden" name="hh" value="LK"> <input type="hidden" name="show[]" value="title"> <input type="hidden" name="keyboard[]" value="标题"> <input type="hidden" name="show[]" value="writer"> <input type="hidden" name="keyboard[]" value="作者">
(Note: The above is a fuzzy query where the title field contains " Title" character or the writer field contains "author" information)
(2) Parallel search with multiple logical operation connectors
1. Example of string transfer:
<input type="hidden" name="hh" value="LK,EQ"> <input type="hidden" name="show" value="title,writer"> <input type="hidden" name="keyboard" value="标题,作者">
(Note: The above is a fuzzy query for information that the title field contains the "title" character or the writer field is equal to "author")
2. Example of string transfer:
<input type="hidden" name="show[]" value="title"> <input type="hidden" name="hh[]" value="LK"> <input type="hidden" name="keyboard[]" value="标题"> <input type="hidden" name="show[]" value="writer"> <input type="hidden" name="hh[]" value="EQ"> <input type="hidden" name="keyboard[]" value="作者">
(Note: The above is a fuzzy query for information that the title field contains the "title" character or the writer field is equal to "author")
6. New special field query
Special fields include:
id: Search by information ID
keyboard: Search by keyword, which can achieve the effect of listing information by tags
userid: Search by user ID
username: Search by user name
Added member variable: You can set it to search only for member contributions or information added by administrators.
If the value is 0, there is no restriction.
If the value is 1, it will only search for information submitted by members.
If the value is 2, it will only search for information added by the administrator.
Example: Only search for member submissions Information
7. Add a new GET submission method
You can submit data directly to e /search/index.php, without the need for 4.6’s /search/keyword transfer.
Just add the "searchget" variable to the parameter, such as: /e/search/?searchget=1&keyboard=Empire&show=title
Application example:: Realize by title, Form for simultaneous search of author, entry person and information ID
<form name="searchform" method="post" action="/e/search/index.php"> <table width="550" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder"> <input type="hidden" name="tbname" value="news"> <input type="hidden" name="tempid" value="1"> <b><input type="hidden" name="andor" value="and"></b> <tr class="header"> <td colspan="2">新闻搜索</td> </tr> <tr bgcolor="#FFFFFF"> <td width="97">标题:</td> <td width="388"> <b> <input type="hidden" name="show[]" value="title"> <input type="hidden" name="hh[]" value="LK"> <input name="keyboard[]" type="text"></b> </td> </tr> <tr bgcolor="#FFFFFF"> <td>作者:</td> <td> <b> <input type="hidden" name="show[]" value="writer"> <input type="hidden" name="hh[]" value="LK"> <input name="keyboard[]" type="text"></b> </td> </tr> <tr bgcolor="#FFFFFF"> <td>录入者:</td> <td> <b> <input type="hidden" name="show[]" value="username"> <input type="hidden" name="hh[]" value="EQ"> <input name="keyboard[]" type="text"></b> </td> </tr> <tr bgcolor="#FFFFFF"> <td>信息ID范围:</td> <td> <b> <input type="hidden" name="show[]" value="id"> <input type="hidden" name="hh[]" value="BT"> <input name="keyboard[]" type="text"></b> <font color="#666666">(例:“1 6”表示1到6之间) </font></td> </tr> <tr bgcolor="#FFFFFF"> <td> </td> <td> <input type="submit" name="Submit" value="马上搜索"> <font color="#666666">(不设置为不限)</font></td> </tr> </table> </form>
The above is the detailed content of How to search with multiple conditions in Empire CMS. For more information, please follow other related articles on the PHP Chinese website!

管理员表有:1、phome_enewsuser,是管理员记录表;2、phome_enewsdolog,是管理员操作记录表;3、phome_enewsgroup,是管理员用户组数据记录表;4、phome_enewslog,是管理员登陆日志;5、phome_enewsloginfail,是管理员登陆失败记录表;6、phome_enewserrorclass,是管理员错误报告记录表。

帝国cms把静态改成伪静态的方法:1、创建.htaccess文件;2、修改网站配置文件;3、重新生成所有页面;4、配置伪静态规则;5、保存并关闭文件即可。

帝国cms404页面的设置步骤为:1、登录到帝国CMS的后台管理界面;2、导航到"内容"或"站点管理"等相关菜单选项;3、找到和选择"404页面"或"错误页面"选项;4、选择使用已有页面或者创建一个新页面作为404页面;5、在新页面编辑器中,编写404页面的内容;6、保存页面并将其设置为404页面;7、更新网站设置;8、保存设置并测试404页面即可。

帝国cms可以删除模块。删除模块的方法:1、登录帝国CMS后台,依次点击“系统”-“系统设置”-“系统参数设置”-“关闭相关功能”,根据自己网站的需求,自行勾选设置来关闭对应的模块功能;2、关闭功能后,删除对应模块的在e目录下的子目录;3、修改e目录下的php文件,在文件第二行加上代码“exit();<?php exit()”,并保存修改即可。

帝国cms留言板是“phome_enewsgbook”表;帝国cms留言分类表是“phome_enewsgbookclass”;帝国cms会员空间留言表是“phome_enewsmembergbook”。

帝国cms连接不上数据库的解决办法:1、打开帝国CMS数据文件的根目录;2、找到并打开“/e/config/config.php”文件;3、将数据库名称以及数据库用户名即数据库密码修改保存后替换空间文件即可。

在帝国cms中,封面模板是指网站频道页面使用的模板,可以制作跟首页一模一样的封面页面;封面模板共使用在两个地方:非终极栏目和专题。封面模板的使用,一般是该栏目为父级栏目(非终级栏目),封面模板的目的就是调用各个子栏目(终级栏目)文章。

帝国cms修改数据库文件的方法:1、打开控制面板,找到phpMyAdmin或类似的数据库管理工具;2、选择您要修改的数据库;3、点击您要修改的表格;4、点击您要修改的字段;5、根据需求,修改相应的属性和值;6、保存您所做的修改;7、重复步骤三至六,对其他字段进行相应的修改即可。


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

SublimeText3 Linux new version
SublimeText3 Linux latest version

SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

WebStorm Mac version
Useful JavaScript development tools

SublimeText3 English version
Recommended: Win version, supports code prompts!
