PHP - Trying To Find The Last Working Day Of The Month

Hi..

I need help in getting the 3 Months Name from my table field FromMonth and ToMonth.
Here is the scenario.

First, I select FromMonth and ToMonth.
Ex.
FromMonth = 5
ToMonth = 7
So it means
FromMonth is May
ToMonth is July.

Now I save the MonthNumber to my database:

table- so_month
FromMonth = 5
ToMonth = 7

Now I need to get the between Months Name from FromMonth to ToMonth which are (May, June, July).

How does it possible?
Thank you so much.

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"));

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!

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

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

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

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

Okay so I have a time in the format yyyy-mm-dd that is pulled from a MySQL array row and I need to add one month to it then echo that out. I assume it has something to do with the strtotime() and date() functions but I have tried every combination and cannot figure it out. Can I get some assistance please and thank you? Very very very new to php.

Here is what I have lol;
Code: [Select]
$row=mysql_fetch_array($result);
$ddaterow=$row['donation_date'];
Like I said the date will always be in the format yyyy-mm-dd

My db:

CREATE TABLE `tb_event` (
  `id` tinyint(4) NOT NULL auto_increment,
  `t_date` date default NULL,
  `t_event` varchar(75) default NULL,
  `t_place` varchar(75) default NULL,
  `t_content` text,
  PRIMARY KEY  (`id`)
)

Records:
1, '2011-01-09', 'event 1', ...
2, '2011-05-12', 'event 2', ...
3, '2011-09-20', 'event 3', ...

-------

My code he

<?
$now    = date("Y-m-d");
...
...
SELECT * FROM tb_acara WHERE t_tanggal >= $now
...
...
?>

It will show all records..
I change >= with <= it didn't show anything

-------

My goal is:
I only want to show the event which in September (month of 9) on record number 3

Can you help me please guys??
Thanks

Ok, so I have made 12 columns in mysql for each month.........I will have an event manager page that you can select each month that the event will take place in 0 is false 1 is true.........so I need to know how I can edit this code so that if the current month equals whatever month is checked, it will display..........is there a way to do this????????or would I need to use a date format instead of varchar and use a format such as yyyy-mm-dd and value = 0000/mm/00 so that only the month will display and then it could equal current month? Code: [Select]
<?php


// if no id is specified, list the available articles
if(!isset($_GET['eventid']))
{

   $query = "SELECT eventid, event, startdate, enddate FROM Registration ORDER BY eventid";
   $result = mysql_query($query) or die('Error : ' . mysql_error());
  
   // create the article list

   while($row = mysql_fetch_array($result, MYSQL_NUM))
   {
      list($eventid, $event, $startdate, $enddate) = $row;
  
      $as .= "<p><a href=\"viewevent.php?eventid=$eventid\">$startdate - $enddate --- $event</a></p>\r\n";
   }


   $Events = 'Events';
} else {
   // get the article info from database
     $query = "SELECT event, description, startdate, enddate, location, subevent1, subevent2, subevent3, subevent4, subevent5, subevent6, subevent7, subevent8, price1, price2, price3, price4, price5, price6, price7, price8 FROM Registration WHERE eventid=".$_GET['eventid'];
   $result = mysql_query($query) or die('Error : ' . mysql_error());
   $row = mysql_fetch_array($result, MYSQL_ASSOC);
   $startdate = $row['startdate'];
      $enddate = $row['enddate'];
     $location = $row['location'];
   $description = $row['description'];
$event= $row["event"];
$subevent1 = $row['subevent1'];
$subevent2 = $row['subevent2'];
$subevent3 = $row['subevent3'];
$subevent4 = $row['subevent4'];
$subevent5 = $row['subevent5'];
$subevent6 = $row['subevent6'];
$subevent7 = $row['subevent7'];
$subevent8 = $row['subevent8'];
$title1 = $row['title1'];
$title2 = $row['title2'];
$title3 = $row['title3'];
$title4 = $row['title4'];
$title5 = $row['title5'];
$title6 = $row['title6'];
$title7 = $row['title7'];
$title8 = $row['title8'];
$price1 = $row['price1'];
$price2 = $row['price2'];
$price3 = $row['price3'];
$price4 = $row['price4'];
$price5 = $row['price5'];
$price6 = $row['price6'];
$price7 = $row['price7'];
$price8 = $row['price8'];
$date1 = $row['date1'];
$date2 = $row['date2'];
$date3 = $row['date3'];
$date4 = $row['date4'];
$date5 = $row['date5'];
$date6 = $row['date6'];
$date7 = $row['date7'];
$date8 = $row['date8'];
}
?> Code: [Select]
<table width="410" border="1" cellspacing="0" cellpadding="0">
    <tr>
      <td width="339" bgcolor="#999999" scope="col">EVENTS</td>
    </tr>
    <tr>
      <td class="afasd"><?php echo date("F",strtotime("-0 month")); ?></td>
    </tr>
    <tr>
      <td><?php echo $as; ?></td>
    </tr>
    <tr>
      <td class="adfaf"><?php echo date("F",strtotime("+1 month")); ?></td>
    </tr>
    <tr>
      <td><?php echo $as; ?></td>
    </tr>
    <tr>
      <td class="jasdfjs"><?php echo date("F",strtotime("+2 month")); ?></td>
    </tr>
    <tr>
      <td><?php echo $as; ?></td>
    </tr>
  </table>
does this make sense?

Hello this code is supposed to sort by year and month, but it doesn't.  It sort by year and months are random.  Any suggestions?  Many thanks,

$sortdata =[];
        $namecolumn = array_column($data, '0');
        foreach($data as $datecolumn){
            $dateexplode = explode('/', $datecolumn[3]);
            $sortdata[] = (isset($dateexplode[1])) ? $dateexplode[1] : ((isset($dateexplode[0])) ? $dateexplode[0] : '');
    
        }
        array_multisort($namecolumn, (($sorttype=='DESC') ? SORT_DESC : SORT_ASC), $sortdata, (($sorttype=='DESC') ? SORT_DESC : SORT_ASC), $data);

            

Edited May 13 by Barand
code tags added

date in my database is save as (dd/mm/yyyy). now i want to create sql to search for activity for chosen month..how do i extract month from (dd/mm/yyyy) and include in sql?

Hi,

I am having set of records,
id       
name
dob

1  philip         1278226800
2  winsent     1278216800
3  Benn          1272226800


now i want to fetch the records based on the month and listing out, can anyone help me to write for the above concept.

Thanks,