simple events calendar using mysql

Hello all, this may sound very elementary and i am sorry for that. I
am struggling with a very simple calendar for my web site. I already
have the database set up and the admin to input events and i have a
way to display the calendar. the problem i am having is querying and
linking my events from the database to the calendar. I have looked at
all the stock calendars out there and what they offer i do not need. i
have gone through what seems to be every tutorial for calendars but
none of which teach how to query and create the links. here is the
code to display the calendar:

$date =time () ;

$day = date('d', $date) ;
$month = date('m', $date) ;
$year = date('Y', $date) ;

$first_day = mktime(0,0,0,$month, 1, $year) ;

$title = date('F', $first_day) ;

$day_of_week = date('D', $first_day) ;

switch($day_of_week){
case "Sun": $blank = 0; break;
case "Mon": $blank = 1; break;
case "Tue": $blank = 2; break;
case "Wed": $blank = 3; break;
case "Thu": $blank = 4; break;
case "Fri": $blank = 5; break;
case "Sat": $blank = 6; break;
}

$days_in_month = cal_days_in_month(0, $month, $year) ;

echo "

Re: simple events calendar using mysql

"jsd219" wrote in message
news:1193798764.191193.112080@57g2000hsv.googlegroups.com...
> Hello all, this may sound very elementary and i am sorry for that. I
> am struggling with a very simple calendar for my web site. I already
> have the database set up and the admin to input events and i have a
> way to display the calendar. the problem i am having is querying and
> linking my events from the database to the calendar. I have looked at
> all the stock calendars out there and what they offer i do not need. i
> have gone through what seems to be every tutorial for calendars but
> none of which teach how to query and create the links. here is the
> code to display the calendar:
>
> $date =time () ;
>
> $day = date('d', $date) ;
> $month = date('m', $date) ;
> $year = date('Y', $date) ;
>
> $first_day = mktime(0,0,0,$month, 1, $year) ;
>
> $title = date('F', $first_day) ;
>
> $day_of_week = date('D', $first_day) ;
>
> switch($day_of_week){
> case "Sun": $blank = 0; break;
> case "Mon": $blank = 1; break;
> case "Tue": $blank = 2; break;
> case "Wed": $blank = 3; break;
> case "Thu": $blank = 4; break;
> case "Fri": $blank = 5; break;
> case "Sat": $blank = 6; break;
> }
>
> $days_in_month = cal_days_in_month(0, $month, $year) ;
>
> echo "

Re: simple events calendar using mysql

On Oct 31, 6:33 am, "Shelly" wrote:
> "jsd219" wrote in message
>
> news:1193798764.191193.112080@57g2000hsv.googlegroups.com...
>
>
>
> > Hello all, this may sound very elementary and i am sorry for that. I
> > am struggling with a very simple calendar for my web site. I already
> > have the database set up and the admin to input events and i have a
> > way to display the calendar. the problem i am having is querying and
> > linking my events from the database to the calendar. I have looked at
> > all the stock calendars out there and what they offer i do not need. i
> > have gone through what seems to be every tutorial for calendars but
> > none of which teach how to query and create the links. here is the
> > code to display the calendar:
>
> > $date =time () ;
>
> > $day = date('d', $date) ;
> > $month = date('m', $date) ;
> > $year = date('Y', $date) ;
>
> > $first_day = mktime(0,0,0,$month, 1, $year) ;
>
> > $title = date('F', $first_day) ;
>
> > $day_of_week = date('D', $first_day) ;
>
> > switch($day_of_week){
> > case "Sun": $blank = 0; break;
> > case "Mon": $blank = 1; break;
> > case "Tue": $blank = 2; break;
> > case "Wed": $blank = 3; break;
> > case "Thu": $blank = 4; break;
> > case "Fri": $blank = 5; break;
> > case "Sat": $blank = 6; break;
> > }
>
> > $days_in_month = cal_days_in_month(0, $month, $year) ;
>
> > echo "

Re: simple events calendar using mysql

