search
HomeCMS TutorialEmpire CMSHow to search with multiple conditions in Empire CMS

How to search with multiple conditions in Empire CMS

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

How to search with multiple conditions in Empire CMS

How to search with multiple conditions in Empire CMS

##HTML code:

<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!

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
帝国cms管理员在哪个表帝国cms管理员在哪个表Feb 22, 2023 pm 07:00 PM

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

帝国cms怎么把静态改成伪静态帝国cms怎么把静态改成伪静态Jul 19, 2023 pm 04:45 PM

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

帝国cms404页面怎么设置帝国cms404页面怎么设置Aug 02, 2023 am 11:54 AM

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

帝国cms可以删除模块吗帝国cms可以删除模块吗Mar 13, 2023 pm 07:18 PM

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

帝国cms留言板是哪个表帝国cms留言板是哪个表Feb 22, 2023 am 09:39 AM

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

帝国cms连接不上数据库怎么办帝国cms连接不上数据库怎么办Feb 27, 2023 am 09:51 AM

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

帝国cms封面模板是什么意思帝国cms封面模板是什么意思Feb 13, 2023 am 10:39 AM

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

帝国cms怎么修改数据库文件帝国cms怎么修改数据库文件Jul 25, 2023 pm 03:37 PM

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

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

SublimeText3 Linux new version

SublimeText3 Linux new version

SublimeText3 Linux latest version

SecLists

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

WebStorm Mac version

Useful JavaScript development tools

SublimeText3 English version

SublimeText3 English version

Recommended: Win version, supports code prompts!