blocks|key|17134|text|在这样的两个日期之间使用Yii2活动记录和access图书。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|17135|public+static+function+getBookBetweenDates($lower,+$upper)
{
++++return+Book::find()
++++++++->where(['and',+"date>=$lower",+"date<=$upper"])
++++++++->all();
}|code-block|syntax|javascript|17136|我假设您正在使用active+record类，并且已经将Book.php+(基于表名的适当名称)创建为模型文件。|17137|entityMap|0|LINK|mutability|MUTABLE|url|http://www.yiiframework.com/doc-2.0/guide-db-active-record.html^0|C|8|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@]|C|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]]]

use <a href="http://www.yiiframework.com/doc-2.0/guide-db-active-record.html" rel="nofollow">Yii2 Active Record</a> and access books between two dates like this.

<pre><code>public static function getBookBetweenDates($lower, $upper)
{
 return Book::find()
 -&gt;where(['and', "date&gt;=$lower", "date&lt;=$upper"])
 -&gt;all();
}
</code></pre>

I assume you are using active record class and you have created Book.php (appropriate name based on table name) As model file .

blocks|key|17139|text|我相信这就是你需要的答案：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|17140|$model+=+ModelName::find()
->where(['between',+'date',+"2014-12-31",+"2015-02-31"+])->all();|code-block|syntax|javascript|17141|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I believe this is the answer you need:

<pre><code>$model = ModelName::find()
-&gt;where(['between', 'date', "2014-12-31", "2015-02-31" ])-&gt;all();
</code></pre>

blocks|key|17163|text|如果以日期格式获得开始和结束，但数据库表中的日期为INT类型，则必须执行如下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|17164|//Get+values+and+format+them+in+unix+timestamp
$start+=+Yii::$app->formatter->asTimestamp(Yii::$app->request->post('start'));
$end+=+Yii::$app->formatter->asTimestamp(Yii::$app->request->post('end'));

//Book+name+from+your+example+form
$bookName+=+Yii::$app->request->post('book');

//Then+you+can+find+in+base:
$books+=+Book::find()
++++->where(['between',+'date',+$start,+$end])
++++->andWhere(['like',+'book',+$bookName])
++++->all();|code-block|syntax|javascript|17165|不要忘记验证来自post的值。|17166|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

If you get start and end in date format, but date in your database table is in INT type, you must do something like this:

<pre><code>//Get values and format them in unix timestamp
$start = Yii::$app-&gt;formatter-&gt;asTimestamp(Yii::$app-&gt;request-&gt;post('start'));
$end = Yii::$app-&gt;formatter-&gt;asTimestamp(Yii::$app-&gt;request-&gt;post('end'));

//Book name from your example form
$bookName = Yii::$app-&gt;request-&gt;post('book');

//Then you can find in base:
$books = Book::find()
 -&gt;where(['between', 'date', $start, $end])
 -&gt;andWhere(['like', 'book', $bookName])
 -&gt;all();
</code></pre>

Not forget validate values given from post.

blocks|key|17215|text|假设以整数形式存储的日期表示unix时间戳，则可以创建一个模型类，并将yii\validators\DateValidator应用于start和end属性。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|17216|/**
+*+Class+which+holds+all+kind+of+searchs+on+Book+model.
+*/
class+BookSearch+extends+Book
{
++++//+Custom+properties+to+hold+data+from+input+fields
++++public+$start;
++++public+$end;

++++/**
+++++*+@inheritdoc
+++++*/
++++public+function+rules()
++++{
++++++++return+[
++++++++++++['start',+'date',+'timestampAttribute'+=>+'start',+'format'+=>+'php:d/m/y'],
++++++++++++['end',+'date',+'timestampAttribute'+=>+'end',+'format'+=>+'php:d/m/y']
++++++++];
++++}

++++public+function+searchByDateRange($params)
++++{
++++++++$this->load($params);

++++++++//+When+validation+pass,+$start+and+$end+attributes+will+have+their+values+converted+to+unix+timestamp.
++++++++if+(!$this->validate())+{
++++++++++++return+false;
++++++++}

++++++++$query+=+Book::find()->andFilterWhere(['between',+'date',+$this->start,+$this->end]);

++++++++return+true;
++++}
}|code-block|syntax|javascript|17217|请参阅更多关于timestampAttribute+on+这份文件的信息。|17218|entityMap|0|LINK|mutability|MUTABLE|url|https://www.yiiframework.com/doc/api/2.0/yii-validators-datevalidator|1|https://www.yiiframework.com/doc/api/2.0/yii-validators-datevalidator#$timestampAttribute-detail^0|1U|5|20|3|Z|S|0|0|0|7|I|T|4|1|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@$9|11|A|12|1|13]]|E|$]]|$1|F|3|G|5|H|7|14|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|15|8|@$9|16|A|17|B|C]]|D|@$9|18|A|19|1|1A]]|E|$]]|$1|M|3|-4|5|6|7|1B|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]|U|$5|P|Q|R|E|$S|V]]]]

Assuming the date stored as integer represents unix timestamp, you can make a model class and apply <a href="https://www.yiiframework.com/doc/api/2.0/yii-validators-datevalidator" rel="noreferrer">yii\validators\DateValidator</a> on <code>start</code> and <code>end</code> attributes.

<pre><code>/**
 * Class which holds all kind of searchs on Book model.
 */
class BookSearch extends Book
{
 // Custom properties to hold data from input fields
 public $start;
 public $end;

 /**
 * @inheritdoc
 */
 public function rules()
 {
 return [
 ['start', 'date', 'timestampAttribute' =&gt; 'start', 'format' =&gt; 'php:d/m/y'],
 ['end', 'date', 'timestampAttribute' =&gt; 'end', 'format' =&gt; 'php:d/m/y']
 ];
 }

 public function searchByDateRange($params)
 {
 $this-&gt;load($params);

 // When validation pass, $start and $end attributes will have their values converted to unix timestamp.
 if (!$this-&gt;validate()) {
 return false;
 }

 $query = Book::find()-&gt;andFilterWhere(['between', 'date', $this-&gt;start, $this-&gt;end]);

 return true;
 }
}
</code></pre>

See more about <code>timestampAttribute</code> on <a href="https://www.yiiframework.com/doc/api/2.0/yii-validators-datevalidator#$timestampAttribute-detail" rel="noreferrer">this documentation</a>.

A date can be represented in different formats. A table itself looks like so:

<pre><code> book varchar(250) NOT NULL, 
 date INT NOT NULL
</code></pre>

Now my problem is that I can not implement search in range between two dates. 
For example, there are 5 books with different dates, but the start date starts
at <code>31/12/14</code> and final date is <code>31/02/15</code>. So when a user selects a range between these dates, it must provide all books in that date range. 

Is there any way to do it in Yii2? I could not find anything so far

UPDATE

I'm implementing a custom filter which doesn't belong to <code>GridView</code> and it looks like as a standalone box outside the table.

It looks like so:

<pre><code>&lt;div class="custom-filter"&gt;

 Date range:
 &lt;input name="start" /&gt;
 &lt;input name="end" /&gt;

 Book name:
 &lt;input name="book" /&gt;

&lt;/div&gt;
</code></pre>

search between two dates in yii2

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

日期可以用不同的格式表示。表本身看起来是这样的：   book varchar(250) NOT NULL,     date INT NOT NULL现在我的问题是我不能在两个日期之间的范围内实现搜索。例如，有5本书有不同的日期，但是开始日期从31/12/14开始，最后的日期是31/02/15。因此，当用户在这些日期...

问在yii2中在两个日期之间搜索
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在yii2中在两个日期之间搜索EN