Ik wil graag als er een mailtje binnenkomt dat de text in de db komt maar is dat wel mogelijk?
Zojha iemand die me kan helpen?
Zojha iemand die me kan helpen?
) Niet via de website
..
http://www.phphulp.nl/php/forum/topic/binnenkomende-email-naar-database/74694/


[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/set_time_limit"]set_time_limit[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/mysql_connect"]mysql_connect[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]localhost[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]DB USERNAAM[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]DB USERPASS[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
[URL="http://www.php.net/mysql_select_db"]mysql_select_db[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]DB NAAM[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
[COLOR= #0000BB]$hostname[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]HOSTNAME[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]//bijvoorbeeld {imap.gmail.com:993/imap/ssl}INBOX[/COLOR]
[COLOR= #0000BB]$username[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]EMAIL[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$password[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]WACHTWOORD[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$inbox[/COLOR] [COLOR= #007700]=[/COLOR] imap_open[COLOR= #007700]([/COLOR][COLOR= #0000BB]$hostname[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$username[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$password[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]Cannot connect to Gmail: [/COLOR] [COLOR= #007700].[/COLOR] imap_last_error[COLOR= #007700]());[/COLOR]
[COLOR= #0000BB]$emails[/COLOR] [COLOR= #007700]=[/COLOR] imap_search[COLOR= #007700]([/COLOR][COLOR= #0000BB]$inbox[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]UNSEEN UNDELETED[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$emails[/COLOR][COLOR= #007700])
{[/COLOR]
[URL="http://www.php.net/foreach"]foreach[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$emails[/COLOR] [COLOR= #007700]as[/COLOR] [COLOR= #0000BB]$email_number[/COLOR][COLOR= #007700])
{[/COLOR]
[COLOR= #0000BB]$overview[/COLOR] [COLOR= #007700]=[/COLOR] imap_fetch_overview[COLOR= #007700]([/COLOR][COLOR= #0000BB]$inbox[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$email_number[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$message[/COLOR] [COLOR= #007700]=[/COLOR] imap_fetchbody[COLOR= #007700]([/COLOR][COLOR= #0000BB]$inbox[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$email_number[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"INSERT INTO berichten (`subject`, `from`, `date`, `message_id`, `bericht`) VALUES ("[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$overview[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700]]->[/COLOR]subject[COLOR= #007700]).[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$overview[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700]]->[/COLOR]from[COLOR= #007700]).[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$overview[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700]]->[/COLOR][URL="http://www.php.net/date"]date[/URL][COLOR= #007700]).[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$overview[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700]]->[/COLOR]message_id[COLOR= #007700]).[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$message[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]")"[/COLOR][COLOR= #007700]);
}
}[/COLOR]
imap_close[COLOR= #007700]([/COLOR][COLOR= #0000BB]$inbox[/COLOR][COLOR= #007700]);[/COLOR]
?>