This article mainly introduces the method of Yii statistics different types of mailboxes, involving Yii database query and string traversal, interception and judgment related operation skills, the need for friends can refer to the next
This paper describes the methods of Yii to count different types of mailboxes. Share to everyone for your reference, as follows:
:
Controller:
Query mailbox Public Function Actionemail () { /*//Query all mailbox data (1 kinds) $arr =users::find ("SELECT * from Users")->asarray () ->all (); Var_dump ($data);d ie; $data =array (); Remove the mailbox Type foreach ($arr as $key + $v) { $str =substr ($v [' Email '],strpos ($v [' email '], ' @ '); $str 1=substr ($STR, 1); $data [$str 1][$key]= $str 1; } Var_dump ($data);d ie; Get the number of different types of mailboxes foreach ($data as $key = + $v) { echo $key. Mailbox has ". Count ($v)." A "." <br> "; } * /(2 ways) $arr =users::find ()->select ("email")->column (); $data =array (); foreach ($arr as $key = + $v) { $pos =strpos ($v, "@"); $str =substr ($v, $pos + 1); $data []= $str; } Var_dump ($data);d ie; $count =array_count_values ($data); Var_dump ($count);d ie; foreach ($count as $key = + $v) { echo $key. The mailbox has ". $v." A "." <br> "; }}
The above is the whole content of this article, I hope that everyone's learning has helped, more relevant content please pay attention to topic.alibabacloud.com!