I've messed up a bit with my php and just wanted some help. At the moment my code takes the values that are selected from the dropdown boxes and puts the values along with their corresponding row in a table, into a 3D array. However, it only needs to be a 2D array but I don't know how to get rid of the first dimension of the 3D array. Php code:
<?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>
Outputting $results gives the following:
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
)
)
)
I don't know how to get rid of the extra array so any help would be appreciated :)