PHP Days of the month counter.

waelaltaqi · 10-19-2007, 01:48 PM

I would like to know if there is a way to make PHP count the days in the current month. I'm just starting to learn PHP and it's kind of difficult at first. I will continue my research.
Any help on this will be appreciated.

vxc69 · 10-19-2007, 04:48 PM

Quote:

Originally Posted by waelaltaqi

I would like to know if there is a way to make PHP count the days in the current month. I'm just starting to learn PHP and it's kind of difficult at first. I will continue my research.
Any help on this will be appreciated.

Hello,

I think I can help out. But what do you mean by counting the days in the current month? Do you mean whether the current month has 30/31 days in it or do you mean finding out which day of the month it is?

vxc

waelaltaqi · 10-19-2007, 05:50 PM

thanks a lot ... i think i figured it out ..
i needed to find out the the number of days for the any given current month. Let's say it's April, then i need to PHP to figure out how many days are in the current month "April".
I read a little bit and i found out that i can use the date(t) function to do the job.

jlinkels · 10-19-2007, 08:15 PM

waelaltaqi, you have been around here long enough to know that it is nice to tell other people *how* you solved the problem. I assume you wanted to continue your project and forgot to elaborate.

Actually, the PHP recommended way is to use an expression like:

PHP Code:



$tomorrow  = mktime(0, 0, 0, date("m")  , date("d")+1, date("Y"));

And in your case I would suggest:

PHP Code:



$last_day  = date("M", mktime(0, 0, 0, date("m")+1  , date(1)-1, date("Y")));

E.q. take the 1st day of the next month and substract one day. from mktime you get back to a date by using the date function.

And an additional comment from my own experience: go to seconds format as soon as possible, do whatever you have to do and go back to date/time only then. Date/time format was made for humans, but not for computers.

jlinkels

waelaltaqi · 10-19-2007, 09:09 PM

Quote:

Originally Posted by jlinkels

I assume you wanted to continue your project and forgot to elaborate.

Well it's kind of a long story to tell. But here you ...
I'm trying to write a PHP script that will send out monthly spam statistics to my clients. In my opnion, it's one of the main featrues that MailWatch is missing. MailWatch team have wrote such a wonderfull piece of software but i wish they would have made that part easier on everybody. my spam server is MailScanner/MailWatch and people who worked on mailscanner know that it depends heavily on MYSQL. I'm trying to give my clients tables for total spam statistics for the month, average month statistics per mailbox and average daily statistics per day.
I'm a PHP super beginner but i was ver glad that i was able to produce some ouput. I'm still stuck on average dailly per mailbox statistics table which why i asked my original question. Here is the script and i would appreciate any advices or adjustments for my mistakes:

Code:

<html>
<head>
<meta name="keywords" content="">
<style type="text/css">
h3 {font-family: sans-serif }
h3.month {font-family: sans-serif ; color:d7060c}
h3.heading {font-family: sans-serif ; color:1c2894}
h4 {font-family: sans-serif }
table {table-layout: automatic}
tr.first {background-color:FFE303; text-align: center ; font-family: sans-serif ; font-weight: bold}
tr.second{background-color:E8E8E8 ; text-align: center ; font-family: sans-serif}
td {padding: 0.2cm}
p {font-family: sans-serif}
</style>
<title>ctiemail.com Spam Report</title>

</head>

<body>
<table>
       <tr>
               <td class="logo"><img src="Logo.jpg"></td>
               <td class="logo">
                       <h3> Monthly Spam Report for mydomain.com</h3><br>
                       <h3 class="month"><?php echo date(F) . " " . date(Y);?></h2>
               </td>
       </tr>
       </td>
</table>


<?php
$con = mysql_connect("localhost","root","mypass");
if (!$con)
 {
 die('Could not connect: ' . mysql_error());
 }

