Can I display a month from a number in a csv file?

**Geoff Berrow** · Jul 17 '05, 12:49 AM

Re: Can I display a month from a number in a csv file?

I noticed that Message-ID: <7eUnb.43950$9E 1.180122@attbi_ s52> from The
Biscuit Eater contained the following:
[color=blue]
>Greetings from a second day newbie to php.
>
>I think I have figured out a way to explode a field in a csv file (like
>11-08-03) and implode it as 031108 and then compare it to the current
>date(ymd) to display data after the current date. What I would like to now
>do is use the 11 and display Nov. Can anybody help or point me in the right
>direction?[/color]

Any particular reason why you're not using a database for this?

--
Geoff Berrow
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

**Pedro** · Jul 17 '05, 12:49 AM

Re: Can I display a month from a number in a csv file?

The Biscuit Eater wrote:[color=blue]
> Greetings from a second day newbie to php.
>
> I think I have figured out a way to explode a field in a csv file (like
> 11-08-03) and implode it as 031108 and then compare it to the current
> date(ymd) to display data after the current date. What I would like to now
> do is use the 11 and display Nov. Can anybody help or point me in the right
> direction?[/color]

My first idea (probably not the best) was:

make an array and select from that:

<?php
$months = array('Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun',
'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec');

// do whatever you need, including
$month = 11;

// and, after being real sure 1 <= $month <= 12
echo $months[$month-1];
?>

--
I have a spam filter working.
To mail me include "urkxvq" (with or without the quotes)
in the subject line, or your mail will be ruthlessly discarded.

**The Biscuit Eater** · Jul 17 '05, 12:50 AM

Re: Can I display a month from a number in a csv file? - got it

