php - 如何在列上减去两个值并在另一列中显示mysql

Question

我是 php 和 mysql 的新手，所以请不要对我的问题投反对票。我有从 html 表单获取输入的数据库，我需要一个名为 KIASI_KILICHOBAKI 的列来自动插入名为 KIASI_ALICHOUZIWA - KIASI_ALICHOTOA 的两列的减法。这些是我的代码：

$KIASI_ALICHOUZIWA =    $mysqli->real_escape_string($_REQUEST['KIASI_ALICHOUZIWA']);
$KIASI_ALICHOTOA = $mysqli->real_escape_string($_REQUEST['KIASI_ALICHOTOA']);

// Attempt insert query execution 

$sql = ("INSERT INTO taarifa (TAREHE,JINA_LA_KWANZA, JINA_LA_MWISHO,     NAMBA_YA_SIMU, SHINGO, BEGA, KIFUA, TUMBO, UPANA_WA_MKONO, UREFU_WA_MKONO,  HIPS_YA_KOTI, CHINI_UPANA_MKONO, HIPS_SURUALI, PAJA, KIUNO, GOTI,  UREFU_WA_SURUALI,CHINI_UPANA_SURUALI, ROUND_SURUALI, UREFU_WA_KIZIBAO, NAFASI_YA_KIZIBAO, HIPS_YA_KIZIBAO, UREFU_WA_MKONO_KIZIBAO , ROUND_YA_MKONO_KIZIBAO, KIASI_ALICHOUZIWA, KIASI_ALICHOTOA, KIASI_KILICHOBAKI) VALUES ('$TAREHE', '$JINA_LA_KWANZA', '$JINA_LA_MWISHO',  '$NAMBA_YA_SIMU', '$SHINGO', '$BEGA', '$KIFUA', '$TUMBO', '$UPANA_WA_MKONO','$UREFU_WA_MKONO','$KOTI', '$CHINI_UPANA_MKONO', '$SURUALI', '$PAJA', '$KIUNO', '$GOTI' ,'$UREFU_WA_SURUALI',  '$CHINI_UPANA_SURUALI', '$ROUND_SURUALI', '$UREFU_WA_KIZIBAO' , '$NAFASI_YA_KIZIBAO', '$HIPS_YA_KIZIBAO' , '$UREFU_WA_MKONO_KIZIBAO' ,'$ROUND_YA_MKONO_KIZIBAO' , '$KIASI_ALICHOUZIWA' , '$KIASI_ALICHOTOA' , '$KIASI_KILICHOBAKI')");
if($mysqli->query($sql) === true){
header('Location: http://127.0.0.1/dashboard/myindex.php');
} else{
echo "ERROR: Could not be able to execute $sql. " . $mysqli->error;
}

// Close connection
$mysqli->close();
?>

标签： phpmysql

Answer 1

您尚未创建 $KIASI_KILICHOBAKI 变量来保存答案。在插入查询之前添加以下代码

$KIASI_KILICHOBAKI = $KIASI_ALICHOUZIWA - $KIASI_ALICHOTOA;