Kalorien Quiz - Was hat weniger Kalorien?

error."[ $szQuery ]"); if($aResult->num_rows > 0) { while( $aRows = mysqli_fetch_array($aResult) ) { $aKalorien[] = $aRows ; } } $iQ1 = rand(0,count($aKalorien)-1); $aQ1Data = $aKalorien[ $iQ1 ]; $iQ2 = rand(0,count($aKalorien)-1); if($iQ2 == $iQ1) { $iQ2 = rand(0,count($aKalorien)-1); } $aQ2Data = $aKalorien[ $iQ2 ]; if($_POST[ 'kcalvoteid' ]) { $szQuery = "SELECT * FROM kalorien WHERE kalorienID_pk = '".$_POST[ 'kcalvotev1_id' ]."'"; $aResult1 = mysqli_query($DBCon,$szQuery) or trigger_error($DBCon->error."[ $szQuery ]"); if($aResult1->num_rows == 1 ) { $aRes1 = mysqli_fetch_array($aResult1); } $szQuery = "SELECT * FROM kalorien WHERE kalorienID_pk = '".$_POST[ 'kcalvotev2_id' ]."'"; $aResult2 = mysqli_query($DBCon,$szQuery) or trigger_error($DBCon->error."[ $szQuery ]"); if($aResult2->num_rows == 1 ) { $aRes2 = mysqli_fetch_array($aResult2); } $res = $aRes1[ 'kcal' ] - $aRes2[ 'kcal' ]; if($res == 0) { $szResultMsg = $aRes1[ 'name' ] . " und " . $aRes2[ 'name' ] . " haben gleich viele Kalorien."; $szResult = "Hehe. "; } else { switch( $res ) { case($res < 0): $resID = $aRes1[ 'kalorienID_pk' ]; $szResultMsg = $aRes1[ 'name' ] . ": " . $aRes1[ 'kcal' ] . " " . $aRes1[ 'einheit' ] . " d.h. " . ($res*(-1)) . " " . $aRes1[ 'einheit' ] . " weniger" . " als " . $aRes2[ 'name' ] . ": " .$aRes2[ 'kcal' ] . " " . $aRes2[ 'einheit' ] ."."; break; case($res > 0): $resID = $aRes2[ 'kalorienID_pk' ]; $szResultMsg = $aRes2[ 'name' ] . ": " . $aRes2[ 'kcal' ] . " " . $aRes2[ 'einheit' ] . " d.h. " . ($res) . " " . $aRes2[ 'einheit' ] . " weniger" . " als " . $aRes1[ 'name' ] . ": " .$aRes1[ 'kcal' ] . " " . $aRes1[ 'einheit' ] ."."; break; } if($resID != $_POST[ 'kcalvoteid' ] ) { $szResult = "Falsch. "; } else { $szResult = "Richtig. "; } } } ?>

Ergebnis

Wieviel Kalorien hat <?= $aQ1Data[ 'name' ] ?> vs. Wieviel Kalorien hat <?= $aQ2Data[ 'name' ] ?>