PHP - How To Add Dates From The Prevoius / Next Month?

Hi guys,

I am trying to do a multidates events availability calender. The script below indicates todays date by highlighting an orange colour and also indicates the start and end date of the event highlighting grey colour on the two dates (The colour are link via css classes as shown).
Code: [Select]
//Today's date
$todaysDate = date("d/m/Y");
            $dateToCompare = $daystring . '/' . $monthstring . '/' . $year;
echo "<td align='center' ";
if($todaysDate == $dateToCompare){
echo "class='today'";
}else{
//Compare's the event dates
$sqlcount = "select event_start,event_end from b_calender where event_start ='".$dateToCompare."' AND event_end='".$dateToCompare."'";
$noOfEvent = mysql_num_rows(mysql_query($sqlcount));
if($noOfEvent >= 1){
echo "class='event'";
}
}
It works ok i.e. if start date = 01/01/2012 and end date = 04/01/2012 both date will be highlighted with grey colour. However I want it to also highlight grey on the dates between the 1st and 4th to show that then anydates between the 1st and 4th are not available and this is when I'm stuck.

Please guys I need help.

Thanks

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

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!

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?

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, 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

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

delete

Hello everyone

I am coding a membership system for my usersystem on my website and I needed a little help. I have searched around quite a bit and can't find a working code.

In my database I have the date the VIP was purchased and I was wondering if anyone had a code which would check if they've had VIP for over a month and if so, delete it from the database.

I'm new-ish to MySQL and PHP and can't seem to code a working one. 

I need to find the last Friday of each month and determine the start and end dates of each month based on the last Friday.  So, for September, the last Friday was the 27th, that means Saturday the 28th will be the last day of September.  September 29 will then start the first day of October....  October 25 is the last Friday in October, so Saturday October 26 will close out October.....  Sun Oct 27 starts November, etc...

7/28 - 8/31

9/1 - 9/28

9/29 - 10/26

10/27 - 11/30

I can build a table and manually key in the start and end dates then query as needed, but if there is a way to do it on the fly, I'd rather do it in php to eliminate mistakes.

 

Below is the code I'm currently using to find the first and last day of each calendar month, but I'll need to convert this to find the fiscal month based on the last Saturday of each month.  And go back a few years in the option select.

      <select name="dateselect" id="dateselect">


          <?php


          $today = date("Y-m-d");
          $monthbegin =   date("Y-m-d",strtotime('first day of this month', strtotime($today)));

          for( $i= 0 ; $i <= 52 ; $i++ )
          {
          if($i == 0){
          $monthselect = date('Y-m-d',strtotime($monthbegin));
          $monthdisplay = date('F Y',strtotime($monthbegin));
          echo '<option ' . ($i == 0 ? 'selected=\'selected\'' : '') . ' value="' . $monthselect . '" >' . $monthdisplay . '</option>';
          }
          else{
          $monthselect = date('Y-m-d',strtotime('-'."$i".' months',strtotime($monthbegin)));
          $monthdisplay = date('F Y',strtotime('-'."$i".' months',strtotime($monthbegin)));
          echo '<option ' . ($i == 0 ? 'selected=\'selected\'' : '') . ' value="' . $monthselect . '" >' . $monthdisplay . '</option>';

          }




          }
          ?>
          </select>

  $begin_date = $_GET["dateselect"];
  $end_date = date("Y-m-t", strtotime($begin_date));

 

Edited November 8, 2019 by jakebur01

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
?>

I'm trying to get a bar graph from total number of hit on a month to month basis.

Everything works out find, except the bar graph is only showing 1 month, not everything that's being pulled out of the db.

Can anybody look and see what I'm doing wrong?

Code: [Select]
$userid = '44';
$t_month = date("Y-m-d h:i:s");
$y_month = date("Y-m-d h:i:s", strtotime("-1 Year"));

//Grabs Unique Visitors to App Page
$query = "SELECT CONCAT_WS(' ', YEAR(date), MONTHNAME(date)) AS RptDate, COUNT(DISTINCT referrer) 'referrer'
FROM app_analytics
WHERE appid = $userid
AND date BETWEEN '" .$y_month."'  AND  '" .$t_month."'
GROUP BY CONCAT_WS(' ', YEAR(date), MONTHNAME(date))
ORDER BY YEAR(date), MONTH(date)";

    $result = mysql_query($query) or die(mysql_error());       
        //$totals = array();
        while($row = mysql_fetch_array( $result )){
           
            $months = date("M", strtotime($row['RptDate']));
            $ip = $row['referrer']; 
             
           $values = array("$months" => $ip);
     
    $img_width=450;
$img_height=300;
$margins=20;

 
# ---- Find the size of graph by substracting the size of borders
$graph_width=$img_width - $margins * 2;
$graph_height=$img_height - $margins * 2;
$img=imagecreate($img_width,$img_height);

 
$bar_width=20;
$total_bars=count($values);
$gap= ($graph_width- $total_bars * $bar_width ) / ($total_bars +1);

 
# -------  Define Colors ----------------
$bar_color=imagecolorallocate($img,0,64,128);
$background_color=imagecolorallocate($img,240,240,255);
$border_color=imagecolorallocate($img,200,200,200);
$line_color=imagecolorallocate($img,220,220,220);
 
# ------ Create the border around the graph ------

imagefilledrectangle($img,1,1,$img_width-2,$img_height-2,$border_color);
imagefilledrectangle($img,$margins,$margins,$img_width-1-$margins,$img_height-1-$margins,$background_color);

 
# ------- Max value is required to adjust the scale -------
$max_value=max($values);
$ratio= $graph_height/$max_value;

 
# -------- Create scale and draw horizontal lines  --------
$horizontal_lines=20;
$horizontal_gap=$graph_height/$horizontal_lines;

for($i=1;$i<=$horizontal_lines;$i++){
$y=$img_height - $margins - $horizontal_gap * $i ;
imageline($img,$margins,$y,$img_width-$margins,$y,$line_color);
$v=intval($horizontal_gap * $i /$ratio);
imagestring($img,0,5,$y-5,$v,$bar_color);

}
 
 
# ----------- Draw the bars here ------
for($i=0;$i< $total_bars; $i++){
# ------ Extract key and value pair from the current pointer position
list($key,$value)=each($values);
$x1= $margins + $gap + $i * ($gap+$bar_width) ;
$x2= $x1 + $bar_width;
$y1=$margins +$graph_height- intval($value * $ratio) ;
$y2=$img_height-$margins;
imagestring($img,0,$x1+3,$y1-10,$value,$bar_color);
imagestring($img,0,$x1+3,$img_height-15,$key,$bar_color);
imagefilledrectangle($img,$x1,$y1,$x2,$y2,$bar_color);
}
 
header("Content-type:image/png");
imagepng($img);
 } 

Thanks in advance

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,

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