PHP Classes
elePHPant
Icontem

Parse importer: Import email addresses into a MySQL database

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   View files Example   Screenshots Screenshots   View files View files (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2013-09-17 (1 year ago) RSS 2.0 feedNot yet rated by the usersTotal: 207 This week: 1All time: 7,416 This week: 1,124Up
Version License PHP version Categories  
importerfp2db 0.5Freely Distributable5.0Email, PHP 5, Databases
Description Author  

This class can import email addresses into a MySQL database.

It takes a string or an uploaded file with email addresses and parses the file to extract the addresses and insert them into a MySQL database table.

The email addresses are sanitized and validated to prevent inserting invalid email addresses.

The database and the table where the email addresses will be inserted, are configurable parameters.

Recommendations  

What is the best PHP class to extract recipients from CSV file?
I need to parse a .csv emails address list and send a message

Picture of Oliver Leuyim Angel
Name: Oliver Leuyim Angel <contact>
Classes: 6 packages by
Country: Mexico Mexico
Age: 28
All time rank: 128615 in Mexico Mexico
Week rank: 600 Up7 in Mexico Mexico Up

Details provided by the author  

This class was developed for a project then is released to use it at freeway. Feel free to use it and upgrade it. Any comment to: oliver.angel@dimworks.org Author: Oliver Leuyim Angel www.dimworks.org

IMPORTER CLASS

PUBLIC PROPERTIES

public $grupo; ///This establish the group is going to be inserted the emails that are going to be extracted public $error_end; /// This is for save the error_log not for to show it

PRIVATE PROPERTIES

private $file; //To store the global $_FILES private $data; private $correos; //For the mixed string before the export private $lista_correos; //for the exported mail addres private $error = array(); // Error log array

Public methods

public identify() // to identify the globals public connectDatabase() // for conecct to the db public procesar() // to ejecute and parse public show_errors() // to show the errors

* Private methods

private extract_email_address($string) // the extract function

steps on the process

1) get all globals and connect to db. 2) mix all content of the globals $_FILES and $_POST in a string 3) extract all mails address of the string 4) store all mail address on a data base.

In case of error show errors.

Screenshots  
  • importer.jpg
  Files folder image Files  
File Role Description
Plain text file class.import.php Class The class file, where have all functions
Accessible without login Plain text file db.sql Data the table of the class
Accessible without login Plain text file example.php Example Example for use this class
Accessible without login Plain text file Readme Doc. Information of the class

 Version Control Unique User Downloads Download Rankings  
 0%Total:207All time:7,416
 This week:1This week:1,124Up
 User Comments (1)  
 
Parse importer.
1 year ago (shyam6511)
77%StarStarStarStar