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>
Laravel 5 - Confirmation before delete record from database example
Open Post
How to create blade view file using command line in Laravel?
Open Post
How to add custom jquery validation for image file upload in summernote ?
Open Post
Laravel 5 dropbox api file upload example using league/flysystem-dropbox package
Open Post
Laravel 5 - Paypal Payment Integration example using netshell/paypal package from scratch
Open Post
Laravel 5 create custom artisan command with example
Open Post
