:
Controller:
Query mailbox
Public Function Actionemail ()
{
/*//Query all mailbox data (1 types)
$arr =users::find ("SELECT * from Users")->asarray ()->all ();
Var_dump ($data);d ie;
$data =array ();
Remove Mailbox Type
foreach ($arr as $key = $v)
{
$str =substr ($v [' Email '],strpos ($v [' email '], ' @ '), 50);
$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> ";
}
}
Count the number of different mailbox types