Page 1 of 1

Calender Output

Posted: Mon Mar 26, 2007 11:26 pm
by JimmyBob15
feyd | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]


Hello,

I have been working on a project and it is about winding down, but I just wanted to add one more thing that has been in the back of my mind for a while, but I just can't figure out the best way to do it.

Basically I have written a database with a front-end in PHP that keeps track of meeting times and attendance from previous meetings for an organization.  All the attendance is kept in just a LONG TEXT, and everyone's name is always formatted the same way and just all thrown together, separated by commas, in the database.  This makes it easy to find who came to every meeting, and I have set up a page to list out the dates of each meeting any one user attended.  It is kind of ugly though and when you go to one-two meetings a week for a year there becomes a lot of information.  Basically I want to make it a little bit more visual, and show a sort of calender, and on every day that some person x attended a meeting, it will be obvious by shading the background a different color or something.

For example, take a look at the following code, it is just a bunch of embedded tables in HTML, but it sort of shows the format that I am shooting for.  If I made it so if you attended a meeting, it was colored in on that day, someone can quickly see exactly when they went to meetings, and still see the date, and not just have to read a big list of data.

[syntax="html"]<HTML>
<HEAD>
<TITLE>Test Page</TITLE>
</HEAD>

<BODY>
<table width="152" height="185" border="1">
    <tr>
      <td width="154"><table width="140" border="0" align="center">
        <tr>
          <td> <div align="center">MONTH</div></td>

        </tr>
        <tr>
          <td><table width="140" border="0">
            <tr>
              <td>S</td>
              <td>M</td>
              <td>T</td>

              <td>W</td>
              <td>R</td>
              <td>F</td>
              <td>S</td>
            </tr>
          </table></td>
        </tr>

      </table></td>
    </tr>
    <tr>
      <td><table width="140" border="0" align="center">
        <tr>
		  <td>1</td>
		  <td>2</td>
		  <td>3</td>

		  <td>4</td>
		  <td>5</td>
          <td>6</td>
		  <td>7</td>
        </tr>
        <tr>
		  <td>8</td>

		  <td>9</td>
		  <td>10</td>
		  <td>11</td>
		  <td>0</td>
          <td>0</td>
		  <td>0</td>

        </tr>
        <tr>
		  <td>0</td>
		  <td>0</td>
		  <td>0</td>
		  <td>0</td>
		  <td>0</td>

          <td>0</td>
		  <td>0</td>
        </tr>
        <tr>
		  <td>0</td>
		  <td>0</td>
		  <td>0</td>

		  <td>0</td>
		  <td>0</td>
          <td>0</td>
		  <td>0</td>
        </tr>
        <tr>
          <td>0</td>

		  <td>0</td>
		  <td>0</td>
		  <td>0</td>
		  <td>0</td>
          <td>0</td>
          <td>0</td>

		</tr>
      </table></td>
    </tr>
</table>
</BODY>
</HTML>
What I can't figure out is the best way to do this, and especially, if I do it this way, how to line up the days to the proper week for the given month in any year. Does anyone have any suggestions on how to do this? Does anyone know of any other way to make the information display in a easy to read more creative format?

Some useful information, all the attendances and meetings have a timestamp, which is just put in as a string as the UNIX time() function when the attendance is being added to the database. It is not stored as the CURRENT_TIMESTAMP in the MySQL database. It is possible for this to change if need be.

Thanks in advance for any help that you can give.

JB


feyd | Please use[/syntax]

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]

Posted: Tue Mar 27, 2007 12:07 pm
by andym01480
It's not too hard!

Get a simple calendar script or work one out. I've used http://www.drquincy.com/resources/tutor ... pcalendar/ recently

Then find the bit where it ouputs each day and make a check in your db for a meeting with the date. If there is one o/p whatever data at that point.

Come back when you have had a play!

Posted: Tue Mar 27, 2007 12:19 pm
by RobertGonzalez
Your database may need to be reworked. Keeping a list of names like that could be better served relating them across different tables.