两个循环文本字段的每一个，可能的 - Foreach of TWO Looping TextFields, possible?

Foreach of TWO Looping TextFields, possible?

    /* Adding Experiences */
$("#addExperience").click(function () {
if(experiencectr>5){
        alert("WOW! But 5 experiences are enough.");
        return false;
}   
var newTextBoxDiv = $(document.createElement('div'))
     .attr("id", 'ExperienceDiv' + experiencectr);
newTextBoxDiv.html('<label>Experience No. '+ experiencectr + ' : </label>' +
      '<input type="text" name="experience[]" id="experience' + experiencectr + '" >&nbsp;' +
      '<input type="text" id="year' + experiencectr +
      '" size="5" name="years[]"><label>years</label>');
newTextBoxDiv.appendTo("#ExperienceBoxesGroup");

experiencectr++;
 });

在上面的代码中，它添加了两个字段:experience和years。

    foreach ($_POST['experience'] as $experience) {
// save $experience to database
$sql_experience = "INSERT INTO experiences(number,experience)
values ('$number','$experience')";
if($result3 = mysql_query($sql_experience ,$db))
    {
            foreach ($_POST['years'] as $years) {
            $sql_years = "UPDATE experiences SET years=$years WHERE experience=$experience";
            if($result = mysql_query($sql_years ,$db))
                { }
            else 
                { echo "ERROR: ".mysql_error(); }
            }
    }
else 
    { echo "ERROR: ".mysql_error(); }
}

在上面的代码中，它保存到数据库中，但字段列在所有行中具有相同的值。你们能帮帮我吗?

您必须获得索引才能访问另一个数组中的值:

foreach($_POST['experiences'] as $idx => $experience) {
    $sql = "INSERT INTO experiences (number, experience, years)
            VALUES ({$idx}, {$experience}, {$_POST['years'][$idx]}");
    // execute query, etc
}

这将工作，但你可能不应该这样做，因为它会让你打开SQL注入。更好的方法是对输入进行消毒(例如:mysql_reaL_escape_string或其mysqli等价)

最好的方法是使用预处理语句:

$stmt = $dbh->prepare("INSERT INTO experiences (number, experience, years) 
                       VALUES (?, ?, ?)");
foreach($_POST['experiences'] as $idx => $experience) {
    // pass values and execute
    $stmt->execute(array($idx, $experience, $_POST['years'][$idx]));
}