"Pedro" <hexkid@hotpop. com> wrote in message
news:bnpg0p$148 ntn$1@ID-203069.news.uni-berlin.de...
[color=blue]
> My first idea (probably not the best) was:
>
> make an array and select from that:
>
> <?php
> $months = array('Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun',
> 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec');
>
> // do whatever you need, including
> $month = 11;
>
> // and, after being real sure 1 <= $month <= 12
> echo $months[$month-1];
> ?>
>[/color]

Thanks, that was where I was heading when, while driving home this evening,
I came up with something that apparently works just fine. I can now pull the
next event or all events from a csv file using the following:

<?

$readfile = file("events.tx t");

for ($k=0; $k<=count($read file)-1; $k++) {
$field = split(";",$read file[$k]);

$date = date("Ymd");

$piece = explode("-", $field[0]);
$array = array($piece[2], $piece[0], $piece[1]);
$c = implode("", $array);
$d = date("jS",mktim e(0,0,0,$piece[0],$piece[1],$piece[2]));
$m = date("M",mktime (0,0,0,$piece[0],$piece[1],$piece[2]));

if ($c >= $date) {

print ("<a class=\"noUL\" href=\"javascri pt:void(0);\"
onclick=\"windo w.open('events/$field[0].htm', 'NextEvent', 'scrollbars=yes ,
resizable=yes, height=600, width=650')\">$ m $d - $field[1]</A>");

exit;
}
}

?>

The csv is setup like:

11-06-2003;Beat the Pro;Individual play;tee choice;8:30 AM Shotgun
01-10-2004;Twister;(S cramble-Stableford);Fou r man teams (white tees)

**Alan Little** · Jul 17 '05, 12:50 AM

Re: Can I display a month from a number in a csv file? - got it

Carved in mystic runes upon the very living rock, the last words of The
Biscuit Eater of comp.lang.php make plain:
[color=blue]
>
> "Pedro" <hexkid@hotpop. com> wrote in message
> news:bnpg0p$148 ntn$1@ID-203069.news.uni-berlin.de...
>[color=green]
>> My first idea (probably not the best) was:
>>
>> make an array and select from that:
>>
>> <?php
>> $months = array('Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun',
>> 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec');
>>
>> // do whatever you need, including
>> $month = 11;
>>
>> // and, after being real sure 1 <= $month <= 12
>> echo $months[$month-1];
>> ?>
>>[/color]
>
> Thanks, that was where I was heading when, while driving home this
> evening, I came up with something that apparently works just fine. I
> can now pull the next event or all events from a csv file using the
> following:[/color]

Great googly-moogly! Now that's newbie code if I ever saw it! :)

$thefile = file("events.tx t");
while (list(,$record) = each($thefile)) {
$fields = split(";", $record);
$stamp = strtotime("$fie ld[0] 00:00:00");
if $stamp > time() {
[do stuff]
}
}

And you can use the date() function on $stamp to get whatever formatted
date info you want. strtotime() is your friend.

--
Alan Little
Phorm PHP Form Processor

http://www.phorm.com/

**The Biscuit Eater** · Jul 17 '05, 01:01 AM

Re: Can I display a month from a number in a csv file? - THANKS!

I want to thank Alan and Jon for sending me in the right direction. With the
following I can pull the next golf tournament from a csv file and display a
link to a popup for more information - and in addition, display the days
until and sign up deadline. Thanks again for your help.

Seems to work nicely... http://www.mgagcai.org/

<?
$thefile = file("events.cs v");
while (list(,$record) = each($thefile)) {
$field = split(";", $record);
$stamp = strtotime("$fie ld[0]");
if (ceil(($stamp - time())/86400) >= 0) {
echo "<a href=\"javascri pt:void(0);\" onclick=\"windo w.open('/"
,date("Ymd", strtotime ($field[0])), ".html', 'NextEvent', 'scrollbars=yes ,
resizable=yes, height=600, width=650')\">" , date("M jS", strtotime
($field[0])), " - $field[1]</A><br />";
echo "<span class=\"sans\"> ";
if (ceil(($stamp - time())/86400) > 7) {
echo ceil(($stamp - time())/86400), " days away";
} else if (ceil(($stamp - time())/86400) >= 4) {
echo "Only ", ceil(($stamp - time())/86400), " days away. Sign up by
Wednesday evening.";
} else if (ceil(($stamp - time())/86400) == 3) {
echo "Only ", ceil(($stamp - time())/86400), " days away. Sign up by
this evening.";
} else if (ceil(($stamp - time())/86400) == 2) {
echo "Only ", ceil(($stamp - time())/86400), " days away. Too late to
sign up.";
} else if (ceil(($stamp - time())/86400) == 1) {
echo "Only ", ceil(($stamp - time())/86400), " day away. Too late to
sign up.";
} else {
echo "Event is today";
}
echo "</span>";
exit;
}
}
?>

---
Bill "Chessie" Hayes

http://www.billhayes.us

ICQ#: 9635690

Bakers trade bread recipes on a knead to know basis.

"Alan Little" <alan@n-o-s-p-a-m-phorm.com> wrote in message
news:Xns9424578 92662Dalanphorm com@216.196.97. 132...[color=blue]
> Carved in mystic runes upon the very living rock, the last words of The
> Biscuit Eater of comp.lang.php make plain:
>[color=green]
> >
> > "Pedro" <hexkid@hotpop. com> wrote in message
> > news:bnpg0p$148 ntn$1@ID-203069.news.uni-berlin.de...
> >[color=darkred]
> >> My first idea (probably not the best) was:
> >>
> >> make an array and select from that:
> >>
> >> <?php
> >> $months = array('Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun',
> >> 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec');
> >>
> >> // do whatever you need, including
> >> $month = 11;
> >>
> >> // and, after being real sure 1 <= $month <= 12
> >> echo $months[$month-1];
> >> ?>
> >>[/color]
> >
> > Thanks, that was where I was heading when, while driving home this
> > evening, I came up with something that apparently works just fine. I
> > can now pull the next event or all events from a csv file using the
> > following:[/color]
>
> Great googly-moogly! Now that's newbie code if I ever saw it! :)
>
> $thefile = file("events.tx t");
> while (list(,$record) = each($thefile)) {
> $fields = split(";", $record);
> $stamp = strtotime("$fie ld[0] 00:00:00");
> if $stamp > time() {
> [do stuff]
> }
> }
>
> And you can use the date() function on $stamp to get whatever formatted
> date info you want. strtotime() is your friend.
>
> --
> Alan Little
> Phorm PHP Form Processor
> http://www.phorm.com/[/color]

Can I display a month from a number in a csv file?

Can I display a month from a number in a csv file?

Comment

Comment

Comment

Comment

Comment