Break While和Foreach循环

Question

I have the following code below, my question is, I want to break out of the while loop if the user enters "n" and also continue with the next foreach interation. Please see my comment within.

foreach($nodeid as $nid){

    $query= $dbh->query("SELECT * FROM Nodes WHERE Node_ID = '$nid' AND New = 1")or die(mysql_error());

    if($query->rowCount() > 0)
    { 
        while (1) {
            fputs(STDOUT, "
"."***New Node*** : $nid 
 Do you want to add ? [y,n]: ");
            $response = strtolower(trim(fgets(STDIN)));
            if( $response == 'y' ) {
                #do something then break and go to next foreach.
            } elseif( $response == 'n' ) {
                #go to next foreach $nid
            } else {
                echo "
", "I don't understand your option, let's try this again", "
";
                continue;
            }
        }
    }
}

Answer 1

You can:

continue 2;

in this case. This will continue with the next run of the outer foreach loop.

However, as @Tularis told in comments, a simple break would have the same effect here because no code is following the while loop. (and might be easier to read)

---

About the query. It looks like it would be better here to issue only one database query for all ids, using the IN statement:

$ids = impldode(',', $nodeids); // assuming the ids are integers
$query= $dbh->query("SELECT * FROM Nodes WHERE Node_ID IN $ids AND New = 1")