PHP - Sorting By Year

Okay I am trying to list out years in a dropdown box. It should show say how many years old. I want to start from 16 though and stop at 100. So the year has to be 1995 for 16 but then I would have to change the code every year. so I was wondering how do I modify this code to do what I explained?
Code: [Select]
<?php
 $start_year = ($start_year) ? $start_year - 1 : date('Y') - 100;
    $end_year = ($end_year) ? $end_year : date('Y');
for ($i = $end_year; $i > $start_year; $i -= 1) {

$date=date(Y);
$age = $i - $date;

        echo '<option value="'.$i.'">'.$age.'</option>';
    }
?>

Thanks in advanced

So I have decided to do research as my project and gain something from this. But also I will have to include programming which i prefer PHP. and will be testing these for my research. Does this sound like a good project and also If it is good sound.. Where do I start?...  need a starting point and then I could go on to doing it..

Gud Pm!
Im trying to display a list of years (last year, current year and next year) with these simple code i made..
It displays the current and next year correctly except last year, which gives me "1970".
I don't get why it gives me that since may next year works properly.. 

Code: [Select]
$currentyear = date('Y');
$subtract_year = strtotime(date('Y', strtotime($currentyear)) . '-1 year');
$lastyear = date('Y', $subtract_year);
$addyear = strtotime(date('Y', strtotime($currentyear)) . '+1 year');
$newyear = date('Y', $addyear);
$year_array = array($lastyear, $currentyear, $newyear);
foreach($year_array as $year)
{
echo "<option value='{$year}'>";
echo $year;
echo "</option>";
}

I'm not familiar with dates yet.. so i'm gonna read the manual while w8ting for your kind replies. 

I'm using this code to get me the variables to a select box on a register page:
$vars['user-birthdate-years'] = array(_VARS_USER_CHOOSE_ => "Please choose", _VARS_USER_NONE_ => _VARS_USER_UNDEF_); for ($i = date('Y') - 18; $i > date('Y') - 75; --$i) { $vars['user-birthdate-years'][$i] = "$i"; }

This gives me this result in the page source:
<select name="birthyear" class="date"><option value="-2" selected="selected">Please choose</option><option value="1997">1997</option><option value="1996">1996</option><option value="1995">1995</option><option value="1994">1994</option><option value="1993">1993</option><option value="1992">1992</option><option value="1991">1991</option><option value="1990">1990</option><option value="1989">1989</option><option value="1988">1988</option><option value="1987">1987</option><option value="1986">1986</option><option value="1985">1985</option><option value="1982">1982</option><option value="1981">1981</option><option value="1980">1980</option><option value="1979">1979</option><option value="1978">1978</option><option value="1977">1977</option><option value="1976">1976</option><option value="1975">1975</option><option value="1974">1974</option><option value="1973">1973</option><option value="1972">1972</option><option value="1971">1971</option><option value="1970">1970</option><option value="1969">1969</option><option value="1968">1968</option><option value="1967">1967</option><option value="1966">1966</option><option value="1965">1965</option><option value="1964">1964</option><option value="1963">1963</option><option value="1962">1962</option><option value="1961">1961</option><option value="1960">1960</option><option value="1959">1959</option><option value="1958">1958</option><option value="1957">1957</option><option value="1956">1956</option><option value="1955">1955</option><option value="1954">1954</option><option value="1953">1953</option><option value="1952">1952</option><option value="1951">1951</option><option value="1950">1950</option><option value="1949">1949</option><option value="1948">1948</option><option value="1947">1947</option><option value="1946">1946</option><option value="1945">1945</option><option value="1944">1944</option><option value="1943">1943</option><option value="1942">1942</option><option value="1941">1941</option></select>

Problem: When running the php code at the top it miss two years in the span as you see in the page source below, the year 1983 and 1984 is completely missing in the page source. Why is this happening, could the php code be corrected or is there a workaround in php for the missing years bug I seem to have found?

I really appreciate any help on this!
Edited by Drezzzer, 12 January 2015 - 05:16 AM.

