Member Avatar for garyjohnson

Here is a link to a list of college names and their .edu email http://pastebin.com/LND21t5F

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?

  • 2 Contributors
  • 1 Reply
  • 116 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by broj1
Member Avatar for broj1

Something like:

$rawString = 'aamu.edu: 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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.