|
|
Posted by jsd219 on 10/31/07 14:40
On Oct 31, 6:33 am, "Shelly" <sheldonlg.n...@asap-consult.com> wrote:
> "jsd219" <i...@musiclanerecording.com> 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 "<table border=1 width=294>";
> > echo "<tr><th colspan=7> $title $year </th></tr>";
> > echo "<tr><td class=month width=42>Sun</td><td class=month
> > width=42>Mon</td><td class=month width=42>Tue</td><td class=month
> > width=42>Wed</td><td class=month width=42>Thu</td><td class=month
> > width=42>Fri</td><td class=month width=42>Sat</td></tr>";
>
> > $day_count = 1;
>
> > echo "<tr>";
>
> > while ( $blank > 0 )
> > {
> > echo "<td></td>";
> > $blank = $blank-1;
> > $day_count++;
> > }
>
> > $day_num = 1;
>
> > while ( $day_num <= $days_in_month )
> > {
> > echo "<td> $day_num </td>";
> > $day_num++;
> > $day_count++;
>
> > if ($day_count > 7)
> > {
> > echo "</tr><tr>";
> > $day_count = 1;
> > }
> > }
>
> > while ( $day_count >1 && $day_count <=7 )
> > {
> > echo "<td> </td>";
> > $day_count++;
> > }
>
> > echo "</tr></table>";
>
> > ?>
>
> > If anyone can please show me how to query and link my events i would
> > really appreciate it.
>
> > God bless
> > jsd219
>
> Just what is it that you are "querying"? IOW, what is it that you want to
> have happen?
>
> Shelly
the calendar is for a mission group, it is mission trips that are in
the database and i would like the calendar to display the trip title
on the appropriate date as a link that opens a popup window with the
trip information. my database has is:
name: calendar
fields: id, title, date, text
God bless
jason
Navigation:
[Reply to this message]
|