We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

php coding question

glenn_1984
glenn_1984 asked
on
Medium Priority
500 Views
Last Modified: 2012-05-07
I have some php code (see attached)

If the user entered the DATE as 07/12/2009
how do I automatically update
Month  to July
Day to 12
Year to 2009
day of week to Sunday
// Add record
	function AddRow() {
		global $conn, $Security, $ride_calendar;
		$rsnew = array();
 
		// Field date
		$ride_calendar->date->SetDbValueDef($ride_calendar->date->CurrentValue, ew_CurrentDate());
		$rsnew['date'] =& $ride_calendar->date->DbValue;
 
		// Field Month
		$ride_calendar->Month->SetDbValueDef($ride_calendar->Month->CurrentValue, "");
	    $rsnew['Month'] =& $ride_calendar->Month->DbValue;
 
		// Field day
		$ride_calendar->day->SetDbValueDef($ride_calendar->day->CurrentValue, "");
		$rsnew['day'] =& $ride_calendar->day->DbValue;
 
		// Field year
		$ride_calendar->year->SetDbValueDef($ride_calendar->year->CurrentValue, "");
		$rsnew['year'] =& $ride_calendar->year->DbValue;
 
		// Field day_of_week
		$ride_calendar->day_of_week->SetDbValueDef($ride_calendar->day_of_week->CurrentValue, "");
		$rsnew['day_of_week'] =& $ride_calendar->day_of_week->DbValue;

Open in new window

Comment
Watch Question

Most Valuable Expert 2011
Author of the Year 2014

Commented:
USE PHP functions strtotime() and date() to perform date conversions and arithmetic.
Most Valuable Expert 2011
Author of the Year 2014

Commented:
You can test these on my web site here:
http://www.laprbass.com/RAY_strtotime.php

Just type in the date you want to test
Most Valuable Expert 2011
Author of the Year 2014

Commented:
Most Valuable Expert 2011
Author of the Year 2014

Commented:
Hope this helps you format the values correctly.  Best regards, ~Ray
<?php // RAY_temp_date.php
error_reporting(E_ALL);
 
// TEST DATA FROM THE OP
$dt = '07/12/2009';
 
// CONVERT TO TIMESTAMP
if (!$ts = strtotime($dt)) die("$dt IS NOT A VALID DATE STRING");
 
// SHOW THE DATE FORMAT INFORMATION
echo date("F", $ts);
echo date("j", $ts);
echo date("Y", $ts);
echo date("l", $ts);

Open in new window

Commented:
Here an example
<?php
$mdate = "04/05/06";
 
echo date("F, j, Y", strtotime ($mdate));
?>

Open in new window

Author

Commented:
Thanks for the help...however, I am not really a php programmer and working with existing code.
In my sample above, I need to convert the data for date_text to the strtotime().

I removed the Month, Day, etc field and created a date_text field.

I have been playing with syntax for an hour or so, with no luck.

Here is my current code snippet:

// Add record
      function AddRow() {
            global $conn, $Security, $ride_calendar;
            $rsnew = array();

            // Field date
            $ride_calendar->date->SetDbValueDef($ride_calendar->date->CurrentValue,  ew_CurrentDate());
            $rsnew['date'] =& $ride_calendar->date->DbValue;

            // Field date_text
            $ride_calendar->date_text->SetDbValueDef($ride_calendar->date_text->CurrentValue, "");
            $rsnew['date_text'] =& $ride_calendar->date_text->DbValue;

How do I get the date_text field to automatically fill as the strtotime() ?

Can you help?
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Thanks, that is the correct track.
Syntax works.
However July 12 came out as July 8 (today).
I need to play with it to grab the data from the field date.

Author

Commented:
I will post back when done.

Author

Commented:
Got it. Just had to change date_text to date at the end fo the line.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.