想寻求帮助以找出这些代码有什么问题。在我添加 op_plan、op_reg、op_proj、audit_plan、audit_reg、audit_proj 之前，它运行良好。但是添加后，数据库和表不会更新。我试着从这个网站寻找答案，仍然没有运气。提前致谢!

错误信息是: 注意:未定义索引:updateplan 中的 op_plan 注意:未定义索引:updateplan 中的 op_reg 注意:未定义索引:updateplan 中的 op_proj 注意:未定义索引:updateplan 中的 audit_plan 注意:未定义索引:updateplan 中的 audit_reg 注意:未定义索引:updateplan 中的 audit_proj 更新计划 您的更改已保存!

<?php
include ('db_config.php');

$alp_plan = $_POST['alp_plan'];
$alveo_plan = $_POST['alveo_plan'];
$avida_plan = $_POST['avida_plan'];
$amaia_plan = $_POST['amaia_plan'];
$bellavita_plan = $_POST['bellavita_plan'];
$vismin_plan = $_POST['vismin_plan'];
$finance_plan = $_POST['finance_plan'];
$finance_reg = $_POST['finance_reg'];
$finance_proj = $_POST['finance_proj'];
$hr_plan = $_POST['hr_plan'];
$hr_reg = $_POST['hr_reg'];
$hr_proj = $_POST['hr_proj'];
$bpaqa_plan = $_POST['bpaqa_plan'];
$bpaqa_reg = $_POST['bpaqa_reg'];
$bpaqa_proj = $_POST['bpaqa_proj'];
$isu_plan = $_POST['isu_plan'];
$isu_reg = $_POST['isu_reg'];
$isu_proj = $_POST['isu_proj'];
$bench_plan = $_POST['bench_plan'];
$bench_reg = $_POST['bench_reg'];
$bench_proj = $_POST['bench_proj'];
$admin_plan = $_POST['admin_plan'];
$admin_reg = $_POST['admin_reg'];
$admin_proj = $_POST['admin_proj'];
$inbound_plan = $_POST['inbound_plan'];
$inbound_reg = $_POST['inbound_reg'];
$inbound_proj = $_POST['inbound_proj'];
$records_plan = $_POST['records_plan'];
$records_reg = $_POST['records_reg'];
$records_proj = $_POST['records_proj'];
$alp_reg = $_POST['alp_reg'];
$alp_proj = $_POST['alp_proj'];
$alveo_reg = $_POST['alveo_reg'];
$alveo_proj = $_POST['alveo_proj'];
$avida_reg = $_POST['avida_reg'];
$avida_proj = $_POST['avida_proj'];
$amaia_reg = $_POST['amaia_reg'];
$amaia_proj = $_POST['amaia_proj'];
$bellavita_reg = $_POST['bellavita_reg'];
$bellavita_proj = $_POST['bellavita_proj'];
$vismin_reg = $_POST['vismin_reg'];
$vismin_proj = $_POST['vismin_proj'];
$op_plan = $_POST['op_plan'];
$op_reg = $_POST['op_reg'];
$op_proj = $_POST['op_proj'];
$audit_plan = $_POST['audit_plan'];
$audit_reg = $_POST['audit_reg'];
$audit_proj = $_POST['audit_proj'];
$remarks = mysqli_real_escape_string($con, $_POST['remarks']);
$year = $_POST['year'];





$sql = "UPDATE manpowerplan SET alp_plan = '$alp_plan', alveo_plan = '$alveo_plan', avida_plan = '$avida_plan', amaia_plan = '$amaia_plan', bellavita_plan = '$bellavita_plan', vismin_plan = '$vismin_plan', finance_plan = '$finance_plan', finance_reg = '$finance_reg', finance_proj = '$finance_proj', hr_plan = '$hr_plan', hr_reg = '$hr_reg', hr_proj = '$hr_proj', bpaqa_plan = '$bpaqa_plan', bpaqa_reg = '$bpaqa_reg', bpaqa_proj = '$bpaqa_proj', isu_plan = '$isu_plan', isu_reg = '$isu_reg', isu_proj = '$isu_proj', bench_plan = '$bench_plan', bench_reg = '$bench_reg', bench_proj = '$bench_proj', admin_plan = '$admin_plan', admin_reg = '$admin_reg', admin_proj = '$admin_proj', inbound_plan = '$inbound_plan', inbound_reg = '$inbound_reg', inbound_proj = '$inbound_proj', records_plan = '$records_plan', records_reg = '$records_reg', records_proj = '$records_proj', alp_reg = '$alp_reg', alp_proj = '$alp_proj', alveo_reg = '$alveo_reg', alveo_proj = '$alveo_proj', avida_reg = '$avida_reg', avida_proj = '$avida_proj', amaia_reg = '$amaia_reg', amaia_proj = '$amaia_proj', bellavita_reg = '$bellavita_reg', bellavita_proj = '$bellavita_proj', vismin_reg = '$vismin_reg', vismin_proj = '$vismin_proj', op_plan = '$op_plan', op_reg = '$op_reg', op_proj = '$op_proj', audit_plan = '$audit_plan', audit_reg = '$audit_reg', audit_proj = '$audit_proj', remarks = '$remarks' WHERE year = '$year'";

    $query = mysqli_query($con, $sql); 
    if(!$query)
        echo $sql;
    else
        echo "Your changes have been saved! " ;
?>

最佳答案

那些变量 op_plan, op_reg, op_proj, audit_plan, audit_reg, audit_proj, 未定义，您应该将它们添加到表单中，在将它们添加到表和 SQL 查询之后，现在它们 $_POST 不会获取它们并将它们设为“未定义”。

请添加表单代码，以便看起来如何。

关于php - 在 MySQL PHP 中更新查询，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/39075170/