如何为Empty($ _ POST)设置默认值? [英] How to set a default Value for Empty($_POST)?
问题描述
我有很多$ _POST变量，想将它们插入数据库中.
I have a lot of $_POST variables and want to insert them into the database.
有效.但是我必须将默认值设置为"NA".当用户没有填写表格时.
it works. But I must set a default value of "NA" when a user doesn't fill in the form.
这是我的代码:
$tgl_real = $_POST['TGL_REAL'];
$rid = $_POST['RID'];
$mesin = $_POST['MESIN'];
$shift = $_POST['SHIFT'];
$produk = $_POST['PRODUK'];
$tanggal = $_POST['HT'];
$no_aduk = $_POST['NO_ADUK'];
$sho = $_POST['SHO'];
$tb1 = $_POST['TB1'];
$gr1 = $_POST['GR1'];
$tb2 = $_POST['TB2'];
$gr2 = $_POST['GR2'];
$tb3 = $_POST['TB3'];
$gr3 = $_POST['GR3'];
$tb4 = $_POST['TB4'];
$gr4 = $_POST['GR4'];
$tb5 = $_POST['TB5'];
$gr5 = $_POST['GR5'];
$spr_besar = $_POST['SPR_BESAR'];
$spr_kecil = $_POST['SPR_KECIL'];
$br1 = $_POST['BR1'];
$br2 = $_POST['BR2'];
$br3 = $_POST['BR3'];
$tebal1 = $_POST['TEBAL1'];
$tebal2 = $_POST['TEBAL2'];
$tebal3 = $_POST['TEBAL3'];
$panjang = $_POST['PANJANG'];
$lebar = $_POST['LEBAR'];
$diameter = $_POST['DIAMETER'];
$kc = $_POST['KC'];
$kkc = $_POST['KKC'];
$kerataaan_poles = $_POST['KERATAAN_POLES'];
$sql = "INSERT INTO adonan SET `RID` = '$rid',
`MESIN` = '$mesin',
`SHIFT` = '$shift',
`HARI_TGL` = '$tanggal',
`TGL_REAL` = '$tgl_real',
`PRODUK` = '$produk',
`NO_ADUK` = '$no_aduk',
`KERATAAN_SHO` = '$sho',
`TEBAL_SHEET_GR1` = '$tb1',
`KECAPATAN_KAIN_GR1` = '$gr1',
`TEBAL_SHEET_GR2` = '$tb2',
`KECAPATAN_KAIN_GR2` = '$gr2',
`TEBAL_SHEET_GR3` = '$tb3',
`KECAPATAN_KAIN_GR3` = '$gr3',
`TEBAL_SHEET_GR4` = '$tb4',
`KECAPATAN_KAIN_GR4` = '$gr4',
`TEBAL_SHEET_GR5` = '$tb5',
`KECAPATAN_KAIN_GR5` = '$gr5',
`SPEED_ROLL_BESAR_WC` = '$spr_besar',
`SPEED_ROLL_KECIL_WC` = '$spr_kecil',
`BERAT1_ADONAN` = '$br1',
`BERAT2_ADONAN` = '$br2',
`BERAT3_ADONAN` = '$br3',
`KETEBALAN1_ADONAN` = '$tebal1',
`KETEBALAN2_ADONAN` = '$tebal2',
`KETEBALAN3_ADONAN` = '$tebal3',
`PANJANG_ADONAN` = '$panjang',
`LEBAR_ADONAN` = '$lebar',
`DIAMATER_ADONAN` = '$diameter',
`MOLDER_SPEED` = '$kc',
`KONVEYOR_SPEED` = '$kkc',
`KERATAAN_POLES` = '$kerataaan_poles',
`PROSENTASE_POLES` = '$prosentase_poles',
`KERATAAN_GULA` = '$kerataaan_gula',
`PROSENTASI_GULA` = '$kerataaan_gula'";
该$ _POST正在从文件中获取数据，但是如何设置默认值("NA") 当用户不填写值时，在我的数据库中.
That $_POST is geting data from a file, but how do I set a default ("NA") value in my database when a user doesn't fill in a value.
铌:
我尝试在mysql数据库中设置默认的NA，但是当用户不填写时，它不起作用，我的列字段仍然为空
I have tried to set a default NA in my mysql database, but it didn't work when a user doesn't fill in, my column field is still empty
不要建议我使用jquery验证，因为有时用户会填写它，有时不会.
Dont advice me to use jquery validation, because sometimes a user fills it in and somtimes not.
数据库列中的字符串("NA")不能为空.
The database column must be not empty with ("NA") string.
我的数据库类型数据是Varchar
my database type data is Varchar
任何人都可以帮助我仅通过PHP或任何其他方式来解决此问题吗?
Can anyone help me to fix this only with PHP or any other way?
谢谢.
推荐答案
In php 5 you can use isset().
$tgl_real = isset($_POST['TGL_REAL'])? $_POST['TGL_REAL']:'NA';
在php 7中，您不需要isset()，可以使用??:
in php 7, you do not need isset(), you can use ??:
$tgl_real = $_POST['TGL_REAL']?? 'NA';
您还可以使用 empty()检查POST数据是否为空或不是.
You can also use empty() to check POST data is empty or not.
if(empty($_POST['TGL_REAL'])){
$tgl_real = 'NA';
}else{
$tgl_real = $_POST['TGL_REAL'];
}
实际上，您可以设置默认约束在mysql中，然后检查以设置NOT NULL
In fact, you can set default Constraint in mysql and check to set NOT NULL
这篇关于如何为Empty($ _ POST)设置默认值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
