Tag : Database


Laravel 9 Left Join Query Example

Laravel 9 Left Join Query Example

In this article, we will see the laravel 9 left join query example. laravel 9 left join eloquent returns all rows from the left table, even if there are no matches in the right table, The result is NULL from the right side. We will also see query of laravel 9 left join with groupBy(). If you...

Laravel 9 Inner Join Query Example

Laravel 9 Inner Join Query Example

In this article, we will see laravel 9 inner join query example. Also, see how to join two tables in laravel 9. In laravel 9 you can use group by query same as PHP. So, we will also see query of laravel 9 inner join with the group by. The query builder may also be used to add join clauses to...

Laravel 9 Autocomplete Search from Database

Laravel 9 Autocomplete Search from Database

In this article, we will see laravel 9 autocomplete search from the databaseUsing ajax autocomplete textbox in laravel 9 we will get records from the database and get in laravel 9.

So, let's see laravel 9 autocomplete search example, autocomplete search in la...

Laravel 9 Multiple Database Connections

Laravel 9 Multiple Database Connections

In this tutorial, we will see laravel 9 multiple database connections. we will implement how to use laravel 9 multiple database connections.

Many times we have requirements in our project to use multiple database connections like MySQL, MongoDB, PostgreSQL etc. When...

How To Get Last 15 Days Records In MySQL

How To Get Last 15 Days Records In MySQL

In this tutorial, we will see how to get the last 15 days records in MySQL PHP.  In PHP, you can use INTERVAL to get the last 15 days record from the database table. For MySQL query, we use the INTERVAL operator. It is mainly used to calculate the date and time value...

How To Get Current Month Records In MySQL

How To Get Current Month Records In MySQL

In this tutorial, we will see how to get current month records in MySQL. For data analysis and reporting, we need more data or records. So, we will learn how to get current month data in MySQL PHP.

For getting data for the current month in MySQL we use the month() function. MySQL m...

How To Get Current Week Records In MySQL

How To Get Current Week Records In MySQL

In this tutorial, we will see how to get current week records in MySQL. Many times we need to get current week records or fetch this week’s records for reporting and analysis. So, we will learn how to get current week data in MySQL PHP.

For getting data for the week in M...

Recommended Post
Featured Post





Follow us
facebooklogo github instagram twitter