laravel - 你如何更改为laravel语法？

Question

我有一个 SQL 查询，我想将其更改为 Laravel Eloquent 或 Query Builder。

$myDate = date("Y-m-d", strtotime( date( "Y-m-d", strtotime( date("Y-m-d") ) ) . "+1 month" ) );


$result = mysql_query( 'SELECT * FROM myTable WHERE expire_date BETWEEN NOW AND "' . $myDate . '"' );

请帮我！

标签： laraveleloquentlaravel-query-builder

Answer 1

你需要做这样的事情：

假设myTable有一个模型称为MyTable：

$now = Carbon::now();
$nowPlus1Month = Carbon::now()->addMonth();
//If you want to sub a month:
$nowMinusMonth = Carbon::now()->subMonth();

$result = MyTable::whereBetween('expire_date', [$now, $nowPlus1Month])->get();

// Or
$result = MyTable::whereBetween('expire_date', [$nowMinusMonth, $now])->get();

希望能帮助到你。