jsd219 wrote:
> On Oct 31, 6:33 am, "Shelly" wrote:
>> "jsd219" wrote in message
>>
>> news:1193798764.191193.112080@57g2000hsv.googlegroups.com...
>>
>>
>>
>>> Hello all, this may sound very elementary and i am sorry for that. I
>>> am struggling with a very simple calendar for my web site. I already
>>> have the database set up and the admin to input events and i have a
>>> way to display the calendar. the problem i am having is querying and
>>> linking my events from the database to the calendar. I have looked
>>> at all the stock calendars out there and what they offer i do not
>>> need. i have gone through what seems to be every tutorial for
>>> calendars but none of which teach how to query and create the
>>> links. here is the code to display the calendar:
>>
>>> $date =time () ;
>>
>>> $day = date('d', $date) ;
>>> $month = date('m', $date) ;
>>> $year = date('Y', $date) ;
>>
>>> $first_day = mktime(0,0,0,$month, 1, $year) ;
>>
>>> $title = date('F', $first_day) ;
>>
>>> $day_of_week = date('D', $first_day) ;
>>
>>> switch($day_of_week){
>>> case "Sun": $blank = 0; break;
>>> case "Mon": $blank = 1; break;
>>> case "Tue": $blank = 2; break;
>>> case "Wed": $blank = 3; break;
>>> case "Thu": $blank = 4; break;
>>> case "Fri": $blank = 5; break;
>>> case "Sat": $blank = 6; break;
>>> }
>>
>>> $days_in_month = cal_days_in_month(0, $month, $year) ;
>>
>>> echo "

Re: simple events calendar using mysql

On Oct 31, 10:57 am, "Shelly" wrote:
> jsd219 wrote:
> > On Oct 31, 6:33 am, "Shelly" wrote:
> >> "jsd219" wrote in message
>
> >>news:1193798764.191193.112080@57g2000hsv.googlegroups.com. ..
>
> >>> Hello all, this may sound very elementary and i am sorry for that. I
> >>> am struggling with a very simple calendar for my web site. I already
> >>> have the database set up and the admin to input events and i have a
> >>> way to display the calendar. the problem i am having is querying and
> >>> linking my events from the database to the calendar. I have looked
> >>> at all the stock calendars out there and what they offer i do not
> >>> need. i have gone through what seems to be every tutorial for
> >>> calendars but none of which teach how to query and create the
> >>> links. here is the code to display the calendar:
>
> >>> $date =time () ;
>
> >>> $day = date('d', $date) ;
> >>> $month = date('m', $date) ;
> >>> $year = date('Y', $date) ;
>
> >>> $first_day = mktime(0,0,0,$month, 1, $year) ;
>
> >>> $title = date('F', $first_day) ;
>
> >>> $day_of_week = date('D', $first_day) ;
>
> >>> switch($day_of_week){
> >>> case "Sun": $blank = 0; break;
> >>> case "Mon": $blank = 1; break;
> >>> case "Tue": $blank = 2; break;
> >>> case "Wed": $blank = 3; break;
> >>> case "Thu": $blank = 4; break;
> >>> case "Fri": $blank = 5; break;
> >>> case "Sat": $blank = 6; break;
> >>> }
>
> >>> $days_in_month = cal_days_in_month(0, $month, $year) ;
>
> >>> echo "

Re: simple events calendar using mysql

On Oct 31, 10:57 am, "Shelly" wrote:
> jsd219 wrote:
> > On Oct 31, 6:33 am, "Shelly" wrote:
> >> "jsd219" wrote in message
>
> >>news:1193798764.191193.112080@57g2000hsv.googlegroups.com. ..
>
> >>> Hello all, this may sound very elementary and i am sorry for that. I
> >>> am struggling with a very simple calendar for my web site. I already
> >>> have the database set up and the admin to input events and i have a
> >>> way to display the calendar. the problem i am having is querying and
> >>> linking my events from the database to the calendar. I have looked
> >>> at all the stock calendars out there and what they offer i do not
> >>> need. i have gone through what seems to be every tutorial for
> >>> calendars but none of which teach how to query and create the
> >>> links. here is the code to display the calendar:
>
> >>> $date =time () ;
>
> >>> $day = date('d', $date) ;
> >>> $month = date('m', $date) ;
> >>> $year = date('Y', $date) ;
>
> >>> $first_day = mktime(0,0,0,$month, 1, $year) ;
>
> >>> $title = date('F', $first_day) ;
>
> >>> $day_of_week = date('D', $first_day) ;
>
> >>> switch($day_of_week){
> >>> case "Sun": $blank = 0; break;
> >>> case "Mon": $blank = 1; break;
> >>> case "Tue": $blank = 2; break;
> >>> case "Wed": $blank = 3; break;
> >>> case "Thu": $blank = 4; break;
> >>> case "Fri": $blank = 5; break;
> >>> case "Sat": $blank = 6; break;
> >>> }
>
> >>> $days_in_month = cal_days_in_month(0, $month, $year) ;
>
> >>> echo "

