secret Posted August 24, 2008 Share Posted August 24, 2008 i have an excel file in which 100 email addresses are saves in one column i want to read this file and insert the addresses in a mysql table then send email to all of these how to do this anyone plz help me about the coding... Link to comment https://forums.phpfreaks.com/topic/121102-php-and-excel-how-to/ Share on other sites More sharing options...
unrelenting Posted August 24, 2008 Share Posted August 24, 2008 Save the excel document as a csv file and upload it to your database via phpmyadmin. Just make sure you change the box that says 'Fields terminated by' from a semi-colon to a comma in phpmyadmin. It will insert just fine as long as your table only has the one field. Link to comment https://forums.phpfreaks.com/topic/121102-php-and-excel-how-to/#findComment-624324 Share on other sites More sharing options...
Caesar Posted August 24, 2008 Share Posted August 24, 2008 Well no one should write the code for you. But you'll want to look into using CSV files and using a loop. (I recently wrote a class to do this exact same thing. I used a while loop.). Link to comment https://forums.phpfreaks.com/topic/121102-php-and-excel-how-to/#findComment-624335 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.