In my database, here is what I have
I've tried to query everything and order by price
$service_plans = DB::table('service_plans') ->orderBy('price', 'asc') ->get();
I kept getting
Did I miss anything or did anything that I'm not suppose to here ?
Any hints ?
P.S. Keep in mind that I'm using jQuery DataTables
Since you're using Datatables jQuery plug-in, remove the orderBy in your controller query.
Instead, sort via datatables (which will do so by default):
$('#datatable').DataTable({
"order": [[ 2, "asc" ]] // Order on init. # is the column, starting at 0
});
There's also a nice little Laravel package for datatables that will set the data. Check it and see if it'd be useful: https://github.com/yajra/laravel-datatables
You still get that data because of the datatables does ordering your data as well, so your orderBy query isn't work. Just set to your parameter datatable ordering: false to make it works.
$('#datatable').DataTable({
ordering: false, //disable ordering datatable
});
so, you can sort your data by whatever fields you want althought you dont want to show them in your table.
You can add a $casts property to your ServicePlan model. This will treat the column as the implicit data type regardless of the database data type.
class ServicePlan extends Model
{
/**
* The attributes that should be casted to native types.
*
* @var array
*/
protected $casts = [
'price' => 'integer',
];
}
https://laravel.com/docs/5.2/eloquent-mutators#attribute-casting
laravel makes sense. Mike Barwick suggested excellent yajra/laravel-datatables package for Laravel to work with jQuery DataTables.Type of price field is string so change it to decimal with 2 numbers after comma.
Run in mysql console:
ALTER TABLE service_plans MODIFY price DECIMAL(10,2);
!!! When making modification on tables on production make sure that You've copy of table before calling ALTER TABLE:
CREATE TABLE service_plans_bak AS SELECT * FROM service_plans;
datatables tag and OP confirms that he's using jQuery DataTables in comments. With jQuery DataTables sorting is either done client-side or server-side but not in the way OP does it.
pricecolumn in your database? Also, you aren't by chance using DataTables for display are you?dd($service_plans)right after your query and look at the output. If it's sorted there (which I expect it is), you know Laravel is doing things correctly and it's something else which is resorting after.orderByis not working.