Re: simple events calendar using mysql

jsd219 wrote:
> My appologies, i know how to do the query but i do not know how to
> tell the code to display the title and a link to a trip that matches
> the date. in other words where in the code below do i say ok, now that
> the calendar is displayed, if 10/31/2007 has a trip in the database

You don't! What I mean by that it is not "now that the calendar is
displayed,". You have to put it in AS you are building your display!

In other words, when you do your query, have it ordered by date (ORDER BY
the_date_field). Then build an array with all those rows. Now, as you are
going about building the display of your calendar, check the date against
the next one in the array. If it matches, then do an

echo 'value="' . $whatever_info_you_want_to_appear_here . '"'; (that last
was single-double-single quotes).

and increment your position in the array so that the next time you check the
date it will be the next one in the array. (Of course, stop all this
checking once you have done all the elements in the array so that you are
not going to get an out-of-bounds problem).

Do you understand now?

Shelly

Re: simple events calendar using mysql

On Oct 31, 12:10 pm, "Shelly" wrote:
> jsd219 wrote:
> > My appologies, i know how to do the query but i do not know how to
> > tell the code to display the title and a link to a trip that matches
> > the date. in other words where in the code below do i say ok, now that
> > the calendar is displayed, if 10/31/2007 has a trip in the database
>
> You don't! What I mean by that it is not "now that the calendar is
> displayed,". You have to put it in AS you are building your display!
>
> In other words, when you do your query, have it ordered by date (ORDER BY
> the_date_field). Then build an array with all those rows. Now, as you are
> going about building the display of your calendar, check the date against
> the next one in the array. If it matches, then do an
>
> echo 'value="' . $whatever_info_you_want_to_appear_here . '"'; (that last
> was single-double-single quotes).
>
> and increment your position in the array so that the next time you check the
> date it will be the next one in the array. (Of course, stop all this
> checking once you have done all the elements in the array so that you are
> not going to get an out-of-bounds problem).
>
> Do you understand now?
>
> Shelly

Please forgive my ignorance but i can not wrap my head around this. is
what you are saying; query everything from the table and order it by
date? i don't understand the . $id part.

God bless
jason

Re: simple events calendar using mysql

jsd219 wrote:
> On Oct 31, 12:10 pm, "Shelly" wrote:
>> jsd219 wrote:
>>> My appologies, i know how to do the query but i do not know how to
>>> tell the code to display the title and a link to a trip that matches
>>> the date. in other words where in the code below do i say ok, now
>>> that the calendar is displayed, if 10/31/2007 has a trip in the
>>> database
>>
>> You don't! What I mean by that it is not "now that the calendar is
>> displayed,". You have to put it in AS you are building your display!
>>
>> In other words, when you do your query, have it ordered by date
>> (ORDER BY the_date_field). Then build an array with all those rows.
>> Now, as you are going about building the display of your calendar,
>> check the date against the next one in the array. If it matches,
>> then do an
>>
>> echo 'value="' . $whatever_info_you_want_to_appear_here . '"';
>> (that last was single-double-single quotes).
>>
>> and increment your position in the array so that the next time you
>> check the date it will be the next one in the array. (Of course,
>> stop all this checking once you have done all the elements in the
>> array so that you are not going to get an out-of-bounds problem).
>>
>> Do you understand now?
>>
>> Shelly
>
> Please forgive my ignorance but i can not wrap my head around this. is
> what you are saying; query everything from the table and order it by
> date? i don't understand the . $id part.

Yes, that is exactly what I am saying. SQL will do that work for you and
all you need do is add the ORDER BY clause. Since you cut where I said
something about $id, I cannot help you other that to guess at what I said.
I guess it was in building a query statement and I had a where clause of
some field = something. Since the something would depend upon the value of
a variable, I put that in. The dot operator is the append operator in PHP.
Example:

$foo = "jsd";
echo "Hello " . $foo;

will output
Hello jsd

I suggest you do a little reading of the manual (www.php.net) or a tutorial
www.w3schools.com for PHP and SQL.

Shelly