Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if(in_array($browser, $uniqueBrowser)) {
- if(in_array($version, $uniqueBrowser[$browser])) {
- $uniqueBrowser[$browser][$version]['times'] = $uniqueBrowser[$browser][$version]['times'] + 1;
- } else {
- $uniqueBrowser[$browser]['version'] = $version;
- $uniqueBrowser[$browser][$version]['times'] = 1;
- }
- } else {
- $uniqueBrowser[] = $browser;
- $uniqueBrowser[$browser]['version'] = $version;
- $uniqueBrowser[$browser][$version]['times'] = 1;
- }
- Browser data: array(4) {
- [0]=>
- string(7) "Firefox"
- ["Firefox"]=>
- array(3) {
- ["version"]=>
- string(6) "14.0.1"
- [15]=>
- array(1) {
- ["times"]=>
- int(2)
- }
- ["14.0.1"]=>
- array(1) {
- ["times"]=>
- int(15)
- }
- }
- [1]=>
- string(17) "Internet Explorer"
- ["Internet Explorer"]=>
- array(2) {
- ["version"]=>
- string(9) "8.0.0.253"
- ["8.0.0.253"]=>
- array(1) {
- ["times"]=>
- int(1)
- }
- }
- }
- +---------+------------------+------+-----+---------+----------------+
- | Field | Type | Null | Key | Default | Extra |
- +---------+------------------+------+-----+---------+----------------+
- | id | int(11) unsigned | NO | PRI | NULL | auto_increment |
- | browser | varchar(120) | YES | | NULL | |
- | version | varchar(50) | YES | | NULL | |
- +---------+------------------+------+-----+---------+----------------+
- +----+---------+---------+
- | id | browser | version |
- +----+---------+---------+
- | 1 | Firefox | 3.6 |
- | 2 | Firefox | 4.1 |
- | 3 | Firefox | 3.6 |
- | 4 | Safari | 5.1.7 |
- | 5 | Safari | 6 |
- | 6 | Firefox | 14.0.1 |
- | 7 | IE | 7 |
- | 8 | IE | 8 |
- | 9 | IE | 7 |
- | 10 | Firefox | 14.0.1 |
- | 11 | Opera | 12.0.1 |
- | 12 | Safari | 5.1.7 |
- +----+---------+---------+
- mysql> SELECT browser, version, COUNT(version) AS times FROM demo.browsers GROUP BY browser;
- +---------+---------+-------+
- | browser | version | times |
- +---------+---------+-------+
- | Firefox | 3.6 | 5 |
- | IE | 7 | 3 |
- | Opera | 12.0.1 | 1 |
- | Safari | 5.1.7 | 3 |
- +---------+---------+-------+
- mysql> SELECT browser, version, COUNT(version) AS times FROM demo.browsers GROUP BY browser, version;
- +---------+---------+-------+
- | browser | version | times |
- +---------+---------+-------+
- | Firefox | 14.0.1 | 2 |
- | Firefox | 3.6 | 2 |
- | Firefox | 4.1 | 1 |
- | IE | 7 | 2 |
- | IE | 8 | 1 |
- | Opera | 12.0.1 | 1 |
- | Safari | 5.1.7 | 2 |
- | Safari | 6 | 1 |
- +---------+---------+-------+
- foreach ($uniqueBrowser as $browserName=>$values){
- echo $browserName .' contains '. print_r($values,true);
- }
Add Comment
Please, Sign In to add comment