unique collection method can be used to get all the unique items in the collection. it’s part of the Enumerable contract. unique collection also you…
Mysql
Laravel Sum Query with Where Condition Example
Laravel Sum Query – i often need to get sum of total visitors, amount, salary etc in PHP laravel. get the sum of two different…
sql concatenate two columns – How to Concat First Name and Last Name in Laravel?
sql concatenate two columns with Concat First Name and Last Name in laravel db select query with Controller Code bellow. sql concatenate two columns you…
laravel search query – How to Search First Name and Last Name in Laravel Query?
Laravel search query with multiple conditions add simple “where” clauses to your search queries Example with Like Operator. laravel search query The database table stores…
Laravel Group By with Max Value Query 3 Example
Laravel Group By with Max Value Query you need help in getting the max id of a table that is grouped by member_id in laravel.…
mysql connect to remote database – Laravel Connect Remote Database using SSH Tunnel Example
mysql connect to remote database To connect remote database using ssh tunnel in laravel Example with demo step by step bellow. mysql connect to remote…
How to run Cron jobs every 5, 10, 15, 20, or 30 minutes?
Cron is a time-based system or logic based useful tool used for scheduling tasks. as well as Tasks could be scheduled to execute by a…
search in php mysql with examples – How to Create a Search Feature with PHP and MySQL?
search in php mysql with examples – You can make an HTML form that allows you to find or search all the database records in…
select data between two dates in mysql – How to query between two dates in MySQL?
select data between two dates in mysql – MYSQL Query for Data between Two Dates Example – SELECT * FROM `table_name` WHERE active=0 AND CURDATE()…
sql sum group by – SQL SUM() function with group by
sql sum group by Using PostgreSQL GROUP BY without an aggregate function, PostgreSQL GROUP BY with SUM() function, PostgreSQL GROUP BY clause with the JOIN…
add column after another column in mysql
add column after another column in mysql – alter table add column after another column mysql. SQL Query to Add a New Column After an…
mysql update join – MySQL update with JOIN and WHERE clause
mysql update join with syntax, MySQL UPDATE JOIN examples, INNER JOIN clause, LEFT JOIN and MySQL UPDATE JOIN with the INNER JOIN and LEFT JOIN…