mysql_select_db("mailscanner", $con);
$domain = "mydomain.com";
//All messages query:
$AllMSG = mysql_query("select COUNT(*) as 'AllMSG' from maillog where to_domain= '$domain' AND MONTH(date) = MONTH(CURRENT_DATE);");

//Clean Message query:
$CleanMSG = mysql_query("select COUNT(*) as 'CleanMSG' from maillog where to_domain= '$domain' AND MONTH(date) = MONTH(CURRENT_DATE) AND isspam=\"0\";");

//Total Spam query:
$TSpamMSG = mysql_query("select COUNT(*) as 'TSpamMSG' from maillog where to_domain= '$domain' AND MONTH(date) = MONTH(CURRENT_DATE) AND isspam=\"1\";");

//High Scoring Spam query:
$HSpamMSG = mysql_query("select COUNT(*) as 'HSpamMSG' from maillog where to_domain= '$domain' AND MONTH(date) = MONTH(CURRENT_DATE) AND ishighspam=\"1\";");

//Black Listed Spam query:
$BSpamMSG = mysql_query("select COUNT(*) as 'BSpamMSG' from maillog where to_domain= '$domain' AND MONTH(date) = MONTH(CURRENT_DATE) AND spamblacklisted=\"1\";");

//White Listed Messages:
$WMSG = mysql_query("select COUNT(*) as 'WMSG' from maillog where to_domain= '$domain' AND MONTH(date) = MONTH(CURRENT_DATE) AND spamwhitelisted=\"1\";");

//Virus Message:
$VirusMSG = mysql_query("select COUNT(*) as 'VirusMSG' from maillog where to_domain= '$domain' AND MONTH(date) = MONTH(CURRENT_DATE) AND virusinfected=\"1\";");

//Bad Content Messages:
$BC = mysql_query("select COUNT(*) as 'BC' from maillog where to_domain='$domain' AND MONTH(date) = MONTH(CURRENT_DATE) AND nameinfected=\"1\";");

//Total Mailboxes Protected:
$TMailbox = mysql_query("SELECT COUNT(*) as 'TMailbox' FROM users WHERE username LIKE '%$domain';");

//Current Date
$CD = mysql_query("SELECT CURRENT_DATE AS 'CD';");

?>
<h4>Total Statistics:<h4/>
<table>
 <tr class="first">
  <td>Total Messages</td>
  <td>Total Spam</td>
  <td>Total Clean</td>
  <td>High Scoring Spam</td>
  <td>White Listed Messages</td>
  <td>Black Listed Spam</td>
  <td>Virus Infected</td>
  <td>Bad Content Messages</td>
 </tr>

 <tr class="second">
  <td>
   <?php
       while($row = mysql_fetch_array($AllMSG))
         {
           $AllMessages = $row['AllMSG'];
           echo $AllMessages ;
         }
     ?>
   </td>
   <td>
        <?php
          while($row = mysql_fetch_array($TSpamMSG))
            {
             $TotalSpam = $row['TSpamMSG'];
             $SpamPer = round(($TotalSpam * 100 ) / $AllMessages,1);
             echo $TotalSpam . "<br>" . "(".$SpamPer.")"."%";
            }
        ?>
   </td>
   <td>
       <?php
         while($row = mysql_fetch_array($CleanMSG))
           {
            $AllCleanMessages = $row['CleanMSG'];
            $CleanPer = round(($AllCleanMessages * 100 ) / $AllMessages,1);
             echo $AllCleanMessages . "<br>" . "(".$CleanPer.")"."%";
           }
       ?>
   </td>
   <td>
       <?php
          while($row = mysql_fetch_array($HSpamMSG))
            {
             $HighSpam = $row['HSpamMSG'];
             $HSpamPer = round(($HighSpam * 100 ) / $AllMessages,1);
             echo $HighSpam . "<br>" . "(".$HSpamPer.")"."%";
            }
        ?>
   </td>
   <td>
       <?php
          while($row = mysql_fetch_array($WMSG))
            {
             $WhiteMessages = $row['WMSG'];
             $WhiteMSGPer = round(($WhiteMessages * 100 ) / $AllMessages,1);
             echo $WhiteMessages . "<br>" . "(".$WhiteMSGPer.")"."%";
            }
        ?>
   </td>
    <td>
       <?php
          while($row = mysql_fetch_array($BSpamMSG))
            {
             $BlackSpam = $row['BSpamMSG'];
             $BSpamPer = round(($BlackSpam * 100 ) / $AllMessages,1);
             echo $BlackSpam . "<br>" . "(".$BSpamPer.")"."%";
            }
        ?>
   </td>
    <td>
       <?php
         while($row = mysql_fetch_array($VirusMSG))
           {
            $VirusMessages = $row['VirusMSG'];
            $VirusSpamPer = round(($VirusMessages * 100 ) / $AllMessages,3);
            echo $VirusMessages . "<br>" . "(".$VirusSpamPer.")"."%";
           }
       ?>
   </td>
     <td>
         <?php
         while($row = mysql_fetch_array($BC))
           {
            $BC = $row['BC'];
            $BCPer = round(($BC * 100 ) / $AllMessages,3);
            echo $BC . "<br>" . "(".$BCPer.")"."%";
           }
       ?>


     </td>

