PHP - Moved: Pull Specific Data From Sql And Group It (best Way I Can Think To Put It)

Hi all,

I would like to ask you if somebody could have a better idea to build this function.

The current one is working, but I feel this built a bit in an amateur manner.

Feel free to add your ideas so we can learn more about PHP and how to deal with arrays.

I have an array:

$arrayVideoSpecs = Array(
    Array(
        'aspect' => '4:3',
        'density' => '442368',
        'resolution' => '768x576'
    ),
    Array(
        'aspect' => '4:3',
        'density' => '307200',
        'resolution' => '640x480'
    ),
    Array(
        'aspect' => '16:9',
        'density' => '2073600',
        'resolution' => '1920x1080'
    ),
    Array(
        'aspect' => '16:9',
        'density' => '121600',
        'resolution' => '1280x720'
    )
);

and I want an array as output grouped by video aspect ratio where the key is the pixel density and the value is the video resolution, namely like that for aspect ratio 16:9 ...

Array
(
    [2073600] => 1920x1080
    [121600] => 1280x720
)

Then I coded this function which is working but seems amateur ...

    function groupAndExtractByAspect($array, $groupBy, $aspect, $density, $resolution)
    {
        $groupByAspect = Array();
        foreach ($array as $value)
        {
            $groupByAspect[$value[$aspect]][] = Array($value[$density], $value[$resolution]);
        }
	        $arrayClean = Array();
        foreach ($groupByAspect as $key => $value)
        {
            if ($key == $groupBy)
            {
                $arrayClean[$key] = $value;
            }
        }
	        foreach ($arrayClean as $aspectGroup)
        {
            $arrayOutput = Array();
            for ($i = 0; $i <= count($aspectGroup); $i++)
            {
                $densityIsValid = false;
                $resolutionIsValid = false;
                if (!empty($arrayClean[$groupBy][$i][0]))
                {
                    $density = $arrayClean[$groupBy][$i][0];
                    $densityIsValid = true;
                }
                if (!empty($arrayClean[$groupBy][$i][1]))
                {
                    $resolution = $arrayClean[$groupBy][$i][1];
                    $resolutionIsValid = true;
                }
                if (($densityIsValid === true) && ($resolutionIsValid === true))
                {
                    $arrayOutput[$density] = $resolution;
                }
            }
        }
        return $arrayOutput;
    }

The usage is as follow ...

$showArray = groupAndExtractByAspect($arrayVideoSpecs, '16:9', 'aspect', 'density', 'resolution');
echo '<pre>';
print_r($showArray);
echo '</pre>';

Thank you very much for your ideas!

Mapg

Hi,

I want to pull data from db, where sometimes all rows and sometimes rows matching given "username".

Here is my code:

	//Grab Username of who's Browsing History needs to be searched. 
	if (isset($_GET['followee_username']) && !empty($_GET['followee_username'])) 
{ 
    $followee_username = $_GET['followee_username']; 
    
    if($followee_username != "followee_all" OR "Followee_All") 
    { 
        $query = "SELECT * FROM browsing_histories WHERE username = \"$followee_username\""; 
        $query_type = "followee_username"; 
        $followed_word = "$followee_username"; 
        $follower_username = "$user"; 
        echo "$followee_username"; 
    } 
    else 
    { 
        $query = "SELECT * FROM browsing_histories"; 
        $query_type = "followee_all"; 
        $followed_word = "followee_all"; 
        $follower_username = "$user"; 
        echo "all"; 
    } 
} 
	

When I specify a "username" in the query via the url:

browsing_histories_v1.php?followee_username=requinix&page_number=1

I see result as I should. So far so good.

Now, when I specify "all" as username then I see no results. Why ? All records from the tbl should be pulled!

browsing_histories_v1.php?followee_username=all&page_number=1

This query shouldv'e worked:

	$query = "SELECT * FROM browsing_histories";