CATEGORIES : MySQL
How To Get Hourly Data In MySQL Query
In this article, we will see how to get hourly data in MySQL Query. Many times we need to get hourly data or we are required to get data every hour in MySQL. For getting data for every ho...
MySQL
Laravel 8 Get Last 30 Days Record From Database
In this article, we see laravel 8 get the last 30 days record from the database. In PHP, you can use INTERVAL to get the last 30 days record from the database. Also, we can see how to get ...
Laravel PHP MySQL
Laravel 8 Get Last 7 Days Records
In this article, we will see laravel 8 get the last 7 days records. In PHP, you can use INTERVAL to get the last 7 days record from the database. In laravel, you can get the last 7 days r...
Laravel PHP MySQL
Laravel 8 Get Latest Record From Database
In this article, we will see laravel 8 get the latest records from the database. In PHP, you can use order by clause with descending order to get the last record from the database but in larav...
Laravel PHP MySQL
Laravel 8 AJAX CRUD Using Datatable
In this article, we will see the laravel 8 AJAX CRUD operation using datatable. we will perform the AJAX CRUD operation without page refresh. If you don't want to page reload when you...
Laravel PHP jQuery MySQL Bootstrap
Laravel 8 Order By Query Example
In this article, we will see laravel 8 order by query example. how to use order by in laravel 8.The orderBy method allows you to sort the results of the query by a given colu...
Laravel 8 Group By Query Example
In this article, we will see laravel 8 group by query example. how to use group by in laravel 8. As you might expect, the groupBy and having metho...
Laravel 8 Left Join Query Example
In this article, we will see laravel 8 left join query example. laravel left join eloquent returns all rows from the left table, even if there are no matches in the right table. The result is...
Laravel PHP MySQL
Laravel 8 Inner Join Query Example
In this article, we will learn about laravel 8 inner join query example. Also, see how to join two tables in laravel 8. In laravel you can use group by query same as PHP. So, we will also see a que...
Laravel PHP MySQL
Laravel 8 Many To Many Polymorphic Relationship
In this article, we will explore Laravel 8/9/10 many-to-many polymorphic relationships. These relationships are more complex than morph one and morph many relationships and can be utilized in Larav...
Laravel PHP MySQL
