PHP - Get Month Value From Date Stamp

I am looking for a way to have my 'start_date', echo ('start_date' + 1 month).  I am looking at the line that reads .... date("F Y",strtotime($row['start_date'])).  Does anyone have a suggestion.  The date format read, July 2014 or alphabetical full month, numerical full year.  Thank you in advance.

    <?php

$query = sqlsrv_query($conn, $sql);if ($query === false){  exit("<pre>".print_r(sqlsrv_errors(), true));}while ($row = sqlsrv_fetch_array($query)){  echo "<tr>
    <td><a href='view_invoice.php?meter_id=$meter_id&subaccount=$subaccount&start_date=$row[start_date]'>$row[meter_id]</a></td>
    <td>" . date("F Y",strtotime($row['start_date']))  . "<td>$row[invoice_no]</td><td>" . date_format($row['invoice_date'],'Y-m-d') . "<td>$row[amount_paid]</td>" . "<td>$row[payment_date]</td>" . "<td>$row[check_number]</td>" 
  ;}sqlsrv_free_stmt($query);
  ?>

Edited by Butterbean, 11 January 2015 - 08:19 PM.

Hi guys, i was having an issue with dates and although it leans a bit more into MYSQL I was hoping i could get some help ive searched all over the net for this so I dont know if im not thinking on how to ask this correctly or can't find it, but ill be as detailed as possible and hope that helps.   Ok I have a table that shows when payment was received on past invoices dating back to say 1995;  The company processes 'ALL' invoices every month on the 9th, so if anything comes in from the first to the ninth it will be processed that month on the ninth.  If it comes in from the tenth to the thirtieth or thirty-first it will be processed the following month.   The table already has a "Received" date filed and now I want to create a column on the table called "Processed Date" (adding the column is no problem don't need help with that part) that shows me the date we processed the invoice.   I know i have to use the "Received" field (because it shows what day the invoice was put into the system) but im not sure how to format the "Processed Date" field, so say the "Received" field shows an invoice came in on  '1995-05-11', I want the "Processed Date" field to display it was payed on '1995-06-09' (notice that is the following month).   I thought i would put in a visual of what I was trying to do below:   So if I pull the two columns in MYSQL from that table I would see something like this:   Received                Processed Date 1996-02-03            1996-02-09 1996-03-03            1996-03-09 1996-04-11            1996-05-09 1996-05-20            1996-06-09 1996-07-13            1996-08-09   If i could get some guidance/help on this i would really appreciate it.   thanks in advance!!   JL

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,

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?

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

Hi if i have $date = "12-08-2018" or "2018-08-12"

Need to subtract a month. Could this be done for day and year even?

TIA

Desmond.

P.S.

What I want to do is clear out a database table with records over a month old so today is 27th Jan 2018. I would like to create a date “2018-12-01”

I can then use this in an SQL to delete all before “2018-12-01”

Edited January 27, 2019 by Paul-D

Hi, I'm having trouble with this:

Code: [Select]
$date = date('d/m/y') ;
echo $date;
echo "<br/>";
$date1 = strtotime('date -1 month');
echo date('Y-m-d', $date1);
My result looks like this:
Current Date:  19/05/11
Date minus 1 month:  1970-01-01

I want it to look like this:
Current Date:  19/05/11
Date minus 1 month:  2011-04-19

I am getting syntax error, unexpected T_CONSTANT_ENCAPSED_STRING
on the date stamp line below but I can't see what is causing the problem.
when I comment it out the problem goes away so I know I it is there.
please help.
 
$email_message = "Form details below.\n\n";
 $email_message = date("m/d/Y")"\n";

Hi Guys,

Been a while since I've been on here,  but I'm currently bashing my head against a wall trying to figure this one out.

Basically I have a calendar that outputs Monday through Sunday, and the user clicks on a date and outputs it to the URL.... ie. ?day=$day&month=$month&year=$year.

Now the next part I need to find out what day (0-6) say the 25th Feb 2011 will be wday 5... now how can I do this in code?

And before anyone says why not output it to url, I cannot as the first week and last weeks use different code

Cheers

James

i have this code to set a date to the 1st of the previous month --

SELECT DATE_FORMAT(DATE_SUB(tbl_col, INTERVAL 1 MONTH), '%Y-%m-01') FROM table

can it be changed to set date to first Monday in that month...?

I have a php page where i need to list all item in a particular month.But the format for date stored is MMMM DD,yyyy that January 22, 2011.
How do i extract the month name only from the above format

Hello,

I have a datepicker that when a date is selected, the post to a php file will get the sum values for that selected day, month, and year.

I have the "by day" working with this...


<?php  
$choice = (isset($_POST['choice'])) ? date("Y-m-d",strtotime($_POST['choice'])) : date("Y-m-d"); 
$con = mysql_connect("localhost","root","xxxxxxxxxx");  
if (!$con)  {  
die('Could not connect: ' . mysql_error());  
}  
mysql_select_db("inverters", $con);  
$sql = "SELECT sum(power/1000) AS choice FROM feed WHERE date = '".$choice."' group by date"; 
$res = mysql_query($sql) or die('sql='.$sql."\n".mysql_error()); 
$row = mysql_fetch_assoc($res); 
echo $row['choice'].'<br />';  
?>

But by month and year are not clicking...

Help Please