</table>

<h4>Monthly Average Statistics (Per Mailbox):</h4>
<table>
 <tr class="first">
 <td>Total Mailboxes Protected </td>
  <td>Total Average</td>
  <td>Spam Messages Average</td>
  <td>Clean Average</td>
  <td>Virus Messages Average</td>
 </tr>

 <tr class="second">
  <td>
   <?php
       while($row = mysql_fetch_array($TMailbox))
         {
           $TotalMailbox = $row[TMailbox];
           echo $TotalMailbox ;
         }
     ?>
   </td>
   <td>
   <?php
       $AVGMonthTotal = round(($AllMessages / $TMailbox),1);
        echo $AVGMonthTotal;
     ?>
   </td>
   <td>
   <?php
       $AVGMonthSpam = round(($TotalSpam / $TMailbox),1);
        echo $AVGMonthSpam;
     ?>
   <td>
   <?php
       $AVGMonthClean = round(($AllCleanMessages / $TMailbox),1);
        echo $AVGMonthClean;
     ?>

   </td>
   <td>
    <?php
       $AVGMonthVirus = round(($VirusMessages / $TMailbox),1);
        echo $AVGMonthVirus;
     ?>
   </td>
</table>
<h4>Daily Average Statistics (Per Mailbox):</h4>
<table>
 <tr class="first">
 <td>Total Mailboxes Protected </td>
  <td>Total Average</td>
  <td>Spam Messages Average</td>
  <td>Clean Average</td>
  <td>Virus Messages Average</td>
 </tr>

 <tr class="second">
  <td>
     <?php
       echo $TotalMailbox ;
     ?>
   </td>
   <td>
   <?php
      $CurrrentDate = day(t);
      $AVGMDayTotal = round(($AVGMonthTotal / $CurrentDate),1);
       echo $AVGDayTotal;
     ?>
   </td>
   <td>
   <?php
       $AVGMonthSpam = round(($TotalSpam / $TMailbox),1);
        echo $AVGMonthSpam;
     ?>
   <td>
   <?php
       $AVGMonthClean = round(($AllCleanMessages / $TMailbox),1);
        echo $AVGMonthClean;
     ?>

   </td>
   <td>
    <?php
       $AVGMonthVirus = round(($VirusMessages / $TMailbox),1);
        echo $AVGMonthVirus;
     ?>
   </td>
</table>

<?php mysql_close($con);?>

</body>
</html>

