OOP Issue Stopping PHP Functioning & MySQL Data Array Retrieval Issue

Question

Now a very kind StackOverflow use has helped me out with a lot of my issues however there's two remaining probelms with my code before it's ready to go, any ideas would be great as i'm currently screaming at it:

First of all i'm using the following to try and pull data from a MySQL Database, return it as a Numeric Array and Order It By ID. There's 2 items in there and no matter what I do I can only get 1 to display (I need it to display ALL data when the table fills up more):

$query = "SELECT * FROM batch ORDER by ID";
$result = $mysqli->query($query);

/* numeric array */
$row = $result->fetch_array(MYSQLI_NUM);
printf ("%s (%s)\n", $row[0], $row[1]);

?> 

Secondly, slightly off topic but this code below was given by a StackOverflow user however I can't get it to work, they've geared it to OOP which is not an area i'm familiar with and no matter what I do to correct the $this-> or public / private it still refuses to work (the aim of the code is to have a number in $userinput which gets checked against the $widgetBatches array for the closest match (i.e. input is 1100 and closest is 1000) this then gets deducted from the input (to leave 100) and the process loops again to check and this time returns 100 as the closest, this process continues until the $userinput reaches 0 or a negative number:

<?php

$userinput = 10000; // Our magic variable - user input

$iterations = 0;

function Widget($userinput)
{
    $this->iterations++;
    $widgetRequested = $userinput;
    $widgetBatches = array("250", "500", "1000", "2000");

    echo "Iteration " . $iterations;
    echo "<br/>";

    echo "Widget requested: " . $widgetRequested;
    echo "<br/>";

    $closest = GetClosest($widgetBatches, $widgetRequested);
    echo "Closest: " . $closest;
    echo "<br/>";

    $widgetRemaining = $widgetRequested - $closest;
    echo "Remainder: " . $widgetRemaining;

    echo "<hr/>";
    if($widgetRemaining > 0)
    {
        Widget($widgetRemaining);
    }
    else
    {
        echo "The value is now below or equaling zero: " . $widgetRemaining . "!";
    }
}

function GetClosest($array, $value)
{
    $lowest = null;
    foreach($array as $val)
    {
        if($lowest == null || abs($value - $lowest) > abs($val - $value))
        {
            $lowest = $val;
        }
    }
    return $lowest;
}


?>

Answer 1

Did you try fetchAll(), I use PDO so not sure, but would suggest you use a while loop, like:

while ($result = $mysqli->query($query));

Or:

foreach($result as $r) then $r['data'];

I'm %100 sure the loop will iterate and pull out every data, which you can send to a table or a list.

Answer 2

This:

<?php

function Widget($input) {
    $currentValue = $input; // Set internal variable from input (Think of this as an initial "remainder")
    $i = 0;
    $widgetBatches = [250, 500, 1000, 2000]; // Setup batch array

    while ($currentValue > 0) { // While the remainder is more than 0
        $i++;
        echo "Iteration " . $i . "<br/>";
        echo "Widget requested: " . $currentValue . "<br/>";
        $closest = GetClosest($widgetBatches, $currentValue); // Find the closest value from batch array
        echo "Closest: " . $closest . "<br/>";
        $currentValue = $currentValue - $closest; // Work out new remainder
        echo "Remainder: " . $currentValue . "<hr/>";
    }

    // Loop will exit when remainder is less than 0
    echo "The value is now below or equaling zero: " . $currentValue . "!";
}

function GetClosest($array, $value) {
    $result = null; // Innitialise the returned variable in case of failure
    foreach($array as $val) { // For every array value, unless stopped
        $result = $val; // Set result to current array value
        if($value <= $result) break; // Stop foreach loop if value is less than or equal to result
    }
    return $result; // Return last result from Foreach loop
}

Widget(9000);

?>

Hopefully the comments are useful... I put more detail in than I would usually...