为什么它是我的数组一个3D而不是一个2D？

Question

我有点搞砸了我的php，只想得到一些帮助。目前，我的代码接受从下拉框中选择的值，并将这些值连同它们对应的行一起放在一个表中，放入一个3D数组中。然而，它只需要一个二维数组，但我不知道如何摆脱三维数组的第一个维度。Php代码：

<?php
function startmatching(){
    define( "DB_DSN", "mysql:host=localhost;dbname=FoodMatching");
    define( "DB_USERNAME", "root");
    define( "DB_PASSWORD", "" ); 

    // define the empty array to be filled from db

    $results = array();
    // any other php tasks that dont needthe ingcats
    // store sql

    $IngName = $_POST['IngredientName'];
    $IngCounter=0;
    while($IngCounter<count($IngName)){
        $sSQL = "SELECT IngID, IngName, Texture, Colour, Bitter, Sweet, Sour, Salty, Umami FROM IngredientCharacteristics WHERE IngName='$IngName[$IngCounter]'";
        // create an instance of the connection
        $conn   = new PDO( DB_DSN, DB_USERNAME, DB_PASSWORD );
        // prepare
        $st   = $conn->prepare( $sSQL );
        // execute the connection
        $st->execute();
        $counter=0;
        // while myslq has rows loop over them and store
        while($row = $st->fetch() ){
            $results[$counter][] = $row;
            $counter++;
        }
        $IngCounter++;
    }
    print_r($results);
}
?>

html：

 <form method='post' role="form" autocomplete="off">

    <div class="entry input-group col-xs-3">
        <?php //this function takes the ing id and ingname from ingredientcharacteristics table.
                    // if there are results stored create the select and loop over
                    if(!empty($aIngList)){
                        echo "<span class='form-control' style = 'float:left; font-size: 20px;font-family:'Helvetica Neue' ><select name = 'IngredientName[]' class = 'custom-dropdown__select custom-dropdown__select--white'>";
                        //class = 'custom-dropdown custom-dropdown--white'
                        echo "<option value='' default >Choose an Ingredient</option>";
                        foreach ($aIngList as $iIngID => $sIngName) {
                            echo "<option value='".$sIngName."' >".$sIngName."</option>";
                        }
                        echo "</select></span>";
                    }else{
                        echo "<p>No results available!</p>";
                    }
                ?>

        <span class="input-group-btn">
            <button class="btn btn-success btn-add" type="button">
                <span class="glyphicon glyphicon-plus"></span>
            </button>
            <button type="submit" class="hidden" name="startmatch" value ="startmatch" id="submit-form"></button>
        </span>
    </div>


</form>

输出$results提供了以下内容：

Array

    (
        [0] => Array
            (
                [0] => Array
                    (
                        [IngID] => 2
                        [0] => 2
                        [IngName] => Apples Fresh
                        [1] => Apples Fresh
                        [Texture] => 4
                        [2] => 4
                        [Colour] => 8
                        [3] => 8
                        [Bitter] => 7
                        [4] => 7
                        [Sweet] => 3
                        [5] => 3
                        [Sour] => 4
                        [6] => 4
                        [Salty] => 8
                        [7] => 8
                        [Umami] => 9
                        [8] => 9
                    )

                [1] => Array
                    (
                        [IngID] => 2
                        [0] => 2
                        [IngName] => Apples Fresh
                        [1] => Apples Fresh
                        [Texture] => 4
                        [2] => 4
                        [Colour] => 8
                        [3] => 8
                        [Bitter] => 7
                        [4] => 7
                        [Sweet] => 3
                        [5] => 3
                        [Sour] => 4
                        [6] => 4
                        [Salty] => 8
                        [7] => 8
                        [Umami] => 9
                        [8] => 9
                    )

            )

    )

我不知道如何摆脱额外的数组，因此任何帮助都是非常感谢的:)

Answer 1

问题是这条线：

$results[$counter][] = $row;

解决办法是将它更改为

$results[] = $row;

PHP将自动将$row附加到$results中，这意味着您根本不需要$counter变量。