I'm stuck on creating another average daily table. To calculate the daily average per mailbox, i need to divide the Monthly average per mailbox by the number of days in a given month. Since the script is supposed to be schdualed in a cron job, i can't set the date manually. I need PHP to figure out what is the current day for any month at any given time and set it to a variable and use the variable in my calculation. If i figured it out, will follow the rules and post my new results. As i said, i welcome any additions for the scripts and i believe a lot of mailwatch users will find it usefull. I feel that it could have been written in a less complex platform, but what can i see ... trying to learn some PHP programing.

Best Regards;

jlinkels · 10-20-2007, 09:41 AM

Is it really the number of days in the current month you are stuck with?

It is quite simple.

Let's get the time stamp (number of seconds since the epoch) for the first day of this month:

PHP Code:



$fd_tm_ts = mktime (0, 0, 0, date ('m'), 1, date ('Y'));

(There was an error in my previous post, sorry about that, it was late)
Get the time stamp for the first day of the next month:

PHP Code:



$fd_nm_ts = mktime (0, 0, 0, date ('m')+1, 1, date ('Y'));

Now the number of days is the difference between the two divided my the number of seconds:

PHP Code:



$nr_days = ($fd_nm_ts - $fd_tm_ts)/86400;

This is all there is. If you want to calculate the number of days between arbitrary dates, use the month and year directly in the mktime function instead of date('m') and date ('Y')

Check the time(), date() and mktime() functions in the PHP manual. They are quite powerful and enable you to do all date arithmetic you'll ever need for programs like you are writing now.

jlinkels

waelaltaqi · 10-20-2007, 08:21 PM

First off, your last post has totaly solved my problem. I get correct average daily output for spam hits. Below is part of the script.

Code:

<?php 
$fd_tm_ts = mktime (0, 0, 0, date ('m'), 1, date ('Y'));       
$fd_nm_ts = mktime (0, 0, 0, date ('m')+1, 1, date ('Y'));  
$nr_days = ($fd_nm_ts - $fd_tm_ts)/86400
?>
 <tr class="second"> 
   <td> 
    <?php
            echo $TotalMailbox ;
    ?>
   </td>
   <td>	
	<?PHP
	$AVGDailyTotal = round(($AVGMonthTotal / $nr_days),1); 
	echo $AVGDailyTotal; 
	?>
   </td>
   <td>	
	<?PHP
	$AVGDailySpam = round(($AVGMonthSpam / $nr_days),1); 
	echo $AVGDailySpam; 
	?>
   </td>
      <td>	
	<?PHP
	$AVGDailyClean = round(($AVGMonthClean / $nr_days),1); 
	echo $AVGDailyClean; 
	?>
   </td>
   </td>
      <td>	
	<?PHP
	$AVGDailyVirus = round(($AVGMonthVirus / $nr_days),3); 
	echo $AVGDailyVirus; 
	?>
   </td>
</table>

i'm having another issue though. The intent of the script is to be mailed out to my clients. I'm trying to find a way to convert the output to static HTML so i could mail it out. I'm going to do my own research, but is there a way to mail the output straight from the PHP script?

graemef · 10-20-2007, 11:05 PM

php has a mail(string to, string subject, string message) function that enables you to send email directly (assuming that you have an email service configured on the server). However you may want to consider the option to have the email as plain text.

waelaltaqi · 10-22-2007, 09:51 AM

the mail function in PHP will send emails from the script but it'll will not send the output of the script itself. I found a solution by outputting the script using curl:

Code:

#curl http://localhost/myscript.php > /root/myoutput.html

Now another problem arised. I want to run a a cron job that will send the static html file every month... I tried this:

Code:

mail -s "MailsCanner Monthly reports" somebody@somedomain.com < /root/myouput.html

that sent the HTML file but in plain text. Just HTML code .. no tables no nothing ... I know that i have to define MIME type for the mail command but i couldn't find the option to do it.
I read some forms talking about modyfing MIME in sendmail config ... but my server is running POSTFIX ... i don't want to play with POSTFIX since it's highly mission critical ... Thanks in advance.