sorting emails by domain in php

Question

Hi!
Hope anybody can help me.
I created database for emails

https://code.sololearn.com/wA4a2A21a14A

after that I want them to display in table-

https://code.sololearn.com/wA5A00a22A14

So far it's working fine, I can sort them by name and date but I would like to filter emails by domain name for example gmail. and when there is inputed new domain like yahoo the filter option automatically apears.
here is html code where to input email-
https://code.sololearn.com/WA23a8A08a4a
Anyone can help with code?

Answer 1

You need to take all domains from the emails and add the separate to the db

Select them
SELECT DISTINCT edomain FROM emails