Alan

Hi,

I've got a date picker on a form which puts data into a database in the YYYY-MM-DD format. Just wondering how I could also put the name of the month (extracted from that) as well as just the year into separate columns. Ie: To use the field race_date from the form to also fill the 'race_month' and 'race_year' columns in the database.

This code obviously only fills the 'race_date' column so far:
Code: [Select]

global $_POST;

$race_date = $_POST["race_date"] ;


....



$query = "INSERT INTO 10k_races (race_date, race_month, race_year)" . "VALUES ( '$race_date', '$race_month',  '$race_year')";

I am using the following code to get the third sunday of every month for +6 Months from todays date.  I have put together the following code which works perfectly when the date is echoed however when it comes to inserting those dates into mysql db it throws a unable to convert to string error.  Im new to this and my head is in a spin as to why those dates can't be inserted if they can echoed ok.  I have spent 2 days at it now and searched many forum however they seem to get side tracked from my issue (or do they)??????? I figure I can't go mixing DateTime and date() the way I have?  Please help???

Code: [Select]
[php]
$month=date('F');
$now=date('Y-m-d');
$year=date('Y');

$num='3'; //example only this will be a $_POST value 0-3
$day='Sunday'; //example only this will be a $_POST value Monday-Sunday

$start= date('Y-m-d', strtotime('+'.$num.' week '.$day.' '.$month.' '.$year.''));

if($start>$now) {
$begin=strtotime('+'.$num.' week '.$day.' '.$month.' '.$year.'');
} else {
$d = new DateTime( $start );
$d->modify( 'first day of next month' );
$nextmonth = $d->format( 'F' );
$year = $d->format( 'Y' );
$begin=strtotime('+'.$num.' week '.$day.' '.$nextmonth.' '.$year.'');
}

$date=date('Y-m-d', $begin);
# insert into db first occurance
//mysql_select_db($database);
//$query_rsFirst = "INSERT INTO event_date VALUES (NULL, '$event', '$d', '$date', '$date')";
//$rsFirst = mysql_query($query_rsFirst) or die(mysql_error());
echo $date.'<br/>';
for($i = 0; $i <= 4; $i++)  {
$d = new DateTime( $date );
$d->modify( 'first day of next month' );
$nextmonth = $d->format( 'F' );
$date=date('Y-m-d', strtotime('+'.$num.' week '.$day.' '.$nextmonth.' '.$year.''));

# insert into db
//mysql_select_db($database);
//$query_rsDate = "INSERT INTO event_date VALUES (NULL, '$event', '$d', '$date', '$date')";
//$rsDate = mysql_query($query_rsDate) or die(mysql_error());
echo $date.'<br/>';
if($nextmonth=="December") {
$d = new DateTime( $date );
$d->modify( 'first day of next year' );
$year = $d->format( 'Y' );
}
}
[/php]

I have set up a function to validate user input date in yyyy-mm-dd format taking into account the following possibilities: the length of the month February 29th when the year is not a leap year When I run the code, I do not get any feedback whatsoever, when it should. This is the code below and I would appreciate your thoughts:

if(!function_exists('checkdate'))
{
	function checkdate($date, $checkyear, $currentmonth)
	{
		if($checkyear == 0)//if it is not a leap year
		{
			// if current month is february
			if($currentmonth == 2)
			{
				if(!preg_match("/^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|1[0-9]|2[0-8])$/", $date))
				{
					// set error for date field
					return ($error = 'Invalid Date!');
				}
				return ($error = 'valid Date!');
			}
			// if current months are april, june, september or november
			elseif($currentmonth == 4 || $currentmonth == 6 || $currentmonth == 9 || $currentmonth ==11)
			{
				if(!preg_match("/^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|1[0-9]|2[0-8]|3[0])$/", $date))
				{
					// set error for date field
					return ($error = 'Invalid Date!');
				}
				return ($error = 'valid Date!');
			}
			else
			{	
				if(!preg_match("/^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|[12][0-8]|3[01])$/", $date))
				{
					// set error for date field
					return ($error = 'Invalid Date!');
				}
				return ($error = 'valid Date!');
			}
		}
		elseif($checkyear == 1)//if it is a leap year
		{
			// if current month is february
			if($currentmonth == 2)
			{
				if(!preg_match("/^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|1[0-9]|2[0-9])$/", $date))
				{
					// set error for date field
					return ($error = 'Invalid Date!');
				}
				return ($error = 'valid Date!');
			}
			// if current months are april, june, september or november
			elseif($currentmonth == 4 || $currentmonth == 6 || $currentmonth == 9 || $currentmonth ==11)
			{
				if(!preg_match("/^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|1[0-9]|2[0-9]|3[0])$/", $date))
				{
					// set error for date field
					return ($error = 'Invalid Date!');
				}
				return ($error = 'valid Date!');
			}
			else
			{	
				if(!preg_match("/^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|[12][0-9]|3[01])$/", $date))
				{
					// set error for date field
					return ($error = 'Invalid Date!');
				}
				return ($error = 'valid Date!');
			}
		
		}
	}
$todate = getdate();
$currentmonth = $todate['mon'];
$checkyear = date('L');
$date = 2014-02-31;
echo checkdate($date, $checkyear, $currentmonth);

Edited by terungwa, 26 July 2014 - 02:43 PM.