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...
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...
In this article, we will see laravel 9 autocomplete search from the database. Using 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...
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...
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...
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...
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...
