(→Perl) |
|||
(사용자 3명의 중간 판 21개는 보이지 않습니다) | |||
1번째 줄: | 1번째 줄: | ||
{{DISPLAYTITLE:함수 array_count_value()}} | |||
[[category: Array]] | [[category: Array]] | ||
{{다른뜻|array length}} | {{다른뜻|array length}} | ||
{{다른뜻|PHP count()}} | |||
;count() | |||
;array_count_value() | |||
==POSIX Shell== | |||
<syntaxhighlight lang='bash' run> | |||
FRUITS="Banana Orange Apple Orange Orange " | |||
echo $FRUITS | tr ' ' '\n' | grep -c 'Orange' # 3 | |||
</syntaxhighlight> | |||
==PHP== | |||
[[category: PHP]] | |||
{{참고|PHP array_count_value()}} | |||
<syntaxhighlight lang='PHP' run> | |||
function array_count_value($arr, $val) { | |||
return count(array_filter($arr, function($v) use($val) {return $v==$val;})); | |||
} | |||
$fruits = ['Banana', 'Orange', 'Apple', 'Orange', 'Orange']; | |||
echo array_count_value($fruits, 'Orange'); # 3 | |||
</syntaxhighlight> | |||
<syntaxhighlight lang='PHP' run> | |||
$fruits = ['Banana', 'Orange', 'Apple', 'Orange', 'Orange']; | |||
$counts = array_count_values($fruits); | |||
echo $counts['Orange']; # 3 | |||
</syntaxhighlight> | |||
==Python== | ==Python== | ||
[[category: Python]] | [[category: Python]] | ||
< | {{참고|Python count()}} | ||
<syntaxhighlight lang='Python' run> | |||
fruits = ['Banana', 'Orange', 'Apple', 'Orange', 'Orange'] | fruits = ['Banana', 'Orange', 'Apple', 'Orange', 'Orange'] | ||
print( fruits.count('Orange') ) | print( fruits.count('Orange') ) # 3 | ||
# 3 | </syntaxhighlight> | ||
</ | |||
==Perl== | |||
[[category:Perl]] | |||
<syntaxhighlight lang='perl' run> | |||
my @fruits = ('Banana', 'Orange', 'Apple', 'Orange', 'Orange'); | |||
print $k = grep { $_ eq 'Orange' } @fruits; # 3 | |||
</syntaxhighlight> | |||
==SQL== | |||
{{참고|SQL COUNT()}} | |||
[[category: SQL]] | |||
===MySQL=== | |||
[[category: MySQL]] | |||
<syntaxhighlight lang='console'> | |||
mysql> SELECT * FROM fruits; | |||
+--------+ | |||
| value | | |||
+--------+ | |||
| Banana | | |||
| Orange | | |||
| Apple | | |||
| Orange | | |||
| Orange | | |||
+--------+ | |||
5 rows in set (0.00 sec) | |||
</syntaxhighlight> | |||
<syntaxhighlight lang='console'> | |||
mysql> SELECT COUNT(*) FROM fruits WHERE value='Orange'; | |||
+----------+ | |||
| COUNT(*) | | |||
+----------+ | |||
| 3 | | |||
+----------+ | |||
1 row in set (0.00 sec) | |||
</syntaxhighlight> | |||
==같이 보기== | |||
*[[array_count_values()]] | |||
*[[array length]] |
2021년 4월 14일 (수) 19:11 기준 최신판
- 다른 뜻에 대해서는 array length 문서를 참조하십시오.
- 다른 뜻에 대해서는 PHP count() 문서를 참조하십시오.
- count()
- array_count_value()
1 POSIX Shell[ | ]
Bash
Copy
FRUITS="Banana Orange Apple Orange Orange "
echo $FRUITS | tr ' ' '\n' | grep -c 'Orange' # 3
Loading
2 PHP[ | ]

PHP
Copy
function array_count_value($arr, $val) {
return count(array_filter($arr, function($v) use($val) {return $v==$val;}));
}
$fruits = ['Banana', 'Orange', 'Apple', 'Orange', 'Orange'];
echo array_count_value($fruits, 'Orange'); # 3
Loading
PHP
Copy
$fruits = ['Banana', 'Orange', 'Apple', 'Orange', 'Orange'];
$counts = array_count_values($fruits);
echo $counts['Orange']; # 3
Loading
3 Python[ | ]

Python
Copy
fruits = ['Banana', 'Orange', 'Apple', 'Orange', 'Orange']
print( fruits.count('Orange') ) # 3
Loading
4 Perl[ | ]
Perl
Copy
my @fruits = ('Banana', 'Orange', 'Apple', 'Orange', 'Orange');
print $k = grep { $_ eq 'Orange' } @fruits; # 3
Loading
5 SQL[ | ]

5.1 MySQL[ | ]
Console
Copy
mysql> SELECT * FROM fruits;
+--------+
| value |
+--------+
| Banana |
| Orange |
| Apple |
| Orange |
| Orange |
+--------+
5 rows in set (0.00 sec)
Console
Copy
mysql> SELECT COUNT(*) FROM fruits WHERE value='Orange';
+----------+
| COUNT(*) |
+----------+
| 3 |
+----------+
1 row in set (0.00 sec)