I have a given date on a webpage, that I'm scraping to insert into a DB.  The date is in this format:

Sun, Feb 9<br />3:00 PM ET

I need to insert this into the DB in this format:  2020-02-09 15:00:00

It will always be this year...How can I change this data to be inserted correctly?

I'm trying this...and it's inserting as 1969

	$date = 'Sun, Feb 9<br />3:00 PM ET':
$healthy = array("<br />", " ET", "Sun.", "Mon.", "Tue.", "Wed.", "Thu", "Fri.", "Sat.", "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec");
$yummy   = array("  ", "2020", "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
	$date = str_replace($healthy, $yummy, $date1);
	$start = date('Y-m-d H:i:s', strtotime("$date -120 minutes"));
	

Thanks!

Hello there,

I stuck in a silly logic ... I will really appreciate if someone helps me...

My Fiscal year starts from 01st April of current year through 31st March of next year, for ex. (01 Apr 2011 to 31st March 2012). I want to put a latefee of 6.25% on total amount, if the payment date is not done on the current fiscal year. Everything depends on the payment date.

For example,

A bill of $8000 was generated on 01st Apr. 2009 then its 6.25% will be $500 and the customer is paying the same on 30th August 2011, then total years passed is 3. So, the late fee will be 500 * 2 = $1000.

i.e. Any bill generated and paid in the current fiscal year (stated above) is free of late fee and after that the above calculation is applicable.

Please help, how to do the calculation. A function is really appreciated.

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!

I've got a class schedule that spans two years and I would like to have the years as headers. startDate is unix date field.

Here is existing code:

$sql = "SELECT *
        FROM classOfferings, classes, instructors   
   WHERE classes.classId = classOfferings.classId
   AND classOfferings.instructorId = instructors.instructorId
   AND classOfferings.startDate >= CURDATE()
   
   ORDER BY classOfferings.startDate";
   

if(! $retval )
{
  die('Could not get schedule: ' . mysql_error());
}
while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
{
   echo "{$row['dates']}";
   if ($row['hours'] != 0){
           echo "</td> ";
      }
   else {
      echo "CANCELLED</td>";
      }
   echo "<td class='cell2'>".
      "<a href='classDetail.php?seq={$row['seq']}'>{$row['title']}</a>".
      "{$row['days']}".
            "{$row['times']}".
            "<a href='instructorDetail.php?instructorId={$row['instructorId']}'>{$row['fName']} "." ".
    "{$row['lName']}</a></td>}
     echo "</td></tr></table></div>";
}

right now i have my date system to say "X amount of seconds ago, X hours ago, X days ago, X years ago, How could i turn mktime()   (1290874161)
into a mm/dd/yyyy format? so it would say like, "Nov 27, 2010 at Hour:Minute"  (whatever the hour/minute is)

I must admit that dates and timestamps really confuse me!

I have a query that gets a field named "date_purchased" and returns it like this "2010-09-05 09:58:12"

What I need to do is add one year to the date, and display it like this "September 5, 2011"

Basically, it's displaying the end date of a one year subscription.

The database captures the purchase date with the order, so I want to grab that, add a year, and display it to the customer.

Any help would be most appreciated!

Start with: Saturday August 13 1978.  What is the next year that August 13th falls on a Saturday?

Couldn't find an answer to that anywhere!

I have PHP code that generates a long list of Birth Years in a Drop-down list, and I want to make the control "sticky".

I know how to make something like this sticky - thanks to help from you guys...
Code: [Select]
<!-- Gender -->
<label for="gender">Gender:</label>
<select id="gender" name="gender">
<option value="">--</option>
<option value="F"<?php echo (isset($gender) && $gender == "F") ? 'selected="selected"' : ''; ?>>Female</option>
<option value="M"<?php echo (isset($gender) && $gender == "M") ? 'selected="selected"' : ''; ?>>Male</option>
</select>


But my Birth Year code is a little more complex and I'm racking me brain how to do it...
Code: [Select]
<!-- Birth Year -->
<label for="birthYear">Year Born:</label>
<select id="birthYear" name="birthYear">
<option value="">--</option>
<?php
// Display dates for Users between 18 and 100.
for($i = $newestYear; $i >= $oldestYear; $i--){
echo '<option value="' . $i . '">' . $i . '</option>';
}
?>
</select>

How do I make this second set of code "sticky"??   

Thanks,


Debbie

Hello, not sure if lack of sleep or just staring at code too long.

This is what I have:

Code: [Select]
while($rowy = mysql_fetch_array( $resulty )) {
mpdate = YYYY-MM-DD
$date = $rowy['mpdate'];

$year = explode('-', $date);
$month = date("F", mktime(0, 0, 0, $year[1]));
?>

<?php echo $year[0]; ?>
<br>
<?php echo $month; ?>
<br>
<?php echo $rowy['mptitle']; 
}
?>

I figure if I use:

if ($year[0] == date('Y"){

echo month and entry stuff

}
 but I keep getting errors.

What I am trying to do is sort everything out into year month and day

ie:

2012
March
Entry 1
Entry 2
February
Entry 1
Entry 2
Entry 3
etc...

This is what I am getting

2012
March
Entry 1
2012
March
Entry 2
2012
February
Entry 1
etc...

Is there a way to fix this?

Hi everybody,   So I used to be a pretty decent PHP developer, but I haven't done much with programming for the last 8 years. I switched to the healthcare industry after the big dot-com boom and I'm finishing up a doctorate in nursing this spring. I decided to try and get back into programming to pursue some online teaching projects I want to take on and wow, have I forgotten a lot!   I've got a WordPress site up and I've manged to teach myself some decent animation skills in Flash and After Effects. Now I'm looking to try and build a set of database tables to house medication calculation equations, answers, and some metadata. I've been looking around to try and find some WordPress addons that will let me edit database tables, but everything I've been able to find turns out to be a table editor in the "Microsoft Word" sense of the word, and not actually usable to manage database tables. Is there anything out there that could save me a big chunk of time?   Looking forward to some development after a long break though. I don't plan on working through a shell, so I'm going to be using a text editor on a PC. Any suggestions for making the writing and syncing easily that might make my life easier?   Thanks,   -Bart
Edited by NerdDoc, 09 September 2014 - 07:21 PM.

Hey everyone!!!

It has been years since I have had to opportunity to post on here. I am, however, getting back into development. I am running into an issue and I was looking for some help. 


Here is the code:

$years = array(); //Build the years array, we can only go forward 3 years, backwards 1 year.
$sYear = date(Y, strtotime('-1 years')); //Start Year
$eYear = date(Y, strtotime('+3 years')); //End Year
while($sYear < $eYear){
    array_push($years, $sYear); //Add each year that fits to the array
    $sYear++;
}

//In order for us to make sure we have clean parameters for our jQuery calls later
//We have to make sure that our year variable usage is consistant throughout. 
//If our case, we are passing the full 4 digit year as am INT = $curYear
$curYear = clean($_GET['curYear']);
print "Before anything: curYear = $curYear <br><br><br>";
if($curYear == "" || $curYear == null){
    //No Year set, use current
    print "empty or null<br>";
    exit;
    $curYear = date(Y);
}elseif(!is_numeric($curYear)){
    //Not even a number lol
    print "not number<br>";
    $curYear = date(Y);
}elseif($aSearch = in_array($curYear, $years, true)){
    print "valid year<br>" . $years[$aSearch];
    //It isn't in our array of valid years
    //$curYear = date(Y);
}else{
    //all else failed
    $curYear = date(Y);
    print "Failed all tests.<br>";
}
//Should be a good year for our calendar by this point.
exit;

I am passing the variable curYear in the url: index.php?curMonth=July&curYear=2013

For some reason, it outputs: 

Before anything: curYear = 2013 


Failed all tests.

  printing the $years array gets: 
 

Array ( [0] => 2013 [1] => 2014 [2] => 2015 [3] => 2016 )

I think you get the just of what I am looking for here. Thanks for the help!!