mark107

Does anyone know how I can fetch 20 emails when I am using imap???????

any idea how i can fetch 20 emails using imap_fetch_overview??

Hi all, I need your help. I am working on my code as I want to set the limit to 25 as I want to fetch 25 emails from gmail using imap. When I try this: <?php ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL); // Load Composer's autoloader require_once "Mail.php"; require_once "Mail/mime.php"; require_once('Mail/IMAPv2.php'); $username = 'myusername@gmail.com'; $password = 'mypassword'; $server = '{imap.gmail.com:993/imap/ssl/ssl}INBOX'; $inbox = imap_open($server, $username, $password); $test = listMessages($inbox); print_r($test); function listMessages($inbox) { $page = 1; $per_page = 25; $sort = null; $limit = ($per_page * $page); $start = ($limit - $per_page) + 1; $start = ($start < 1) ? 1 : $start; $limit = (($limit - $start) != ($per_page-1)) ? ($start + ($per_page-1)) : $limit; $info = imap_check($inbox); $limit = ($info->Nmsgs < $limit) ? $info->Nmsgs : $limit; $msgs = ''; $result = ''; $perPage = 25; $start = $page == 1 ? 0 : $page * $perPage - ($perPage - 1); $order = 0; $by = SORTDATE; if (is_array($sort)) { $order = $this->sortBy['order'][$sort[0]]; $by = $this->sortBy['by'][$sort[1]]; } $sorted = imap_sort($inbox, $by, $order); $mails = array_chunk($sorted, $perPage); $mails = $mails[$page - 1]; print_r($mails); return $return; } ?> It will fetch and display 77,500 emails which is too much so I need to reduce it. How I can fetch 25 emails from gmail using imap when I connect to my gmail inbox?

The problem I am having is I am getting the size of the database but without the KB, MB and GB which I need it. How I can use the code to select the bytes in the database?

Oh right, well I just copied the code from other site so I must have got it wrong. I want to query the select of the byte values so I can convert it to MB easily. Could you please show me how I can use the code to select the bytes in example code? I did look on the link you sent you, but I need to query the byte values first then format them into kb, mb or gb using with PHP.

Hi all. I need some help with my PHP code. I have got a problem with the code, because it did not come with MB, KB or GB as the return output. I'm only getting which it is "60.1" as the return output. Here is the code: $db_name = "dbuser_table"; $mailbox = $link->prepare("SELECT table_schema,ROUND(SUM(data_length + index_length) *1024, 2) AS dbsize FROM information_schema.TABLES WHERE table_schema = '$db_name'"); $mailbox->execute(); $data = $mailbox->fetch(PDO::FETCH_ASSOC); $db_size = $data['dbsize']; echo $db_size; Here is what I want to achieve as the return output: 60.1MB The only way I can do is convert it to byte, but I cant convert to byte because I'm keep getting "60.1" as the return output. Do you know how I can get the return output of the database size with kb, mb or gb? What do I need to use to get the return output of the DB size with the kb, mb or gb? Thanks in advance.

Hi all, I need your help with my PHP coding. I'm working on the snippet to calculating on the two folders and the database to get the used size, then I'm calculating on the used size with the percent to make the width size. <?php //Connect to the database require_once('../config.php'); $db_name = "db_user"; $mailbox = $link->prepare("SELECT table_schema,SUM( data_length + index_length ) / 1024 AS dbsize FROM information_schema.TABLES WHERE table_schema = '$db_name'"); $mailbox->execute(); $data = $mailbox->fetch(PDO::FETCH_ASSOC); $db_size = $data['dbsize']; $SIZE_LIMIT = 1073741824; // 1 GB $upload_folder = foldersize('../uploads/'); $attachments_folder = foldersize('../u/attachments/'); $bytes = $upload_folder + $attachments_folder; $disk_used = $bytes + $db_size; $disk_remaining = $SIZE_LIMIT - $disk_used; $free_space = convertToReadableSize($disk_remaining); $total = $SIZE_LIMIT; $free = $SIZE_LIMIT - $disk_used; $percentage = ($free / $total) * 100; $width_size = 100 - round($percentage); echo "width_size.............." . $width_size . '%'; ?> I want to make the width size with percent that start from 0% to 100% when I calculate on the two folders and the database to get the disk size and then calculate on the percent. On my code, it show that I have used 8% of the disk size when the disk used size is 144MB and the limit size I can use is 1GB. I'm not sure if I have wrote the code correctly. Is that the correct way to calculate to make the total size and take away the disk used size then work out the percent or if I have done it wrong?

