[PHP] Nähere Zahl suchen

$qWerte = sprintf("SELECT * FROM TB_Werte WHERE Name='ul'");
$rWerte = mysql_query($qWerte);

$a1 = array();
$a2 = array();
$a3 = array();

while ($row= mysql_fetch_assoc($rWerte)) {
	$aKoordUL = explode(":",$row['Koordinaten']);
	array_push($a1,(int)$aKoordUL[0]);
	array_push($a2,(int)$aKoordUL[1]);
	array_push($a3,(int)$aKoordUL[2]);
}
asort($a1);
asort($a2);
asort($a3);

$GLOBALS['steps'] = 0;

$iKoord = "16:8:23";		
$array = explode(":",$iKoord);


echo findClosest((int)$array[0], $a1, 0, count($a1)-1), "\n";
echo "steps: {$GLOBALS['steps']}"; 

function findClosest($needle, $numbers, $from, $to){    
	$GLOBALS['steps']++; 
	
	$p = ($from + $to)/2;
	$ceil = ceil($p);    
	$floor = floor($p);    
	
	if ($from == $floor || $to == $ceil){
		 $d1 = abs($needle - $numbers[$floor]);
		 $d2 = abs($needle - $numbers[$ceil]);

		if($d1 < $d2){
			return $numbers[$floor];
		}
		else{
			return $numbers[$ceil];
		}        
	}    
	elseif ($numbers[$floor] > $needle) {
		return findClosest($needle, $numbers, $from, $floor);
	}
	else {
		return findClosest($needle, $numbers, $ceil, $to);        
	}
}

echo "Meine Koordinaten: " . (int)$array[0] . ":" .  (int)$array[0] . ":" .  (int)$array[0] . "<br>";
for ($i = 1; $i <= count($a1); $i++) {
	echo sqrt(pow(($a1[$i] - (int)$array[0]),2) + pow(($a2[$i] - (int)$array[1]),2) + pow(($a3[$i] - (int)$array[2]),2)) . " => Koordinaten zum Vergleich " . $a1[$i] . ":" . $a2[$i] . ":" . $a3[$i] . "<br>" ;
}

 static Opponent GetClosestTarget()
                {
                    var possibleShips = _opponents.Where(s => s.Company != 0 /*&& s.Company != _hero.FractionId*/).ToList();
                    Opponent ret = null;
                    if (possibleShips.Count > 0)
                    {
               
                        if (possibleShips.Count == 1)
                        {
                            ret = possibleShips[0];
                        }
                        else
                        {
                            ret = possibleShips[0];
                            double dist = _getDistance(_hero.X, _hero.Y, ret.X, ret.Y);

                            foreach (var x in possibleShips)
                            {
                                double d = _getDistance(_hero.X, _hero.Y, x.X, x.Y);
                                double com = Math.Min(dist, d);
                                if (com != dist)
                                {
                                    ret = x;
                                    dist = d;
                                }
                            }

                        }

                
                    }
                    return ret;
                }

$data = $api->findClosest($_POST['spielername'];

//weiter unten

echo $data[0][0];

if ($_POST['findClosest']){
	if(empty($_POST['spielername']))
	{
		$Information = "<p>Bitte geben Sie einen Spieler ein</p>";
	}else{
		$Information = "<p>Gefunden: ";
		foreach($api->findClosest($_POST['spielername']) as $key=>$value)
		{
			$Information .= " [" . $key . "] ".$value;
		}
		$Information .= "</p>";
	}
}

public static function findClosest($spielerName){
	$getPlayerID = sprintf("SELECT ID FROM TB_DatenPlayer WHERE Spieler='" . mysql_real_escape_string($spielerName) . "'");
	$playerID = mysql_query($getPlayerID);
	while($varID = mysql_fetch_array($playerID))
	{
		$finalID = $varID['ID'];
	}
	
	$getPlayerI = sprintf("SELECT Koordinaten FROM TB_DatenKoo WHERE ID='" . $finalID . "'");
	$playerKoord = mysql_query($getPlayerI);
	while($varInseln = mysql_fetch_array($playerKoord))
	{
		$finalInseln = $varInseln['Koordinaten'];
	}

	$array = explode(":",$finalInseln);
	
	$qWerte = sprintf("SELECT * FROM TB_DatenKoo WHERE Koordinaten='ul'");
	$rWerte = mysql_query($qWerte);
	
	$a1 = array();
	$a2 = array();
	$a3 = array();
	
	while ($row = mysql_fetch_assoc($rWerte)) {
		$aKoordUL = explode(":",$row['Koordinaten']);
		array_push($a1,(int)$aKoordUL[0]);
		array_push($a2,(int)$aKoordUL[1]);
		array_push($a3,(int)$aKoordUL[2]);
	}
	asort($a1);
	asort($a2);
	asort($a3);
	
	$a4 = array();
	for ($i = 1; $i <= count($a1)-1; $i++) {
		$varAbstand =  round(sqrt(pow(($a1[$i] - (int)$array[0]),2) + pow(($a2[$i] - (int)$array[1]),2) + pow(($a3[$i] - (int)$array[2]),2)), 3);
		$zwischenWerte["Abstand"] 	= $varAbstand;
		$zwischenWerte["Lange"] 		= $a1[$i];
		$zwischenWerte["Breite"] 		= $a2[$i];
		$zwischenWerte["Punkt"] 		= $a3[$i];
		array_push($a4,$zwischenWerte);
	}
	$min = min($a4);
	return $min;
}