|
|
Posted by jsd219 on 10/31/07 16:28
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 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
with the same date display the trip title and link it to open a popup
window with the trip details?
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>";
//This counts the days in the week, up to 7
$day_count = 1;
echo "<tr>";
//first we take care of those blank days
while ( $blank > 0 )
{
echo "<td></td>";
$blank = $blank-1;
$day_count++;
}
//sets the first day of the month to 1
$day_num = 1;
//count up the days, untill we've done all of them in the month
while ( $day_num <= $days_in_month )
{
echo "<td> $day_num </td>";
$day_num++;
$day_count++;
//Make sure we start a new row every week
if ($day_count > 7)
{
echo "</tr><tr>";
$day_count = 1;
}
}
//Finaly we finish out the table with some blank details if needed
while ( $day_count >1 && $day_count <=7 )
{
echo "<td> </td>";
$day_count++;
}
echo "</tr></table>";
God bless
jason
Navigation:
[Reply to this message]
|