PHP Looping through a FOREACH loop

Question

I have a FOREACH loop which is not picking up the first element in the array.

I have a submit form which has the following:

<input name="repaired[<?php echo $row_Faults['UniqueID']; ?>]" type="checkbox" id="repaired" value="1" class="required"/>

If I echo the $_POST['repair'] array I see two records but when the code is run the first record is not been processed.

foreach($_POST['repaired'] as $uniqueID => $repairedValue){   

$updateSQL = sprintf("UPDATE ".$Hist." SET Status=%s, LettoStatus=%s WHERE UniqueID= '".$_POST["UniqueID"]."'",
 GetSQLValueString($_POST['Status'] = $StatusCode , "int"),
GetSQLValueString($_POST['LettoStatus'] = $LettoCode , "int"));

mysql_select_db($database_iMaint, $iMaint);
$Result1 = mysql_query($updateSQL, $iMaint) or die(mysql_error());
}

Can anyone see where I am going wrong.

Many thanks in advance for your time.

Although not directly related to your question I highly recommend sanitizing your inputs. See stackoverflow.com/questions/129677/… — Kenneth P. Hough
– Kenneth P. Hough, Commented Jan 30, 2017 at 20:52
You have $uniqueID var in your foreach but in your $updateSQL you still use $_POST["UniqueID"]. — Vitalii Strimbanu
– Vitalii Strimbanu, Commented Jan 30, 2017 at 20:55
@Jose Manuel Abarca Rodríguez He should, I am waiting for hime to do so. — DCJones
– DCJones, Commented Jan 30, 2017 at 21:18

Vitalii Strimbanu · Accepted Answer · 2017-01-30 21:21:27Z

3

You have $uniqueID variable initialized in your foreach but in your $updateSQL you still use $_POST["UniqueID"] So all you need is to change your $updateSQL

$updateSQL = sprintf("UPDATE ".$Hist." SET Status=%s, LettoStatus=%s WHERE
    UniqueID= '".$uniqueID."'",    
    GetSQLValueString($_POST['Status'] = $StatusCode , "int"),
    GetSQLValueString($_POST['LettoStatus'] = $LettoCode , "int"));

answered Jan 30, 2017 at 21:21

Vitalii Strimbanu

4773 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP Looping through a FOREACH loop

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related