Yes I do but I will use sa-learn to scan my spam / junk folders in my mail directory later on. I will let the cron job to do the work automatically. It sounds like to me I would need to call imap to move the emails to junk folder and let the cron job to run sa-learn later to scan these spam messages in the mail directory, is that correct??

Yes this is what I am doing right now to move the emails to spam folder when I mark them as spam. I know that it can be easily be done by insert the data into Spam DB and delete the emails from any DB table. I need to inform sa-learn to let them know that I have mark the emails as spam and I know that I don't need to use sa-learn later when I report the emails as spam or revoke as ham. When I report the emails as spam and not spam, I have got two choice to do this. 1. Create a file to output the header in the file and run the sa-learn to scan these spam messages. 2. Call imap to move the emails to junk folder and run the sa-learn to scan these spam messages. As I can see the files have already been created in "/home/username/mail/mydomain.com/myaccount/.spam/" so there is no need to create the same file with the same output. It will save my disk space from being waste. It sounds like to me I would need to call imap using with uid to move the emails to junk folder and run the sa-learn later on to scan the emails automatically to train the filter, is that correct?

What do you mean what I'm doing that is unnecessary? Yes, I am using the class, but I can also run shell_exec which it works the same way as the class I use which it can be done by using this: $output = shell_exec('/usr/local/cpanel/3rdparty/bin/sa-learn -p /home/username/.spamassassin/user_prefs --spam /home/username/public_html/test/{new}'); echo "<pre>$output</pre>"; I have been using it as it works great, but there is a problem. I need to create a new file in order to run the command. If I report 2 emails as spam and then report one of these emails as not spam, how would sa-learn suppose to know which emails I report is not spam if I use the same filename that I created in the /home/username/public_html/test/new folder??

Oh right, if I use this: Update_bayes.php <?php ini_set('display_errors', '1'); ini_set('display_startup_errors', '1'); error_reporting(E_ALL); require_once('../Spamassassin/Client.php'); require_once('../Spamassassin/Client/Exception.php'); require_once('../Spamassassin/Client/Result.php'); $spam_mailbox = $link->prepare("SELECT count(*) FROM `Spam` WHERE readtype = ?"); $spam_mailbox->execute([$unread]); $row = spam_mailbox->fetch(PDO::FETCH_ASSOC); $header = $row['header']; $fp = fopen('/home/user/myfolder/spam.txt', 'w'); fwrite($fp, $header); fclose($fp); $message = @file_get_contents('spam.txt'); $params = array( "hostname" => "localhost", "port" => "783", "user" => "root"); $sa = new Spamassassin\Client($params); if ($isSpam == 'Spam') { $sa->report($email_content); } else if ($isSpam == 'Not Spam') { $sa->revoke($email_content); } ?> To run on cron job, example: /usr/local/cpanel/3rdparty/bin/sa-learn -p ~/.spamassassin/user_prefs --spam ~/public_html/username/myfolder/update_bayes.php Would it work to get the Bayes database update if I run PHP script on cron job so the sa-learn could scan my emails and learn from it?? But what if the server goes offline would the sa-learn lose the information before the server get back online??

Great. I have been told that I need to create the file to output the email header included the body for sa-learn to scan the email and then update the bayes database??

