simple PHP to MYsql filtering

by

As I understand you receive plain text emails with data.

Then you want to parse it. If your ‘labels’ are automatically generated and consistent then you can parse it quite easily… say something like this:

Say you load your email text into a variable $email_content.

$lines = explode("\n",$email_content);
$array_of_values = array();
foreach ($lines as $line) {
    if (str_pos(":",$line)!==false) {
        $temp_array = explode(":",$line);
        $array_of_values[trim($temp_array[0])] = trim($temp_array[1]);
    }
}

In the end you will have an array like this:

array(
    'First Name'=> 'John',
    'Last name' => 'Smith',
    'telephone' => '01234 56789'
)

Then you will be able to easily access whichever value you like by key and subsequently save it to database if you like.

There are certain assumptions though – that you only have : in lines that contain label:value pairs. Also end of the line char is always /n. But this is just a pointer not a ready made solution.

More Related Contents:

  1. Use PHP to render multiple images to the browser [closed]
  2. How to prevent duplicate usernames when people register?
  3. MySQL connection not working: 2002 No such file or directory
  4. Sum values of multidimensional array by key without loop
  5. Get sum of MySQL column in PHP
  6. mysqli: can it prepare multiple queries in one statement?
  7. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  8. Laravel 5 PDOException Could Not Find Driver
  9. Escaping MySQL wild cards
  10. Import CSV file directly into MySQL
  11. mysql_fetch_array, mysql_fetch_assoc, mysql_fetch_object
  12. Using MySQLi from another class in PHP
  13. How do I display a MySQL error in PHP for a long query that depends on the user input? [duplicate]
  14. Php – Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  15. Whats the easiest way to determine if a user is online? (PHP/MYSQL)
  16. What is the advantage of using try {} catch {} versus if {} else {}
  17. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  18. How to convert ISO8601 to Date format in php
  19. Javascript function post and call php script
  20. return one value from database with mysql php pdo
  21. Trying to access array offset on value of type bool
  22. onbeforeprint() and onafterprint() equivalent for non IE browsers
  23. How to get a query error from prepare() in PDO PHP?
  24. Fatal error: Call to a member function query() on null
  25. MySQL & PHP Parameter 1 as Resource
  26. MySQL GROUP BY and Fill Empty Rows
  27. mysql injection damages?
  28. PHP PDO how to run a multiple query request?
  29. How do you make good use of multicore CPUs in your PHP/MySQL applications? [closed]
  30. How to get a list of databases?

Leave a Comment