My journey with stackoverflow developers led me to successfully complete my first task, which involved creating an incoming email insert to the database query.
Here is the code I used:
#!/usr/bin/php -q
<?PHP
/* connect to gmail */
$hostname = '{example.org:995/pop3/ssl/novalidate-cert}';
$username = 'user';
$password = 'pass';
/* try to connect */
$inbox = imap_open($hostname,$username,$password) or die('Cannot connect to SERVER: ' . imap_last_error());
/* grab emails */
$emails = imap_search($inbox,'ALL');
/* if emails are returned, cycle through each... */
if($emails) {
/* begin output var */
$output = '';
/* put the newest emails on top */
rsort($emails);
/* for every email... */
foreach($emails as $email_number) {
/* get information specific to this email */
$overview = imap_fetch_overview($inbox,$email_number,0);
$message = imap_fetchbody($inbox,$email_number,2);
/* output the email header information */
//$read_status = '<div class="toggler '.($overview[0]->seen ? 'read' : 'unread').'">';
$subject = $overview[0]->subject;
$from = $overview[0]->from;
$received_date = '<span class="date">on '.$overview[0]->date.'</span>';
//$output.= '</div>';
/* output the email body */
$output= '<div class="body">'.$message.'</div>';
}
//echo $output;
$servername = "localhost";
$username = "username ";
$password = "password ";
$dbname = "dbname";
$conn = mysqli_connect($servername, $username, $password, $dbname) or die("Connection failed: " . mysqli_connect_error());
//INSERT INTO DATABASE
$sql = "INSERT INTO ads(`banner_name`, `hd_image`)VALUES('".$message."', '".$subject."') ";
$result = mysqli_query($conn, $sql);
}
/* close the connection */
imap_close($inbox);
?>
The code is functioning well, but I am facing a challenge. Every time I send a new email to my address, the query executes and inserts the details of the first email instead of the newly sent email. How can I resolve this issue?
Additionally, I would like to know how to download an attachment if an email is received with one.
I truly appreciate your assistance.