PHP Classes

Parse importer: Import email addresses into a MySQL database

Recommend this page to a friend!
     
  Info   Example   Screenshots   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 239 All time: 8,050 This week: 140Up
Version License PHP version Categories
importerfp2db 0.5Freely Distributable5.0Email, PHP 5, Databases
Description 

Author

Oliver Leuyim Angel

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.

Picture of Oliver Leuyim Angel
  Performance   Level  
Name: Oliver Leuyim Angel <contact>
Classes: 7 packages by
Country: Mexico Mexico

Level 3 StarStarStar

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

Example

<form action="" method="POST" enctype="multipart/form-data">

emails:<textarea cols='35' rows='15' name='address'></textarea>
<br>gile:<input type='file' name='addresses'>
<br>Group:<input type='text' name='grupo'>

<br>
<input type="submit" value="Send!" name="submit">
</form>

<?php

if(!empty($_POST['address']) or !empty($_FILES['addresses']))
{

require("class.import.php");
$import = new Import();

$import->grupo = $_POST["grupo"];
$import->dbtableName = "datatable";
$import->identify();
$resultaqdo = $import->procesar();
if($resultaqdo){
   
    print "
    <fieldset style=\"border-color:green;background-color:#C0FFC0;color:black;text-decoration:blink;\">
    <legend>Alert!</legend>
    Pefect Uploaded... ".count($resultaqdo)." contacto(s).
    </fieldset>
    ";
}else{
    print "
    <fieldset style=\"border-color:red;background-color:#FF9D9D;color:black;text-decoration:blink;\">
    <legend>Alerta!</legend>
    Got stock. {$import->show_errors()}
    </fieldset>
    ";
}

}
?>

Details

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 (1)  
  • importer.jpg
  Files folder image Files (5)  
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

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadimporterfp2db-2013-09-17.zip 24KB
Downloadimporterfp2db-2013-09-17.tar.gz 24KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:239
This week:0
All time:8,050
This week:140Up
User Comments (1)
Parse importer.
11 years ago (shyam6511)		77%StarStarStarStar
 

  Applications that use this package  
A module for dim works cms to send mails campaigns.

Add link image If you know an application of this package, send a message to the author to add a link here.


  Related pages  
A solution on cloud.