CODEWITHSUNDEEP
sqllaraveleloquentlaravel-5
confm
confm

Reputation: 297

Laravel - Number with 4 decimals

I want to store 1 number with 4 decimals, in my database.

If i use float i can add only 2 decimals

$table->float('sell');

enter image description here

If I try with decimal i get an error

$table->decimal('sell', 1, 4);

The first number must be greater than or equal to the second number.

SQLSTATE[42000]: Syntax error or access violation: 1427 For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column '

sell'). (SQL: create table customers (id int unsigned not null auto_increment primary key, sell decimal(1, 4) not null,
created_at timestamp null, updated_at timestamp null) default character set utf8 collate utf8_unicode_ci)

Any help?

Thanks

Upvotes: 8

Views: 52660

Answers (5)

Vinay Kaithwas
Vinay Kaithwas

Reputation: 1513

In your schema file.

 $table->decimal('your_field_name', 13, 4);
  • your_field_name = Database field name.
  • 13 = Total number of digit. Example- $99,999,999,999.99
  • 4 = value after decimal. Example - $999,999,999.9999

Upvotes: 22

Maizied Hasan Majumder
Maizied Hasan Majumder

Reputation: 1053

Try number_format

For laravel:

{!! number_format((float)($item->amount), 5) !!}

For Raw PHP:

number_format((float)($yourVariable), 5)

Upvotes: 1

Akbor
Akbor

Reputation: 1358

Please following code

$table->float('sell', 5, 4); FLOAT equivalent for the database, 5 digits in total and 4 after the decimal point.

Thanks

Upvotes: -2

Nikunj K.
Nikunj K.

Reputation: 9199

You have made a small mistake with parameter 

$table->decimal('amount', 5, 2);

In above example first parameter is the field name. Second, parameter is the total length. Third, parameter is the float value.

Upvotes: 3

Darren Taylor
Darren Taylor

Reputation: 2025

Use the following;

$table->decimal('foo', 5, 4);

The first parameter is the total number of numbers, the second parameter is the "decimal precision".

Upvotes: 28

Related Questions