Here is a link to a list of college names and their .edu email

I want to take those lines of code and put the .edu part into one coloumn of a database and the name of the college into another coloumn.

My database is structure like this (id, college_email, college_name)

Can some one help me do this?

Something like:

$rawString = ' Alabama A&M University';
$temp = explode(': ', $rawString);
// $temp[0] -> college_email
// $temp[1] -> college_name

$query = "INSERT INTO tableName (college_email, college_name) VALUES ('{$temp[0]}', '{$temp[1]}')";

And do not forget to sanitize strings first.