I need a script to import all emails addresses into an email table in my database. I have one csv file with email and first name. I have one text file which contains all email addresses. The script needs to have the option of importing the email address and/or first Name into table.
You can choose to run script with phpMyAdmin, SSH, or a php file. Please provide detail instructions.
I will put money in escrow, and will not release money until I am able to successfully import email addresses.
CSV File Contains:
Email First Name
----- -----------
email1 Testy
email2 Tester
Text file:
email1,
email2,
email3
Database table scheme:
emailAddr(
`id` bigint(20) NOT NULL auto_increment,
`fName` varchar(100) NOT NULL,
`email` varchar(100) NOT NULL,
`status` varchar(10) NOT NULL default '0',
PRIMARY KEY (`id`)
)
Please only respond if you are able to complete this task quickly. This should be a task that you have completed previously.
Thanks,
lls