Laravel Sum Query – i often need to get sum of total visitors, amount, salary etc in PHP laravel. get the sum of two different…
Programming
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…
10 digit mobile number validation in php – how to validate 10 digit phone number?
10 digit mobile number validation in php – preg_match() checking it is integer or not and in strlen() it is checking no of digit in…
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…
how to uninstall angular cli – uninstall/upgrade Angular CLI
how to uninstall angular cli : We will use the following command to uninstall Angular CLI like this: the npm uninstall -g @angular/cli & npm…