How do I find a date using php in a MySQL database?
December 20, 2011 | 1 Comment
What I want to do is find the next occurrence of the next Tuesday listed. There may be many dates before today and several dates after the next tuesday listed. Let’s say today is 12/17/11 and the next date listed is 1/3/12, which is 3 tuesday’s from now so I can’t do a strtotime(‘next tuesday’).
This will get you started to get a list of the next 10 Tuesdays to then compare to your list.
One you get your "array of Tuesdays" you can then loop over your list of dates, checking if they are in the array, if you find a match, break out of the loop.
$today = date("D"); // returns Sun Mon Tue…..
echo ‘<p>Today ‘. $today;
//Based on todays date, figure out how many days you need to add to make the next tuesdays
//ie if today = Sun, then you need to add 2 to get to tuesday
$addToValue = 2;
$nextTues = date(‘m-d-Y’,mktime(0, 0, 0, date("m"),date("d") + 2, date("Y")));
echo ‘<p>The Next Tues ‘.$nextTues;
//Then create an array of the next x number of tuesdays you need
$tuesArr = array(); // first tues
$dateAdd=0;
for ($i=0; $i<=70; $i+= 7){
$dateAdd = $dateAdd+ $add; // add week to this coming tues
$nextT = mktime(0, 0, 0, date("m"),date("d") +$i + $addToValue, date("Y"));
// add to array
$tuesArr[] = date(‘m-d-Y’,$nextT);
}
//output list of tuesdays to see
echo ‘<pre>’;
echo ‘Array of Next 10 Tuesdays
‘;
print_r($tuesArr);
echo ‘</pre>’;
// next step YOU will need to compare your list to the array to find a match….
You can see the output here:
http://www.freelancewebprogrammer.com/dev/tuescheck.php
If you like this post, be sure to subscribe to my RSS feed!How do I find out the passport appointment date once I submitted the passport online application?
December 13, 2011 | 1 Comment
I have submitted the online application for passport reissue at http://passport.gov.in/pms/OnlineRegistration.jsp. It had asked me to choose a date and time for appointment which I do not remember now. The date and time isn’t printed on the passport application form that . How do I find the date of appointment?
submit another time
how do i find date of parents marraige?
December 2, 2011 | 3 Comments
I have narrowed it down to within 3 months via ancestry website but can i find exact date with out purchasing a certificate
Ask them.
How would I find an older man to date.?
September 9, 2011 | 3 Comments
I’m 20 and I really want to date an older man 40+ with gray hair or just older. I’m not sure why i guess father issues maybe but i just find older men attractive and I want to date an older man to get it out of my system. But how should i go about finding an older man to date?
Have you tried a retirement home or an AA RP meeting? I am jk. It should be pretty easy to find one being as you are very young and there are many old creeps out there who like them young. Perhaps online dating sites.
On a dirt bike, where do you find the month and date of manufacture?
September 2, 2011 | 1 Comment
I have a Kawasaki KLX 110 dirt bike and I am trying to find the date of manufacture on it. I also need to find the sticker that states it is in compliance with US safety regulations. Where do you find these on the bike?
call your local kawasaki dealer and give them the serial number they will be able to tell you what you need to know. the bike is in compliance with all US safety regs or it would not have been sold here.