Hi all, I wonder if any of you could help me with this. I'm storing the source emails in a database after I have fetching the emails from imap. I'm running the cron job in every 24 hours to monitor for spam emails in the spam folder so the Bayes database can get update. Here is what I use to run on cron job: /usr/local/cpanel/3rdparty/bin/sa-learn -p ~/.spamassassin/user_prefs --spam ~/mail/mydomain.com/myaccount/.spam/{cur,new As I'm using to store the emails in a database, can I run the PHP on cron job to get the Bayes database update? Example: /usr/local/cpanel/3rdparty/bin/sa-learn -p ~/.spamassassin/user_prefs --spam ~/public_html/username/myfolder/update_bayes.php Would it ever work to get the Bayes database update so the spamassassin could learn from it??

Oh right, what command do you use to put in the cron job to get it to run in every 24 hours?? How do you call the spamassassin to add the rules when you mark the emails as spam? Do you use the same API as I use?

How do you use your PHP to run sa-learn to train the emails as junk?? I need to see it how you did it so I can run for a test, if you dont show it I won't know how you did it.

How I can run sa-learn to train it using with PHP??

Oh right, so what is the main reason that most providers use mark as spam?? When I mark the emails as spam, does it add to the spamassassin rules so spamassassin will learn from it??

I just want to add the records in the SpamAssasin when I mark the emails as spam, so the emails will be identify as spam next time I receive them. I don't know why you ask me these questions.

Hi all, I need your help with the code, because I am not sure which variable I should use to send the report to spamassassin to mark my emails as spam and not spam. I am using the script from this link: https://samprasanna.blogspot.com/2017/06/php-api-to-spamassassin-spamd-protocol.html Here is the code: <?php ini_set('display_errors', '1'); ini_set('display_startup_errors', '1'); error_reporting(E_ALL); require_once('Mail.php'); require_once('Mail/IMAPv2.php'); require('Spamassassin/Client.php'); require('Spamassassin/Client/Result.php'); // Connect to the server: $username = 'username'; $password = 'tester; $params = array( "hostname" => "localhost", "port" => "783", "user" => "user"); $sa = new Spamassassin\Client($params); $inbox = '{imap.domain.com:993/imap/ssl/novalidate-cert}INBOX'; $inbox = imap_open($inbox, $username, $password) or die("Can't connect: " . imap_last_error()); $email_number = '121'; $message = imap_fetchbody($inbox, $email_number, "", FT_UID); $header = htmlspecialchars(imap_fetchbody($inbox, $email_number, "", FT_UID|FT_PEEK)); ?> It works fine, but I need some help with this: $sa->report($message) Report message as spam, both local and remote And this: $sa->revoke($message) Revokes a message previously reported as spam When I send the report to spamassassin, which variable do I have to use $message or $header to report the email as spam and not spam?? Do I have to use `$message` or `$header` when send report to spamassassin?? I have tried to find the answer on Google, but I couldn't find it. I guess I would have to use the $header variable when I report the emails as spam and not spam but I am not really sure. Any advice would be much appreciated. Thanks in advance.

Any idea????????

Code for array: $searchemail = '%' . 'gmail.com' . '%'; $searchsubject = '%' . 'gmail.com' . '%'; $searchmessage = '%' . 'gmail.com' . '%'; $mailbox = $link->prepare("SHOW TABLES"); $mailbox->execute(); $email_arr = array(); $folders = array(); $total_results = 0; $i = 0; while ($folder = $mailbox->fetch(PDO::FETCH_NUM)) { $folder = $folder[0]; //if (strpos($folder, 'trash') !== false) { //$folder = str_replace('trash', '', $folder); //} if (strpos($folder, 'users') !== false) { $folder = str_replace('users', '', $folder); } else { $folders[$i] = $folder; } $i++; } foreach($folders as $folder) { $search_mailbox = $link->prepare("SELECT * FROM $folder WHERE from_email LIKE ? OR subject LIKE ? OR message LIKE ? ORDER BY received_date DESC"); $search_mailbox->execute([$searchemail, $searchsubject, $searchmessage]); $total_results += $search_mailbox->rowCount(); //Close connection $search_mailbox = null; } $i = 0; $page = 1; $limit = 50; $pages = ceil($total_results / $limit); $end = $limit; $start = 0; if ($page >= 2) { $start = $page * $limit - 50; } echo "the start in page 1 is........................." . $start; echo "<br>"; echo "<br>"; foreach($folders as $folder) { $search_mailbox = $link->prepare("SELECT * FROM $folder WHERE from_email LIKE ? OR subject LIKE ? OR message LIKE ? ORDER BY received_date DESC"); $search_mailbox->execute([$searchemail, $searchsubject, $searchmessage]); if ($search_mailbox->rowCount() > 0) { foreach($search_mailbox->fetchAll() as $k => $row) { $email_number = $row['id']; $search_from = $row['from_email']; $search_subject = $row['subject']; $email_arr[$i] = ['email_number' => $email_number, 'email_from' => $search_from, 'email_subject' => $search_subject]; $i++; } } } $test = array_slice($email_arr, $start, $end); $ii = 0; foreach($test as $emails) { $ii++; echo $emails['email_subject'] . '........................' . $ii; echo "<br>"; echo "<br>"; echo "<br>"; } Code for database: $searchemail = '%' . 'gmail.com' . '%'; $searchsubject = '%' . 'gmail.com' . '%'; $searchmessage = '%' . 'gmail.com' . '%'; $mailbox = $link->prepare("SHOW TABLES"); $mailbox->execute(); $folders = array(); $total = 0; $total_rows = 0; $i = 0; while ($folder = $mailbox->fetch(PDO::FETCH_NUM)) { $folder = $folder[0]; if (strpos($folder, 'users') !== false) { $folder = str_replace('users', '', $folder); } else { $folders[$i] = $folder; } $i++; } foreach($folders as $folder) { $search_mailbox = $link->prepare("SELECT * FROM $folder WHERE from_email LIKE ? OR subject LIKE ? OR message LIKE ? ORDER BY received_date DESC LIMIT 0, 50"); $search_mailbox->execute([$searchemail, $searchsubject, $searchmessage]); if ($search_mailbox->rowCount() > 0) { $total += $search_mailbox->rowCount(); } } $i = 0; $page = 1; $limit = 50; $pages = ceil($total_results / $limit); $end = $limit; $start = 0; if ($page >= 2) { $start = $page * $limit - 50; } $offset = ($page - 1) * $limit; echo 'start.........................' . $start; echo "<br>"; echo 'end.........................' . $end; echo "<br>"; foreach($folders as $folder) { $search_mailbox = $link->prepare("SELECT * FROM $folder WHERE from_email LIKE ? OR subject LIKE ? OR message LIKE ? ORDER BY received_date DESC LIMIT 50, 50"); $search_mailbox->execute([$searchemail, $searchsubject, $searchmessage]); if ($search_mailbox->rowCount() > 0) { foreach($search_mailbox->fetchAll() as $k => $row) { $email_number = $row['id']; $search_from = $row['from_email']; $search_subject = $row['subject']; $limit--; $total_rows++; echo $search_subject . '.........................' . $total_rows; echo "<br>"; } } }

here is the results for the array when I am on the page 1: Image body........................1 Hey........................2 Hey........................3 Testing........................4 Re: Re: This weekend........................5 Re: This weekend........................6 This weekend........................7 Hey........................8 Meeting this weekend........................9 Meeting this weekend........................10 Re: Working on a project........................11 Hey Mark 7........................12 Hey Mark 6........................13 Hey Mark 5........................14 Hey Mark 4........................15 Hey Mark 3........................16 Hey Mark 2........................17 Hey Mark........................18 This lead Unsubscribed: ************@gmail.com........................19 This lead Unsubscribed: ************@gmail.com........................20 This lead Unsubscribed: ************@gmail.com........................21 This lead Unsubscribed: ************@gmail.com........................22 This lead Unsubscribed: ************@gmail.com........................23 This lead Unsubscribed: ************@gmail.com........................24 This lead Unsubscribed: ************@gmail.com........................25 This lead Unsubscribed: ************@gmail.com........................26 This lead Unsubscribed: ************@gmail.com........................27 This lead Unsubscribed: ************@gmail.com........................28 This lead Unsubscribed: ************@gmail.com........................29 This lead Unsubscribed: ************@gmail.com........................30 Hey........................31 Контрольные точки в переговорах........................32 Hey 2........................33 Hey........................34 Hey........................35 test spam........................36 [Earn 50 Credits] - Get A 10-Pack Of Ads At Ads........................37 [Earn 50 Credits] - Get A 10-Pack Of Ads At Ads........................38 [Earn 50 Credits] - Get A 10-Pack Of Ads At Ads........................39 Test 4 images........................40 Hey Mark........................41 Image body........................42 zip and rar attachment........................43 test image attachment no 5........................44 Hey........................45 Image in body and attachement........................46 checking message body........................47 New Email For Test........................48 Test Message From Shibbir........................49 Hey Mark 2........................50 here is the results for the array when I am on the page 2: Re: Test Email by Koviri J........................1 Re: Test Email by Koviri J........................2 Test Email by Koviri J........................3 How are you........................4 Hey Mark........................5 Re: Meeting this weekend........................6 Hello........................7 Re: What’s the minimum?........................8 1,000 visitors per DAY.........................9 DIRTY CHEAP traffic!........................10 4 cent clicks. (OPEN NOW)........................11 Up to $400... per DAY...........................12 Turn a few bucks into $197+...........................13 How To Get An Extra $100-$500 in Your PayPal........................14 Re: Test Email........................15 GET MONEY in the next 24 hours - up to $200+ per day...........................16 3 steps to $200+ a day...........................17 $318+ per day with this 60 SECOND NICHE SITE GENERATOR...........................18 Booooooombarded............................19 THIS WEEKEND: Over $400 in less than 1 hour............................20 FREEEEEE videooooooooo traaaaaaffic............................21 THIS WEEKEND: $408 in 45 minutes..........................22 Weird system SPITS OUT $97 payments...........................23 $97 a pop pop pop...........................24 FREE SYSTEM: Affiliate marketing IN REVERSE...........................25 traaaaaaaaaaaaaaaaaaaffiiiiiiiiiiic........................26 dead business........................27 hey, YOU need this........................28 CLONE this!........................29 Your money........................30 Re: Hey........................31 Re: Hey........................32 AI: New FREE 7 figure traffic getting system............................33 FREE SYSTEM: Stuffs your pockets with $20 bills...........................34 FREEEEEEEEEE system sucks in $20 bills...........................35 DFY websites that suck in $12,000+ per month (can be YOURS)............................36 OPEN NOW: If you've never made money online (new $12K per month system)............................37 $100 to $200, day after day...........................38 CASH FAST: $200 a day...........................39 You bloody motherfucker didn't pay anyone...........................40 you're only $200-a-day away from FIRING your boss...........................41 -----> weird fun income video for ya...........................42 Re:........................43 Re:........................44 Re:........................45 Re:........................46 Re:........................47 ........................48 my last email...........................49 crazy deal........................50 Here is the results for the database when I am on the page 1: Image body.........................1 Hey.........................2 Hey.........................3 Testing.........................4 Re: Re: This weekend.........................5 Re: This weekend.........................6 This weekend.........................7 Hey.........................8 Meeting this weekend.........................9 Meeting this weekend.........................10 Re: Working on a project.........................11 Hey Mark 7.........................12 Hey Mark 6.........................13 Hey Mark 5.........................14 Hey Mark 4.........................15 Hey Mark 3.........................16 Hey Mark 2.........................17 Hey Mark.........................18 This lead Unsubscribed: ************@gmail.com.........................19 This lead Unsubscribed: ************@gmail.com.........................20 This lead Unsubscribed: ************@gmail.com.........................21 This lead Unsubscribed: ************@gmail.com.........................22 This lead Unsubscribed: ************@gmail.com.........................23 This lead Unsubscribed: ************@gmail.com.........................24 This lead Unsubscribed: ************@gmail.com.........................25 This lead Unsubscribed: ************@gmail.com.........................26 This lead Unsubscribed: ************@gmail.com.........................27 This lead Unsubscribed: ************@gmail.com.........................28 This lead Unsubscribed: ************@gmail.com.........................29 This lead Unsubscribed: ************@gmail.com.........................30 Hey.........................31 Контрольные точки в переговорах.........................32 Hey 2.........................33 Hey.........................34 Hey.........................35 test spam.........................36 [Earn 50 Credits] - Get A 10-Pack Of Ads At Ads.........................37 [Earn 50 Credits] - Get A 10-Pack Of Ads At Ads.........................38 [Earn 50 Credits] - Get A 10-Pack Of Ads At Ads.........................39 Test 4 images.........................40 Hey Mark.........................41 Image body.........................42 zip and rar attachment.........................43 test image attachment no 5.........................44 Hey.........................45 Image in body and attachement.........................46 checking message body.........................47 New Email For Test.........................48 Test Message From Shibbir.........................49 Hey Mark 2.........................50 Re: Test Email by Koviri J.........................51 Re: Test Email by Koviri J.........................52 Test Email by Koviri J.........................53 The computer must make money.........................54 Earnings on your PC.........................55 Программа пассивного дохода.........................56 How to use a PC to earn money?.........................57 test.........................58 How to use a PC to earn money?.........................59 Security Notice. mark@************.com was hacked! Change your password now!.........................60 Test signature.........................61 Try this.........................62 Hey.........................63 Hey.........................64 Hey.........................65 ***SPAM*** [Earn 50 Credits] - Get A 10-Pack Of Ads At Ads.........................66 ***SPAM*** [Earn 50 Credits] - Get A 10-Pack Of Ads At Ads.........................67 ***SPAM*** [Earn 50 Credits] - Get A 10-Pack Of Ads At Ads.........................68 ***SPAM*** [Earn 50 Credits] - Get A 10-Pack Of Ads At Ads.........................69 [Earn 50 Credits] - Get A 10-Pack Of Ads At EvolutionAds.........................70 ***SPAM*** stuff $400 a day with this............................71 ***SPAM*** .........FAST cash...................................72 ***SPAM*** URGENT: Here's how my buddy Matt made over $50,000 last month............................73 ***SPAM*** .........$500+ per day campaigns DONE FOR YOU....................................74 Testing 2.........................75 This weekend.........................76 This lead Unsubscribed: ************@gmail.com.........................77 This lead Unsubscribed: ************@gmail.com.........................78 test spam.........................79 Here is the results for the database when I am on the page 2: How are you.........................1 Hey Mark.........................2 Re: Meeting this weekend.........................3 Hello.........................4 Re: What’s the minimum?.........................5 1,000 visitors per DAY..........................6 DIRTY CHEAP traffic!.........................7 4 cent clicks. (OPEN NOW).........................8 Up to $400... per DAY............................9 Turn a few bucks into $197+............................10 How To Get An Extra $100-$500 in Your PayPal.........................11 Re: Test Email.........................12 GET MONEY in the next 24 hours - up to $200+ per day............................13 3 steps to $200+ a day............................14 $318+ per day with this 60 SECOND NICHE SITE GENERATOR............................15 Booooooombarded.............................16 THIS WEEKEND: Over $400 in less than 1 hour.............................17 FREEEEEE videooooooooo traaaaaaffic.............................18 THIS WEEKEND: $408 in 45 minutes...........................19 Weird system SPITS OUT $97 payments............................20 $97 a pop pop pop............................21 FREE SYSTEM: Affiliate marketing IN REVERSE............................22 traaaaaaaaaaaaaaaaaaaffiiiiiiiiiiic.........................23 dead business.........................24 hey, YOU need this.........................25 CLONE this!.........................26 Your money.........................27 Re: Hey.........................28 Re: Hey.........................29 AI: New FREE 7 figure traffic getting system.............................30 FREE SYSTEM: Stuffs your pockets with $20 bills............................31 FREEEEEEEEEE system sucks in $20 bills............................32 DFY websites that suck in $12,000+ per month (can be YOURS).............................33 OPEN NOW: If you've never made money online (new $12K per month system).............................34 $100 to $200, day after day............................35 CASH FAST: $200 a day............................36 You bloody bad didn't pay anyone............................37 you're only $200-a-day away from FIRING your boss............................38 -----> weird fun income video for ya............................39 Re:.........................40 Re:.........................41 Re:.........................42 Re:.........................43 Re:.........................44 .........................45 my last email............................46 crazy deal.........................47 OUTTA NOWHERE: Newbie system rakes over $8,000 per mo. ...............................48 $8k per month for NEWBIES............................49 FAST $20-$80 within 24 hours (open up to start)............................50

I find it very strange because when I store the list of strings in the array and when I use: $test = array_slice($email_arr, 50, 50); It works fine, but when I try this: $search_mailbox = $link->prepare("SELECT * FROM $folder WHERE from_email LIKE ? OR subject LIKE ? OR message LIKE ? ORDER BY received_date DESC LIMIT 50, 50"); I will not be able to see the same output as above. Any idea?

Thanks, but it will do nothing as it will display more than 50 rows.

What value do you want me to reset before each folder?