Warm tip: This article is reproduced from serverfault.com, please click
laravel-5.4 php schema

creating a column for price in a laravel schema

发布于 2017-07-08 10:11:05

I want to create a column for price in a laravel schema.

public function up()
{
    Schema::create('cameras', function (Blueprint $table) {
        $table->increments('id');
        $table->string('name');
        $table->string('condition');
        $table->string('price');
        $table->string('type');
        $table->timestamps();
    });
}

Or is there an alternative data type I can use? As I don't see anything for monetary value in the documentation. Any help would be appreciated.

Questioner
AltBrian
Viewed
0
分享
3,958 2021-02-09 16:05:08

There is 'float' type for your purpose it seems fine unless you don't want to save currency too:

$table->float('amount')

Available types are listed in documentation. https://laravel.com/docs/5.4/migrations#creating-columns

If you do want to save currency with price you will have to use string , or create a new column for currency-type can be another work around.

stardust4891 2019-04-06 07:31:46

float can lead to precision issues. better to use decimal.

i-- 2021-01-21 21:42:19

Decimals are what should be used, see this post

热门帖子

1
有什么不错的口粮茶推荐吗
2
有人需要代开吗 虚拟卡付款 120 一月
3
BT 真的死了吗
4
Win11 绕过 TPM2.0 安装后能否正常更新
5
MES给制造业带来看得见的效益
6
2024 了 苹果为什么还是不上电荷泵？
7
Casvisor：带 Web UI 的开源堡垒机，支持 RDP、VNC、SSH 远程桌面、主机和数据库管理、批量执行命令、单点登录
8
App Store (iOS) 能不能赠送“内购项目”给别人？
9
移动芒果卡 59 月租升到 79，到处都不能办？！
10
出一台紫色 mini6 64gb 蜂窝版

热门github

1
Implementation of paper - YOLOv9: Learning What You Want to Learn Using Programmable Gradient Information
2
A Windows and Office activator using HWID / Ohook / KMS38 / Online KMS activation methods, with a focus on open-source code and fewer antivirus detections.
3
Get up and running with Llama 2, Mistral, Gemma, and other large language models.
4
该项目可以让你通过订阅的方式使用Cloudflare WARP+，自动获取流量。This project enables you to use Cloudflare WARP+ through subscription, automatically acquiring traffic.
5
Multi functional app to find duplicates, empty folders, similar images etc.
6
Xray panel supporting multi-protocol multi-user expire day & traffic & ip limit (Vmess & Vless & Trojan & ShadowSocks & Wireguard)
7
The Free Software Media System
8
lightweight, standalone C++ inference engine for Google's Gemma models.
9
📚 Freely available programming books
10
A collective list of free APIs
11
1️⃣🐝🏎️ The One Billion Row Challenge -- A fun exploration of how quickly 1B rows from a text file can be aggregated with Java
12
🎓 Path to a free self-taught education in Computer Science!
13
Curso para aprender el lenguaje de programación Python desde cero y para principiantes. 75 clases, 37 horas en vídeo, código, proyectos y grupo de chat. Fundamentos, frontend, backend, testing, IA...
14
This repository contains System Design resources which are useful while preparing for interviews and learning Distributed Systems
15
Mamba is a new state space model architecture showing promising performance on information-dense data such as language modeling, where previous subquadratic models fall short of Transformers. It is based on the line of progress on structured state space models, with an efficient hardware-aware design and implementation in the spirit of FlashAttention.