PHP - Fiscal Month

Hello. I want to generate the initial of the day of all the days of a chosen month. Meaning, if I choose this month it will give me:

TFSSMTWTFSSMTWTFSSMTWTFSSMTWTF

Is that clear? Can anybody help me? thanks!

OK, since today is the 31st, I guess I figured out that strtotime("-1 Month') really only goes back 30 days, so where I think it should be September, its registering October 1st. Is there a fix for this?
Code: [Select]
$month = date('F Y', strtotime("-1 month"));
$month1 = date('F Y', strtotime("-2 month"));
$month2 = date('F Y', strtotime("-3 month"));
$month3 = date('F Y', strtotime("-4 month"));
$month4 = date('F Y', strtotime("-5 month"));
$month5 = date('F Y', strtotime("-6 month"));

Hi, this one has me stumped!

For some reason February refuses to show up in my calender, that is, month 2 reads as march as well as month 3 (being correct).

Here is my code which is fine except for this silly bug:


$month = $_GET['month'] ;

$year = $_GET['year'] ;

if(!$month) $month = date('n') ;

if(!$year) $year = date('Y') ;

$days = cal_days_in_month(CAL_GREGORIAN, $month, $year) ;

echo "<div style='width:100%;text-align:center;font-size:1.3em;font-weight:bold;'>" ;

if($month == 1) echo "<a href=\"?month=12&year=" . ($year-1) ;

else echo " <a href=\"?month=" . ($month-1) . "&year=" . $year ; 

echo "\"><img style='border:none;' width='16' src='prev-month.png' /></a>" ;

echo " Classes for " . date("F, Y", strtotime("$year-$month")) . "\n" ;

if($month == 12) echo "<a href=\"?month=1&year=" . ($year+1) ;

else echo " <a href=\"?month=" . ($month+1) . "&year=" . $year ;

echo "\"><img style='border:none;' width='16' src='next-month.png' /></a>\n" ;

echo "</div>\n" ;

for($i=1;$i < 8;$i++) { // Create day headers...

echo "<div style='float:left;width:110px;margin:20px 5px 0px 5px;text-align:center;background:#1552ff;color:white;border:1px solid #155BFF;'>" . date("l", strtotime("$year-$month-$i")) . "</div>\n" ;

}

for($i=1; $i < $days+1;$i++) { // Create days...

$result = mysql_query("SELECT *

   FROM classes

   WHERE DAY(classDate) = '$i'

   AND MONTH(classDate) = '$month'

   AND YEAR(classDate) = '$year'")or die(mysql_error()) ;

$classCount = mysql_num_rows($result) ;

while($row = mysql_fetch_assoc($result)) {

$classes .= $row['title'] . "<br />" ;

}

echo "<div style='float:left;width:104px;height:104px;margin:0px 5px 0px 5px; border:1px solid #155BFF;border-top:none;cursor:pointer;padding:3px;' onmouseover=\"this.style.background='#ffbdec';\" onmouseout=\"this.style.background='none';\" title=\"" . str_replace('<br />', "\n\n", $classes) . "\" alt=\"" . str_replace('<br />', "\n\n", $classes) . "\">\n" ;

echo "<div style='float:left;height:84px;width:104px;'>\n" ;

echo "<span style='font-weight:bold;'>$i</span><br />\n" ;

echo "<span style='font-size:0.7em;'>" ;

echo $classes ;

echo "</span></div>\n" ;

echo "<div style='float:left;height:20px;width:104px;text-align:center;'>\n" ;

echo "<a href='#' style='font-size:0.7em;'>click to book a class</a>\n" ;

echo "</div>\n" ;

echo "</div>\n" ;

$classes = '' ;

}


working example he www.caketopper.co.uk/2011/class-schedule.php

I am trying to compare values and if the month is not of 2 digits then the comparison goes wrong.

Here is some hacked crap that doesn't work.


if (strlen($_POST['m'] <= 1)){$month = "0".$_POST['m'];}else{$month = $_POST['m'];}
if (strlen($_POST['d'] <= 1)){$day = "0".$_POST['d'];}else{$day = $_POST['d'];}

<form>

function GetDays(){
    $Listd = '<select name="d">';
if (isset($_POST['d'])){$Listd .='<option value="'.$_POST['d'].'">'.$_POST['d'].'</option>';}
    for ($x = 1; $x <= date('d'); $x++)
$Listd .= '<option value="'.$x.'">'.$x.'</option>';
    $Listd .= '</select>';
    return $Listd;
}

function GetMonths(){
    $Listm = '<select name="m">';
if (isset($_POST['m'])){$Listm .='<option value="'.$_POST['m'].'">'.$_POST['m'].'</option>';}
    for ($x = 1; $x <= date('m'); $x++)
$Listm .= '<option value="'.$x.'">'.$x.'</option>';
    $Listm .= '</select>';
    return $Listm;
}



Here is what I am comparing:
Now:          201012141292327875
Submitted: 201110101292353200 // 2 digit month/day

Now:          201012141292327984
Submitted: 2011991292353200 // not 2 digits month/day

2 hours is enough for me...can someone shed some light on this for me please?

Hi, I m trying to extract data by month from my date table.
my date format 2011-03-28

my query

$sql = "select * from table WHERE MONTH(date) = 03 " 


Now problem is i have many records in 3rd month but it only display the first row with above $sql. How can i see all month records.
Thanks

delete

I'm trying to get a total number from the db where the month is the same and the ip is different.
This is a stats script that someone else wrote, and I'm just trying to get a month-to-month total.

Right now, it pulls the information out and displays the month with how many different ips came that month, the problem is, it lists like this:

June - 41 - 41

June - 1 - 1

June - 1 - 1

June - 1 - 1

June - 1 - 1

June - 1 - 1

June - 9 - 9

June - 2 - 2

June - 2 - 2

June - 2 - 2

June - 1 - 1

June - 3 - 3

June - 2 - 2

June - 4 - 4

June - 1 - 1

June - 13 - 13

June - 154 - 154

what I need to do is grab all those numbers and give a total for that month, in this case, June.

This is my query
Code: [Select]
$query = "SELECT date, COUNT(referrer)'referrer' FROM app_analytics WHERE appid = $userid AND date BETWEEN '" .$y_month . "' AND '" . $t_month . "' GROUP BY referrer ORDER BY date";

Can anybody help out?

Thanks in advance

Hello,
Doing a little calendar where days are incremented as variable $i formatted like 'j' or single digit numbers 1,2,3 etc.  (The calendar works fine)
However for querying DB tables I need the day formatted as 'd' or 01,02,03 etc. so on any day I need to make this conversion.

I can't find an easy solution though there must be one.  Thanks in advance.
Code: [Select]
<?php
//test day
$i=7;
$day=date('d', mktime($i));
echo "$day";
//Should be 07
?>

Hi,

As the title says, I'm trying to get the last working day of the month (by this I mean excluding Saturday and Sunday). My thinking was that I basically need to this:

If (day = Sat)
   {
      -1 day
   }
elseif (day = Sun)
   {
     -2 days
   }
else
   {
     keep it as it is
   }

So far, all I have is the below to echo out the day of date("t/m/y"), however, all I'm getting is Thursday, whereas the last day of March is a Saturday

Code: [Select]
<?php

$lastdateofthemonth = date("t/m/y");
$lastworkingday = date('l', strtotime($lastdateofthemonth));
echo $lastworkingday; 

?>
Can anyone help, or point me in the way of where this may have been answered in the past? I've searched all over Google but can't find what I'm looking for.

Thanks

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=355706.0

hi all!
i have 2 tables:

PRODUCTS
id_prod, id_cat, date, prod_name

CATEGORIES
id_cat, cat_name

My goal is obtain the average (day and month) of all products inserted by users in this format:

category Hardwa avg daily 20, month 100
category Components: avg daily 2, month 15
and so on.

PS: the 'date' field is unix timestamp (int 10).

Can you help me?

How can i add dates from the previous / next month to the calendar for this calendar script? id like it to appear so its like:

28 29 30 31 1 2 3 4 5 6 etc.. then at the end 29 30 31 1 2 3 etc...


function av_calendar () {
$monthNames = Array("January", "February", "March", "April", "May", "June", "July", 
"August", "September", "October", "November", "December");
if (!isset($_REQUEST["sm"])) $_REQUEST["sm"] = date("n");
if (!isset($_REQUEST["sy"])) $_REQUEST["sy"] = date("Y");
$cMonth = $_REQUEST["sm"];
$cYear = $_REQUEST["sy"];

$prev_year = $cYear;
$next_year = $cYear;
$prev_month = $cMonth-1;
$next_month = $cMonth+1;

if ($prev_month == 0 ) {
$prev_month = 12;
$prev_year = $cYear - 1;
}
if ($next_month == 13 ) {
$next_month = 1;
$next_year = $cYear + 1;
}
//
$today = date('d');
echo '
<div class="head">
<h1>'.$monthNames[$cMonth-1].' '.$cYear.'</h1>
</div>
<div class="blockitem2">
<table width="100%" class="calendar" style="margin-left:-10px;" border="0" cellpadding="2" cellspacing="2">
<tr style="font-size:20px">
<th align="center"><strong>S</strong></th>
<th align="center"><strong>M</strong></th>
<th align="center"><strong>T</strong></th>
<th align="center"><strong>W</strong></th>
<th align="center"><strong>T</strong></th>
<th align="center"><strong>F</strong></th>
<th align="center"><strong>S</strong></th>
</tr> ';
$timestamp = mktime(0,0,0,$cMonth,1,$cYear);
$maxday = date("t",$timestamp);
$thismonth = getdate ($timestamp);
$startday = $thismonth['wday'];
$sy = date("Y",$timestamp);
$sm = date("m",$timestamp);
$sd = date("d",$timestamp);


for ($i=0; $i<($maxday+$startday); $i++) {
$day = ($i - $startday + 1);


if(($i % 7) == 0 ) { echo "<tr>\n"; }
if($i < $startday) { echo "<td></td>\n";
} else {
$now = "$sy-$sm-$day 00:00:00";
$then = "$sy-$sm-$day 23:59:59";
$sql = "SELECT av_episodes.id,av_episodes.date FROM av_episodes WHERE date between UNIX_TIMESTAMP('$now') AND UNIX_TIMESTAMP('$then')";
$query = exec_mysql_query($sql)  or die(mysql_error());
$rows = mysql_num_rows($query);
$nowurl = "$sy/$sm/$day/";

if(!empty($rows)) {
echo "<td class='dates' align='center' valign='middle' height='20px'><b><a href='".SITE_URL."updates/".$nowurl."'>". add_nulls($day) . "</a></b>";
} else { 
echo "<td class='datesInactive' align='center' valign='middle' height='20px'>". add_nulls($day) . "";
}
echo "</td>\n";





if(($i % 7) == 6 ) {echo "</tr>\n"; }



}
}
echo '</table></div>
';

Thanks to aleX_hill and RussellReal for the help so far. I'm trying to utilise the code before to find the next month. However, it needs to be used with the current year. So I altered the below


<?php
$nextMonth = date("m") + 1;
$daysInNextMonth = date("t",mktime(0,0,0,$nextMonth));
echo $daysInNextMonth;?>


to

#NEXT MONTH
$nextMonth = date("m") + 1;
echo $nextMonth; 
$daysInNextMonth = date("t",mktime(0,0,0,$nextMonth));
echo $daysInNextMonth ;
$year = date("o"); 
echo $year;


I can then pass it into my url query like so:

<a href="<?php echo $url_path; ?>after=<?php echo $year; ?>-<?php echo $nextMonth;  ?>-01&before=<?php echo $year; ?>-<?php echo $nextMonth;  ?>-<?php echo $daysInNextMonth; ?>">Next Month</a>


Brilliant I thought, until it comes to December 2010, the next month needs to be January 2011. Now I'm bamboozled. How do I get around this one?

Many thanks, your help is always appreciated!

Hi all,
I am currently storing dates and times for certain events in the following format:

$now= date('Y-m-d H:i:s');

This variable is then stored in a MySQL field of type DATETIME. I am looking for a way to query the database to return all results in a certain month, or within a certain time range, or a certain year etc.

How would this be achieved?

e.g. If I wanted to select everything for the year 2009, would it be:
SELECT * FROM table WHERE date BETWEEN '2009-01-01 00:00:00' AND '2009-12-31 11:59:59' ?

Thanks!

Hello,
I've been struggling for days on this problem now. And I'm getting frustrated!  I know that the answer is simple, and I've done it before but I cannot figure out what I'm doing wrong.
What do I want?
Well, I get a date from the database in this format: YYYY-MM-DD. I first want to distract one month from that and then set in into this form: YYYY, MM, DD. I've got this but it's not working (I've tried a lot different values).

$transformdate = date("Y-m-d", strtotime("-1 month", $d_datevalue)); 
$startpoint = str_replace("-", ", ", $transformdate);


Thanks,
NLCJ