Opdeling af navn med explode

$q = 'Anders A Andersen';
$lastSpace = strrpos($q, ' ');
$q1 = trim(substr($q, 0, $lastSpace));
$q2 = trim(substr($q, $lastSpace));

if (!empty($_GET["q"]))
{
    $parts= explode(" ", $_GET["q"]);

    if (count($parts) == 1)
    {
        $sql = 'Select * FROM Person WHERE Firstname LIKE "%" . $array[0] ."%"';
   
    }
    elseif (count($parts) == 2)
    {
        $sql = 'Select * FROM Person WHERE Firstname LIKE "%" . $array[0] ."%" AND Lastname LIKE "%" . $array[1] ."%"';
   
    }
    elseif (count($parts) > 2)
    {
        $sql = 'Select * FROM Person WHERE Firstname LIKE "%" . array_pop($parts) ."%" AND Lastname LIKE "%" . implode(" ", $parts) ."%"';
   
    }

$parts = explode(" ", $_GET["q"]);   
   
    if (count($parts) == 1)
    {
        $sql = 'SELECT TOP 5 Firstname, Lastname FROM Persons WHERE Firstname LIKE ?';
        $params = array($parts[0] . '%');
    }
   
    elseif (count($parts) > 1)
    {
        $lastname =  array_pop($parts);
        $firstname = implode(" ", $parts);
        $sql = 'SELECT TOP 5 Firstname, Lastname FROM Persons WHERE Firstname LIKE ? AND Surname LIKE ?';
        $params = array($firstname . '%', $lastname . '%');
    }

$params = array('%'. $firstname . '%','%'. $lastname . '%');

$sql = 'SELECT TOP 5 Firstname, Lastname FROM Persons WHERE Firstname LIKE ? OR Lastname LIKE ?';