Fetch data year and month wise in laravel
<?php $datas = DB::table('order') ->whereYear('created_at', '2021') ->whereMonth('created_at', '04') ->sum('total'); echo $datas; ?>
0 Comments
July 29, 2023
Calculator for invoice using javascript
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.3/jquery.min.js"></script> <script> function totalPrice($val){ let amt = 0; let arrlength = 1; let arr = document.getElementsByName('owner_shares'); for(let index = 0; index < arr.length; index++){ let price = arr[index].value;…
July 29, 2023
Flash Session in laravel and PHP
If you wish to add flash data to a redirect and show the message on the destination page instead, Livewire is smart enough to persist the flash data for one…
July 29, 2023
Duplicate form using jquery
<form class="duplicateForm"> <div class="row duplicate my-3"> <div class="col-12 col-sm-6 col-md-6 col-lg-4 col-xl-4"> <lable>Fixed Cost</lable> <input type="number" name="owner_name[]" class="form-control owner_name" /> </div> <div class="col-12 col-sm-6 col-md-6 col-lg-4 col-xl-4"> <lable>Urgent Cost</lable>…
July 29, 2023
Where clause for date & time
In SQL, some problems require us to retrieve rows based on their dates and times. For such cases, we use the DATETIME datatype present in SQL. For this article, we…
July 28, 2023
Where and like condition with laravel aggregates operators
Friends, in where condition and like operator both are very important to fetch the data in any Laravel query and it is very useful not only in laravel but also…
July 28, 2023
Where in laravel
The where clause queries a database. In this shot, we will learn to use the where() query builder to query the database. This is an important and basic concept while writing a query in…
July 28, 2023
- Go to the previous page
- 1
- …
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- …
- 77
- Go to the next page