|
|
Posted by jsd219 on 10/31/07 16:14
On Oct 31, 10:57 am, "Shelly" <sheldonlg.n...@asap-consult.com> wrote:
> jsd219 wrote:
> > 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
>
> Then do a query with
> $q = "select * from calendar where id=" . $id;
> where $id is the one you want. Then work on the result to fetch the values
> of each field. Then use an echo statement enclosed with <?php ?> for the
> value of the particular field in the html document.
>
> Shelly
my apologies, I can do the query fine the problem I am having is I do
not know how to use the loop for the days to pull the results from the
query. :-) not sure if that made since. in other words, where and what
would i put in the code to make $day_num link to a trip?
God bless
jason
Navigation:
[Reply to this message]
|