在数据库表中插入值时会插入一些值，而有些值则不会

Question

This is my php code. when i enter the values only divisionname, divisionchief, month and periods values gets inserted in the database table.

if (isset($_POST['submit'])) {

include('includes/connect.php');
for ($i=1; $i<=3; $i++)
{
$divisionname = $_POST['divisionname'];
$divisionchief= $_POST['divisionchief'];
$period = $_POST['period'];
$month = $_POST['month'];
$activityname = $_POST['activityname'.$i];
$unit = $_POST['unit'.$i];
$weightage = $_POST['weightage'.$i];
$per100 = $_POST['per100'.$i];
$per75 = $_POST['per75'.$i];
$per50 = $_POST['per50'.$i];
$perless50 = $_POST['perless50'.$i];


$sql="INSERT INTO workplan_detail(division_name, division_chief, Period, Month, activity_name, Unit, Weightage, per_100, per_75, per_50, per_less50) VALUES ('$divisionname', '$divisionchief', '$period', '$month', '$activityname', '$unit', '$weightage', '$per100', '$per75', '$per50', '$perless50')";
    mysql_query($sql);

    header("location:workplan.php");
    }`
    echo"This information has been added to the database."; 
}
?>

Answer 1

This code:

$activityname = $_POST['activityname'.$i];

generates, for instance on the first loop:

$activityname = $_POST['activityname1'];

If there is no input from the form with that precise name, the value will be empty.

If you have an array of inputs coming from a form like:

<input name="activityname[]" />

Then the array index will start at 0, and your PHP should be:

for ($i=0; $i<=2; $i++)
{
    $divisionname = $_POST['divisionname'];
    $divisionchief= $_POST['divisionchief'];
    $period = $_POST['period'];
    $month = $_POST['month'];
    $activityname = $_POST['activityname'][$i]; //right here
    $unit = $_POST['unit'][$i];
    //etc, following this pattern...
}