Tag : Now
We may sometimes require to get few days ago records from table like last 2 days, last 3 days, last 10 days or last 15 days etc. Most of developer choose other logic but we can easily get using mysql query(using CURDATE and INTERVAL).
In this example mysql query i have one table "elements" and columns are id, title, description, created_at(timestamps) and update_at, Now we will get all records of last 2 days.so you can fetch fields value using CURDATE and INTERVAL of mysql. In following example you can see how to select data of last two days.
<strong>Query:</strong>
<pre>
SELECT * FROM `elem.....
If you require to get all the records of current year using mysql query. for example you have one table "items" and columns are id, title, description, created_at and update_at, Now you want to get all records of this year. so you can fetch fields value using DATE_SUB and INTERVAL of mysql. In following example you can see how to select data of current year.
<strong>Example:</strong>
<pre>
SELECT * FROM items WHERE created_at > DATE_SUB(NOW(), INTERVAL 1 YEAR);
</pre>
If you require to get all the records of current month using mysql query. for example you have one table "items" and columns are id, title, description, created_at and update_at, Now you want to get all records of this month. so you can fetch fields value using DATE_SUB and INTERVAL of mysql. In following example you can see how to select data of current month.
<strong class="example">Example:</strong>
<pre class="language-mysql">SELECT * FROM items WHERE created_at > DATE_SUB(NOW(), INTERVAL 1 MONTH);</pre>
How to create custom facade in laravel 5.2?
Open Post
How to integrate stripe payment gateway in Laravel 5.4 Application ?
Open Post
PHP Image upload without refreshing page using jquery example
Open Post
Laravel 5.3 - Form Input Validation rules example with demo
Open Post
Laravel 5 Ajax CRUD with Pagination example and demo from scratch
Open Post
Laravel 5 Stripe example using Laravel Cashier from Scratch
Open Post
